API Reference Document Solutions Data Viewer Features Sort Conditional Formatting Average Rule Cell Value Rule Color Scale Rule Data Bar Rule Date Occurring Rule Expression Rule Icon Sets Rule Top Bottom Rule Unique Rule Data Validations Add Validations Delete Validation Modify Validation Filter Group Outline Subtotals Create Row or Column Group Outline Column Remove a Group Row or Column Group Information Summary Row Styles Create and Set Custom Named Style Set Sheet Styling Barcodes Codabar Code128 Code39 Code49 Code93 Data Matrix EAN-13 EAN-8 GS1-128 PDF417 QRCode Comments Threaded Comments Data Binding Defined Names Digital Signatures Document Properties Form Controls Hyperlinks Import Data Logging Formulas Asynchronous Functions Calculation Mode Cross Workbook Formula Dynamic Array Formulas Formula Functions Formula Parser Iterative Calculation Localized Formulas Precedents and Dependents Set Array Formula Set Formula to Range Set Table Formula What-If Analysis Goal Seek Operation Scenarios Workbook Create Workbook Cut or Copy Across Sheets Enable or Disable Calculation Engine Open and Save Workbook Protect Workbook Workbook Views Worksheet Customize Worksheets Freeze Panes in a Worksheet Freeze Trailing Panes in a Worksheet Range Operations Access a Range Access Areas in a Range Access Cells, Rows and Columns in a Range Auto Fit Row Height and Column Width Auto Merge Cells Cut or Copy Cell Ranges Cut or Copy Shape, Slicer, Chart and Picture Find and Replace Data Get Address of Cell Range Get Intersection, Union and Offset Range Get Range and Range Area Get Row and Column Count Get Special Cell Ranges Hide Rows and Columns Ignore Errors in Cell Range Insert And Delete Cell Ranges Insert and Delete Rows and Columns Measure Digital Width Merge Cells Paste or Ignore Data in Hidden Range Protect Cell Range Set Cell Background Image for Cell Range Set Custom Objects to a Range Set Default Values for Cell Range Set Row Height and Column Width Set Values to a Range Work with Used Range Rich Text Tags Cell Types Range Template Cell Quote Prefix Work with Worksheets Worksheet Views Pivot Chart Print Page Setup Configure Columns to Repeat at Left and Right Configure Page Breaks Configure Page Header and Footer Configure Page Settings Configure Paper Settings Configure Paper Source Configure Print Area Configure Rows to Repeat at Top and Bottom Configure Sheet Print Settings Themes and Colors Chart Chart Sheet Configure Chart Chart Area Chart Title Plot Area Create and Delete Chart Customize Chart Objects Axis and Other Lines Configure Chart Axis Data Table Data Label Floor Legends Series Configure Chart Series Display Empty Cells Display #N/A Values Error Bars Walls Chart Types Area Chart Bar Chart Column Chart Combo Chart Line Chart Pie Chart Radar Chart Specialized Chart Funnel Sunburst TreeMap Statistical Chart Box Whisker Histogram Pareto Chart Waterfall Chart Stock Chart Surface Chart XY (Scatter) Chart Pivot Table Pivot Table Style Create Pivot Table Pivot Table Filter Pivot Table Settings Slicer Add Slicer in Pivot Table Add Slicer in Table Slicer Style Modify Slicer with Custom Style Modify Table Layout for Slicer Style Auto-Filter Table with Slicer Configure Slicer Layout Cut or Copy Slicer Duplicate Slicer Use Do Filter Operation Sparkline Table Add and Delete Table Columns and Rows Table Sort Table Style Modify Table Layout Modify Table with Custom Style Convert Table to Range Create and Delete Tables Modify Tables Table Filters Custom Functions Shapes and Pictures Background Image Control Position of Overlapping Shapes Customize Shape Format and Shape Text Group or Ungroup Shapes Hyperlink on Shape Image Transparency Linked Picture Shape Adjustment Size and Position of Image Getting Started End User License Agreement License Information Quick Start Redistribution Contacting Sales Technical Support Upgrade to Latest Version Key Features File Operations Convert to Image Export to PDF Adjust Column Width and Row Height Configure Fonts and Set Style Control Image Quality Control Pagination Delete Blank Pages From Middle Export Custom Page Information Export Different Headers On Different Pages Export Last Page Without Headers Export Multiple Sheets To One Page Export Specific Pages To PDF Export Worksheet to PDF Keep Rows Together Over Page Breaks Render Excel Range Inside PDF Save Multiple Workbooks to Single PDF Customize Border Style Export Charts Export Slicers Export Barcodes Export Form Controls to Form Fields Export Pivot Table Styles And Format Export Shapes Export Signature Lines Export Vertical Text Shrink To Fit With Text Wrap Support Document Properties Support Security Options Support Sheet Background Image Support Background Color Transparency Track Export Progress Working With Page Setup Export to HTML Import and Export CSV File Import and Export CSV File with Delimiters Import and Export Excel Options Import and Export Excel Templates Import and Export JSON Stream Import and Export from JSON string Import and Export from JSON without Worksheets Import and Export Macros Import and Export OLE Objects Import and Export SpreadJS Files Import and Export .sjs Files Import and Export JSON Files SpreadJS Sparklines Support for SpreadJS Features Import and Export .xlsx Document Import CSV File with Custom Parser Document Solutions for Excel, .NET Edition Overview Release Notes Breaking Changes Release Notes for Version 8.1.0 Release Notes for Version 1.4.0 Release Notes for Version 1.5.0.1 Release Notes for Version 1.5.0.3 Release Notes for Version 1.5.0.4 Release Notes for Version 2.0.0 Release Notes for Version 2.1.0 Release Notes for Version 2.2.0 Release Notes for Version 3.0.0 Release Notes for Version 3.1.0 Release Notes for Version 3.2.0 Release Notes for Version 4.0.0 Release Notes for Version 4.1.0 Release Notes for Version 4.2.0 Release Notes for Version 5.0.0 Release Notes for Version 5.0.3 Release Notes for Version 5.1.0 Release Notes for Version 5.2.0 Release Notes for Version 6.1.0 Release Notes for Version 6.2.0 Release Notes for Version 7.0.0 Release Notes for Version 7.1.0 Release Notes for Version 7.2.0 Release Notes for Version 8.0.0 Release Notes for Version 6.0.0 Templates Create Excel Report using Template Data Source Binding Paginated Templates Pagination Properties and Functions Template Configuration Charts Conditional Formatting Default Values in Template Cells Fixed Layout Global Settings PDF Form Builder Custom Form Input Types Sparklines Tables Template Fields Template Formula Usage Template Properties Cell Context Cell Expansion