need one help for finding technical approach for below requirement. Technical requirement: We have excel templates where business calculations are maintained in excel formulas. Template has 2 types of cells. Type 1 where values are replaced from application and type 2 which has formulas to do calculation on type 1 cells. We want solution that will read values, formula of all excel and load type 1 values and parse excel formulas and perform calculation. We are basically looking for excel formula parser who will parse and calculate excel formula outside excel efficiently.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip