Spreadsheet conversion options

Spreadsheet conversion options

When converting spreadsheets, use these properties on ConvertOptions to control the Markdown table output.

Column and row truncation

using GroupDocs.Markdown;

var options = new ConvertOptions
{
    MaxColumns = 8,     // Only first 8 columns
    MaxRows = 50,       // Only first 50 data rows per sheet
};

string md = MarkdownConverter.ToMarkdown("large-data.xlsx", options);

// Truncated columns/rows show "..." indicators.
// Warnings are reported in ConvertResult.Warnings.

Sheet separator and hidden sheets

using GroupDocs.Markdown;

var options = new ConvertOptions
{
    SheetSeparator = "\n---\n",    // Separator between worksheets
    IncludeHiddenSheets = false    // Skip hidden worksheets (default)
};

using var converter = new MarkdownConverter("workbook.xlsx");
ConvertResult result = converter.Convert(options);

foreach (string warning in result.Warnings)
    Console.WriteLine($"Warning: {warning}");
// e.g. "Worksheet 'Data' truncated at 50 rows."

Available options

PropertyTypeDefaultDescription
MaxColumnsint0 (unlimited)Maximum columns per table
MaxRowsint0 (unlimited)Maximum data rows per worksheet
SheetSeparatorstring"\n---\n"Separator inserted between worksheets
IncludeHiddenSheetsboolfalseWhether to include hidden worksheets