How to bind an arraylist to a listobject

Question

0.00/5 (No votes)

See more:

Hi,

as a new comer to VSTO , i want to bind a new arraylist to a listobject ,the code is very simple, but when i run the code , in the excel list, only shows the length of strings , not the content.

C#

ArrayList myAL = new ArrayList()
      myAL.Add("Jimmy");
      myAL.Add("Judy");
      list1.DataSource = myAL;

which is missing ?

Thanks for any help，and how to add a header in code ?

Posted 28-Dec-14 20:28pm

july2008

Updated 30-Dec-14 18:21pm

v2

Add a Solution

Comments

Arjsrya 29-Dec-14 6:22am

are you binding the listobject?.Might help this link "http://msdn.microsoft.com/en-us/library/c5f64c2x.aspx"

july2008 30-Dec-14 1:15am

Thanks Arjunan,but that can not help me.
Yes, I'm bulinding a listobj in my code.

http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.listobject.datasource.aspx
from here , you can see these points

•Any component that implements the IListSource interface.

•Any component that implements the IList interface.

ArrayList is one of components that implements, but with my sample code, it just shows the length of the strings "5,4" ,not the content ,"Jimmy, Judy"

Sergey Alexandrovich Kryukov 31-Dec-14 0:48am

Why using ArrayList? Non-specialized non-generic collections have been made obsolete as early as of v.2.0, when generics were introduced. Don't use ArrayList for new development.
—SA

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)