EasyXLS
http://forum.easyxls.com/

reading xls file in dataset with firstrow as header
http://forum.easyxls.com/viewtopic.php?f=4&t=920
Page 1 of 1

Author:  pankajmittal3 [ Mon Dec 08, 2008 3:36 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:13 am ]
Post subject: 

Yes, the first row (even the header row) from the spreadsheet si always the first row in the dataset.

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/