Excel (xlsx)

[David Wikström]

Just wondering if anyone has given Excel (xlsx) creation via Apache POI or some other library a serious go?

 

Since there are a lot elements of an Excel we don't control properly, or at all, in FileMaker's native Excel export, this would seem to be useful (if nothing else, it might push FileMaker Inc. to improve the native Excel export...

 

 

 

[john renfrew]

Yes....

Its lovely once, like all java libraries, you get your head round the API

AND can for client who need it create xls from fmp13..!

 

Hiding columns, creating calculation cells, individual colours & font sizes....

 

quick sample attached...

a.xlsx.zip

[David Wikström]

OK, nice to see that it's been done - not surprised that it was by you...

Not sure I'll have the time/patience/skills it takes to put something together, but I'll try to play with it when I have some time.

 

What's your experience when it comes to speed and memory issues? Say when creating a file with 50 columns of mixed data types, and a few thousand lines?