MATLAB: More efficient way to export output to Excel

export to excelxlswrite

Hello,

I am currently following this method to export the results to one Excel file:

   xlswrite('C:\Users\...\Graph.xlsx',{'A' 'B' 'C' 'D'},'Sheet1','A1');
   xlswrite('C:\Users\...\Graph.xlsx',PriceA','Sheet1','A2');
   xlswrite('C:\Users\...\Graph.xlsx',PriceB','Sheet1','A2');
   .
   .
   etc

There must be a more efficient way that opens the excel file only once, but I am not able to locate it. It is not really logical to write every time separately to the same file.

Any assistance is appreciated.

Thanks

Best Answer

EDIT

header={'A' 'B' 'C' };
priceA=[1 2 3]';
priceB=[4 5 6 8 9 1 0 12 15 20]';
priceC=[7 8 9 10]';
max_n=10;
tr=@(price)[num2cell(price) ;repmat({[]},max_n-numel(price),1)]
priceA=tr(priceA)
priceB=tr(priceB)
priceC=tr(priceC)
M=[header;[priceA priceB priceC]]
xlswrite('C:\Users\...\Graph.xlsx',M)

Related Solutions

MATLAB: XLSread – multiple sheets

Hi, Pratha.

I'm not sure if it helps or not because I also have similar situation with you but my parameter can combine in one excel file.

TimeP1=xlsread('Book001.xlsx','PRN1','A:A');
PRNP1=xlsread('Book001.xlsx','PRN1','B:B');
S4P1=xlsread('Book001.xlsx','PRN1','C:C');
%_______________read PRN1_______________%
TimeP2=xlsread('Book001.xlsx','PRN2','A:A');
PRNP2=xlsread('Book001.xlsx','PRN2','B:B');
S4P2=xlsread('Book001.xlsx','PRN2','C:C');
%_______________read PRN2_______________%

In another word:

ParameterP1 = xlsread('your excel file with format','your tab name in that excel','column selected');

MATLAB: Functions in a script file

It does not look like you understand how functions work. When you write

function [totalA, totalB]=Cost(gallons, priceA, priceB)

gallons, priceA and priceB, within the functions, are variables that automatically receive values from the caller (as long as the caller includes the values in the call). If you then overwrite these values as you've done with the next three lines, these inputs are totally pointless.

Therefore your function should just be:

function [totalA, totalB]=Cost(gallons, priceA, priceB);
   totalA=gallons*priceA;
   fprintf('\n To buy %d gallons of gas at Station A it would cost $%2.2d\n',[gallons,totalA])
   totalB=gallons*priceB;
   fprintf('\n To buy %d gallons of gas at Station B it would cost $%d\n',[gallons,totalB])
end

And in your script you call the function with

Cost(something, somethingelse, somethingelseagain);

if you don't care about the outputs of the function or

[output1, output2] = Cost(something, somethingelse, somethingelseagain);

if you want to receive the outputs of the function. something, somethingelse and somethingelseagain can be any variable name. They don't have to match the name of the inputs defined in the function.

Best Answer

Related Solutions

MATLAB: XLSread – multiple sheets

MATLAB: Functions in a script file

Related Question