Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

Icon

When ExcelWriter streams a file to the client, the output result will depend on the browser as well as the server-side script.

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

  • No labels