MiraiSolutions
 
 

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)
or
Error: NotImplementedException (Java): Error evaluating cell Sheet1!A1
 
 
Why is there no MacOS X binary package?  
 

Show all / hide all

Show all answers