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. It is possible to prevent the display of this dialog box, and open the spreadsheet in the browser window. To do this, you will need to,

1. 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.
   
   
   
2. 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.

Copyright © 2003, SoftArtisans, Inc.