When converting spreadsheets, use these properties on ConvertOptions to control the Markdown table output.
Column and row truncation
usingGroupDocs.Markdown;varoptions=newConvertOptions{MaxColumns=8,// Only first 8 columnsMaxRows=50,// Only first 50 data rows per sheet};stringmd=MarkdownConverter.ToMarkdown("large-data.xlsx",options);// Truncated columns/rows show "..." indicators.// Warnings are reported in ConvertResult.Warnings.
Sheet separator and hidden sheets
usingGroupDocs.Markdown;varoptions=newConvertOptions{SheetSeparator="\n---\n",// Separator between worksheetsIncludeHiddenSheets=false// Skip hidden worksheets (default)};usingvarconverter=newMarkdownConverter("workbook.xlsx");ConvertResultresult=converter.Convert(options);foreach(stringwarninginresult.Warnings)Console.WriteLine($"Warning: {warning}");// e.g. "Worksheet 'Data' truncated at 50 rows."
Available options
Property
Type
Default
Description
MaxColumns
int
0 (unlimited)
Maximum columns per table
MaxRows
int
0 (unlimited)
Maximum data rows per worksheet
SheetSeparator
string
"\n---\n"
Separator inserted between worksheets
IncludeHiddenSheets
bool
false
Whether to include hidden worksheets
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.