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);
- Yellow cells are accounting format.
- 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,