[Ronald R DiFrango]

i would liek a more robust export facility with the SQL Explorer. At a minimum, I would like to see the column headers as the first row of the “Copy to Clipboard” facility. Also, I would like to export either directly from the result pane to somethign like Excel or XML.

[Riyad Kalla]

I will pass this along, thank you for the suggestion

[bonevich]

By “more robust” can you give me more specifics. I will definitely add what you have here as an enhancement request and we will see what we can do – just would like as much detail as possible,

[Ronald R DiFrango]

Although I like the “Copy to Clipboard” functionality, I need the ability to save it to a file as well. Also, when I perform either the the columns should be the first row of the data. If I had my druthers, either save it as an Excel type file [CSV or ; seperated like the Clipboard functionality] or XML so that I can read it into another app or in my case distribute it out.

[support-jeff]

What do you know about that? The column header export is already there! You have to specifically enable it in the preference page. Go to Window -> Preferences -> MyEclipse -> Editors -> SQL and check the box that says “Export column names” and you are all set. I have left your other requests in bugzilla as enhancements. Maybe we will get to them, maybe not.

[Ronald R DiFrango]

Thanks Jeff. This helps tremendously.

[seade]

Just a few small enhancements to enable decent Excel style csv output would be great.
– Support for a comma delimiter
– If a column value contains the delimiter character then it should be surrounded by double quotes
– If a column value contains double quotes then it should be surrounded by double quotes and double quotes within should be repeated (this might be Excel specific)
– Formatting of dates (yyyy-mm-dd), booleans, etc. can be an issue

Some great classes for dealing with CSV and Excel CSV files can be found at http://ostermiller.org/utils/CSV.html – I seem to recall an Apache commons component being not too far off being able to do this as well (most likely something in commons-lang).

For xml (which I personally am less interested in) Apache Jakarta Torque provides a datadump (maven goal, ant target) for dumping data to xml (disclosure: I am a Torque committer) and I think db-unit might also do the same.

Cheers,

Scott

[Ben Eng]

Jakarta POI works pretty well for writing Excel .xls files. The basic support seems to be there from what I’ve tried.

[support-jeff]

Thanx for the pointers, folks!

[Author]

Posts