MATLAB: Write data from gui in excel

xlswrite for gui

Hi! Does anybody know how can a variable calculated on matlab GUI and stored in the handles be written on an already existing excel file?`

Or in other words, does the function xlswrite work at GUI? and if not, which function should be used instead?

Thanks a lot!

Best Answer

The format for range is 'a2:c4' as an example. For a single cell, you need to specify it as 'd4:d4' for example.

The range for 4th column and i+1 row would be

[dec2base27(4),num2str(i+1),':'dec2base27(4),num2str(i+1)]

The function dec2base27() is to convert 1 to 'A', 4 to 'D', 28 to 'AB' etc. It is to facilitate the xlswrite() function. You probably don't have it. I took it from xlswrite.m. Open xlswrite.m and you can find the dec2base27() function. Make it separate so you can use it anywhere else.

Related Solutions

MATLAB: Programatically change range of excel sheet depending on data

It can be handled. Before you write the array to the Excel sheet, you can use size() function to get the number of rows and columns. xlswrite() allows you to specify the range of the sheet to write to so you just need to "remember" the position of the last writing and properly calculate the position of the next writing.

The only thing you need to do is to have a function to convert a number to the Excel column position. For example, second column means 'B', 26th column means 'Z' and 27th column means 'AA'. The function is called 'dec2base27'. It is inside the xlswrite.m. You need to dig it out and make it a separate function so you can use it. Maybe also dig out the 'base27dec' function too. I've done it and advised several others to do the same. It's quite useful for doing xlswrite().

MATLAB: Color the particular row of the excel sheet

% Connect to Excel
Excel = actxserver('excel.application');
% Get Workbook object
WB = Excel.Workbooks.Open(fullfile(pwd, 'Book1.xlsx'),0,false);
% Set the color of cell "A1" of Sheet 1 to Yellow
WB.Worksheets.Item(1).Range('A1').Interior.ColorIndex = 6;
% Save Workbook
WB.Save();
% Close Workbook
WB.Close();
% Quit Excel
Excel.Quit();

Does this, ofcourse you can change all the values.

Best Answer

Related Solutions

MATLAB: Programatically change range of excel sheet depending on data

MATLAB: Color the particular row of the excel sheet

Related Question