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/