timer output saving in excel in new column
显示 更早的评论
Hi
I write the code with timer function to do some calculate and I want to save the output in the excel file but I have 2 problems one is when it save the outputs it save them in the same column each time and delete older values and replace the new ones, the 2nd problem is at the function I don't know how to define the x to replace at the initial one which I have defined as zeros
this is my code:
function parentFunction
t=timer('Period',0.01,'ExecutionMode','fixedRate');
t.TimerFcn=@function1;
t.TasksToExecute=1000;
start(t)
function function1(~,~)
x=zeros(9,1);
k=5*x;
T=k+3;
xlswrite('Book100',T)
end
end
actually I want to save each T in new column, the excel file must be 9x1000 but it is just 9x1
and I want to update x each time to T just for the first time be zeros(9,1) the replaced with T for the other 999 times of TaskToExecute.
thanks
采纳的回答
Walter Roberson
2021-1-27
Grab one of the File Exchange contributions that converts column numbers into excel notation; https://www.mathworks.com/matlabcentral/fileexchange?q=Excel+A1
Then
function function1(~,~)
persistent colnum
if isempty(colnum); colnum = 0; end
x=zeros(9,1);
k=5*x;
T=k+3;
colnum = colnum + 1;
excol = ConvertColumnNumberToExcel(colnum); %substitute the Fex contribution name here
xlswrite('Book100', T, [excol '1'])
end
12 个评论
john white
2021-1-27
Walter Roberson
2021-1-27
I specifically commented to substitute the name of the Fex contribution you choose to use.
john white
2021-1-28
编辑：john white
2021-1-28
Walter Roberson
2021-1-28
Look in the File Exchange at the link I gave. Pick one of the contributions to work with. Install it, making sure that it is on your MATLAB path. Then change ConvertColumnNumberToExcel to the function name of the contribution.
Note: you can use the Add-on Explorer to add contributions.
john white
2021-1-28
Jan
2021-1-28
Your search find a working function as first hit, and a lot of others:
- https://www.mathworks.com/matlabcentral/fileexchange/30180-calculate-excel-range
- https://www.mathworks.com/matlabcentral/fileexchange/28794-convert-index-to-excel-a1-notation
- https://www.mathworks.com/matlabcentral/fileexchange/81258-getletter
- https://www.mathworks.com/matlabcentral/fileexchange/28343-column-converter-for-excel
- https://www.mathworks.com/matlabcentral/fileexchange/14008-convert-an-a1-style-spreadsheet-column-label-to-a-number
- https://www.mathworks.com/matlabcentral/fileexchange/15748-excel-column-number-to-column-name
- ...
Walter Roberson
2021-1-28
If you are using MATLAB Online, visit this URL https://www.mathworks.com/add-ons/1c54a094-2b81-46f5-96b9-2f2ac14fc531/ and click on Add .
If not, then visit https://www.mathworks.com/matlabcentral/mlc-downloads/downloads/1c54a094-2b81-46f5-96b9-2f2ac14fc531/017d7cbf-a0c8-4dec-94e9-3c2c71723196/packages/zip and save the file to your downloads directory, and then in MATLAB use the folder view to visit the downloads directory and double-click on the mltbx file to run it in MATLAB, and that will install the program.
Once that all is done, then
function function1(~,~)
persistent colnum
if isempty(colnum); colnum = 0; end
x=zeros(9,1);
k=5*x;
T=k+3;
colnum = colnum + 1;
excol = ExcelColumn(colnum);
xlswrite('Book100', T, [excol '1'])
end
This was, by the way, the very first contribution in that list of contributions I had you visit.
john white
2021-1-28
Walter Roberson
2021-1-28
function function1(~,~)
persistent colnum
if isempty(colnum); colnum = 0; end
x=zeros(9,1);
k=5*x;
T=k+3;
colnum = colnum + 1;
excol = ExcelColumn(colnum);
xlswrite('Book100', T, [excol : excol])
end
john white
2021-1-28
john white
2021-1-28
Walter Roberson
2021-1-28
xlswrite('Book100', T, 1, [excol : excol])
will force it to write to sheet 1.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
