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 .NET Excel documents with the help of Range property of the iWorksheet interface.
GcExcel provides many properties to customize the appearance of a range in your .NET Excel spreadsheet.
Manage Tables independently in Excel worksheets, format rows & columns, perform calculations for a specific table range.
Create conditional formatting rules for individual cells or a range of cells based on cell values.
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.
GcExcel supports one-way data binding with cell, sheet and Table binding in .NET Excel spreadsheets.
Specify page setup attributes (left margin, bottom margin, paper size, and so on) on Excel workbook.
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.
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 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.
New ImportData() function to import just the data from Excel files without loading the whole object model.
Add reply, delete threaded comments, move to next comment, move to previous comment and more such operations