David Wikström Posted February 4, 2015 Share Posted February 4, 2015 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 More sharing options...
john renfrew Posted February 7, 2015 Share Posted February 7, 2015 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 More sharing options...
David Wikström Posted February 8, 2015 Author Share Posted February 8, 2015 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 More sharing options...
Recommended Posts
This topic is 3365 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 accountSign in
Already have an account? Sign in here.
Sign In Now