Solved

Listview Item Add, nothing shows up just a long scrollbar

Posted on 2011-09-27
4
182 Views
Last Modified: 2012-05-12
I don't know what I am overlooking but it should work fine from what I can see.


Dim oExcel, oWorkbook, oSheet, oNewSheet

            oExcel = CreateObject("Excel.Application")
            oWorkbook = oExcel.Workbooks.Open("C:\data.xlsx")
            oSheet = oWorkbook.Sheets("HTDB")
            Try
                For i As Integer = 0 To 90
                    CompliantSkus.Items.Add(oSheet.Range("A" & i + 1).Value)
                    CompliantName.Items.Add(oSheet.Range("B" & i + 1).Value)
                    CompliantCategory.Items.Add(oSheet.Range("C" & i + 1).Value)
                    CompliantQuantity.Items.Add(oSheet.Range("D" & i + 1).Value)
                Next

                oWorkbook.Save()
                oExcel.Quit()
                oNewSheet = Nothing
                oSheet = Nothing
                oWorkbook = Nothing
                oExcel = Nothing
            Catch

            End Try
        End If

Open in new window

0
Comment
Question by:Jack_Jones
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 36712914
Have you tried referring to the Text member of the Range class rather than the Value member? You may also try Value2.
0
 
LVL 1

Author Comment

by:Jack_Jones
ID: 36713020
Still blank, I don't get it lol!
0
 
LVL 1

Accepted Solution

by:
Jack_Jones earned 0 total points
ID: 36713208
Helps when you put columheaders in huh! LOL...
0
 
LVL 1

Author Closing Comment

by:Jack_Jones
ID: 36898984
Don't forget your columheaders, duh finally figured it out.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

729 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