https://community.blueprism.com/t5/Product-Forum/Excel-VBO-Copy-specific-column-into-collection/m-p/83001#M34342 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. Tue, 17 Jan 2017 20:30:00 GMT John__Carter 2017-01-17T20:30:00Z https://community.blueprism.com/t5/Product-Forum/Excel-VBO-Copy-specific-column-into-collection/m-p/83000#M34341 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 Tue, 17 Jan 2017 04:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-VBO-Copy-specific-column-into-collection/m-p/83000#M34341 Anonymous 2017-01-17T04:22:00Z https://community.blueprism.com/t5/Product-Forum/Excel-VBO-Copy-specific-column-into-collection/m-p/83001#M34342 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. Tue, 17 Jan 2017 20:30:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-VBO-Copy-specific-column-into-collection/m-p/83001#M34342 John__Carter 2017-01-17T20:30:00Z