HORNEKS ANS

ACF Library

Excel_DocProp

Back to List

Description: Create EXCEL document properties XML stub. OBSOLETE - New Excel functions in 1.7.8.2

FileMaker Prototype: 

Set Variable [$res; ACF_Run("Excel_DocProp"; string_Author)]

Category: EXCEL

Function source:

Function Excel_DocProp(string Author)
   timestamp createdZ = now(); 
   string CreatedS = string ( createdZ, "%Y-%m-%dT%H:%M:%SZ");
   XML xmlvar;
   xmlVar["DocumentProperties"] = 
         XML("Author",Author,"LastAuthor",Author,"Created",CreatedS
         ,"LastSaved",CreatedS,"Version","16.00");
   // Assign attributes to the XML...
   XMLattributes(xmlVar["DocumentProperties"], XML("xmlns","urn:schemas-microsoft-com:office:office");
   return XmlVar;
End

This is the old XML Excel spreadsheet functions: We encourage programmers to look at the new functions with .xlsx support instead as they are much easier to use. Look at sample here.

Excel_DocProp is one of the Excel library functions that create snippets of XML code that is assembled together in the final function to generate an EXCEL XML document. It has the "Author" of the XML document as its parameter. This will be the Author when displayed document properties in Excel later. Created date and such is added automatically.

The EXCEL functions that compose the library is listed in the category EXCEL.

If you have installed the EXCELlib package, you can get access to these functions using the "USE" statement: 

USE ExelLib;

img

Back to List