Excel to PDF question (for John McNamara & Corion, especially)

[cypress]

Hi all,

On Mac OS X with ActivePerl 5.10, I need to save/convert Excel files as/to PDF files. I thought I'd come up with a roundabout solution -- write & save the Excel files as XML using Spreadsheet::WriteExcelXML and then convert them to PDFs with PDF::Template -- only to discover this morning that PDF::Template won't install on this Mac and that, according to Corion in post 771578, I'd lose my fancy formatting anyhow.

Any other solutions out there for me? Remember: I'm on a Mac, where I don't believe OLE is of any use (though Spreadsheet::ParseExcel, with its "OLE::Storage_Lite" dependency, installed and runs -- so maybe I'm a little confused).

Thanks. --cypress

PS: My spreadsheets include image files.

[NiJo]

I'd use a PDF printer, as it should be readily availabe for the CUPS based printing system. In most cases the name of tthe PDF file is somehow based on the XLS file. Your perl script just needs to do the printing, but in simple cases even that is not required. Just mark the XLS files and "print" to the PDF printer.

P.S: I'm not a Mac user

[jmcnamara]

I'm almost certain that you can't do what you want to do with the Spreadsheet::* modules.

If you have Excel installed you could probably do this easily enough using Mac Automator like in this example.

--
John.

[MidLifeXis]

Can you drive OpenOffice? I am usually happy with the Excel and PDF support offered by OpenOffice.

Update: You should also be able to use the print-to-PDF option built into the Mac printing system, assuming, of course, that you can somehow open the XLS file. I am a Mac user, and do this often when building meeting packets.

[marto]

Perhaps using OpenOffice::UNO to automate things.

Martin

[tbone1]

I'll second this. The built-in print-to-PDF functionality of OS X is one of the hidden gems of the operating system. I've caught myself trying to use it on Windows and Linux systems more than a few times.