Cells cells = excel.Worksheets.Cells;
int thisRow = 0;
int prevRowMarker = 0;
|" + c.Value.ToString().Trim() + "");|
FileStream file = new FileStream(@liveName, FileMode.OpenOrCreate, FileAccess.Write);
For some reason Cells only contains cells that have data! So there is no easy way to loop through correctly if there are blank cells in the spreadsheet.
I also tried doing ExportToDataTable but that won't work for me because the datatypes are sometimes different in the excel spreadsheet (column 1 is sometimes dates and sometimes hyperlinks and sometimes numbers).
So can someone please just show me some sample code that will loop through a worksheet and display it in a HTML table?