G
Guest
Is it possible to utilize MS Excel 2003 on a shared server?
I have designed a web application that I am trying to now launch. I signed
up with a host that I am using. I have never ran a web page before, but have
been developing my web application over the last two years. My web
application allows member users to log in to the site, and access a number of
financial calculators. Once they select the desired financial calculator
that they would like to access, an applicable form for that calculator opens
up. The user has a number of fields that they must fill in to get the
results of the calculator. Once the user has filled out the required form
fields they click on a submit button. At that point, the following steps are
performed:
1) The information that the user has entered in the form is transmitted to
an xml file. Each field corresponds to a particular variable in the xml file.
2) Next, the server runs a command that opens up MS Excel on the server,
not on the user's machine. The user does not know that Excel is being
opened, it is only done on the server side. Once excel is opened, a specific
excel workbook is opened. The workbook is opened for the particular
calculator that the user is using. Once the workbook has opened, a macro
runs that imports all of the variables from the xml file to the xml variables
mapped cells in the excel workbook. Once the variables are imported, the
excel workbook calculates the results.
3) Next, the server reads all of the result cells from the excel file and
returns the results back to the server. These results are then passed
through the web page back to the user.
The user never knows or sees MS Excel opening. It is only utilized for the
calculations by the server.
The host that I am currently utilizing along with other shared web hosts
that I have talked to say that it is not possible to have MS excel installed
on a shared server, and that I would not be able to use MS excel from a
shared server, that the only way I could possibly utilize excel would be
through a dedicated server. I am trying to decide whether or not I should
continue to pursue the possibility of using the method that I described
above, or if I should re-code my calculators to do everything within the web
file.
I would appreciate any feedback or advice.
Thank you,
Ryan
I have designed a web application that I am trying to now launch. I signed
up with a host that I am using. I have never ran a web page before, but have
been developing my web application over the last two years. My web
application allows member users to log in to the site, and access a number of
financial calculators. Once they select the desired financial calculator
that they would like to access, an applicable form for that calculator opens
up. The user has a number of fields that they must fill in to get the
results of the calculator. Once the user has filled out the required form
fields they click on a submit button. At that point, the following steps are
performed:
1) The information that the user has entered in the form is transmitted to
an xml file. Each field corresponds to a particular variable in the xml file.
2) Next, the server runs a command that opens up MS Excel on the server,
not on the user's machine. The user does not know that Excel is being
opened, it is only done on the server side. Once excel is opened, a specific
excel workbook is opened. The workbook is opened for the particular
calculator that the user is using. Once the workbook has opened, a macro
runs that imports all of the variables from the xml file to the xml variables
mapped cells in the excel workbook. Once the variables are imported, the
excel workbook calculates the results.
3) Next, the server reads all of the result cells from the excel file and
returns the results back to the server. These results are then passed
through the web page back to the user.
The user never knows or sees MS Excel opening. It is only utilized for the
calculations by the server.
The host that I am currently utilizing along with other shared web hosts
that I have talked to say that it is not possible to have MS excel installed
on a shared server, and that I would not be able to use MS excel from a
shared server, that the only way I could possibly utilize excel would be
through a dedicated server. I am trying to decide whether or not I should
continue to pursue the possibility of using the method that I described
above, or if I should re-code my calculators to do everything within the web
file.
I would appreciate any feedback or advice.
Thank you,
Ryan