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
};

MarkdownConverter.ToFile("cost-analysis.xlsx", "spreadsheet-truncation.md", options);

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

cost-analysis.xlsx is a sample file used in this example. Click here to download it.

## Summary

| Category | FY2024 | FY2025 | FY2026 |
| --- | --- | --- | --- |
| Parts and materials | $1,325,000.00 | $1,480,000.00 | $1,620,000.00 |
| Manufacturing equipment | $900,500.00 | $980,000.00 | $1,050,000.00 |
| Warehousing | $420,000.00 | $510,000.00 | $590,000.00 |
| Shipping | $380,000.00 | $445,000.00 | $520,000.00 |
| Marketing | $250,000.00 | $340,000.00 | $480,000.00 |
| R&D | $180,000.00 | $230,000.00 | $310,000.00 |
[TRUNCATED]

Download full output

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("cost-analysis.xlsx");
ConvertResult result = converter.Convert("spreadsheet-sheets.md", options);

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

cost-analysis.xlsx is a sample file used in this example. Click here to download it.

## Summary

| Category | FY2024 | FY2025 | FY2026 |
| --- | --- | --- | --- |
| Parts and materials | $1,325,000.00 | $1,480,000.00 | $1,620,000.00 |
| Manufacturing equipment | $900,500.00 | $980,000.00 | $1,050,000.00 |
| Warehousing | $420,000.00 | $510,000.00 | $590,000.00 |
| Shipping | $380,000.00 | $445,000.00 | $520,000.00 |
| Marketing | $250,000.00 | $340,000.00 | $480,000.00 |
| R&D | $180,000.00 | $230,000.00 | $310,000.00 |
[TRUNCATED]

Download full output

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