C# - print all files in a directory

Question

I'm looking for a way to print all files in a given directory. Each file will be an Excel doc created by my program.

I have tried using PrintDocument but couldn't figure out how I actually specify to PrintDocument which file it should be printing...

private void PrintSheets(string filepath)
{
            //get directory
            DirectoryInfo dirInfo = new DirectoryInfo(filepath);
            //get all files in directory
            FileInfo[] Files = dirInfo.GetFiles();

            //loop through files
            foreach (FileInfo file in Files)
            {
                //create new print doc
                PrintDocument printDocument = new PrintDocument();
                //select printer
                printDocument.PrinterSettings.PrinterName = cmbSelectPrinter.SelectedItem.ToString();
                //set filename document
                printDocument.DocumentName = file.Name;

                //print the doc
                printDocument.Print();               
            }
}

Any help appreciated. Thanks!

Did you look at the docs? The example there spells it out pretty plainly — DetectivePikachu, Nov 27 '19 at 15:44
you probably want to put some filtering like `*.xlsx` in your `dirInfo.GetFiles();` — T.S., Nov 27 '19 at 16:02

score 2 · Accepted Answer · answered Nov 27 '19 at 16:04

2

To print a file (document) you instruct the operating system to print it. Using Process.Start with the print Verb, and the filename.

The OS (Windows) will find the correct application to open the document (Excel) and send it a command to print the file.

 var fileName = @"C:\Path To Your Excel file.xlsx";

 var startInfo = new ProcessStartInfo(fileName);
 startInfo.Verb = "print";

 Process.Start(startInfo);

PrintDocument is when you want to layout and and print a document yourself.

answered Nov 27 '19 at 16:04

GvS

52,015
16
101
139

Exactly what I was looking for! Thank you. Is there any way to define which printer to use or will it always just use the default? – Paul Alexander Nov 27 '19 at 16:18
1

You can use the printto verb. Read the documentation for the Verb property. – GvS Nov 27 '19 at 16:21
Thanks for your help :) – Paul Alexander Nov 27 '19 at 16:51
@PaulAlexander [this answer](https://stackoverflow.com/a/37527746/5174469) might also be of help. At least it was for me ;) – Mong Zhu Nov 27 '19 at 16:58

C# - print all files in a directory

1 Answers1