Seamlessly import and export Excel-compatible XLSX files with no Excel dependency
Create, import, export, use passwords, add sheets, cut and copy ranges, copy and move worksheets, activate, configure, delete, protect, and add iterative calculations.
GcExcel introduces new templates support with comprehensive syntax and API to bind Excel documents to data and generate Excel reports with advanced layouts. With flexible syntax and easy notations for data expansion and formulas, the new template syntax and API will make it easy to define Excel templates and generate Excel reports supporting numerous use cases.
Use hundreds of built-in functions and operators to perform complex calculations, add external formulas, or build your own custom functions and create what you need
Create, parse and modify formulas with GrapeCity.Documents.Excel.
Expressions namespace to parse the formula expressions into syntax tree.
Create, initialize and use the FontCollection class to manage and use when rendering texts to PDF documents.
GcExcel provides many properties for fill, borders, and formatting to customize the appearance of a range.
Create conditional formatting rules for individual cells or a range of cells based on cell values.
Validate data by restricting the information format and the values that can be entered in cells of a worksheet. Create distinct validation scenarios for individual cells or for a range of cells.
Create and use 450+ in-built functions formulas that let you calculate the value of a cell quickly and accurately. You can also use built-in functions and operators to generate formulas and calculate values in cells.
Summarise large amounts of information in groups so that complex spreadsheets are easier to navigate. You can expand and collapse details with the click of a button in the group header row.
GcExcel supports one-way data binding with cell, sheet and Table binding in Excel spreadsheets.
Specify page setup attributes (left margin, bottom margin, paper size, and so on) on Excel workbook.
GcExcel provides the Sort method to perform data sorting based on a range of cells, range by value, color or icon in a worksheet. The Apply method is used to apply the selected sort state and display the results.
Add a picture to a worksheet, use the AddPicture method of the worksheet's Shapes collection to create, delete, cut, copy and duplicate pictures in the worksheet.
Slicers are visual filters that you can use to filter a table or pivot table. GcExcel supports adding both built-in and custom slicer styles in Excel workbook.
Export spreadsheet directly to HTML files with various Html options to preserve the formatting of Excel content into HTML files.
GcExcel provides you with a set of built-in themes so you can quickly change the overall appearance of a workbook. It also lets you create custom themes and apply them to workbooks.
Explore complete code demonstrating how to generate an Excel file, or you may have your own Excel files and just want to open and update some of its contents at server side.