Supported file formats

Input/Output

• Microsoft Excel: XLS, XLSX, XLSB, XLT, XLTX, XLTM, XLSM, XML, OTS
• OpenOffice: ODS
• Text: CSV, TSV, TXT
• Web: HTML, MHTML
• Numbers: Apple's iWork office suite Numbers app documents
• Others: SXC, FODS, EPUB

Output Only

• Fixed Layout: PDF, PDF/A, XPS
• Data Interchange: DIF
• Images: JPEG, PNG, BMP, SVG, TIFF, EMF, GIF
• Others: MARKDOWN, SQL, XTHML

Features

• Read Excel spreadsheets.
• Render spreadsheets to PDF, EMF and images.
• Adjust worksheets within workbooks.
• Protect/unprotect worksheets.
• Add images as well as create charts.
• Create pivot tables and pivot charts.
• Add and edit comments at cell level.
• Search and replace data.
• Split and merge cells.
• Add or remove grouping to rows and columns.
• Set number formatting.
• Read and set formulas.
• Configure page setup.
• Adjust page orientation, scaling and paper size.
• Read and write conditional formatting.