Alternatives of openxlsx when importing Excel to R
The problem of openxlsx
At work, I rely on the R package openxlsx heavily and use openxlsx::read.xlsx to import excel spreadsheet, which is the most common format in business settings.
Now here is the issue I discovered recently. I have a sp...
![](https://asterhu.com/post/2022-11-18-import-excel-formula-with-ampersand-to-R/Page19.png)