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
Explicitly formatting data (Read 2951 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Explicitly formatting data
03.06.07 at 22:31:24
Explicitly formatting data
Retrieving results from SQL select statements into Excel, SQL*XL will apply default data formatting. Most of the options of the data formatting can be changed in the formatting preferences but you may still have the need to change how SQL*XL formats certain data. For this you can use the explicit formatting functions.
The formatting functions are SQL*Plus like commands that can be run directly from the SQL dialog along with other SQL commands. The commands that are supported in SQL*XL are:  
column <column_name> format <format_spec>;
column <column_name> format <cell_reference>;
column <column_name> heading <heading_text>;
The column format function will explicitly format a column to a certain format specification. Example: column sal format " ###,##0.00";
Further reading:
Back to top
« Last Edit: 04.06.07 at 07:45:14 by Gerrit-Jan Linker »  

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