Microsoft® Excel Format Conversion via .NET
Import & export Excel files as spreadsheet, web, image and fixed-layout formats
.NET Excel Library speeds up spreadsheet programming and conversion processes while supporting popular formats including XLS, XLSX, XLSM, XLSB, XLTX, XLTM, CSV, SpreadsheetML, ODS. It also allows to export Excel files to PDF, XPS, HTML, MHTML, Plain Text and popular image formats such as TIFF, JPG, PNG, BMP and SVG.
Convert Excel to XLSX, ODS, SXC & FODS
Inter-conversion of spreadsheet format only requires loading a spreadsheet with an instance of Workbook and saving back in the desired format while selecting appropriate value from SaveFormat enumeration.
C# Code for Excel File Format Conversion
// load the template file
var workbook = new Aspose.Cells.Workbook("template.xls");
// save as XLSX, ODS, SXC & FODS formats
workbook.Save("output.xlsx", Aspose.Cells.SaveFormat.Xlsx);
workbook.Save("output.ods", Aspose.Cells.SaveFormat.Ods);
workbook.Save("output.scx", Aspose.Cells.SaveFormat.Sxc);
workbook.Save("output.fods", Aspose.Cells.SaveFormat.Fods);
Convert Excel to PDF, XPS, HTML & MD
Specialized classes are available to control the conversion process for specific output formats such as PdfSaveOptions to export Excel files as PDF, XpsSaveOptions for Excel to XPS conversion, HtmlSaveOptions to render Excel as HTML and MarkdownSaveOptions for Excel to Markdown conversion.
C# Code for Excel to PDF and Web Formats
// load template Excel file from disc
var book = new Aspose.Cells.Workbook("template.xlsx");
// save Excel in PDF/A-1a format
book.Save("output.pdf", new Aspose.Cells.PdfSaveOptions() { Compliance = PdfComplianceVersion.PdfA1a });
// save Excel in XPS with 1 page per worksheet
book.Save("output.xps", new Aspose.Cells.XpsSaveOptions() { OnePagePerSheet = true });
// save Excel in HTML with images as Base64
book.Save("output.html", new Aspose.Cells.HtmlSaveOptions() { ExportImagesAsBase64 = true });
// save Excel in Markdown (MD) while retaining cell formatting
book.Save("output.md", new Aspose.Cells.MarkdownSaveOptions() { FormatStrategy = Cells.CellValueFormatStrategy.CellStyle });
Convert JSON to Excel & Excel to JSON
JSON data can be imported into an instance of Cells class with the help of JsonUtility.ImportData for further processing or simple conversion to any of the supported formats. Similarly, Worksheet data can be exported as JSON by creating a Range or cells and calling the JsonUtility.ExportRangeToJson method.
C# Code for JSON to Excel Conversion
// create a Workbook object
var workbook = new Cells.Workbook();
var worksheet = workbook.Worksheets[0];
// read JSON data from file
string jsonInput = File.ReadAllText("Data.json");
// set JsonLayoutOptions to treat Arrays as Table
var options = new Cells.Utility.JsonLayoutOptions();
options.ArrayAsTable = true;
// import JSON data to worksheet starting at cell A1
Cells.Utility.JsonUtility.ImportData(jsonInput, worksheet.Cells, 0, 0, options);
// save resultant file in XLSX format
workbook.Save("output.xlsx", Cells.SaveFormat.Auto);
C# Code for Excel to JSON Conversion
// load XLSX file with an instance of Workbook
var workbook = new Workbook("template.xlsx", new LoadOptions(Cells.LoadFormat.Auto));
// access CellsCollection of the worksheet containing data to be converted
var cells = workbook.Worksheets[0].Cells;
// create & set ExportRangeToJsonOptions for advanced options
var exportOptions = new Utility.ExportRangeToJsonOptions();
// create a range of cells containing data to be exported
var range = cells.CreateRange(0, 0, cells.LastCell.Row + 1, cells.LastCell.Column + 1);
// export range as JSON data
string jsonData = Cells.Utility.JsonUtility.ExportRangeToJson(range, exportOptions);
// write data file to disc in JSON format
System.IO.File.WriteAllText("output.json", jsonData);
Convert Excel Worksheets to JPG, BMP, PNG & GIF
Each worksheet of an Excel file can be converted to different image formats set by the
ImageOrPrintOptions.ImageType
property. Default value is ImageFormat.Bmp.
C# Code for Excel to Image Conversion
// load template spreadsheet
var workbook = new Aspose.Cells.Workbook("template.xlsx");
// create & set an instance of ImageOrPrintOptions
var options = new Aspose.Cells.Rendering.ImageOrPrintOptions();
options.OnePagePerSheet = true;
// set output image format
options.ImageType = Aspose.Cells.Drawing.ImageType.Jpeg;
// create SheetRender for first worksheet in the collection
var render = new Aspose.Cells.Rendering.SheetRender(workbook.Worksheets[0], options);
// render worksheet to image
render.ToImage(0, "output.jpg");
Convert Excel to Word & PowerPoint
It is possible to load any spreadsheet and convert it to Word DOCX & PowerPoint PPTX files while using DocxSaveOptions & PptxSaveOptions classes as demonstrated below.
C# code for Excel to Word & PowerPoint Conversion
// load the template file
var workbook = new Aspose.Cells.Workbook("template.xlsx");
// save spreadsheet as DOCX
workbook.Save("output.docx", new Aspose.Cells.DocxSaveOptions());
// save spreadsheet as PPTX
workbook.Save("output.pptx", new Aspose.Cells.PptxSaveOptions());