The majority of data on the web is arranged in rows and columns, and Excel spreadsheets are the most common, familiar way for storing, analyzing, calculating, sorting, and arranging data. If you're looking for a high-speed solution to handle budgets, transactions, profit & loss statements, and profitability analyses, you likely need more power than a basic web app can provide. The new GrapeCity Documents for Excel, a high-speed, small-footprint spreadsheet API based on VSTO for .NET Core, supports most Excel features and allows you to deploy on Windows, Mac, Linux, and Azure.
The feature set helps you work with a variety of features like importing spreadsheets, calculate data, query, generate, and export any spreadsheet, add sorting, filtering, formatting, conditional formatting and validate data, add grouping, sparklines, charts, shapes, pictures, slicers, comments, hyperlinks, themes etc. In addition, you can import existing Excel templates, add data and save the spreadsheets back.
You can also use GrapeCity Documents for Excel together with Spread.Sheets, another Spread product that is included in SpreadJS. GrapeCity Documents for Excel works on the server side to import and export Excel template files. Spread.Sheets works in the browser (client side) as a viewer or editor. Learn more about Spread.Sheets.
With Documents for Excel, you can create spreadsheets like:
Take your pick:
As Documents for Excel supports .NET Core, it acts as a cross-platform solution, which means that you can generate and work with Excel spreadsheets using a single code base that can run across .NET Core, Mono, .NET Framework and Xamarin platforms.
Documents for Excel is fast. The lightweight architecture makes it an efficient tool that offers high performance and memory efficiency while generating or working with Excel spreadsheets.
In order to work with spreadsheets and modify data, you need to access the range of data. Documents for Excel supports following operations when working with range of cells:
Intuitive, attractive spreadsheets are a must in professional enterprize apps. This Excel API includes:
Depending upon the information on the cells, you can add conditional formatting or highlight your cells based on some rules. If the cell values match the rule, formatting can be applied. The following conditional formatting rules can be applied on the range of cells:
Tables help you to organize data in rows and columns, and you can assign a range of data to the table. These operations are supported for tables:
With Documents for Excel, you can restrict the data entered into the cells by applying data validations like whole number, decimal, list, date, time, text length, and custom. This also helps in generating spreadsheets with fewer errors!
The most powerful feature of Excel is the ability to add formulas to the data that can recalculate the results for you even if you change the data. Documents for Excel helps you replicate the same advantages, and you can apply these formulas to your spreadsheet:
Grouping is a vital tool in organizing and analyzing data; it helps you summarize your data and easily navigate it. Documents for Excel provides these methods to group your data:
Documents for Excel supports all the standard settings for determining how to print your spreadsheets, including:
Filtering is a must in spreadsheets, and Documents for Excel API supports filtering on number, text, color, icon, and date.
In addition to filtering your data, you can also sort your data in multiple ways with Documents for Excel. You can sort on value, font color, interior, icon, or create a custom sorting list. This can help you identify the information faster as the data before you is sorted in the order you choose.
Documents for Excel provides the ability to add sparklines, mini charts within the boundaries of a cell that show trends for increase or decrease of values over a year. Line, column and win/loss are the sparklines supported by Documents for Excel.
Documents for Excel provides comprehensive API for adding charts to your spreadsheets. There are 50+ chart types that you can use with detailed chart properties. You can
To enhance your data in the spreadsheet, you can add drawing objects in the form of shapes and pictures with Documents for Excel. You can insert arrows, lines, charts, slicers, pictures, and general shapes. In addition, you can fill shapes, add text to them and set the line styles on them. You can also add, delete, cut, copy and duplicate pictures.
Slicers make it easier and faster to apply filters to tables and pivot tables. While you can filter data with standard filtering capabilities of Documents for Excel, slicers are more kind of visual filter to slice data you exactly want to see. You can:
You cannot put every type of information on your spreadsheets. Sometimes, you want to review the data and add comments for any modifications, or want to add notes, or put short summaries over data etc. With Documents for Excel, you can -
Sometimes, you need to go beyond than just having a table, calculations and formulas and extract significance from a larger data set. Without explicitly setting formulas to perform the calculations you can play around with different arrangements of data and summarize values. You can do following to work with pivot tables using Documents for Excel:
You don't need to apply specific formatting on your cells, but can make use of several in-built themes to change the way how your spreadsheets look using just one simple line of code. You can also build your own custom themes or change existing workbook themes to apply on your spreadsheets.
All above features can be worked upon through the workbook class. You use these functions with a workbooks:
Save to Excel file
Save to Excel file with password
You can add several worksheets and arrange data in it with Documents for Excel. These functions are possible to use with worksheets:
If you have an existing template and just want to modify data, you can load it in Documents for Excel, modify the data, and save it back. This provides an added advantage to working with Documents for Excel because you can create even more advanced spreadsheets by loading such templates and just modify data in it.
While Documents for Excel can help in import and export of Excel templates, in order to finally view or edit data in browser, you can use Documents for Excel with the Spread.Sheets control. Here's how to use it:
One of the most essential aspects when working with documents is to finally convert it to PDF for long term storage, because this is one format that adds security, data preservation for long-term archiving. With Documents for Excel API, you can directly save a workbook to PDF without creating an Excel file first. These export features are supported:
Help us evaluate GrapeCity Documents for Excel and let us know what you think about the library? Please leave a comment with us and we 'll get back to you. Thanks!