Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General Discussion » View Thread |
Messages 1 to 4 of 4 total |
Print EDB table with Excel |
Thu, May 31 2018 11:04 PM | Permanent 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 Have Fun! Jim S. Attachments: edbToExcelTestTable.SQL |
Mon, Jun 4 2018 2:42 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 PM | Permanent 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. |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |