Martin Studer

Support for singleton entities

1

It would be nice if activate could support singleton entities. More information available at https://groups.google.com/forum/?fromgroups#!topic/activate-persistence/qPc7u_5Fq2w

Upgrade to latest version of Apache POI (5.2.2 as of this writing)

Add support for built-in cell styles

1

Built-in cell styles are currently not supported in XLConnect. Therefore, the following call fails: ``` > wb = loadWorkbook("builtin.xlsx", create = TRUE) > csH3

Adding images does not work with Windows Meta File format

1

Adding windows meta files to xls workbooks seems to generate corrupt files. Adding windows meta files to xlsx workbooks seems to work fine if `originalSize` is set to `FALSE`, but...

Support for RGB color values

1

"One feature that would be nice is if I could provide the RGB values for the color. I have an application that creates, via ‘rainbow’, about 200 gradations of color...

Copying sheets between workbooks

2

It's currently not possible to copy sheets between workbooks.

Limited support for pivot tables is available in XSSF but not HSSF: http://poi.apache.org/spreadsheet/limitations.html Simple example for creating pivot tables: http://thinktibits.blogspot.ch/2014/08/Create-Pivot-Table-Java-Apache-POI-Example.html

"I just discovered your package XLConnect and find it very useful. Before, I used read.xls() from package gdata, but the columns containing dates were imported in unpredictable manner and I...

"I am not sure if XLConnect can do this already, but in Excel, I can click on a row, right click, and then delete the row with all the rows...