Questions about a Blog Article

Add-in Express™ Support Service
That's what is more important than anything else

Questions about a Blog Article
Populating Excel workbooks and ranges with arrays 
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Hi, Andrei

I am now studying this sample in VB.NET:
Populating Excel workbooks and ranges with arrays
https://www.add-in-express.com/creating-addins-blog/2013/11/29/populate-excel-workbooks-ranges-with-arrays/

I downloaded the files and built > register > debug

I see a ribbon in Excel with 3 buttons:
(1). Insert into Range using a Silly Loop
(2). Insert into Range using a database query
(3). Insert into Range from selected range

I have never worked with arrays before, but the blog appears interesting, and the codes appear short and simple.
A good way to learn programming Excel.


When I click (1), I get "Row 0" in my worksheet.
When I click (2), I get "Company A" in my worksheet.
When I click (3), I don't see anything happening.

Can you briefly explain to me how we are supposed to proceed so that clicking the buttons produces something interesting?

This will help me jump start on this sample.

Thanks
Leon
Posted 27 Feb, 2019 09:24:31 Top