- GcExcel .NET Overview
- Key Features
- Getting Started
-
Features
- Worksheet
- Workbook
- Comments
- Hyperlinks
- Sort
- Filter
- Group
- Conditional Formatting
- Data Validations
- Data Binding
- Digital Signatures
- Formulas
- Custom Functions
- Shapes and Pictures
- Document Properties
- Styles
- Form Controls
- Barcodes
- Theme
- Chart
- Table
- Pivot Table
- Pivot Chart
- Sparkline
- Slicer
- Logging
- Defined Names
- Templates
- File Operations
- Release Notes
Configure Sheet Print Settings
You can set the PrintGridlines property, PrintHeadings property, BlackAndWhite property, PrintComments property and PrintErrors property of the IPageSetup interface in order to configure the print settings for the sheet.
//Configure sheet print settings
worksheet.PageSetup.PrintGridlines = true;
worksheet.PageSetup.PrintHeadings = true;
worksheet.PageSetup.BlackAndWhite = true;
worksheet.PageSetup.PrintComments = PrintLocation.InPlace;
worksheet.PageSetup.PrintErrors = PrintErrors.Dash;