I keep getting the following error in R when trying to export a query as an .xlsx file on the server

This is a good example where a screenshot isn't a good idea. That's a lot of text you're asking people to type.

Googling a bit suggests this kind of error is sometimes associated with writing large excel files.

Some discussion below, http://r.789695.n4.nabble.com/output-td4727325.html

Asking this kind of question with something closer to a reprex (FAQ: What's a reproducible example (`reprex`) and how do I do one? -- specifically more context about the table you're saving and the code you used) will likely make it easier for folks to help.

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).

'summary by Effective Date/qry_policy_summary_by_EffectiveDate.xlsx',

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.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.