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

3 次查看(过去 30 天)
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)];

回答(1 个)

Gouri Chennuru
Gouri Chennuru 2020-11-5
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
Hope this Helps!

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by