XLConnect FAQ

The following collection is updated regularly according to user feedback. Click questions to view the answers or use the sidebar to expand all answers!
I'm running out of memory when processing large data sets:
> writeNamedRegionToFile("huge.xls", data = giant.data.frame, namedRegion = "LargeRegion", formula = "LotsOfData!A1")
Error: OutOfMemoryError (Java): Java heap space
How can I style my output - set fonts, colors etc?
I'm getting errors trying to import Excel data like
Unexpected eval type (org.apache.poi.hssf.record.formula.eval.MissingArgEval)
Error: NotImplementedException (Java): Error evaluating cell Sheet1!A1
Why is there no MacOS X binary package?

Show all / hide all

Show all answers