Save Each Worksheet to a Different PDF

Aspose.Cells - Save Each Worksheet to a Different PDF

Aspose.Cells supports converting XLS files (that contain images, charts, etc.) to PDF documents. Aspose.Cells for .NET can work independently to convert a spreadsheet to a PDF document, and you do not need to use Aspose.Pdf for .NET for the conversion any longer. The conversion does not require creating or using any temporary files, as the whole process can be done in memory.

C#

 // Instantiate a new workbook and open the Excel file from its location
Workbook workbook = new Workbook("../../data/test.xlsx");

// Get the count of the worksheets in the workbook
int sheetCount = workbook.Worksheets.Count;

// Make all sheets invisible except the first worksheet
for (int i = 1; i < workbook.Worksheets.Count; i++)
{
    workbook.Worksheets[i].IsVisible = false;
}

// Take PDFs of each sheet
for (int j = 0; j < workbook.Worksheets.Count; j++)
{
    Worksheet ws = workbook.Worksheets[j];
    workbook.Save(ws.Name + ".pdf");
    if (j < workbook.Worksheets.Count - 1)
    {
        workbook.Worksheets[j + 1].IsVisible = true;
        workbook.Worksheets[j].IsVisible = false;
    }
}

Download Running Code

Download Save Each Worksheet to a Different PDF from any of the below‑mentioned social coding sites:

• GitHub

For more details, visit Save Each Worksheet to a Different PDF File.