I am evaluating aspose.cell componet for one our excel reporting requirements from .net applications. I have down loaded the evaluation software and created a test application. The excel file is generated succesfully in the folder i have mentioned, but the worksheet.pagesetup options are not changed as I have specified in the code. Am I missing any files here, Please let me know.
Here is the code:
Dim excel As Excel = New Excel
excel.Worksheets(0).Name = "ASPose Test"
Dim ws As Worksheet = excel.Worksheets(0)
.Orientation = PageOrientationType.Landscape
.Zoom = 51
.PrintTitleColumns = "$A:$C"
.PrintArea = "A1:K9"
.FitToPagesWide = 2
.FitToPagesTall = 1
Out put file also attached for your reference.