GcExcel provides a way to visualize data at the cell level with SparklineEx. The Apply method is used to apply the selected sort state and display the results. GcExcel provides the Sort method to perform data sorting based on a range of cells, range by value, color or icon in a worksheet. GcExcel supports all types of filters which you can apply on selected range of data. GcExcel supports features to interact with SpreadJS (a comprenehsive enterprise JavaScript solution developed by GrapeCity) by json in a lossless way. GcExcel allows users to add digital signatures to Excel spreadsheets to make them authentic and easier to validate. PivotCharts are also interactive, allowing users to filter and sort the underlying data. PivotCharts provide graphical representations of the data in their associated PivotTables. GcExcel allows you to create a PivotChart in the worksheet. xlsx spreadsheets to PDF at server side with various PDF options. Specify page setup attributes (left margin, bottom margin, paper size, and so on) on Excel workbook.Įxport Excel. A JSON file can also be used as the data source of a GcExcel Template. NET supports the import and export of a json stream using. GcExcel allows users to export a workbook, worksheet, or any specific range to an HTML file making it convenient to publish and share spreadsheet data on a website.Įxplore complete code demonstrating how to export sheet/range/shape/chart to image files at server side. GcExcel supports Form Controls, like buttons, check boxes, drop downs and more, to collect and present data in your spreadsheet. GcExcel supports one-way data binding with cell, sheet and Table binding in Excel spreadsheets.įind and replace text in Excel workbook with different options. Create and use 11 types of barcodes to enable scanning information easily and quickly within your PDF template.Īpply rich text formatting in the cells of the worksheet.Ĭreate your own custom functions, allowing you to easily create any custom arithmetic logic you may need. GcExcel provides API to add barcodes in worksheets. You can expand and collapse details with the click of a button in the group header row. Summarise large amounts of information in groups so that complex spreadsheets are easier to navigate. You can also use built-in functions and operators to generate formulas and calculate values in cells. Create distinct validation scenarios for individual cells or for a range of cells.Ĭreate and use 450+ built-in functions formulas that let you calculate the value of a cell quickly and accurately. Validate data by restricting the information format and the values that can be entered in cells of a worksheet. Manage Tables independently in Excel worksheets, format rows & columns, perform calculations for a specific table range.Ĭreate conditional formatting rules for individual cells or a range of cells based on cell values. GcExcel provides many properties to customise the appearance of a range. In this tutorial, we create a real-life scenario with GrapeCity Documents for Excel to give you a fundamental understanding of what it can do.Įxecute operations on cells, rows or columns in Excel documents with the help of Range property of the IWorksheet interface. FeatureĮxplore 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. Each main feature demo link listed below contains several demos that show how to use a particular feature.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |