Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Fri Apr 27, 2012 4:49 pm

Would you please give example for setup print area in coding?

Thanks!

ctseng123
 
Posts: 12
Joined: Sun May 22, 2011 10:25 pm

Tue May 01, 2012 10:36 am

Hi ,

Thanks for your patience and so sorry for the long-time waiting.

You can use the following code to set the print area:

Code: Select all
 workbook.Worksheets[0].PageSetup.PrintArea = "A1:F8";
//give the area you want to print

If you have any other questions, please feel free to contact us.

Have a nice day.

Kind Regards
Suvi
e-iceblue support
User avatar

Suvi.Wu
 
Posts: 154
Joined: Thu Oct 20, 2011 2:53 am

Fri Feb 15, 2013 9:24 am

Many thanks.

naigneeUrinia
 
Posts: 1
Joined: Sun Dec 23, 2012 11:14 pm

Return to Spire.XLS