
		Forums Knowledge Base OfficeWriter Online


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

ExcelTemplate in Depth > Output Options

Output Options

Using the ExcelTemplate object's Process method, you can,

Save a spreadsheet to disk.
Stream the spreadsheet to the client and open it in Excel.
Stream the spreadsheet to the client and open it in the browser. In this case, Internet Explorer's menus and toolbars will be replaced with Excel's.
Return the spreadsheet as an ExcelApplication object. The spreadsheet can then be modified using ExcelApplication's objects, methods, and properties. See Passing ExcelTemplate to ExcelApplication. *

*This feature is not available in ExcelWriterSE.

ExcelTemplate's Process method takes three parameters:

ExcelTemplate.Process Parameters

FileName Path and file name of the new spreadsheet

ProcessMethod

Optional. Specifies whether to save the file to disk, open it in Excel, open it in the browser, or return an ExcelApplication object. Assign ProcessMethod by name or number:

`0`	`saProcessDefault`	Save the file to disk
`1`	`saProcessOpenInExcel`	Open the file in Excel
`2`	`saProcessOpenInPlace`	Open in the browser
`3`	`saProcessOpenForScripting`	Return the file in memory as an ExcelApplication object. The spreadsheet can then be modified using ExcelApplication's objects, methods, and properties. See Example 2: Using ExcelTemplate with ExcelApplication. Note: This value is not available in ExcelWriterSE and ExcelWriterLE.

Default value: 0

ExcludeMacro Optional. If set to True, macros in the template will be excluded from the generated spreadsheet.

When ExcludeMacro is enabled, buttons associated with macros may produce the error "Data may have been lost." Therefore, when excluding macros, remove all associated buttons from the spreadsheet. Default value: False