Overwrite single row excel information based on Unique ID in column data

Question

Ganesh Naik 2021-6-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/844975-overwrite-single-row-excel-information-based-on-unique-id-in-column-data

回答： Vimal Rathod 2021-6-7

Hi all,

Each time when I execute some functions I am storing the results in an excel file. Rows of column one contains unique ID for each subject. Whenever I execute the function new results are automatically appended into a new row. Whenever the same information is executed, I would like to overwrite rows containing unique ID information with a warning sign such as “The information is already exists would you like to overwrite them” etc. I tried this with “unique” function in matlab but no success. Any help in this regard is highly appreciated.

2 个评论
显示无隐藏无

Monika Jaskolka 2021-6-1

Please provide the Excel file you are using and your code

Ganesh Naik 2021-6-2

BP_Analysis.xlsx

Hi Monika, thanks for your email. Please find below the code and excel sheet attached. I would like to overwrite any rows if the data with same lastname is executed. I have created a dummy problem to reflect my original data.

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

LastName = {'Sam';'John';'Bella';'Diana';'Kelly'};

Age = [48;53;58;80;29];

Smoker = logical([1;0;1;0;1]);

Height = [61;59;64;69;62];

Weight = [126;153;141;153;129];

BloodPressure = [104 95; 119 79; 115 85; 127 85; 112 81];

Table = table(LastName,Age,Smoker,Height,Weight,BloodPressure)

writetable(Table,"BP_Analysis.xlsx","WriteMode","append","AutoFitWidth",false);

%Overwirte the rows "Lastname" if same results are executed

%again.

data = readtable('BP_Analysis.xlsx','PreserveVariableName', true);

data.Properties.VariableNames{1} = 'Lastname';

[~,idx]=unique(strcat('Lastname','rows'));

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

请先登录，再进行评论。

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

Answer 1

Vimal Rathod 2021-6-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/844975-overwrite-single-row-excel-information-based-on-unique-id-in-column-data#answer_719100

在 MATLAB Online 中打开

Hi,

You could use the find and strcmp functions to find the index where the name or uniqueIndex matches.

newName = "Diana";
data = readtable('BP_Analysis.xlsx','PreserveVariableName', true);
idx = find(strcmp(data.Lastname,newName));

If find function returns empty column vector then there is no match in the available uniqueIds and you could append or else if idx is a number you will get the index.

Refer the following links to know more about find and strcmp functions.

https://de.mathworks.com/help/matlab/ref/find.html

https://de.mathworks.com/help/matlab/ref/strcmp.html