Odd printing query - filenames

Discussion in 'macOS' started by sim667, Nov 11, 2011.

  1. sim667 macrumors 65816

    Joined:
    Dec 7, 2010
    #1
    I need to batch process some XLS documents and print them out..... No each document is for a specific person, whose name is the filename, however the name is not actually in the document anywhere.

    There's about 70 of them, so the last thing I want to do is to open each on, add a name and then resave.

    Does anyone know of how I can get the filename to printout on the bottom of each print? That would be a massive timesaver for me.
     
  2. r0k macrumors 68040

    r0k

    Joined:
    Mar 3, 2008
    Location:
    Detroit
    #2
    You haven't mentioned which software you are using. Is it LibreOffice? Office 2004? iWork? There are functions available in most spreadsheet programs to take all or part of the document's name and or path and put it into a cell. You can look up the formulas in each app's help system. In Excel and Libre Office, it's called "Cell". I'm not sure what it's called in Numbers.

    So you will end up editing all 70 files but you can simply paste in the formula each time and it should give its own filename when you print the spreadsheet after pasting in the formula. It's easier to pick rows to put at the top and left of a printout than the bottom or right, so paste the formula in at the top and it should show up on every page (if you have print area set up that way).
     
  3. sim667 thread starter macrumors 65816

    Joined:
    Dec 7, 2010
    #3
    Or another way round is to make an excel automator script to add the file name as a header and save it again. I'm just rubbish with automator
     
  4. sim667 thread starter macrumors 65816

    Joined:
    Dec 7, 2010
    #4
    Oh sorry it's office, the latest one
     

Share This Page