View unanswered posts | View active topics
It is currently Sun May 05, 2024 10:59 pm
|
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
|
![Post Post](./styles/easyXLS/imageset/icon_topic_latest.gif) 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 |
|
![](./styles/easyXLS/theme/images/spacer.gif) |
daniela
Joined: Fri Feb 03, 2006 12:23 pm Posts: 190 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 |
|
![](./styles/easyXLS/theme/images/spacer.gif) |
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 |
|
![](./styles/easyXLS/theme/images/spacer.gif) |
daniela
Joined: Fri Feb 03, 2006 12:23 pm Posts: 190 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
|
|