Set width and height of sheet

Aspose.Cells Product Family
1

Using aspose.net in C# is there anyway to set the sheets width and height to 1 page (see attached to see example of where you would do this in excel)


//Open an Excel file
Workbook workbook = new Workbook(file.InputStream);

// Make every sheet fit one page
foreach (Worksheet sheet in workbook.Worksheets)
{
// Set width and height to 1 page?
}

2

Hi,


Well, you may use FitToPagesTall/Wide attributes for your needs. Please see the updated sample code (I have added few lines to the code segment accordingly):
e.g
Sample code:

//Open an Excel file
Workbook workbook = new Workbook(file.InputStream);

// Make every sheet fit one page
foreach (Worksheet sheet in workbook.Worksheets)
{
sheet.PageSetup.FitToPagesWide = 1;
sheet.PageSetup.FitToPagesTall = 1;
}

Thank you.