dataset does not read the correct numbers from excel

9 次查看(过去 30 天)
I use data = dataset('xlsfile','AGTIRQ_DA2011w.xlsx'). The numbers in the "data" variable look very different from the actual numbers in the excel file. I changed the excel number format many times and yet the data numbers do not match. Any idea? I am use Matlab2014b

回答(2 个)

Image Analyst
Image Analyst 2014-10-24
Try xlsread() or readtable(). Attach your workbook if you want us to try anything.

Kelly
Kelly 2014-10-24
File is attached. xlsread gives the same error: [ndata, test, data2] = xlsread('AGTIRQ_DA2011w.xlsx')

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by