R语言 如何将多个数据框写入Excel不同的Sheet

很久没有这个需求了，忘了怎么操作。写一下记录作为备忘吧。
貌似很多包都可以实现，可要么就是写在了同一个sheet里，要么就是把行名自动省略了,改不回来的那种。
试了几次有一个包可以完美实现:openxlsx
比方说我有10个数据框。res_PC1,res_PC2...
然后想要分别写入10个sheet，sheet名是PC1,PC2...
并且需要保留行名。

list_of_datasets <- list("PC1" = res_PC1, "PC2" = res_PC2,
                         "PC3" = res_PC3, "PC4" = res_PC4,
                         "PC5" = res_PC5, "PC6" = res_PC6,
                         "PC7" = res_PC7, "PC8" = res_PC8,
                         "PC9" = res_PC9, "PC10"= res_PC10)
openxlsx::write.xlsx(list_of_datasets, "PC_loading_with_Pvalue.xlsx",rowNames=TRUE)

完美实现。一开始最后一行写错了指令,被贴心的自动修正了。好评。

row.names=TRUE

> openxlsx::write.xlsx(list_of_datasets, "PC_loading_with_Pvalue.xlsx",row.names=TRUE)
 警告メッセージ: 
1: Please use 'rowNames' instead of 'row.names' 
2: Please use 'rowNames' instead of 'row.names' 
3: Please use 'rowNames' instead of 'row.names' 
4: Please use 'rowNames' instead of 'row.names' 
5: Please use 'rowNames' instead of 'row.names' 
6: Please use 'rowNames' instead of 'row.names' 
7: Please use 'rowNames' instead of 'row.names' 
8: Please use 'rowNames' instead of 'row.names' 
9: Please use 'rowNames' instead of 'row.names' 
10: Please use 'rowNames' instead of 'row.names'