Import and Export Excel Using C#
Seamlessly import and export Excel-compatible XLSX files without Excel dependency
Workbooks and Worksheets
Create, import, export, use passwords, add sheets, cut and copy ranges, copy and move worksheets, activate, configure, delete, protect, and add iterative calculations.
Formulas (450+ C# Excel Functions) and Custom Functions
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
Excel Formula Parser
Create, parse and modify formulas with GrapeCity.Documents.Excel.
Expressions namespace to parse the formula expressions into syntax tree.
Range Operations
Execute operations on cells, rows or columns in C# Excel documents with the help of Range property of the iWorksheet interface.
Dynamic Array Formulas
Use 7 new Dynamic Array Formula functions to return multiple values on a range of cells.
Spreadsheet Formatting Options
GcExcel provides many properties to customize the appearance of a range in your .NET Excel spreadsheet.
C# Excel Tables
Manage Tables independently in Excel worksheets, format rows & columns, perform calculations for a specific table range.
Forms
Create AcroForm fields, submit data forms to a server, import XML data, and import form data submitted on the client to a PDF.
Conditional Formatting
Create conditional formatting rules for individual cells or a range of cells based on cell values.
Data Validation
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.
Grouping
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.
Graphics
Use linear and radial gradient brushes.
Cell Rich Text
Apply rich text formatting in the cells of the worksheet.
Custom Excel Functions
Create custom functions, allowing you to easily create custom arithmetic logic you may need in your .NET app.
C# Excel Data binding
GcExcel supports one-way data binding with cell, sheet and Table binding in .NET Excel spreadsheets.
Find and replace
Find and replace text in Excel workbook with different options.
Image Exporting
Explore complete code demonstrating how to export sheet/range/shape/chart to image files at server side.
Page Setup
Specify page setup attributes (left margin, bottom margin, paper size, and so on) on Excel workbook.
C# Excel to PDF Exporting
Export Excel .xlsx spreadsheets to PDF at server side with various PDF options.
Filtering
GcExcel supports all types of filters which you can apply on selected range of data.
Charts
GcExcel provides a comprehensive charting API to add charts in Excel.
Shape
Embed drawing objects like shapes and pictures in the cells of a worksheet. You can insert arrows, lines, charts, slicers, pictures, and general shapes.
Picture
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.
Excel Slicer
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.
Comments
GcExcel enables users to annotate worksheets, write comments for cells to add information about the data it contains.
Pivot Table
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.
Hyperlinks
Export spreadsheet directly to HTML files with various Html options to preserve the formatting of Excel content into HTML files.
Theme
Our .NET Excel API provides you with a set of built-in themes so you can change the appearance of a workbook. It also lets you create custom themes and apply them to workbooks.
Workbook
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.
C# Excel Templates
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.
SpreadJS Viewer
Examples in this folder demonstrate how to use GrapeCity Documents for Excel and SpreadJS. GrapeCity Documents for Excel works on the server side to import and export Excel template files. SpreadJS works in the browser (client side) as a viewer or editor.
SpreadJS Feature Support
GcExcel adds support for SpreadJS features adding more compatibility with the client-side SpreadJS product. View complete supported features list here.
Showcase
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.
Quick Start
In this tutorial, we create a real-life scenario with GrapeCity Documents for Excel to give you a fundamental understanding of what our .NET Excel API can do.
Import data
New ImportData() function to import just the data from Excel files without loading the whole object model.
Threaded comments
Add reply, delete threaded comments, move to next comment, move to previous comment and more such operations
Linked Picture (Camera shape/snapshot)
A linked picture can be created to the actual data/table/chart in your final dashboard.
Workbook views
Programmatically set three predefined views, Normal, Page Layout and Page Break Preview.
Print Excel file to printer (Windows)
Directly print Excel file to printer using interfaces IWorkbook. PrintOut and IWorksheet.PrintOut
Featured Blogs
Featured Videos
