MATLAB: Image Write in Excel

xlswrite

Hello all,

I am trying to write image pixels values in excel file, the size of image 2048×1365 uint8. presently using windows 10. It seem small issue, but stuck last 10 minutes.

ver: Matlab 2017a

im=rgb2gray(imread('coolerdarker.jpg'));
xlswrite('Test1',im);

#Error:

Error using xlswrite (line 226)
The specified data range is invalid or too large to write to the specified file format. Try writing to an XLSX file and use Excel
A1 notation for the range argument, for example, ‘A1:D4’.
Error in matlab_test_file (line 16)
xlswrite('Test1',im);

Thanks

Best Answer

https://answers.microsoft.com/en-us/msoffice/forum/all/what-is-the-maximum-number-of-columns-in-a/5a053135-4865-e011-8dfc-68b599b31bf5

Xls files support only 256 columns. You need to switch to xlsx files.

Related Solutions

MATLAB: How to write character(39) to excel file

Hi,

actually the character is written. It's an Excel display feature that it seems like its not there. But when you click at A1 and take a look at the upper text field in Excel (dont know how its called, but the thing which also displays the content of the cell which is currently selected) you will see the '. Basically a single apostrophe does not show up because Excel treats it as a Text marker and not part of the text stream. Enter two apostrophes to get the single quote in the text:

xlswrite('Test1.xlsx',{[char(39),char(39)]},1,'A1');

MATLAB: How to open an existing Excel file and communicate with it using ActiveX

This bug has been fixed in Release 14 Service Pack 3 (R14SP3). For previous product releases, read below for any possible workarounds:

The following provides an example of opening an existing Excel file named example.xls and proceeding to write and read with it:

% Specify file name
file = 'D:\Applications\MATLAB701\work\example.xls'; % This must be full path name
% Open Excel Automation server
Excel = actxserver('Excel.Application');
Workbooks = Excel.Workbooks;
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook=Workbooks.Open(file);
% Specify sheet number, data, and range to write to 
sheetnum=1;
data=rand(4);  % use a cell array if you want both numeric and text data
range = 'F10:I13';
% Make the first sheet active
Sheets = Excel.ActiveWorkBook.Sheets;
sheet1 = get(Sheets, 'Item', sheetnum);
invoke(sheet1, 'Activate');
Activesheet = Excel.Activesheet;
% Put MATLAB data into Excel
ActivesheetRange = get(Activesheet,'Range',range);
set(ActivesheetRange, 'Value', data);
% Here you might manipulate the data in Excel
% Now read the data from the sheet; you could specify a new range here
Range = get(Activesheet,'Range',range);
out = Range.value;
% Save file
invoke(Workbook,'Save')
% Close Excel and clean up
invoke(Excel,'Quit');
delete(Excel);
clear Excel;

Best Answer

Related Solutions

MATLAB: How to write character(39) to excel file

MATLAB: How to open an existing Excel file and communicate with it using ActiveX

Related Question