Gerrit-Jan Linker
|
Store Excel formulas in the database Using SQL*XL you can store Excel formulas in the database. Simply store them as varchar data. To retrieve the formulas you can use the as formula syntax and you must not forget to switch off the formatting. Otherwise SQL*XL will format the formulas as text which will lead to the text of the formula to be displayed instead of the function result. Example: Create a test table: create table formulatest (f varchar2(255)); Insert some formulas: insert into formulatest (f) values ('=A1'); insert into formulatest (f) values ('=A1*B2'); insert into formulatest (f) values ('=mycellname'); Now query it into Excel (remember to not format the results): select f as formula from formulatest;
|