Page 1 of 1

Printing spreadsheet (Excel), Powerpoint and other files

Posted: Fri Jun 23, 2023 10:30 am
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.

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

Posted: Tue Jun 27, 2023 10:12 am
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

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

Posted: Tue Jun 27, 2023 4:45 pm
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

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

Posted: Tue Jun 27, 2023 10:56 pm
by tdeschampsBluewest
Here we use Sumatra PDF :
https://www.sumatrapdfreader.org/docs/C ... -arguments

-print-to-default -print-settings fit "%1"

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

Posted: Wed Jun 28, 2023 9:00 am
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?