MATLAB: Compare data types between 2 excel data sets

excelMATLAB

I have 2 datasets in Excel, and I need to compare the data types of each column, how can I achieve this?

Best Answer

In Excel, each cell entry potentially has its own datatype and own format. The tools such as readtable() and xlsread() do not give access to that level of information. You would need to use an ActiveX or .NET control to talk to Excel to query the type of each entry.