Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

sim667

macrumors 65816
Original poster
Dec 7, 2010
1,470
2,952
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.
 
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.

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).
 
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
 
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).

Oh sorry it's office, the latest one
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.