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
How to return blank on worksheet function errors (Read 1227 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
How to return blank on worksheet function errors
30.10.06 at 09:37:37
 
How to return blank on worksheet function errors
 
Question
SQL*XL user Mike asked the following question:
Upon running the sqlqueryvalue command and requesting a specific row, that may or may not
be available, SQL*XL returns the error that it could not find the row.  Is there any way to suppress/hide the error in the excel cell in the event no row is returned.  Ideally if now row exists, leave the cell blank.  Is this handled via an Excel Function best?
 
Answer
You can specify this in the SQL*XL program preferences. In the Worksheet functions category set Blank on Error to True.
 
Note: A small error prevented the setting to take effect in version 4.1.3. Setting the value to TRUE enables it ok. SQL*XL should accept the value as True and not all upper case. This was fixed in version 4.1.4.
Back to top
 
« Last Edit: 30.10.06 at 20:40:07 by Gerrit-Jan Linker »  

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