|
View unanswered posts | View active topics
It is currently Sun Dec 22, 2024 2:01 am
|
Page 1 of 1
|
[ 4 posts ] |
|
reading xls file in dataset with firstrow as header
| Author |
Message |
|
pankajmittal3
Joined: Fri Nov 07, 2008 6:56 am
Posts: 3
Location: Delhi,India
|
 reading xls file in dataset with firstrow as header I am reading a .xls file as dataset using
easy_ReadXLSSheet_AsDataSet(filepath,sheetname)
I am able to fetch the file in dataset but the problem is I want to treat excel first row as header in dataset but easy xls read the excel first row as normal row not as a header. I am using .net 2.0 c#, excel 97 to 03
|
| Mon Dec 08, 2008 3:38 am |
|
|
|
daniela
Joined: Fri Feb 03, 2006 12:23 pm
Posts: 199
Location: Brasov, Romania
|
Yes, the first row (even the header row) from the spreadsheet si always the first row in the dataset.
|
| Mon Dec 08, 2008 5:14 am |
|
|
|
pankajmittal3
Joined: Fri Nov 07, 2008 6:56 am
Posts: 3
Location: Delhi,India
|
but i want to treat excel first row as header column name in dataset but currently my dataset header column name is "column1","column2".........etc....
|
| Mon Dec 08, 2008 5:55 am |
|
|
|
daniela
Joined: Fri Feb 03, 2006 12:23 pm
Posts: 199
Location: Brasov, Romania
|
That is not possible...
|
| Mon Dec 08, 2008 6:20 am |
|
|
|
|
Page 1 of 1
|
[ 4 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 1 guest |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
|
|
