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
Excel worksheet functions (Read 4305 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Excel worksheet functions
03.03.06 at 16:07:25
 
SQL*XL Excel worksheet functions are introduced in version SQL*XL 4.0.41.
 
A set of worksheet functions that can be added to your spreadsheet to display database related information are added. For now the following functions were introduced:
SQLQueryValue : to display the result of a query
SQLCreateInsertStatement : to create SQL insert statements from data on your spreadsheet
SQLBindVariable : to display the value of a bind variable
SQLSubstitutionVariable : to display the value of a substitution variable
 
These functions can be added through a new SQL*XL menu item: Insert Function
 
In addition to providing these worksheet functions two calculation commands are added to the SQL*XL menu. With Calculate | Calculate SQL*XL functions you force Excel to recalculate the SQL*XL worksheet functions. With Calculate | Force calculation of all functions you force Excel to recalculate all the formulas in the worksheet.
 
This functionality is introduced in SQL*XL 4.0.41
Back to top
 
 

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