Printing spreadsheet (Excel), Powerpoint and other files

Post Reply
matthew.hearne
Member
Posts: 24
Joined: Thu Dec 19, 2019 3:00 pm

Printing spreadsheet (Excel), Powerpoint and other files

Post by matthew.hearne »

We are looking for a way to automatically send a number of different file types to a printer.

We currently print out PDFs fine using PDFPrinter but wondered what would be the best solution for other file types.

And for things like Excel files, we'd need to scale them to fit on the page.
User avatar
magnussandstrom
Advanced member
Posts: 365
Joined: Thu Jul 30, 2020 6:34 pm
Location: Sweden
Contact:

Re: Printing spreadsheet (Excel), Powerpoint and other files

Post by magnussandstrom »

I've been using this with Execute command: https://www.cmd2printer.com

Example:
Command or path: C:/Program Files (x86)/2Printer/2Printer.exe
Arguments: -src "%1" -prn "\\printserver\printerA" -options alerts:no
matthew.hearne
Member
Posts: 24
Joined: Thu Dec 19, 2019 3:00 pm

Re: Printing spreadsheet (Excel), Powerpoint and other files

Post by matthew.hearne »

Hi

Thanks for the solution to this.

One issue we have is with Excel files and scaling to fit on a page.

I can't see a way to do this. It appears that all of the scaling for Excel files is handled within Excel. I know when you print from it, you can tell it to fit the Worksheet to the page.

If a document has not been setup in that way though, can we force it to fit to page?

Hope that makes some sense!

Thanks,
Matt
tdeschampsBluewest
Member
Posts: 37
Joined: Tue Jun 01, 2021 11:57 am

Re: Printing spreadsheet (Excel), Powerpoint and other files

Post by tdeschampsBluewest »

Here we use Sumatra PDF :
https://www.sumatrapdfreader.org/docs/C ... -arguments

-print-to-default -print-settings fit "%1"
User avatar
magnussandstrom
Advanced member
Posts: 365
Joined: Thu Jul 30, 2020 6:34 pm
Location: Sweden
Contact:

Re: Printing spreadsheet (Excel), Powerpoint and other files

Post by magnussandstrom »

matthew.hearne wrote: Tue Jun 27, 2023 4:45 pm One issue we have is with Excel files and scaling to fit on a page.
Could a solution be to use the Excel-configurator to convert the Excel-file to PDF before sending to print?
Post Reply