Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Store Excel formulas in the database (Read 5480 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Store Excel formulas in the database
20.03.07 at 17:10:58
 
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;
Back to top
 
« Last Edit: 20.03.07 at 17:12:08 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1