MATLAB: Input and excel sheet and output a different one

excelgui

I would like to create an application that imports an excel sheet, modifies it (mainly transpose) and then exports it to a new excel sheet having the modified format. Explicit answers are appreciated. Thanks

Best Answer

Hello Michel,

Create a GUI for the same. Add one Push Button, So that when you click on that Pushbutton, it will import the excel file (ABC.xlsx), it will read it, it will store the data into some Array variables, it will modify it as per your requirement, it will then write the modified data into another excel (XYZ.xlsx).

Code will be as follows:

 % --- Executes on button press in OK_.
function OK__Callback(hObject, eventdata, handles)
% hObject    handle to OK_ (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
 importData = xlsread('ABC.xlsx');
 modifiedData = 2 * importData + 100;
 xlswrite('XYZ.xlsx',modifiedData;
 winopen('XYZ.xlsx');

Note: The both excel files should be present in current directory.

Related Solutions

MATLAB: Excel plotting using popup menu

Varun - when you import the data from the Excel file, you are doing

handles.data1=xlsread(filename, selectedsheet)
data1=handles.data1
set(hObject, 'data1')

where the data1 field of the handles struct is being created and set to the data from the file. This is fine but what you need to do next is to save this new field to the structure (right now, you are just updating a local copy)

handles.data1=xlsread(filename, selectedsheet)
guidata(hObject, handles); % <---- the updated handles object is now saved

The other two lines (the second which may throw an error if the data1 field is not a property of hObject) can be removed. So remove

data1=handles.data1
set(hObject, 'data1')

Then in the popupmenu6_Callback, you would access data1 via

if isfield(handles, 'data1')
    item=handles.data1(item_selected, 29)
end

The line get(handles.popupmenu1, 'data1') which is throwing the error, can be removed.

MATLAB: Open an excel sheet after clicking a pushbutton in GUI

Hello Michel,

Consider you have GUI " Test.m" and " Test.fig" files, along with your template " ABC.xlsx" file.

Keep all files in current directory of matlab. Now, for your GUI, there is pushbutton called ' OK'.

Consider, the template Excel file have three column ' Sr_No', ' Name', ' Age', which you want to update when you click on ' OK' push button.

so you need to update the following code into callback of pushbutton ' OK':

 % --- Executes on button press in OK_.
function OK__Callback(hObject, eventdata, handles)
% hObject    handle to OK_ (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
 Sr_No = {'1';'2';'3';'4';'5'};
 Name = {'A';'B';'C';'D';'E'};
 Age = {'10';'11';'12';'13';'15'};
 final_Data = [Sr_No,Name,Age];
 xlswrite('ABC.xlsx',final_Data,'Sheet1','A2');
 winopen('ABC.xlsx');

Best Answer

Related Solutions

MATLAB: Excel plotting using popup menu

MATLAB: Open an excel sheet after clicking a pushbutton in GUI

Related Question