File Operations

GcExcel .NET allows users to export (save) data from a spreadsheet into several different file types (.xlsx, .xlsm, .xltx, .csv, .pdf, .json, and .sjs files) and import data (open) files from several different file types (.xlsx, .xlsm, .xltx, .csv, .json, and .sjs files) into GcExcel .NET. Using code, you can save the whole component, a particular sheet, or data from a particular range of cells to several different file types or streams.

Information related to the UID attribute for worksheets, tables, table filters, and table columns in Excel I/O will be added.

Refer to the following procedures to handle file operations for a range of file types in GcExcel.NET:

• Import and Export .xlsx Document

• Export to PDF

• Export to a HTML File

• Import and Export CSV File

• Import CSV File with Custom Parser

• Import and Export CSV File with Delimiters

• Import and Export JSON Stream

• Import and Export SpreadJS Files

• Import and Export Macros

• Import and Export Excel Templates

• Import and Export OLE Objects

• Convert to Image

• Import and Export Excel Options

Note: While exporting a worksheet to PDF, HTML or image file formats, you can set the HorizontalAlignment enumeration to CenterContinuous to center align the text across multiple cells. However, the horizontal alignment should be set before merging the cells. Otherwise, the cells may be drawn incorrectly in exported file formats.