From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.


Showing results for 
Search instead for 
Did you mean: 

MS Office Toolkit

I am trying the toolkit out for the first time to get some data out of an excel spreadsheet.  It appears that the toolkit only supports creating files, not opening/reading existing files.  All the installed vi's on the pallette are under Report Generation.  I was looking for the "Open Excel File" type vi and it is not there.  Is this right?  I was able to look thru the lower level vi's and figure out how to open files, but it appears this functionality is not supported at the top level?  Unless I'm missing something, it looks to me like the toolkit only has half the functionality it should.
Bill F
0 Kudos
Message 1 of 2

Hey Bill,

Here is a sub vi I wrote that opens an excel file then extracts data from named cells in excel and writes it to a spreadsheet.  I had to search the forums for a little bit before I figured out how to do it myself.

The reason for the error case is because sometimes excel would not open for every file I was looking in for data.  I was getting data from 50+ excel files and random files would not get opened giving me bad data.  I guess it is a known problem that excel sometimes takes too long to open and will generate an error.



0 Kudos
Message 2 of 2