How can save by : Xwrite data sets into excel more than 26 ,A-Z, columns?
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Gouri Chennuru
le 5 Nov 2020
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 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!