Convert XLSX File to PDF Format

Converting Excel to PDF

This example uses an Excel file (SampleInput.xlsx) as a template. The workbook contains worksheets with charts and image. Each worksheet contains different types of formats using fonts, attributes, colors, shading effects and borders. There’s a column chart on the first worksheet and an image on the last.

The Template Excel File

The template file has three worksheets, including charts and image as Media. The first worksheet has charts and last worksheet has an image as shown below in the screenshots.

todo:image_alt_text todo:image_alt_text
The first worksheet (Sales Forecast) The second worksheet (Sales Report)
todo:image_alt_text todo:image_alt_text
The third worksheet (Data Entry) The last worksheet (Image)

Conversion Process

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
try
{
// Get the template excel file path.
string designerFile = dataDir + "SampleInput.xlsx";
// Specify the pdf file path.
string pdfFile = dataDir + "Output.out.pdf";
// Open the template excel file
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(designerFile);
// Save the pdf file.
wb.Save(pdfFile, SaveFormat.Pdf);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
Console.ReadLine();
}

Result

When the above code has been run, a PDF file is created in the Files folder in your application directory. The following screenshots show the PDF pages. Note that headers and footers are also retained in the output PDF file.

todo:image_alt_text todo:image_alt_text
The first worksheet (Sales Forecast) The second worksheet (Sales Report)
todo:image_alt_text todo:image_alt_text
The third worksheet (Data Entry) The last worksheet (Image)