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
Query results in pre-formatted template (Read 2648 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Query results in pre-formatted template
19.06.06 at 13:55:35
 
Query results in pre-formatted template
 
SQL*XL use Shyam from Australia asked the following question.
 
Question:
The SQL*XL software does not retain our preset worksheet formats for the reports. Can SQL*XL put data into the spreadsheet and use the exiting cell formats?
 
Answer:
Yes it can. Choose in the resultset options dialog to not apply any formatting.  
See this page for information about the options on SQL*XL's resultset options dialog:
http://www.oraxcel.com/projects/sqlxl/help/dialogs/resultset_options/index.html
 
You are correct that SQL*XL applies its own formatting to the data. If you would not like SQL*XL to do that specify to not let SQL*XL apply any formatting on the data. This way you can format the sheet and let SQL*XL only dump the values into the cells.
Back to top
 
« Last Edit: 21.06.06 at 14:14:58 by Gerrit-Jan Linker »  

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