ExcelFile.Load data types

GemBox.Spreadsheet
1

I am trying to load a CSV, but ExcelFile.Load is treating string fields as doubles. How do I set it to load everything as a string or scan more rows?

I am on v. 39.3.30.1024.

2

Hi Jeff,

You can disable number and date parsing with CsvLoadOptions.
For example, try this:

var options = new CsvLoadOptions(CsvType.CommaDelimited)
{
    ParseNumbers = false,
    ParseDates = false
};
var workbook = ExcelFile.Load("input.csv", options);

Does this solve your issue?

Regards,
Mario