Timeline for How can I access Excel from my backend?
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 27, 2022 at 8:07 | comment | added | LoztInSpace | @DocBrown Correct. Last time I used it there was no VBA support but all native Excel functions were implemented. Of course all solutions will have limitations but unless the OP engages my consultancy services, I'm not going to do a full analysis or speculate on whether they need VBA. :) | |
| Jan 27, 2022 at 6:41 | comment | added | Doc Brown | Sounds interesting, maybe sufficient for the OP. However, I am pretty sure this solution has limits. For example, I guess it cannot evaluate Excel formulas using embedded UDFs (written in VBA), otherwise they must include the full VBA execution environment. | |
| Jan 27, 2022 at 4:36 | comment | added | oligofren | At 200 USD/developer for a year the price is an absolute steal too. | |
| Jan 27, 2022 at 4:30 | comment | added | oligofren | This seems pretty good and actually answers the question! Formula support (absolute and relative references, names, 3D cell references, more than 260 supported functions). The OP never said he needed Excel to do the computations, just hand over the excel document and get the calculations back. This should fit like hand in glove. That being said, if you go this route, you need to have automated testing in place and make good use of Git so that you store all versions of the excel file, as it is a good chunk of the actual application and might break easily without the business dep knowing | |
| Jan 26, 2022 at 9:15 | history | answered | LoztInSpace | CC BY-SA 4.0 |