C# 3.0 in a Nutshell
C# 3.0 in a Nutshell, Third Edition A Desktop Quick Reference By Joseph Albahari, Ben Albahari
September 2007
Pages: 858

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
Dump() To Excel?
ifwdev
post May 6 2009, 12:40 PM
Post #1


New Member
*

Group: Members
Posts: 4
Joined: 13-January 09
Member No.: 1,988
I often find myself trying to copy/paste into excel but the HTML output from Dumping is messy. Is there a way to get a more Excel-friendly output quickly? I know I can write using LINQtoCSV or similar but thats more work and has zero formatting (no column widths or data types).

Thanks!
Go to the top of the page
 
+Quote Post
JoeAlbahari
post May 6 2009, 05:50 PM
Post #2


Advanced Member
******

Group: Members
Posts: 215
Joined: 15-February 08
From: Perth, Australia
Member No.: 90
Thanks for the suggestion. I'll look into this in the next update. Maybe a "Copy Special" option that excluded formatting might be the way to go.

Joe

This post has been edited by JoeAlbahari: May 6 2009, 05:50 PM
Go to the top of the page
 
+Quote Post
Alex Jeffreys
post May 12 2009, 04:46 AM
Post #3


New Member
*

Group: Members
Posts: 2
Joined: 12-May 09
Member No.: 18,089
That would be a really useful addition for me. I do copy and paste data (with headers option) from the results pane in SQL Server Management Studio into Excel

Regards
Go to the top of the page
 
+Quote Post
MaslowJax
post Jul 3 2009, 04:27 AM
Post #4


New Member
*

Group: Members
Posts: 7
Joined: 1-July 09
From: Jacksonville,FL
Member No.: 18,958
QUOTE (Alex Jeffreys @ May 12 2009, 04:46 AM) *
That would be a really useful addition for me. I do copy and paste data (with headers option) from the results pane in SQL Server Management Studio into Excel

Regards


I too would get a ton of use from this capability. I know of at least 3 ways it could be written: interop(worst), odbc into excel(decent) ,spreadsheet ML (rumored best)

This post has been edited by MaslowJax: Jul 3 2009, 04:28 AM
Go to the top of the page
 
+Quote Post
cioah
post Sep 2 2009, 11:45 AM
Post #5


New Member
*

Group: Members
Posts: 1
Joined: 2-September 09
Member No.: 20,014
What about hosting LinqPad as an Office Add-In?
Go to the top of the page
 
+Quote Post
Terry Aney
post Nov 3 2009, 11:45 AM
Post #6


Active Member
**

Group: Members
Posts: 16
Joined: 25-March 08
Member No.: 169
QUOTE (ifwdev @ May 6 2009, 03:40 PM) *
I often find myself trying to copy/paste into excel but the HTML output from Dumping is messy. Is there a way to get a more Excel-friendly output quickly? I know I can write using LINQtoCSV or similar but thats more work and has zero formatting (no column widths or data types).

Thanks!


if you don't care about the formatting, a DumpCSV extension method against an IQueryable can be found at: http://www.aneyfamily.com/terryandann/post...Pad-Heaven.aspx
Go to the top of the page
 
+Quote Post
 

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

RSS Lo-Fi Version Time is now: 22nd November 2009 - 04:58 PM
Powered By IP.Board © 2009  IPS, Inc
Powered by Minerva SEO IPB module