I have a project I'm working on and it entails converting an EXCEL file to PHP.
There are over 30,000 formulas on the spreadsheet.
I want to convert the formulas to PHP, and use my file on a server. I am not interested in seeing the spreadsheet, just need the formulas converted.
Is there a program out there that can convert EXCEL formuals to PHP.
Here are some examples:
$HA$49 =AVERAGE(GY49:GY55)
$HB$49 =IF(GW49<0,(((E49+F49)/2)-F49)*GW49+(E49+F49)/2,(E49-(E49+F49)/2)*GW49+(E49+F49)/2)
$HC$49 =((GY49-HC50)*0.5)+HC50
$HD$49 =((GY49-HD50)*0.1818)+HD50