MS Excel VBO – GetWorksheetAsCollection(fast)

MS Excel VBO – GetWorksheetAsCollection(fast)

Another method is to use the Microsoft Excel VBO and to use its GetWorksheetAsCollection(fast) method to read the file in. This method takes a bit more preparation, and it requires having MS Excel installed on the machine that will execute the Process or Object. However, the advantage is that it reads all the data as text, and is therefore a more reliable for reading source data as pure text without trying to convert the data into a specific data type.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s