function arguments block for replacing data in existing excel file

1 次查看（过去 30 天）

Davindra Usov 2023-3-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1934409-function-arguments-block-for-replacing-data-in-existing-excel-file

回答： Jack 2023-3-29

Hi,

I am new to function arguments block. I am trying to use it to replace data in an existing excel file data.csv by doing some calculations that use input data from another csv file InputData.csv. Is this the correct format I should use to do this?

function f = replacedata(InputData.csv)
arguments 
    InputData.csv (1,1) string {mustBeFile(InputData.csv)}
end
% place calculations that use data from InputData.csv file here.
end

6 个评论
显示 4更早的评论隐藏 4更早的评论

Davindra Usov 2023-3-29

is there a way to read in opt variables from this function in another function? data = namedargs2cell(opts)

read(data) does not work

Jack 2023-3-29

The format you provided for the function definition is not correct.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Jack 2023-3-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1934409-function-arguments-block-for-replacing-data-in-existing-excel-file#answer_1204034

在 MATLAB Online 中打开

The format you provided for the function definition is not correct. Here's a corrected version:

function f = replacedata(input_csv)
% input_csv: file path to InputData.csv
arguments 
    input_csv (1,1) string {mustBeFile(input_csv)}
end
% Read data from input_csv file
input_data = readmatrix(input_csv);
% Place calculations that use data from InputData.csv file here.
% ...
% Write results to data.csv file
writematrix(results, 'data.csv');
end

In this code, input_csv is the file path to the InputData.csv file. The arguments block is used to validate that the input_csv argument is a string representing a valid file path. You can then use readmatrix to read the data from the InputData.csv file and perform your calculations. Finally, you can use writematrix to write the results to the data.csv file.