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.
Printing spreadsheet (Excel), Powerpoint and other files
-
- Member
- Posts: 24
- Joined: Thu Dec 19, 2019 3:00 pm
- magnussandstrom
- Advanced member
- Posts: 376
- Joined: Thu Jul 30, 2020 6:34 pm
- Location: Sweden
- Contact:
Re: Printing spreadsheet (Excel), Powerpoint and other files
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
Example:
Command or path: C:/Program Files (x86)/2Printer/2Printer.exe
Arguments: -src "%1" -prn "\\printserver\printerA" -options alerts:no
-
- Member
- Posts: 24
- Joined: Thu Dec 19, 2019 3:00 pm
Re: Printing spreadsheet (Excel), Powerpoint and other files
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
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
-
- Member
- Posts: 38
- Joined: Tue Jun 01, 2021 11:57 am
Re: Printing spreadsheet (Excel), Powerpoint and other files
Here we use Sumatra PDF :
https://www.sumatrapdfreader.org/docs/C ... -arguments
-print-to-default -print-settings fit "%1"
https://www.sumatrapdfreader.org/docs/C ... -arguments
-print-to-default -print-settings fit "%1"
- magnussandstrom
- Advanced member
- Posts: 376
- Joined: Thu Jul 30, 2020 6:34 pm
- Location: Sweden
- Contact:
Re: Printing spreadsheet (Excel), Powerpoint and other files
Could a solution be to use the Excel-configurator to convert the Excel-file to PDF before sending to print?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.