Convert to Spreadsheet with advanced options Leave feedback
On this page
GroupDocs.Conversion provides the SpreadsheetConvertOptions class to give you control over conversion result when convert to spreadsheet format. Along with common convert options from base class SpreadsheetConvertOptions has the following additional options:
- Format specifies desired result document type. Available options are: Xls, Xlsx, Xlsm, Xlsb, Ods, Ots, Xltx, Xlt, Xltm, Tsc, Xlam, Csv, Tsv.
- Encoding specifies the encoding to be used when converting to delimited formats (CSV, TSV). Default is UTF-8.
- Separator specifies the separator character to be used when converting to delimited formats (CSV, TSV). For CSV, the default is comma (
,). For TSV, use tab character (\t). - Password whether the converted document will be password protected with the specified password.
- Zoom specifies the zoom level in percentage. Default is 100.
The following code snippet shows how to convert to Spreadsheet with advanced options:
using (Converter converter = new Converter("sample.docx"))
{
SpreadsheetConvertOptions options = new SpreadsheetConvertOptions
{
PageNumber = 2,
PagesCount = 1,
Format = SpreadsheetFileType.Xlsx,
Zoom = 150
};
converter.Convert("converted.xlsx", options);
}
When converting to CSV format, you can specify the character encoding:
using System.Text;
using (Converter converter = new Converter("sample.xlsx"))
{
SpreadsheetConvertOptions options = new SpreadsheetConvertOptions
{
Format = SpreadsheetFileType.Csv,
Encoding = Encoding.UTF8
};
converter.Convert("converted.csv", options);
}
Use a custom separator character for CSV conversion. Semicolon separator is common in European locales where comma is used as a decimal separator:
using (Converter converter = new Converter("sample.xlsx"))
{
SpreadsheetConvertOptions options = new SpreadsheetConvertOptions
{
Format = SpreadsheetFileType.Csv,
Separator = ';' // Semicolon separator for European locales
};
converter.Convert("converted.csv", options);
}
Combine both encoding and separator settings for international CSV exports:
using System.Text;
using (Converter converter = new Converter("sample.xlsx"))
{
SpreadsheetConvertOptions options = new SpreadsheetConvertOptions
{
Format = SpreadsheetFileType.Csv,
Encoding = Encoding.UTF8,
Separator = ';'
};
converter.Convert("international-data.csv", options);
}
Convert to TSV format using tab character as separator:
using (Converter converter = new Converter("sample.xlsx"))
{
SpreadsheetConvertOptions options = new SpreadsheetConvertOptions
{
Format = SpreadsheetFileType.Tsv,
Separator = '\t' // Tab character
};
converter.Convert("converted.tsv", options);
}
Was this page helpful?
Any additional feedback you'd like to share with us?
Please tell us how we can improve this page.
Thank you for your feedback!
We value your opinion. Your feedback will help us improve our documentation.
