How can save by : Xwrite data sets into excel more than 26 ,A-Z, columns?
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (1)
Gouri Chennuru
il 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 Commenti
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!