I'm unable to access data using xlsread
信息
此问题已关闭。 请重新打开它进行编辑或回答。
显示 更早的评论
w=xlsread("data.xlsx",1,g9:g345");
5 个评论
androidguy
2018-2-8
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')
per isakson
2018-2-8
编辑:per isakson
2018-2-8
Whould a capital S help
Sheet1
?
Walter Roberson
2018-2-8
Try
SOC=xlsread('EIG_Battery.xlsx',1,'g9:g86');
Aletta Wilbrink
2018-2-8
Is the name sheet1 spelled correctly? Maybe you have an capital s or a space somewhere
Walter Roberson
2018-2-8
[status, sheetnames] = xlsinfo('EIG_Battery.xlsx');
will return the sheet names in the second output.
回答(1 个)
Abhinav
2018-2-8
0 个投票
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.
0 个评论
此问题已关闭。
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!