Hi, I have the following error while saving a CSV file that contains some cells with more than 32K chars (I've tested with CheckExcelRestriction with no success).
I've tested with the following code :
Workbook workbook = null;
if (format == ExportFormat.CSV)
workbook = new Workbook(null, new TxtLoadOptions() { CheckExcelRestriction = false });
else
workbook = new Workbook();
workbook.Settings.Encoding = Encoding.Unicode;
workbook.Worksheets[0].Name = "Export";
workbook.SaveOptions.ClearData = true;
workbook.SaveOptions.CachedFileFolder = Path.GetTempPath();
workbook.ImportDataTable(datatable, 65535);
TxtSaveOptions saveOptions = new TxtSaveOptions();
saveOptions.Separator = _delimiter;
workbook.Save(filename + ".csv", saveOptions);Workbook workbook = null;
if (format == ExportFormat.CSV)
workbook = new Workbook(null, new TxtLoadOptions() { CheckExcelRestriction = false });
else
workbook = new Workbook();
workbook.Settings.Encoding = Encoding.Unicode;
workbook.Worksheets[0].Name = "Export";
workbook.SaveOptions.ClearData = true;
workbook.SaveOptions.CachedFileFolder = Path.GetTempPath();
workbook.ImportDataTable(datatable, 65535);
TxtSaveOptions saveOptions = new TxtSaveOptions();
saveOptions.Separator = _delimiter;
workbook.Save(filename + ".csv", saveOptions);
Thanks