The key to maximizing performance is that the spreadsheet data is streamed and operated on immediately without preserving the document model in memory.
Append new worksheets to an existing workbook.
Helps you more easily read, compare and summarize data by organizing it in sections.
Hide data from individual rows and columns that you currently don’t need displayed.
Format cell properties like alignment, font, border and more.
Achieve unified cell appearance with cell styles. Cell styles format multiple cell properties in one go. You can modify an existing one or create your own.
Combine two or more adjacent cells into a single one to center headings, wrap text and outline data.
You can apply a scale factor to the exported document.
Export a document with selection range and specified active cell of the selection.
Choose whether to keep or remove all lines in your worksheet.
Freeze row and column headers to always keep them visible while scrolling down and across your worksheet.
Direct the user’s attention to a particular value or part on the worksheet when they open it.