V
vtoh95
Guest
I want to read excel file using OLEDB C#, however the Headers of the file are dynamic.
If let's say the headers are in Row 7 of the Excel file, I want to read the data from row 8 onwards (cell A8 and beyond)
How can I use comm.CommandText to query dynamically the data? An approach would possibly to identify the first header column (e.g. 'Record ID') and return its cell reference (A7), and then search A8 onwards using this result. However, I have no idea how to do this in code.
Any suggestions are appreciated.
Continue reading...
If let's say the headers are in Row 7 of the Excel file, I want to read the data from row 8 onwards (cell A8 and beyond)
How can I use comm.CommandText to query dynamically the data? An approach would possibly to identify the first header column (e.g. 'Record ID') and return its cell reference (A7), and then search A8 onwards using this result. However, I have no idea how to do this in code.
Any suggestions are appreciated.
Continue reading...