Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Print EDB table with Excel
Thu, May 31 2018 11:04 PMPermanent Link

Shedden

Hi All,

I like to put procedures in database tables. I didn't find a table print in EDBManager and I'm used to having it in dbsys. I could have missed it, but this hack seems to suffice. There is a script for a test table attached. I used Excel 2016. There might be a limitation on the number of rows, but for what I need it's good enough.

Export the table to XML with EDBManager

Open a new workbook in Excel 2016

On the data tab select
 From other sources
 From XML import
 Select the exported file
 Ignore the schema warning click OK

In the worksheet
 delete the rows that aren't blank in col A (keep header row)
 delete col A
 
Format (to your liking)
 Cell alignment to top
 Increase cell boundary density
 
Print

Have Fun!
Jim S.



Attachments: edbToExcelTestTable.SQL
Mon, Jun 4 2018 2:42 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jim,

<< I like to put procedures in database tables. I didn't find a table print in EDBManager and I'm used to having it in dbsys. I could have missed it, but this hack seems to suffice. There is a script for a test table attached. I used
Excel 2016. There might be a limitation on the number of rows, but for what I need it's good enough. >>

Cool, thanks !

Tim Young
Elevate Software
www.elevatesoft.com
Tue, Jun 5 2018 5:49 AMPermanent Link

Adam Brett

Orixa Systems

Thanks Jim

Note that you can also EXPORT from EDB to CSV format, and Excel is very happy to open this as a basic rows and columns spreadsheet.

I use this a lot.
Thu, Jun 14 2018 10:39 PMPermanent Link

Shedden

Hi Adam,

The CSV was my first attempt, but it didn't seem to like dealing with the CLOB data. With the XML, I didn't have to worry the CLOB contained quotes, commas, newlines, or other things that would affect the CSV.

All the best,
Jim S.
Image