Upload Excel Workbook

Prerequisite:

1. WebCalculator is only installed in client PCs. Do not install BC Excel Server 2005 EE client.

2.IE Settings.

3.MS Office XP/2003 Setings.

4.Use IP as Server Name 

Configuring  web.config can set IP as default server name via <add key="DBServer" value="" /> :. 

5.The template of Excel to be upload need to be set "Available on website" in property.

6. Can access MS SQL Server 2000 via Internet or Intranet.

7. Data fetcher, data writer and input criteria are not used in the excel template to be uploaded.

Steps:

1.Click "Upload Excel workbook":

2.Select the excel template to be uploaded:

3.Brose the excel workbook to be uploaded, and click "Open":

4.Click "Upload":

5.Confirm the action:

6.Save the file:

7.Finished.