My question is how to create an Excel sheet from Filemaker Pro (DB),Already I created fields employee id,date ,Time_in and Time_out based on the following:
If users expect well-formatted excels with custom column titles etc., try a plugin.
I have used this in the past GitHub - SoliantMike/FM-js_ExcelSheets: Save XSLX files programatically with Javascript
3 Likes
Multiple questions/comments opened here:
1st principle of data management: "One version of the truth"
Once data is exported to Excel, all bets are off.
The new Confucius proverb "Man with one watch, always knows the time; man with 2 watches never sure" states the case succinctly
I have never given a user access to the table view in FileMaker; too easy for them to damage stuff and locking down table features is a complex exercise in futility. List views are more coding/UI but you have far more control over the user's data manipulations, IMHO
There is nothing I am aware of in Excel that FileMaker can't do equally well or better (although some of it is complex, like pivot tables).
FM is multi-user - Excel is typically not (back to one version of the truth)
IF you want to export to Excel, there are a couple built in commands to do this, one an EXPORT and the other a SAVE FILES AS
Well, if you need more than FileMaker's basic Excel export, you could use XL functions in MBS FileMaker Plugin.
See blog post: Read And Write Excel Files With FileMaker
and for an example this one: New column names in an Excel document
2 Likes
The Scribe plugin from 360 Works is a wonderful plugin for creating and modifying Excel files.
Could you please provide the URL 360 works?
I have not used this plugin but I have used 3060 Works MirrorSync and I have been very happy with it.
I have a number of solutions which use the native tools in FM to export data to Excel. I agree with @Kirk with regard to not providing a Table view to users, but my clients do require a number of Export options, including Excel, PDF reports, etc.
For our use cases, the native options work fine, with the minor annoyance of column headings being a bit inelegant in that column headings may appear as "InventDetail::subLotNum" or "c_residCost". So one may need or choose to edit those once in Excel, especially if being used externally from the company (sent to a client, for example).
That said, anything that needs to have an elegant presentation and does not require the flexibility of editing cells, we provide reports instead of Excel exports.
1 Like
A "trick" in this arena: exporting to .CSV files, loses the header (field names). however exporting a MERGE file (.mer) is just a CSV WITH the field names. 
Also, virtual lists are pretty awesome reporting tools, where you can combine tables, set header names, etc. The concept is simple ONCE you "get it" - but "getting it" can be a struggle.
1 Like
Another trick is that excel will open and read HTML. The nice thing about this is that you can control the header names, and you can control formatting for both the text and the cells.
2 Likes
If you have sample file will be fine and I appreciated it .