Free Support Forum - aspose.com

Number of copies

Hi there

I have a small problem. I can create a a workbook without any apparent problems.
The thing is, when I try to print, the default number o copies is 12336.
I can’t find a property to set this value to 1.
What am I doing wrong?

Thanks in advance,
drati

Hi,

By default, the number of copies option should show 1 when you create a new excel file from the scratch. If you want to manipulate the attribute programmatically, I am afraid your request is linked with Print Settings that enforces some limitation. We need to check/analyze whether this print setting is saved with the Workbook or not. If the information is saved with the excel file, we can support it otherwise we cannot.

We will get back to you soon.

Thank you.

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

Please use PageSetup.PrintCopies property to set Number of copies to be printed. Please see the following sample code in this regard.

//Instantiating a Workbook object

Workbook workbook = new Workbook();

//Open the template workbook

workbook.Open("C:\\CustomerReport.xls");

//Accessing the first worksheet in the Excel file

Worksheet worksheet = workbook.Worksheets[0];

//Setting the orientation to Portrait

worksheet.PageSetup.Orientation = PageOrientationType.Portrait;

//setting number of copies to be printed

worksheet.PageSetup.PrintCopies = 1;

//Save the workbook

workbook.Save("C:\\PageSetup.xls");

Thank You & Best Regards,