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.

red

This will help me jump start on this sample.

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