Re: Reading Data from Excel spreadsheet, unusual problem - C# Discussion Boards

musefan22-Apr-09 23:33

musefan

22-Apr-09 23:33

easy...

string text = "abokf.okhj.jkoklk.";
string start = "ok";
string end = ".";
string replace = "D";
string answer = "abokD.okD.jkokD.";

console.WriteLine(answer);

of course you could optimise it...

console.WriteLine("abokD.okD.jkokD.");

...or perhaps you wanted something different Laugh | :laugh:

Life goes very fast. Tomorrow, today is already yesterday.

OriginalGriff23-Apr-09 2:06

OriginalGriff

23-Apr-09 2:06

You sarcastic bunch!
This is a really difficult problem (if you have no experience and your IQ is smaller than your shoe size) so give the chap a break.
Just because it would take us less than a minute to complete (or two if we did it manually, rather than use built in members) doesn't mean we should take the piss out of really lazy students who want us to do thier homework for free.

So, the complete solution:

string s = "abokf.okhj.jkoklk.";
string startString = "ok";
string endString = ".";
string replacementString = "D";
while (ReplaceAllIncidencesOfDataDelimitedByTwoStringsWithAnotherStringForReallyLazyStudentsWithNoIdeaNoExperienceAndAnIQSmallerThanTheirShoeSize(ref s, startString, endString, replacementString))
   {
   }
Console.Writeline(s);

Obviously, you will need the method "ReplaceAllIncidencesOfDataDelimitedByTwoStringsWithAnotherStringForReallyLazyStudentsWithNoIdeaNoExperienceAndAnIQSmallerThanTheirShoeSize" and it is here, with all the others:
http://PleaseDoMyHomeworkForMe.com/ComputerProjects/UnbelievablySimple/Index.html

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced

Eddy Vluggen23-Apr-09 6:19

Eddy Vluggen

23-Apr-09 6:19

I just had to follow the link, and the first hit on Google is a blog with excuses on forgetting to do your homework Big Grin | :-D

I did resist the urge to add "CodeProject members refused to make it" Suspicious | :suss:

I are troll Smile | :)

Guffa23-Apr-09 6:33

Guffa

23-Apr-09 6:33

I created an Animal class, then I created a Dog class and a Cat class that inherited from the Animal class. Then the Dog class ate my homework.

Wink | ;)

Despite everything, the person most likely to be fooling you next is yourself.

Reading Data from Excel spreadsheet, unusual problem

OriginalGriff23-Apr-09 8:13

OriginalGriff

23-Apr-09 8:13

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Member 436780422-Apr-09 22:15

Member 4367804

22-Apr-09 22:15

Hi

Wonder if anyone out there can help me.

I have been working on retrieving data from xls files using ole and have had no problems until i received a file that is causing me considerable greif.

The file in question is 26k in size and is a simple headed workbook with 2 pages.

When I connect to the file and try to retreive schema info (using schema = GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" })) no table rows (pages) are found (ie schema.Rows is null).

If I open the file in Excel and click on the save button (without making any changes) the file grows by 10k in size and the data can then be retrieved without any problems!!???

Has anyone out there ever experienced an issue of this nature and if so, could you possibly explain what is making this happen.

Many thanks in advance to anyone who can help,
Steve Confused | :confused:

Re: Reading Data from Excel spreadsheet, unusual problem

Mycroft Holmes22-Apr-09 22:31

Mycroft Holmes

22-Apr-09 22:31

Now you begin to understand why most devs avoid Excel like the plague. We force the supplier to send us CSV files, this would mean you get 2 files for multiple pages.

Excel OLEDB connections are too fragile in my opinion, you have no control over the excel sheet, I could go on for many additional reasons not to use Excel. This is not helping you, sorry.

You may end up in the position where you need to read in each cell from each sheet.

Never underestimate the power of human stupidity
RAH

Re: Reading Data from Excel spreadsheet, unusual problem

Natza Mitzi22-Apr-09 23:19

Natza Mitzi

22-Apr-09 23:19

I work with this:
conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables_Info, null);
check the excel version maybe it is related

Natza Mitzi

what does this error mean

benson.misi22-Apr-09 21:45

benson.misi

22-Apr-09 21:45

{"DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'UserId'."}

DoctorMick22-Apr-09 22:00

DoctorMick

22-Apr-09 22:00

It looks like you have a control (e.g. GridView) for which you have specified a column with the DataItem UserId but the UserId does not exist in the object you are binding to the gridview. Check your gridview data source contains a UserId column/property.

Nagy Vilmos22-Apr-09 22:19

Nagy Vilmos

22-Apr-09 22:19

The answer is the same as it was yesterday. And the day before.
You need to do three things:
- Read what people have said.
- Take action based upon it.
- Discover magical fairy la la land where your grade school code works.

Panic, Chaos, Destruction.
My work here is done.

Mbah Dhaim22-Apr-09 22:22

Mbah Dhaim

22-Apr-09 22:22

have you read yesterday replies? D'Oh! | :doh:

dhaim
ing ngarso sung tulodho, ing madyo mangun karso, tut wuri handayani. "Ki Hajar Dewantoro"
in the front line gave a lead, in the middle line build goodwill, in the behind give power support

Christian Graus22-Apr-09 23:10

Christian Graus

22-Apr-09 23:10

It means you're too stupid to use a computer. Put it in it's box, take it back to the store, and choose a different course.

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

Michael Bookatz22-Apr-09 23:34

Michael Bookatz

22-Apr-09 23:34

You really need to read the answers from your last post. And get a book about data binding!

Pete O'Hanlon23-Apr-09 0:29

Pete O'Hanlon

23-Apr-09 0:29

It means the psychic link has failed to update your code to supply a UserId.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

0x3c023-Apr-09 0:41

0x3c0

23-Apr-09 0:41

The error code will be 119047 (convert it to hexadecimal to read it). It means that something bad happened. Don't panic, if it doesn't run well it probably won't be shipped (unless the lead developer is the CEO's relative) and people won't have to maintain it
Additional option: plug the error message into Google
Final option: blame someone else. It works in government all the time

[Message Deleted]

hkjghkj122-Apr-09 21:00

hkjghkj1

22-Apr-09 21:00

[Message Deleted]

Pauwels Bart22-Apr-09 21:06

Pauwels Bart

22-Apr-09 21:06

Just use a loop to read out the array and add every element to the existing string.

Thomas Krojer22-Apr-09 21:16

Thomas Krojer

22-Apr-09 21:16

string[] arr = new string[] { "one", "2", "three", "IV" };
string x = String.Join("\", \"", arr);

guoyz_122-Apr-09 23:22

guoyz_1

22-Apr-09 23:22

牛！