
		Forums Knowledge Base OfficeWriter Online


	This documentation is for OfficeWriter v3.7.1 ASP/COM Platform View Docs for Another Version or Platform

Programmer's Reference > ExcelTemplate > Open

Open Method

Syntax:

Public Void Open(FileName As String)

Description:

Opens an ExcelWriter template spreadsheet - a file created in Microsoft Excel that contains data markers where values will be inserted. A data marker is a cell value beginning with "%%=" that specifies a database column, variable, or array to insert in the spreadsheet column containing the marker.

The Open method takes one parameter, the file path and name of the template .xls file to open.

Example:

objTemplate.Open "c:\templates\template.xls"

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.