开发者

Convert Excel spreadsheet to PHP script

开发者 https://www.devze.com 2023-01-12 16:48 出处:网络
I have an excel spreadsheet that contains some formulas to calculate ROI for an upcoming product of a client. Is it possible to convert this into a php script whereby a user would type into some boxes

I have an excel spreadsheet that contains some formulas to calculate ROI for an upcoming product of a client. Is it possible to convert this into a php script whereby a user would type into some boxes and then submit it working out the same. The ex开发者_如何学JAVAcel spreadsheet is here: http://www.solidcamxpress.co.uk/roi.xls


Sure, PHP can do math just like Excel's formulas. However, there is no magic method of converting Excel to a Web page, if that's what you're asking.


@Cameron

There is a software in the market which can convert the spreadsheet to active html/php with ease. You can get the software at the following url:
http://www.spreadsheetconverter.com

Even you can also convert the spreadsheet by yourself as it is simple to convert with scripts. but you can also this software for the conversion =)


You can use PHPExcel to read an existing spreadsheet and extract its data/formulas, but converting those formulas from Excel syntax to PHP is rather non-trivial.

Unless you're doing a generalized Excel->PHP converter, the time/effort required to write such a converter will be far greater than it would take you do analyze the one spreadsheet by hand and code up some PHP stuff to recreate it.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号