Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Excel (xlsx)

David Wikström
in ScriptMaster by 360 Works

Featured Replies

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

 

 

 

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

  • Author

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?

Create an account or sign in to comment

https://fmforums.com/topic/94979-excel-xlsx/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.