ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using Excel as a Server for Web Application (https://www.excelbanter.com/excel-programming/297424-using-excel-server-web-application.html)

John[_83_]

Using Excel as a Server for Web Application
 
Dear all

Maybe the question looks like stupid but ..
Indeed, we have some Excel Worksheet which store some complex product configuration.
Some logic has been built into those worksheet so as to calculate the price of our products
The data and business rules are of course very complex

We want to build a Web application for our Sales so as they can quote the products they are selling
Instead of redevelopping the whole logic, reinventing a logical and physical data model, implementing the business rules which anyaway will change many time in a year, I think we should better build a web form by which the Sales can enter the 10 parameters needed to describe the products and on the server side feed the Worksheet with those data to get the price
Indeed, it is as if we will use an Excel Form as server application

The issue is that I am totally ignorant of MS technologies. Do you know if this is at all possible
Could you give me some ideas of how to implement this in a robust and scalable way

Thanks a lot

John


All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com