Jump to content
Sign in to follow this  
MarcW

Reading from an excel file into an array

Recommended Posts

MarcW

Hello,

I need to be able to select an excel SS and have each cells contents stored in an array for later access. I have the select file dialog working, just need to know what the best function is to capture each cells contents and store in an array index. What would be the best way to go about this?

Thank you all in advance!

Share this post


Link to post
Share on other sites
hawky358

_ExcelReadSheetToArray() does exactly this

Share this post


Link to post
Share on other sites
MarcW

Thank you, it does exactly what I needed!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×