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.
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.
Execute operations on cells, rows or columns in Excel documents with the help of Range property of the iWorksheet interface.
Manage Tables independently in Excel worksheets, format rows & columns, perform calculations for a specific table range.
Create AcroForm fields, submit data forms to a server, import XML data, and import form data submitted on the client to a PDF.
Validate data by restricting the format and values that can be entered in cells of a worksheet. Create distinct validation scenarios for individual cells or for a range of cells.
Summarize 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.
Create your own custom functions, allowing you to easily create any custom arithmetic logic you may need.
Explore complete code demonstrating how to export sheet/range/shape/chart to image files at server side.
Embed drawing objects like shapes and pictures in the cells of a worksheet. You can insert arrows, lines, charts, slicers, pictures, and general shapes.
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.
GcExcel enables users to annotate worksheets, write comments for cells to add information about the data it contains.
Add pivot table to Excel workbook for data summarization, automatically count, total, or average the data stored in a spreadsheet, and display the resulting summarized data in a second table.
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.
GcExcel provides all the necessary properties and methods required to create a workbook, perform complex operations on the data residing in the spreadsheets and make use of several workbook events that are triggered when called explicitly by the user through code.
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 makes it easy to define Excel templates and generate Excel reports supporting numerous use cases.
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.