Workbook

Workbook is the first object instance you create from a running xlsgen instance.

You can create or open existing workbooks on a storage device using a fully qualified filepath (hard drive, remote directory, ...) or in memory.

Starting with a workbook, you can create an arbitrary number of worksheets.

There are a number of options available from the IXlsWorkbook object interface :

• FactorizedStringsMode : stores the same label only once (smaller Excel files)
• FactorizedFloatsMode : tries to factorize adjacents floating-point values (smaller Excel files)
• StyleOption : defines whether altering an existing workbook should affect the style and the content simultaneously.
• FormulaLanguage : sets the locale language to use for reading and writing formulas. xlsgen supports English and French.
• IgnoreErrorNumberAsText : in Excel itself, avoids showing a green triangle in the top-left corner of cells where a number is stored as a string. Applies to Excel XP and above only (it will not cause crashes in earlier Excel versions).
• CalculationOptions : defines the behavior of the calculation engine, particularly in regards to the retained mode (auto-recalc).
• ExcelTargetVersion : sets the version of Excel to target. It is useful with formulas if you'd like to avoid that Excel brings a user prompt when closing a document.
• Workbook properties : lets you read and write the document summary properties such as the Author, Title, Date, ...
• Named Ranges : lets you retrieve and edit existing named ranges.
• EnforceDataValidation : enables/disables the enforcement of data validation rules when data is added in the spreadsheet.
• AutoAdjustDefinedNames : enables/disables the auto-adjusting of defined names when new data is added to rows or columns. The adjusting mechanism works by monitoring whenever data is added in rows just below the range of a defined name, or a column just on the right of the range of a defined name. The adjusting simply inflates the range to include said data.
• Arabic : allows to set whether or not the spreadsheet should use the Arabic user interface (right-to-left).
• AutoOpenExternalWorkbookReference : enables/disables the automatic opening of external workbooks whenever formulas need it.