Problem with Licence and GridWeb

Aspose.Cells Product Family
1

Hi,
I want to put a gridWeb in a ASPX, to display a chart directly in the page.
To do that, I create a ASPOSE.Cells workbook, I build my chart, and I put it in the gridweb.
The problem, is that a message appears directly on the chart (see the attached document), but I have a Total.Lic.

Here’s my code:

Dim workbook As Workbook = New Workbook()
Dim worksheet As Aspose.Cells.Worksheet = workbook.Worksheets(0)
Dim license As New Aspose.Cells.License
license.SetLicense(Me.Context.Server.MapPath(“bin/Aspose.Total.lic”))
worksheet.Cells(“A1”).PutValue(50)
worksheet.Cells(“A2”).PutValue(100)
worksheet.Cells(“A3”).PutValue(150)
worksheet.Cells(“B1”).PutValue(4)
worksheet.Cells(“B2”).PutValue(20)
worksheet.Cells(“B3”).PutValue(50)
Dim chartIndex As Integer = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column3D, 5, 0, 15, 5)
Dim chart As Aspose.Cells.Charts.Chart = worksheet.Charts(chartIndex)
chart.NSeries.Add(“A1:B3”, True)
Dim ms As MemoryStream = New MemoryStream()
workbook.Save(ms, SaveFormat.Excel97To2003)
ms.Position = 0
GridWeb1.WebWorksheets.ImportExcelFile(ms)


I put this code in the Application_Start of the Global.asax:
Dim lic As Aspose.Cells.GridWeb.License = New Aspose.Cells.GridWeb.License()
lic.SetLicense(Me.Context.Server.MapPath(“bin/Aspose.Total.lic”))

What is wrong with my code? I use the version 2.7.0.2000 of the gridweb and the version 7.0.3.0 of the aspose.cells.
Thanks

2

Hi,


You should set the license for both Aspose.Cells component and Aspose.Cells.GridWeb control before using any APIs of both Aspose.Cells and Aspose.Cells.GridWeb control, e.g
Dim license As New Aspose.Cells.License
license.SetLicense(Me.Context.Server.MapPath(“bin/Aspose.Total.lic”))

these lines also need to be processed before using any other APIs of Aspose.Cells.

We also recommend you to kindly try to download and install our latest version v7.1.1:
http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry360981.aspx
It has binaries (assemblies) for Aspose.Cells --> 7.1.1 and Aspose.Cells.GridWeb --> 2.7.3.xxxx


If you still find the issue, kindly provide us the sample project, you may zip it and attach it here. Also, do not include your Aspose.Total license in it. We will check it soon.

Thank you.


3

It works with the version that you recommended.

Thanks a lot!

4

Hi,


Thanks and good to know that your issue is resolved!