I'm having an issue where am reading in a file and then resaving it to an archive location. The file is CSV and it appears to be removing commas at the end.
BNYDCPE,08/15/2013,XB2NYGN,,Healy,,B11,401.80,,,,,,,BNYDCPE,08/15/2013,XB2NYGN,,Healy,,B11,401.80,,,,,,,
Becomes
DCPE,08/15/2013,XB2NYGN,,Healy,,B11,401.80,,,,,,,DCPE,08/15/2013,XB2NYGN,,Healy,,B11,401.80
Is there a setting that will prevent this? Just fyi, I am opening the file in notepad, not excel, so that's not what is causing the truncation.
LoadFormat loadFormat = LoadFormat.CSV;
SaveFormat saveFormat = SaveFormat.CSV;
Aspose.Cells.LoadOptions loadOptions = new Aspose.Cells.LoadOptions(loadFormat);
// Open the workbook and save it in the session
// Create the workbook
var workbook = new Workbook(fileName.ToString(), loadOptions);
workbook.Settings.ConvertNumericData = false;
Cells cells = workbook.Worksheets[0].Cells;
//workbook.Save(stream, saveFormat);
workbook.Save("c:\\bnym\\test.csv");
Thanks