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)];
0 个评论
回答(1 个)
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.
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!
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!