08-15-2011 01:02 PM
I have a company standard Excel file that needs to be read to determine what tests to run. I have no control over its format. I need to be able to tell what the data type is in order to read it using the LabView sample code. It is a hodge poge of numbers and strings. Some of the numeric fields are formated as hex while some are floating point. There does not appear to be a vi that I can call to determine info about the cell formating. As I remember it, the Windows Active X control for accessing Excel support that. I really was hoping to avoid dealing with the Active X control for Excel directly.
Any help/ideas?
Outputting it in CSV or similar is not an option.
Solved! Go to Solution.
08-15-2011 01:25 PM - edited 08-15-2011 01:25 PM
If you have to deal with Excel directly, I don't see how you're going to get around using Active X.
08-15-2011 03:02 PM
Thanks for the info. I just bit the bullet and coded it in Active X.