I'm unable to access data using xlsread

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

[androidguy]

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]

Whould a capital S help

Sheet1

?

[Walter Roberson]

Try

SOC=xlsread('EIG_Battery.xlsx',1,'g9:g86');

[Aletta Wilbrink]

Is the name sheet1 spelled correctly? Maybe you have an capital s or a space somewhere

[Walter Roberson]

[status, sheetnames] = xlsinfo('EIG_Battery.xlsx');

will return the sheet names in the second output.

Answer 1

[Abhinav]

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.