dataset does not read the correct numbers from excel

9 views (last 30 days)
Kelly
Kelly on 24 Oct 2014
Answered: Kelly on 24 Oct 2014
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

Sign in to answer this question.

Answers (2)

Image Analyst
Image Analyst on 24 Oct 2014
Try xlsread() or readtable(). Attach your workbook if you want us to try anything.
Kelly
Kelly on 24 Oct 2014
File is attached. xlsread gives the same error: [ndata, test, data2] = xlsread('AGTIRQ_DA2011w.xlsx')

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!