| EasyXLS http://forum.easyxls.com/ |
|
| reading xls file in dataset with firstrow as header http://forum.easyxls.com/viewtopic.php?f=9&t=921 |
Page 1 of 1 |
| Author: | pankajmittal3 [ Mon Dec 08, 2008 3:38 am ] |
| Post subject: | 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 |
|
| Author: | daniela [ Mon Dec 08, 2008 5:14 am ] |
| Post subject: | |
Yes, the first row (even the header row) from the spreadsheet si always the first row in the dataset. |
|
| Author: | pankajmittal3 [ Mon Dec 08, 2008 5:55 am ] |
| Post subject: | |
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.... |
|
| Author: | daniela [ Mon Dec 08, 2008 6:20 am ] |
| Post subject: | |
That is not possible... |
|
| Page 1 of 1 | All times are UTC - 4 hours |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|