News & Releases

Minimize
Nasosoft Components for .NET v5.4.0 Released - Friday, September 06, 2013

Nasosoft Component for .NET v5.4.0 has released with many improvements.

What's new

Nasosoft Excel for .NET   
  • Bug Fixes

 

 

Nasosoft Excel for .NET

   Minimize
Print a Worksheet
Set Print Area
Code Sample
[C#]
 
//Create a Workbook object
XlsWorkbook workbook = new XlsWorkbook();
 
//Get the page setup of the worksheet
XlsPageSetup pageSetup = workbook.Worksheets[0].PageSetup;
 
//Set the area of the worksheet to print
pageSetup.PrintArea = "A1:D20";
 
[VB.NET]
 
'Create a Workbook object
Dim workbook As XlsWorkbook = New XlsWorkbook ()
 
'Get the page setup of the worksheet
Dim pageSetup As XlsPageSetup = workbook.Worksheets(0).PageSetup
 
'Set the area of the worksheet to print
pageSetup.PrintArea = "A1:D20"
 
Set Print Tile
Code Sample
[C#]
 
//Create a Workbook object
XlsWorkbook workbook = new XlsWorkbook();
 
//Get the page setup of the worksheet
XlsPageSetup pageSetup = workbook.Worksheets[0].PageSetup;
 
//Set print title columns
pageSetup.PrintTitleColumns = "$A:$B";
 
//Set print title rows
pageSetup.PrintTitleRows = "$1:$2";
 
[VB.NET]
 
'Create a Workbook object
Dim workbook As XlsWorkbook = New XlsWorkbook ()
 
'Get the page setup of the worksheet
Dim pageSetup As XlsPageSetup = workbook.Worksheets(0).PageSetup
 
'Set print title columns
pageSetup.PrintTitleColumns = "$A:$B"
 
'Set print title rows
pageSetup.PrintTitleRows = "$1:$2"