Convert between Excel formats

Converting Excel to PDF

PDF files are widely used for exchanging documents between organizations, government sectors and individuals. It is a standard document format and software developers are often asked to find a way to convert Microsoft Excel files into PDF documents. Aspose.Cells supports converting Excel files to PDF and maintains high visual fidelity in the conversion.

Aspose.Cells for .NET supports conversion from spreadsheets to PDF independently of other software. Save an Excel file to PDF using the Workbook class' Save method. The Save method provides the SaveFormat.Pdf enum member that converts the native Excel files to PDF format.

Converting directly from spreadsheet to PDF, instead of using a third-party tool or external API, has several advantages:

1. Direct conversion does not require temporary files because the whole process can be done in memory.
2. No XML file is needed so large files can easily be converted.
3. The conversion speed is much faster.

To convert files to PDF:

1. Instantiate an object of the Workbook class by calling its empty constructor.
2. You may open/load an existing template file or skip this step if you are creating the workbook from scratch.
3. Do your desired work (input data, apply formatting, set formulas, insert pictures or other drawing objects, and so on) on the spreadsheet using Aspose.Cells' APIs.
4. When the spreadsheet code is complete, call the Workbook class' Save method to save the spreadsheet. The file format should be PDF so select Pdf (a pre-defined value) from the SaveFormat enumeration to generate the final PDF document.

  Workbook workbook = new Workbook(openFileDialog1.FileName);

  workbook.Save(saveFileDialog1.FileName, SaveFormat.Pdf);

Converting Excel to MHTML

MHTML combines normal HTML with external resources (that is, content that is usually linked in, like images, animations, audio and so on) into one file. They are used for emails with the .mht file extension. Aspose.Cells supports reading and writing MHTML files.

  Workbook workbook = new Workbook(openFileDialog1.FileName);

  //Specify the HTML Saving Options

  HtmlSaveOptions sv = new HtmlSaveOptions(SaveFormat.MHtml);

  workbook.Save(saveFileDialog1.FileName, sv);

Converting Excel to XPS

Sometimes, you want to convert or save a workbook with multiple worksheets into text format. For text formats (for example TXT, TabDelim, CSV etc.), by default both Microsoft Excel and Aspose.Cells save the contents of the active worksheet only.

  Workbook workbook = new Workbook(openFileDialog1.FileName);

 workbook.Save(saveFileDialog1.FileName, SaveFormat.CSV);

Download Sample Code

• Github
• Bitbucket