Free Support Forum - aspose.com

Semicolon as Delimiter

Hi how can we create a semicolon delimited csv file..
This message was posted using Aspose.Live 2 Forum

Hi,

I think you may try the sample code with latest version e.g 5.1.3

Workbook workbook = new Workbook();
Cells cells = workbook.Worksheets[0].Cells;
cells[“A1”].PutValue(“Hello world”);
for (int i = 1; i <= 10; i++)
{
cells[0, i].PutValue(i);
}

TxtSaveOptions options = new TxtSaveOptions();
//Specify the separator.
options.Separator = Convert.ToChar(";");
workbook.Save(“e:\test\semicols.txt”, options);

Thank you.