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

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.
JimrustmanAsked:
Who is Participating?
 
NorieConnect With a Mentor VBA ExpertCommented:
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
 
Saqib Husain, SyedEngineerCommented:
Please give some more explanation.

Also,

What is list (of T)?
What do you mean by (not visible)
0
 
JimrustmanAuthor Commented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
aikimarkCommented:
Are you doing this in a VSTO environment?
0
 
JimrustmanAuthor Commented:
XL environment
0
 
aikimarkCommented:
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
 
JimrustmanAuthor Commented:
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
 
aikimarkCommented:
@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
 
JimrustmanAuthor Commented:
Didn't really solve the problem, just offered a work around that was somewhat obvious
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.