Streams the specified workbook to the client. It should be the only method that uses the response object, as it automatically sets response headers, clears the body of the response, and flushes it to the client.

 public virtual void Save(Workbook workbook, System.Web.HttpResponse response, System.String fileName, boolean openInBrowser)
Public Overridable Sub Save(ByVal workbook As Workbook, ByVal response As System.Web.HttpResponse, ByVal fileName As String, ByVal openInBrowser As Boolean)

A Workbook object representing the workbook to save.

A object, usually Page.Response.

Specifies a file name for the workbook. This name will be displayed in the download dialog when the file is streamed to the browser.

If true, the spreadsheet will be opened in place in Internet Explorer, rather than spawning a seperate Excel window.

If there is an error obtaining the response stream from the Response object.

If the extension of the filename given is invalid for the given workbook. For example, a file created with Excel 2007, that has macros must be saved with the .xlsm extension

ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();

//--- Do something here
xla.Save(wb, Page.Response, "generated.xls", false);
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Create()

'--- Do something here
xla.Save(wb, Page.Response, "generated.xls", False)