我有一个超过20000
行的数据集,因为它的总行上载限制为20000
,所以无法导入到SharePoint
中.共有17
列,每列有6694
行,总计113798
行.
因此,我想将这xlsx
个文件拆分成总行数少于20000
行的更小的文件.
我怎么能这样做呢?
样本数据:
df2 <- data.frame(a = seq(1,6694), b = seq(1,6694), c = seq(1,6694),
d = seq(1,6694), e = seq(1,6694), f = seq(1,6694),
g = seq(1,6694), h = seq(1,6694), i = seq(1,6694),
k = seq(1,6694), l = seq(1,6694), m = seq(1,6694),
n = seq(1,6694), o = seq(1,6694), p = seq(1,6694),
q = seq(1,6694), replace = T)