将（重度公式加载的）Excel电子表格转换为用户友好的网络计算器
I need to create a webtool that takes several input values and generates a number of outputs based on complex sequences of arithmetic calculations in an Excel workbook. I am thinking of hard-coding the formulas into Javascript and creating a live-update user input form, but I don't want to waste my time if there is a more efficient way of doing this...I have heard of embedding live spreadsheets in webpages but realize this is only compatible with IE, which is not preferable. Does anyone have suggestions to help get me started?
我需要创建一个webtool,它接受几个输入值,并根据Excel工作簿中复杂的算术计算序列生成许多输出。我正在考虑将公式硬编码为Javascript并创建实时更新用户输入表单,但我不想浪费我的时间,如果有更有效的方法这样做...我听说嵌入直播网页中的电子表格,但意识到这只与IE兼容,这是不可取的。有没有人有建议帮助我入门?
2 个解决方案
#1
2
You would need more than javascript to accomplish this. Despite the web guru naysayers, I made it work. You need IIS and Excel on the server. People are getting hung up on the 2nd requirement, but you have to use what is available. SpreadSheet Gear is an alternative.
你需要的不仅仅是javascript来实现这一目标。尽管网络大师反对者,我还是成功了。您需要在服务器上使用IIS和Excel。人们对第二项要求感到困惑,但你必须使用可用的东西。 SpreadSheet Gear是另一种选择。
But the first question you should ask yourself, do you really need a web front-end? I would explore building your front-end in excel; having a cell mapping tab that maps your UI elements to the cells of your calculator spreadsheet and have a macro copy/paste the contents from one spreadsheet to another.
但是你应该问自己的第一个问题,你真的需要一个网络前端吗?我会探索在excel中构建你的前端;有一个单元格映射选项卡,用于将UI元素映射到计算器电子表格的单元格,并将内容从一个电子表格宏复制/粘贴到另一个电子表格。
The beauty of this set-up is you can run batch through your calculator spreadsheet.
这种设置的美妙之处在于您可以通过计算器电子表格批量运行。