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
column headings as row headings (Read 2847 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
column headings as row headings
30.10.06 at 20:47:27
column headings as row headings
SQL*XL user Doug sent in the following question.
I did something really stupid in the SQL*XL setups, somewhere. The column headings are row headings, and I can’t move them back where they belong as column headings.
You are looking for the transpose option. In the SQL*XL resultset options screen you can set this option. In the corresponding program preferences screen you can save this setting.
Transpose means that you get columns for rows. Each column in Excel contains a row, the column headers will also be placed vertically in Excel as a column. Data from the database will be placed as columns in Excel. This can be handy when you have a lot of columns and not too many rows.
Back to top

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