Im bit new in FM world and Ive been looking few posts but not sure if its possible.
I would liket to export diferent data to diferent spreadhseets in excel. Is that possible?
thanks a lot
Do you just mean using a different file variable for the output file to write to or something beyond that?
Shall we clarify?
Say you have a workbook (Excel file/spreadsheet), and it has several "tabs", aka worksheets.
I'd like to know if you meant different worksheets in one workbook.
IF so, this is much more difficult, unless you make multiple Exports (as CSV, for example) and import them into the various worksheets.
Another alternative, is if you have precise formatting on sheets 2..n and can import into sheet 1, where the data "flows" (by Excel calcs) into the other sheets. This takes careful pre-setup.
These are merely ideas for triggering what you really want to see in Excel (with I'm presuming export - or more - from FileMaker). Can you explain just a bit more, please?
Tahnks for your quick respone and sorry for not given enough details.
what I mean is one excel file with several tabs.
I want to export some data on one tub and another data into another one
For creating new excel file, you can use XML exporting with XSL.
Yes! That's how I do this. But since JSON started stepping on XML's toes, we need to find a way for Excel to work with it (or so I've been told).
Spreadsheet Markup Language is pretty old (sigh...)
Sent from miPhone
This take first field as worksheet name, so it shouldn't be empty.
Save the result with filename.xml, then you can open it with Excel.
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fmp">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<xsl:if test="not(preceding-sibling::fmp:ROW/fmp:COL/fmp:DATA = current()/fmp:COL/fmp:DATA)">
<xsl:variable name="sheetName" select="fmp:COL/fmp:DATA"></xsl:variable>
<xsl:for-each select="//fmp:ROW[fmp:COL/fmp:DATA = $sheetName]">
Beverly, I read your reply about using XML to create multiple worksheets in one excel file. Is this the only way to create multiple worksheets? Here is my scenario, I have a table of unique grant applications. I have a script that copies key values from the grant application list and then navigates to the grant responses and then does a find. The results I save as an excel file. There are two parts to the results (technical and peer). I repeat the process twice, once each for the result types. What the end users would like is a two tabbed excel file one tab (technical), second tab (peer).
I originally hoped to Append to the created excel file. Only to find that option is only available if I am saving to a PDF. I'm not sure if the end users will be able to handle opening an XML file in excel. There are only 111 grants that I need to create excel files for. Any help is appreciated. Thanks.
I'm sure that you (someone) can use other means to write multiple worksheets in a workbook (Web/PHP? plug-in? ??)
Append may also be possible by external means.
I have a client with a beautiful Excel report. It's all based on the data table in Worksheet 1, the other "pages" are printed as a report. This gets repeated for several different sets of data. It's convenient enough to clear the first worksheet and bring in the FMP data prior to printing. But automated? It probably can. I think mostly the client liked to see how the report looks each time so manual changes are desirable.
I just have been able to create the XML/.xls with the use of XSLT into multiple worksheets. But that is a new workbook each time (not any append) when exporting XML from FileMaker.
Retrieving data ...