Linker IT Software
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
SQLQueryValue worksheet function improved (Read 4547 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
SQLQueryValue worksheet function improved
13.02.07 at 16:29:10
SQLQueryValue worksheet function improved
The SQLQueryValue worksheet function was improved to:

  • Do not display function errors where there is no data in the returned rowset.
    Example. Hitherto when the array formula SQLQueryValue was applied to a larger range of cells than there was result data, Excel showed the error #N/A. This error will not show anymore. When there is no data to display, SQL*XL will display a blank cell.
  • Transpose option added
    You can now optionally transpose the resulting rowset. When you transpose the recordset rows will be displayed in columns. This may be handy when you display results vertically.
  • Row limit removed
    Hitherto the SQLQueryValue worksheet function was limited to display 50 rows. Now this limit was removed.

New syntax for the worksheet formula:
SQLQueryValue( select_statement [, transpose] [, rownum] )
=SQLQueryValue("select * from emp") -- Display the contents of the emp table
=SQLQueryValue("select * from emp" , True) -- Tranpose the rowset. Rows are columns
=SQLQueryValue("select * from emp", False, 10) --Show from row 10. Do not transpose
=SQLQueryValue("select * from emp", , 10) --Same as above. Empty transpose will default to False.
Note that you need to type True or False in your own language, e.g. WAAR and ONWAAR in Dutch.
This feature will be released as SQL*XL 4.1.11
Back to top
« Last Edit: 13.02.07 at 16:29:38 by Gerrit-Jan Linker »  

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