The problem resides in the fact that I have a number in a column that has a comma as the number separator. This comma is being copied as is into the comma delimited file but no quotes are added to tell the system that the comma is not an actual field separator.
Here is the code that was used
- Code: Select all
Workbook workbook = new Workbook();
workbook.LoadFromFile(FilePath);
Worksheet sheet = workbook.Worksheets[0];
sheet.SaveToFile(SavePath, delimiter.ToString(), Encoding.ASCII);