Output Options for ExcelApplication

Using the ExcelApplication object's Save methods, you can:

Save to Disk

To save the generated file on the server, call one of the following methods:

fileName specifies a complete physical path and file name for the generated file. ExcelWriter will save the file to this location. If a file with the same name exists, it will be overwritten by the new Excel file.

Example

Stream to Client

To stream the generated file to the client, call one of the following methods:

Browsers other than Internet Explorer cannot embed an Excel file in the browser window. When the generated spreadsheet is streamed to a browser other than IE, the user will always be prompted to open or save the file. If the user chooses to open the file, it will open in Microsoft Excel or another spreadsheet application.

Internet Explorer can display an Excel file in the browser window. When the generated spreadsheet is streamed to Internet Explorer, the browser's settings will determine whether the file opens automatically or the user is asked to open or save the file. The parameter openInBrowserdetermines whether the file will open in IE or in a spreadsheet application. If openInBrowser is set to true, the response content-disposition header is set to open the file in the browser window.

Example

Write to Stream

To write the generated spreadsheet to a System.IO.Stream, call the following method:

Example

Return a Template

You can use ExcelApplication to create a spreadsheet with data markers (i.e., a template) and pass the spreadsheet to ExcelTemplate to populate the data markers. In this case, do not call Save. Instead, pass your Workbook object to ExcelTemplate's Open method:

Example