How can save by : Xwrite data sets into excel more than 26 ,A-Z, columns?

Hi , please i have image data sets as (784 rows * 128coulums ) i need save its in an Excel file ?

the problem is when i save by xwrite in an Excel file , i cant save at the columns more than 26 or more than (z) in Excel, i cant do that !

w='A':'Z';
     for n=1:total_images
25:   range=[w(n) '1:' w(n) num2str(784)];
      full_name= fullfile(image_folder, filenames(n).name);         
      our_images = imread(full_name);                  
     img=our_images;
     img3=im2double(img);
     ImgVector = img3(:);
    xlswrite('your_file.xlsx',ImgVector,range)
end

gave me this error :

Index exceeds the number of array elements (26).

Error in multiple_images (line 25)

range=[w(n) '1:' w(n) num2str(784)];

Answer 1

[Gouri Chennuru]

Hi Furat,

As per my understanding, instead of using “xlswrite” we can make use of “writetable” function available in MATLAB.

xlswrite function is not recommended because of the compatibility issues.

You can change the worksheet to write to by specifying the index corresponding to the worksheet.

You can refer to the below link for more information on writetable function

https://www.mathworks.com/help/matlab/ref/writetable.html#btydeub-1

Hope this Helps!