Solved

Copy list(of T) to Excel (2003) spreadsheet from Visual Basic Project (or Dataset)

Posted on 2010-08-29
9
363 Views
Last Modified: 2012-06-27
I have a VB Project and need to copy list(of T)  or Datasets (not visible) from Visual Basic Projet to generate a spreadsheel in a new or existing Excel workbook.
0
Comment
Question by:Jimrustman
9 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 33556030
Please give some more explanation.

Also,

What is list (of T)?
What do you mean by (not visible)
0
 

Author Comment

by:Jimrustman
ID: 33559415
list(of T) is VB collection generality where T is some general class.  Such as list(of string) or list(of Integer) or list(of ClassTime) .  T represents a general object.

Not viibile implies that the list is never exposed to a gridview or data view or any form object.  It is strickly a VB collection or array.
0
 
LVL 45

Expert Comment

by:aikimark
ID: 33559752
Are you doing this in a VSTO environment?
0
 

Author Comment

by:Jimrustman
ID: 33603397
XL environment
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 45

Expert Comment

by:aikimark
ID: 33603419
If you're in an Excel environment, you are limited by the VBA.  The List (of T) syntax is a .Net construct.  That's why I asked you about VSTO.
0
 

Author Comment

by:Jimrustman
ID: 33607603
I'm not in a VBA environment, notice I said a VB project.    Yes, list(of T) is a .Net construct, and is also available to VB Project work also.    I would prefer to use this as a VB class to fit into a Class library, but could use a solution outside of a library.  

I am coming quickly to the conclusion that it is not possible to form a solution independent of year (2000, to 2006, excluding 2007)  and I'm working to generate a csv file that can the be manually loaded into Excel.  This does seem junkie, but it works.

Thanks
0
 
LVL 45

Expert Comment

by:aikimark
ID: 33607673
@Jimrustman

>>I'm not in a VBA environment, notice I said a VB project.

This question is in the VB classic zone and general spreadsheet software zone.  Both of these are pretty far removed from VB.Net.  Your "VB Project" response is applicable to both VB classic and VB.Net development environments and Excel VBA development also has a "project" organization.

It is for these reasons, and the "list(of T)" subject at the heart of your question that I asked my VSTO and VBA questions.  If we can get the development and run-time environments nailed down, I can help you get this question into the proper zones.  This will expose your question to the appropriate subject matter experts.
0
 
LVL 33

Accepted Solution

by:
Norie earned 250 total points
ID: 33612403
Why don't you generate the CSV file and automatically open it in Excel?

How are you currently using Excel in the code?

Are you using it?
0
 

Author Closing Comment

by:Jimrustman
ID: 33653787
Didn't really solve the problem, just offered a work around that was somewhat obvious
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.
Viewers will learn the basics of the new Quick Analysis feature in Excel 2013.

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now