Formatting pagesetup options are not SET in evaluation copy

Aspose.Cells Product Family
1

Hi,

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:

Imports Aspose.Cells

Dim excel As Excel = New Excel

excel.Worksheets(0).Name = "ASPose Test"

excel.Save("C:\test\aspose_test.xls")

Dim ws As Worksheet = excel.Worksheets(0)

With excel.Worksheets(0).PageSetup

.Orientation = PageOrientationType.Landscape

.Zoom = 51

.PrintTitleColumns = "$A:$C"

.PrintArea = "A1:K9"

.FitToPagesWide = 2

.FitToPagesTall = 1

End With

Out put file also attached for your reference.

Thanks,

Prakash billa

2

I don't find your attached file.

For your sample code, please try to change it to:

Imports Aspose.Cells

Dim excel As Excel = New Excel

excel.Worksheets(0).Name = "ASPose Test"

Dim ws As Worksheet = excel.Worksheets(0)

With excel.Worksheets(0).PageSetup

.Orientation = PageOrientationType.Landscape

.Zoom = 51

.PrintTitleColumns = "$A:$C"

.PrintArea = "A1:K9"

.FitToPagesWide = 2

.FitToPagesTall = 1

End With

excel.Save("C:\test\aspose_test.xls")

3

It's working. Looks like I ma saving the excel file before the format options are set.

Thanks for your help.

Can I get a temporaty licence for 30 days evaluation. here is my order id: 060322202037

Thanks,

Prakash Billa

4

Please post your temporary license request at http://www.aspose.com/Community/Forums/220/ShowForum.aspx. Our sales team will support you soon.