Trying to pull the dataset (large), It works writing to CSV but not for xlsx.
Tried writing to CSV and then save as xlsx, but thisis eliminating leading zeros. zip code by example (01056) reads as (1056).
write.xlsx(qry_policy_Summary_by_EffectiveDate,
'summary by Effective Date/qry_policy_summary_by_EffectiveDate.xlsx',
sheetName="SBE",
col.names=TRUE,
row.names=FALSE,
showNA=FALSE)
throws up this error
Error in .jnew("org/apache/poi/xssf/usermodel/XSSFWorkbook") :
Java Exception <no description because toString() failed>.jnew("org/apache/poi/xssf/usermodel/XSSFWorkbook")<S4 object of class "jobjRef">
Thanks in Advance.