Import Excel Range to Dataset

eresina · August 27th, 2007, 12:31 PM

Hello,

I need to import an Excel range (not the whole worksheet...I begam to import the whole sheet, not a good ideia...) to a Dataset. Does any one can help me?

Thanks in advance

Elisa

Elisa Resina

swifty_programmer · August 28th, 2007, 01:54 AM

Hi,
You can use a StreamReader to read the file and select what part you want. You have a special StreamReader called FileReader for making it easier.

example:

Code:

if (_ofdSelectFile.ShowDialog() == DialogResult.OK)
            {
                using (StreamReader sr = new StreamReader(_ofdSelectFile.FileName))
                {
                    //Read file with url's
                    while (!sr.EndOfStream)
                    {
                        string directImportLine = sr.ReadLine();
                        //actions with 1 line
                    }
                }
            }

They are also a few tips and tricks with excel sheets.
You can acces (write and read) data from an excel sheet just like in a DB. It uses special SQL statement so you can select cells, colums or rows.

Hope it helped.

Grtz

zaghmout · August 28th, 2007, 05:39 AM

In such a case I really prefer using oledbCommand, I thing you should try it

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"

eresina · August 28th, 2007, 05:52 AM

I already tryed with OleDBCommand (select * from [xxxx]) and it importes the whole sheet. I just want to import a range of values, which I don't know how to do it.

thanks

Elisa

Quote:

quote:Originally posted by zaghmout
In such a case I really prefer using oledbCommand, I thing you should try it

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"

Elisa Resina

eresina · August 28th, 2007, 05:59 AM

Hi!

Thank you for your answer. I'm going to read it and try it!

thanks,

Elisa

Quote:

quote:Originally posted by swifty_programmer
Hi,
You can use a StreamReader to read the file and select what part you want. You have a special StreamReader called FileReader for making it easier.

example:

Code:

if (_ofdSelectFile.ShowDialog() == DialogResult.OK)
            {
                using (StreamReader sr = new StreamReader(_ofdSelectFile.FileName))
                {
                    //Read file with url's
                    while (!sr.EndOfStream)
                    {
                        string directImportLine = sr.ReadLine();
                        //actions with 1 line
                    }
                }
            }

They are also a few tips and tricks with excel sheets.
You can acces (write and read) data from an excel sheet just like in a DB. It uses special SQL statement so you can select cells, colums or rows.

Hope it helped.

Grtz

Elisa Resina