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!
Copy table to clipboard, Excel-ready
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.
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.
Please login to leave a reply, or register at first.