Large Excel Spreadsheets to PDF in .NET

GroupDocs.Conversion Product Family
1

I need a way to split worksheet into pages by rows and columns. I know GroupDocs.Viewer can do it like:

How to achieve this by GroupDocs.Conversion for .NET?

1 Like
2

@jefflin0322

You can specify the convert range for example: “D1:F8”.
The following code shows how to convert Spreadsheet document and specify exact range of rows and columns to be converted:

Contracts.Func<LoadOptions> getLoadOptions = () => new SpreadsheetLoadOptions
{
    ConvertRange = "10:30",
    OnePagePerSheet = true
};
using (Converter converter = new Converter("sample.xlsx", getLoadOptions))
{
    PdfConvertOptions options = new PdfConvertOptions();
    converter.Convert("converted.pdf", options);
}

You can explore our GitHub example as well.

3

@Atir_Tahir

I have tried this, and actually it’s not what I want. This is specify exact range, means the other rows and columns won’t be conveted into PDF. I would like to split worksheet into pages by rows and columns.

For example, I have a worksheet has 200 rows and want to split it 100 rows per page. After conversion, I will get the PDF file that has 2 pages and each page has 100 rows.

The scenario just like the link below that done by GroupDocs.Viewer.

1 Like
4

@jefflin0322

We are investigating this scenario. Your investigation ticket ID is CONVERSIONNET-5465. You’ll be notified in case of any update.