Sudden issue with licencing

[MANISHA GHOSH]

I am using React spreadsheet in one of my projects for past 2 months. Everything was going smooth. Suddenly I am getting an error about wrong License key. I can assure that I am using a valid key for my project, and for the proper version, as it was working even a week ago.

Some things to note:

i) The error does not appear on the actual spreadsheet component.

ii ) The error is appearing in two places - Loading a saved file using base 64 and exporting in excel format.

Thus I am assuming the error is occurring whenever I am using this URL: 

https://services.syncfusion.com/react/production/api/spreadsheet/open

https://services.syncfusion.com/react/production/api/spreadsheet/save

Versions I am using: 

Kindly help with this.

Thank you,

Manisha

[Babu Periyasamy]

Hi MANISHA GHOSH,

We have reviewed your reported query and would like to inform you that we encountered a license error message when exporting Spreadsheet using the hosted Syncfusion service URLs provided in our demos. However, we have resolved the license issue in our online service and refreshed the services recently.

Additionally, please note that the online service URLs used for the Open and Save actions in our demos are intended for demonstration purposes only. Therefore, we recommend avoiding the use of these online service URLs for development purposes. Instead, we suggest creating and using your own local service for Open and Save actions.

We kindly inform you that we have implemented the Open and Save (server-side) functionality in ASP.NET Core and ASP.NET MVC using the Syncfusion XLSIO library. The XLSIO library is used on our server to handle these actions. When you open a file, the XLSIO library reads and converts it to a spreadsheet-compatible workbook in JSON format. Similarly, when you save the spreadsheet, we process the workbook JSON into an Excel model using the XLSIO library. Rest assured, your data is not stored on our server during these actions, ensuring it remains safe and secure.

Please follow the below steps to launch the local service on your end.

1. Download and unzip the attached local service (WebAPI).
2. Open the WebAPI.sln file in the WebAPI folder.
3. In that right click on the Dependencies folder inside WebAPI.
4. Then, click the Manage Nuget Packages.
5. In Browse, search Syncfusion.EJ2.Spreadsheet.AspNet.Core package and install the latest package.
6. If already, the package exists, remove the package, and re-install it to get the latest package with its necessary dependent packages will get downloaded.
7. Now, build the solution and run in a local host.

For your convenience, we have attached the Open and Save code snippets for the local service. Additionally, we have provided a local service sample along with the client-side sample below for your reference.

Code snippet:

//Open method

[HttpPost]

[Route("Open")]

public IActionResult Open([FromForm]IFormCollection openRequest)

{

    OpenRequest open = new OpenRequest();

    open.File = openRequest.Files[0];

return Content(Workbook.Open(open));

}

//Save method

[HttpPost]

[Route("Save")]

public IActionResult Save([FromForm]SaveSettings saveSettings)

{

return Workbook.Save(saveSettings);

}

After, launching the local service, you need to update the open and save URL in the Client-Side sample like in the below code snippet.

openUrl: 'https://localhost:{port number}/api/spreadsheet/open'

saveUrl: 'https://localhost:{port number}/api/spreadsheet/save'

Example:

openUrl: 'https://localhost:44354/api/spreadsheet/open'

saveUrl: 'https://localhost:44354/api/spreadsheet/save'

Note: Launch the service before running the client-side sample.

Local Service Sample: Please refer to the attachment below.

Client – Side Sample: https://stackblitz.com/edit/react-uvveppjf-yzp4jkue?file=index.js

Registering license in the shared webApi application.

Program.cs

Syncfusion.Licensing.SyncfusionLicenseProvider.RegisterLicense("Your Syncfusion license key");

For local service you need ASP.NET project as a backend for Open/Save functionality. And the Local service is available in the below GitHub location also:

https://github.com/SyncfusionExamples/EJ2-Spreadsheet-WebServices/

Create ASP.NET Core project and generate the license based on the below KB link.
https://www.syncfusion.com/kb/8976/how-to-generate-license-key-for-essential-studio-products

And include the licensed key in your project startup file as like in the below documentation link.
https://help.syncfusion.com/common/essential-studio/licensing/license-key

You can also host and run our Spreadsheet-oriented service as a Docker image. Utilizing a Docker image necessitates only a simple and basic Docker environment with minimal commands to effortlessly host and run our service. You can utilize the below service and use it for Spreadsheet Open and Save services, by pulling the spreadsheet docker image and following the steps from the URL mentioned below.

Spreadsheet docker image: https://hub.docker.com/r/syncfusion/spreadsheet-server

For more information regarding the docker deployment, please refer the below documentation.

https://ej2.syncfusion.com/react/documentation/spreadsheet/docker-deployment

Kindly check the above shared details and get back to us if you have any concerns.

Regards,

Babu.

Attachment: WebAPI_141a83ce.zip