Multiple Worksheet Excel Exports
When someone asks a simple question like "How can I make FileMaker export a second worksheet in Excel?" The method you use to achieve this may not be immediately apparent. Especially if you've not worked with other programming languages like Python. Rest assured, however, you can certainly solve most any FileMaker problem as long as you're willing to take a little journey into the land of other tools.
And, it's probably not as scary as you think it is. Yes, FileMaker is nice and comfortable, but it has it's limits. When you want to become a power developer, you have to become familiar with what's possible.
In this video, I walk through the use of Python, in conjunction with FileMaker in order to export a multiple sheet Excel workbook. Need to include Excel calculations, multiple worksheets, graphics and charts? Do the corporate leaders demand that you provide your report within Excel? Well, let's take a quick trip to Python land and we find all kinds of wonderful gems in our brand new toolset!
Comments
Excellent job !
As usually, Matt with his perspective & know how, gave a beautiful lesson.
Regards,
Marius
Great video!
I was not aware, of how much can be done with filemaker.
Thank you for all the insight!
Gerf
you explain how to install pip but how do we get a password
you did not say how to get the password for pip
Peter Cortiel
you explain how to install pip but how do we get a password
you did not say how to get the password for pip
Peter Cortiel
pip
I found this
https://stackoverflow.com/questions/17271319/how-do-i-install-pip-on-mac...
Peter Cortiel
FM Sub Summary Report to Excel
I wonder, if this would be a solution for exporting a filemaker sub summary report to excel - please let me know if someone got any experience on this...
Multiple Iterations
Anyway you can get one iteration of data on worksheet 1 and a second iteration of data on worksheet 2? I have the data separated through 2 separate variables in filemaker. Independently, I can get both data to go where I want it to go. However doing it together in one command, the "row += 1" on the first set of data is not allowing the populating of data on worksheet 2. Thoughts?
Error
Hi
If the foundset is bigger than 5, it's in error
"1556
Python Exception: <type 'exceptions.ValueError'>
Python Value: too many values to unpack"
Any idea how to avoid this problem
Thanks
same error - do you have a solution
hi, i know this thread is a little old, however i was trying to implement this with filemaker 19 and got this error, was reading through the post and saw you got a similar error.
mine is:
1556
Python 3 not installed
were you able to find a solution?
ykroitoro
Not sure how to use the new python3Run script step
I had no luck running the sample after I installed v19 to install python xlsxwriter. So I upgraded to Python3 and could install xlsxwriter. However, the recommendation is to use python3Run script step, but I'm not sure exactly where it should go. I'm confused about the extra parameters after mode and script. Not sure what they are, nor is there an example of actual use. I even tried adding fm.evaluate inside the script to set path and logopath. I'm still getting an error singling out python3Run use is wrong. Can you help with a brief variation of the sample you had? I've tried it with mode 16 (alternate location for python 3.9) but no difference - still an error #1.
Special Characters in python
Hy Matt, I follow your youtube videos for a while already and am now proud subscriber of you as a sign of gratitude of what you do for the community.
I am really glad you made this post and video since that's something that always bothered me in the standard filemaker to excel export. I have understood all of it and could recreate your example from scratch (my way of learning) BUT (there's always a but ;) As a German I'd like to use the python script with special german characters like ÄÖÜ. With those characters in the python script within your example it returns an error. I read documentation but I could find the position in the script or handover with bBox for changing the encoding. Would it be to much to ask if you can point me onto the right direction?
Best Kai
Kai
Found it
Searched a bid more and found it....
Tanx anyway
Kai
Windows Server
Hi and compliments for the great job!!
I actually have FMS in a windows server and I have to create an excel file with 3 different worksheet.
Is there a bBox plugin equivalent for windows?
Or do you have a similar tutorial for windows?
Thanks in advance!!
Stefania Merella
error 1556 Python 3 not installed
has anyone gotten this error?
i just tried running the original code, it worked one time and now it says?
1556
Python 3 not installed
any input you can share?
ykroitoro
error 1556 Python 3 not installed
some one solved this error?
excellent content
i was looking for this for long time
_
www.totalclearance.net
Great Video
Ironically I just finished a project where I had to export data from a small found set of 800+ records to multiple work sheets and ended up using Monkeybread XL Library of functions to do it BUT watching this it's very nice to know that I could have used python to achieve the same results. The nice thing about using MBS is that it was easy to use on both platforms right out of the box BUT I learned a lot from this and I'm sure I could use python for future projects. As always. . .great job Matt !!!
Dominick Capobianco