Excel API Library for .NET - Sample Browser | Document Solutions | Printing workbook
[
フレーム]
Refer to the following example code to see how to output the workbook to printer.
//create a new workbook
var workbook = new GrapeCity.Documents.Excel.Workbook();
object[,] data = new object[,]{
{"Name", "City", "Birthday", "Eye color", "Weight", "Height"},
{"Richard", "New York", new DateTime(1968, 6, 8), "Blue", 67, 165},
{"Nia", "New York", new DateTime(1972, 7, 3), "Brown", 62, 134},
{"Jared", "New York", new DateTime(1964, 3, 2), "Hazel", 72, 180},
{"Natalie", "Washington", new DateTime(1972, 8, 8), "Blue", 66, 163},
{"Damon", "Washington", new DateTime(1986, 2, 2), "Hazel", 76, 176},
{"Angela", "Washington", new DateTime(1993, 2, 15), "Brown", 68, 145}
};
IWorksheet worksheet = workbook.Worksheets[0];
worksheet.Range["A1:F7"].Value = data;
worksheet.Range["A:F"].ColumnWidth = 12;
//add table.
worksheet.Tables.Add(worksheet.Range["A1:F7"], true);
// Create a print options.
PrintOutOptions options = new PrintOutOptions();
// Set the printer name to print.
options.ActivePrinter = "[Real printer name]";
// Print 3 copies.
options.Copies = 3;
//Set Double-sided, vertical printing.
options.Duplex = System.Drawing.Printing.Duplex.Vertical;
//Print this workbook to "Microsoft Print to PDF".
workbook.PrintOut(options);
' Create a new Workbook
Dim workbook As New Workbook
Dim data As Object(,) = {
{"Name", "City", "Birthday", "Eye color", "Weight", "Height"},
{"Richard", "New York", #6/8/1968#, "Blue", 67, 165},
{"Nia", "New York", #7/3/1972#, "Brown", 62, 134},
{"Jared", "New York", #3/2/1964#, "Hazel", 72, 180},
{"Natalie", "Washington", #8/8/1972#, "Blue", 66, 163},
{"Damon", "Washington", #2/2/1986#, "Hazel", 76, 176},
{"Angela", "Washington", #2/15/1993#, "Brown", 68, 145}
}
Dim worksheet As IWorksheet = workbook.Worksheets(0)
worksheet.Range("A1:F7").Value = data
worksheet.Range("A:F").ColumnWidth = 12
'add table.
worksheet.Tables.Add(worksheet.Range("A1:F7"), True)
'Create a print options.
Dim options As New PrintOutOptions
'Set the printer name to print.
options.ActivePrinter = "[Real printer name]"
'Print 3 copies.
options.Copies = 3
'Set Double-sided, vertical printing.
options.Duplex = System.Drawing.Printing.Duplex.Vertical
'Print this workbook to "Microsoft Print to PDF".
workbook.PrintOut(options)