
		Forums Knowledge Base OfficeWriter Online


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

Installation > Configuring IIS

Configuring IIS

When a spreadsheet is streamed directly to the client (rather than saved on the Web server's hard disk), an "Open or Save" dialog box will open in the browser. With Internet Explorer, it is possible to prevent the display of this dialog box, and open the spreadsheet automatically in the browser window. To do this, you will need to:

Associate Excel's xls extension with asp.dll when configuring your virtual directory:
1. Open the Internet Services Manager.
2. Right click the virtual directory containing your ExcelWriter scripts, and select Properties.
3. Click Configuration. If the Configuration button is disabled, first click Create.
4. Select the App Mappings tab.
5. Click Add.
6. Browse to select asp.dll, typically in c:\winnt\system32\inetsrv.
7. Enter xls in the Extension text box.
8. Select "All Verbs."
9. Check "Script Engine."
10. Do not check "Check that file exists."
11. Click Ok.
Rename your ExcelWriter scripts with the extension .xls. For example, at the DOS command prompt, enter, "ren xlgen.asp xlgen.xls."

If you associate the xls extension with asp.dll within the settings of a virtual directory, do not save standard Excel spreadsheets in this directory. If you do, ASP will attempt to interpret these Excel spreadsheets as ASP script and fail.

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.