How to set read data format in Microsoft.ACE.OleDB

I was trying to read data from excel2010 which is "intermixed" data format in each cell to matlab workspace using below command:

connString = 'Provider=Microsoft.ACE.OLEDB.12.0;';
connString = [connString,'Data Source = ','Sample1.xlsx',';'];
connString = [connString,'Extended Properties="Excel 12.0;HDR=No;IMEX=1;ImportMixedTypes=Text;Mode=Read;ReadOnly=True;"'];
conn = actxserver('ADODB.Connection');
sqlQuery = ['select * from [','Sheet1$',']'];
res = conn.Execute(sqlQuery);
myData = res.GetRows;
myData = transpose(myData);


  1. Yellow cells are accounting format.
  2. Orange cells are General format.

According to sentence in this forum below

"IMEX=1;" tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text.

I expected to get all cell as 'text' , It look like I got random format data type in matlab workspace.

Anyone have any idea for this?

Thank you in advance,

0 answers