Jump to content

Excel (xlsx)


This topic is 2856 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

 

 

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

This topic is 2856 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.