Copy to CSV or similar
I can effectively do this using export to Excel and then select all / copy. But I do a lot of statistical analysis and need to copy data results to and from other programs. They support importing from the clipboard, but the clipboard text must be comma or tab separated (or even fixed--parsable in a line-per-row fashion--i.e., not markup).
It would also be nice if you could suppress the summary line.
Paul
shared this idea
-
Charlie
commented
These workarounds mentioned in the comments work great... but I am recently using the SQL language most often, and I don't know how I would send the output to a csv or tab-sv from there.
-
Dennis Hafström
commented
Another workaround I tend to use when I need the data to clipboard is to simply use Clipboard.SetText() at the end of my query.
This means some more lines if the data is directly from a query but it's usually fast with String.Join("\t", <data>) or similar.
-
mortb
commented
Another apporach:
It would actually be quite easy to change your linq query into a program that would save your results to a csv file in the temp folder. At the end of your program you could add a call to process.start("excel", "tempfile.csv");
Or:
You could convert the query to a program (as above) and add a call to the clipboard object http://msdn.microsoft.com/en-us/library/637ys738.aspx