Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Excel VBO - Copy specific column into collection

Anonymous
Not applicable

‎17-01-17 04:22 AM

Hello, I'm trying to get a specific column from an excel file into a collection. Is there an easy way to do this? Currently I'm: 1. Getting an entire worksheet into a collection 2. Using a calculator to get values from that column into a new collection 3. Looping until the rows have completed This takes a long time for 20k plus rows. I'm wondering if someone has found an easier solution? Thanks, Kevin
0 Likes
1 REPLY 1

John__Carter
Staff
Staff

‎17-01-17 08:30 PM

The Data - OLEDB utility object is a good alternative to reading large Excel files - it does not open Excel and queries the file directly. However, regardless of the method used, care should be taken with large collections as they can sap the memory of the PC, and it is sometime necessary to read data in chunks rather than in one go. I'll post an article on the Knowledgebase this week showing how it can be done.
0 Likes