Convert Workbook to Different Formats

Converting Excel Workbook to XPS

The XPS document format consists of structured XML markup that defines the layout of a document and the visual appearance of each page, along with rendering rules for distributing, archiving, rendering, processing, and printing documents.

The markup language for XPS is a subset of XAML which allows it to incorporate vector graphics elements in documents, using XAML to mark up the Windows Presentation Foundation (WPF) primitives. The elements used are described in terms of paths and other geometrical primitives.

An XPS file is, in fact, a Unicoded ZIP archive using the Open Packaging Conventions, containing the files which make up the document. These include an XML markup file for each page, text, embedded fonts, raster images, 2D vector graphics, as well as the digital rights management information. The contents of an XPS file can be examined simply by opening it in an application that supports ZIP files.

From Aspose.Cells 6.0.0, Microsoft Excel to XPS conversion is supported.

Converting Excel Workbook to MHTML Files

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.

The code example below shows how to save a workbook as an MHTML file.

Converting Excel Workbook to HTML

The Aspose.Cells API provides support for exporting spreadsheets to HTML format. For this purpose, Aspose.Cells uses the HtmlSaveOptions class to provide the flexibility to control several aspects of the output HTML.

The code example below shows how to save a workbook as an HTML file.

Setting the Image Preferences for HTML

Starting from 8.0.2, Aspose.Cells has exposed ImageOptions for the HtmlSaveOptions class, allowing developers to specify image preferences when saving spreadsheets to HTML format.

Below are details of some of the image settings that can be applied,

  • ImageType: Specifies the image type. Please note, all shapes, including charts, render as images in the output HTML.
  • SmoothingMode: Specifies the anti-aliasing for lines, curves & edges of filled areas.
  • TextRenderingHint: Specifies the quality of text rendering.
  • Quality: Specifies the quality of the image between 0 to 100, when ImageType is specified as Jpeg.
  • VerticalResolution: Gets or sets the vertical resolution of the image in dots per inch.
  • HorizontalResolution: Gets or sets the horizontal resolution of the image in dots per inch.
  • TiffCompression: Gets or sets the compression type for the images when ImageType is specified as Tiff.
  • Transparent: Indicates if the background of an image should be transparent when ImageFormat is specified as Png.

The code below demonstrates how to use HtmlSaveOptions.ImageOptions to specify different preferences.

Convert Excel Workbook to Markdown

The Aspose.Cells API provides support for exporting spreadsheets to Markdown format. To export the active worksheet to Markdown, pass SaveFormat.Markdown as the second parameter of Workbook.Save method. You may also use MarkdownSaveOptions class to specify additional settings for exporting worksheet to Markdown.

The following code example demonstrates exporting active worksheet to Markdown by using SaveFormat.Markdown enumeration member. Please see the output Markdown file generated by the code for reference.

Convert Excel Workbook to DOCX

The Aspose.Cells API provides support for converting spreadsheets to DOCX format. To export the workbook to DOCX, pass SaveFormat.Docx as the second parameter of Workbook.Save method. You may also use DocxSaveOptions class to specify additional settings for exporting worksheet to DOCX.

The following code example demonstrates exporting active worksheet to DOCX by using SaveFormat.Docx enumeration member. Please see the output DOCX file generated by the code for reference.

Convert Excel Workbook to PPTX

The Aspose.Cells API provides support for converting spreadsheets to PPTX format. To export the workbook to PPTX, pass SaveFormat.Pptx as the second parameter of Workbook.Save method. You may also use PptxSaveOptions class to specify additional settings for exporting worksheet to PPTX.

The following code example demonstrates exporting active worksheet to PPTX by using SaveFormat.Pptx enumeration member. Please see the output PPTX file generated by the code for reference.