I'm unable to access data using xlsread

w=xlsread("data.xlsx",1,g9:g345");

5 个评论

Your excel sheet might not have sheet 1 or has a different name. So you need to check the excel sheet or just leave the sheet name out of the function and try again.
SOC = xlsread('EIG_Battery.xlsx','g9:g86')
Whould a capital S help
Sheet1
?
Try
SOC=xlsread('EIG_Battery.xlsx',1,'g9:g86');
Is the name sheet1 spelled correctly? Maybe you have an capital s or a space somewhere
[status, sheetnames] = xlsinfo('EIG_Battery.xlsx');
will return the sheet names in the second output.

回答(1 个)

Abhinav
Abhinav 2018-2-8
You need to use the exact name of sheet. This is case sensitive. For e.g. if sheet name in excel workbook is Sheet1, then in function you should type Sheet1, not sheet1.

此问题已关闭。

标签

关闭:

2021-8-20

Community Treasure Hunt

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

Start Hunting!

Translated by