|
|
Document Settings
Essential XlsIO can work with spreadsheets that are stored as streams and can also save to a stream.
|
|
|
|
Essential XlsIO supports reading of an XLS workbook from a stream and also writing a workbook to a stream.
The ability to write a workbook to a stream lets you create workbooks in-memory and transmit them via emails or save them in a database. All these can be achieved without having to write any intermediate files to disk and this improves performance greatly.
Sample Code-Open and Save Document Using Stream
|
|
|
|
The built-in document properties such as Application Name, Document Title, Category, Keywords and Company can be specified for a document using Essential XlsIO. It is also possible to set custom document properties.
Sample Code-Set Document Properties
Document Properties in MS Excel
|
|
|
|
|
|
|