distal-attribute
distal-attribute
distal-attribute
distal-attribute

Copy table to clipboard, Excel-ready

User, date Message
Written by Dave
4 years ago
Category: Import/Export
24 posts since Fri, 19 Sep 08
Would it be possible now or in a future release to copy tables or query results to the clipboard so that all one would have to do is paste directly into an Excel spreadsheet, and rows and columns would conform properly?

Perhaps I've missed this feature and it is already here.

Thanks very much!smile
Written by ansgar
4 years ago
4789 posts since Fri, 07 Apr 06
This is already a feature in HeidiSQL - you just need to set the control characters which Excel expects in Tools > Preferences > Export:
Field separator: \t (Tab)
Field encloser seems not to be important for Excel
Line separator: \r\n (Microsoft linefeed)
Additionally, you should check "Use local number format..." on the same page.
Written by ansgar
4 years ago
4789 posts since Fri, 07 Apr 06
Ah, forgot to mention the most important thing :)
In the end, just right click any data or query grid > Copy data > Copy as CSV
Written by Dave
4 years ago
24 posts since Fri, 19 Sep 08
Oh, excellent!! Thank you!! Made my day!!
 

Please login to leave a reply, or register at first.