How to determine data type of cell in Excel file

[THouston]

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.

[Taki1999 · Accepted solution]

If you have to deal with Excel directly, I don't see how you're going to get around using Active X.

MSDN page on using ActiveX

[THouston]

Thanks for the info.  I just bit the bullet and coded it in Active X.