AnsweredAssumed Answered

Formatting exported Excel file

Question asked by FileMakerNovice on Feb 21, 2013
Latest reply on May 2, 2013 by PeerSchuimer


Formatting exported Excel file

Your post


     I would like to know the best way to automate the formating of an exported Excel file.  I have a script that exports a list of employees.  Filemaker's export looks horrendous.  I would like to do the following to the Excel file.  I am thinking that this will need to be done with AppleScript or Automator but am very unfamiliar with them.
     1.  Change color or multiple cells.  For instance A1 to C1 should be blue.  C1 to F1, red.  Etc.
     2.  Format cells.  For instance A2 to A200 should be centered, integer value without decimal.
     3.  Add a row and column at the beginning of the sheet.

     Is there any way to do this?  Is there any helpful documentation that you guys can point me to?  Thanks in advance.