|
Programmer's Reference
> ExcelTemplate
The ExcelTemplate Object
The ExcelTemplate object represents a template workbok -
a file created in Microsoft Excel that contains data markers. A
data marker specifies a database column, variable, or array to
insert in the spreadsheet column containing the marker.
To create an instance of the ExcelTemplate object, use,
Set objTemplate = Server.CreateObject("SoftArtisans.ExcelTemplate") Note:
- The ExcelTemplate object supports
Excel's BIFF8 (Excel 97/2000/XP) format only; ExcelTemplate does not support BIFF7 (Excel 95)
format templates, and will not generate BIFF7 format files.
(The ExcelApplication object
can produce either Excel 97/2000/XP (BIFF8) format files
or Excel 95 (BIFF7) format files.)
ExcelTemplate Methods and Properties
| ExcelTemplate Methods |
| AnsiToUnicode |
Converts an Ansi string to a Unicode string. |
| ContentType |
Sets or returns the generated spreadsheet's MIME content type. |
| DataSource |
Sets a data source to bind to template data markers. |
| DecryptPassword |
Set DecryptPassword to decrypt an encrypted template. |
| EncryptPassword |
If you set EncryptPassword, ExcelWriter will encrypt the generated spreadsheet
using RC4 encryption. |
| Open |
Opens an ExcelWriter template spreadsheet. |
| PreserveStrings |
Sets whether ExcelWriter will insert all data source values into the
template as strings or try to convert non-string values (numbers, dates, etc.)
to Excel data types. |
| Process |
Enters database values in the template and generates a new spreadsheet. |
| SpreadsheetsCreatedToday |
Returns the number of spreadsheets ExcelWriter created so far, in a 24 hour period. |
| UnicodeToAnsi |
Converts a Unicode string to an Ansi string. |
Copyright 2007 © SoftArtisans, Inc. All Rights Reserved.
|
