I Nugot SpreadsheetLight. To subsequently use it, I need to add the following usings: using DocumentFormat.OpenXml; using DocumentFormat.OpenXml.Spreadsheet; using SpreadsheetLight; For the firs...

Upon execution of the dBWorksheet.SaveAs(xlsFileSpec), in the code below, I am seeing an exception: "entries cannot be opened multiple times in update mode." SLDocument dBWorksheet = new SLDocu...

I'm looking for a function similar to DataTable.Rows.Count that can be used with an SLDocument to find out how many rows have data in them. Is there something available in SpreadsheetLight? Any oth...

I'm trying to populate a combobox with the names of the columns in a spreadsheet. I'm using the spreadsheetlight library. I can set the cell value using the following code where A refers to column ...