Example of Print in ASP.NET MVC Spreadsheet Control

Spreadsheet
Printing
Print

This sample demonstrates the print functionality of the Spreadsheet within a car sales scenario as an example.

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAY
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Ivaa Premium Cars
CustomerNameMailIDModelNoofcarsDeliveryDateAmount
Sarah Johnsonsarah.johnson@example.comTaurus27/11/2020$8,529.22
Michael Smithmichael.smith@example.comSparrow17/13/2021$17,866.19
Emily Davisemily.davis@example.comGrand Cherokee19/4/2020$13,853.09
John Andersonjohn.anderson@example.comGTO312/15/2022$2,338.74
Jessica Martinezjessica.martinez@example.comLX210/8/2019$9,578.45
Daniel Thompsondaniel.thompson@example.comCatera17/1/2022$19,141.62
Samantha Harrissamantha.harris@example.comSeries 7312/20/2020$6,543.30
Christopher Wilsonchristopher.wilson@example.comCorvette211/24/2019$13,035.06
Ashley Brownashley.brown@example.comRegal15/12/2019$18,488.80
Matthew Taylormatthew.taylor@example.comS4212/30/2019$12,317.04
Olivia Garciaolivia.garcia@example.comTL312/18/2023$6,230.13
David Hernandezdavid.hernandez@example.comClub Wagon22/2/2020$9,709.49
Emma Mooreemma.moore@example.comV8 Vantage211/19/2019$9,766.10
Andrew Lewisandrew.lewis@example.comCaravan32/8/2019$7,685.49
Elizabeth Clarkelizabeth.clark@example.comBravada18/5/2021$18,012.45
James Walkerjames.walker@example.comColorado35/30/2021$2,785.49
Ava Rodriguezava.rodriguez@example.comRunner312/10/2021$9,967.74
Ryan Whiteryan.white@example.comTSX310/23/2019$5,584.33
Noofcars
Properties
Print type
Enable row and column headers

Enable gridlines

In this example, the spreadsheet's "File" menu features a "Print" option, allowing you to print the current worksheet without gridlines as well as row and column headers, which serves as the default print setting. You can also invoke the print option using the Ctrl + P keyboard shortcut. Any texts, charts, images, and formatted content incorporated into the document will be previewed and then printed.

Furthermore, there are built-in customization options available. If you need to print either the current worksheet or the entire workbook, you can select the appropriate option from the "Print type" dropdown list in the property panel. To include row and column headers in the printed output, you can check the "Enable row and column headers" checkbox. Similarly, you can include gridlines in the printed output by checking the "Enable gridlines" checkbox. Upon selecting the desired options in the property panel and clicking the "Print" button, the print method of the spreadsheet is invoked, facilitating customized printing.

Transform your ASP.NET MVC web apps today with Syncfusion® ASP.NET MVC components
100+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE
opens in a new tab