Showing results for 
Search instead for 
Did you mean: 

How to determine data type of cell in Excel file

Go to solution

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.

0 Kudos
Message 1 of 3
Accepted by topic author THouston

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

Get Number Format from Excel.png


MSDN page on using ActiveX

0 Kudos
Message 2 of 3

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

0 Kudos
Message 3 of 3