Hello all,
I’m trying to export a data frame to .xlsx file using the write.xlsx function in the openxlsx package. I keep receiving the error below and not sure how to get around it. Do you know what the issue is?
write.xlsx (qry_Claims_Transactions,
'/mnt_Hf1fi0002_Everyone/Actuarial/Core Ad Hoc/R files/Claims Transactions/Reconciliation/qry_Claims_Transactions (R) v2019.08.13.xlsx',
sheetName = "qry_Claims_Transactions",
col.names = TRUE,
row.names = FALSE)
Error -
Error in gsub ("&", "&", v, fixed = TRUE) :
input string 3478246 is invalid UTF -8