Jack_Jones
asked on
Visual Basic ListView
Is it possible to set format to the different colums, for example $ & % values?
Here is what I have that is working, just need to format the colums. This takes data from an excel sheet, but only gives the values and no formatting. Thanks
Here is what I have that is working, just need to format the colums. This takes data from an excel sheet, but only gives the values and no formatting. Thanks
ListView1.Items.Add(oSheet.Range("A3").Value)
ListView1.Items(0).SubItems.Add(oSheet.Range("D3").Value)
ListView1.Items(0).SubItems.Add(oSheet.Range("F3").Value)
ListView1.Items(0).SubItems.Add(oSheet.Range("G3").Value)
ListView1.Items(0).SubItems.Add(oSheet.Range("I3").Value)
ListView1.Items(0).SubItems.Add(oSheet.Range("N3").Value)
ListView1.Items(0).SubItems.Add(oSheet.Range("R3").Value)
ListView1.Items(0).SubItems.Add(oSheet.Range("V3").Value)
ListView1.Items(0).SubItems.Add(oSheet.Range("Y3").Value)
ListView1.Items(0).SubItems.Add(oSheet.Range("Z3").Value)
ListView1.Items(0).SubItems.Add(oSheet.Range("AA3").Value)
Last Comment
Deepak Lakkad
are you displaying data in tabular format ?
If yes, I think DataGridView will be a good option rather then Listview.
ASKER
Well I couldn't get a datagridview to work ;(, but got the listview to work good.
ASKER
Would I just hide the table, and just impliment a datagridview to pickup the items?
what is your requirement?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
MTroutwine,
I found the excel method on here under searching solutions. So I am really limited on how else to do it.
I found the excel method on here under searching solutions. So I am really limited on how else to do it.
ASKER
So there is no way to do this?
ASKER
Thanks
Visual Basic.NET
Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to Visual Basic pre-2002, it is not the same technology,
96K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
