Copy table to clipboard, Excel-ready
| User, date | Message |
|---|---|
|
Written by Dave
3 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! 
|
|
Written by ansgar
3 years ago 3950 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
3 years ago 3950 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
3 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. |