remove weekends and holidays data from excel file

2019 1 15
1 个回答
回答已采纳
更新时间：2019 1 15
5 次查看（30 天）

0 个投票

I had excel file ABC.xlsx, in which sheet A having data from date 01-04-2017 to 31-12-2018 and the sheet2 having the list dates which are holidays( holiday may be fall on weekends). So now I want to create a another excel to seprate the weekdays and weekends/holidays data???
Thanks

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

 采纳的回答

KSSV
KSSV 2019-1-15

0 个投票

% Read data
T1 = readtable('ABC.xlsx','sheet',1) ;
T2 = readtable('ABC.xlsx','sheet',2) ;
% Get dates common in both
idx = ismember(T1.(1),T2.(1)) ;
% Pick which are not common
T = T1(~idx,:) ;
% write to a file
writetable(T,'test.xlsx')

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Calendar 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by