Getting a Json parse error when trying to load certain Excels

Aspose.Cells Product Family
1

We are getting a Json error when trying to load in certain excels. It seems like this might be related to having a Textbox object type in the excel. Attached is a problem Excel and the console error.

image.png (150.0 KB)

Rtxt Error Excel.zip (22.9 KB)

2

@gpaolano,

I simply used the following line of code using Aspose.Cells for .NET v23.1 and it works fine:
e.g.
Sample code:

Workbook wb = new Workbook("e:\\test2\\Enron_000715950.xls");

Could you please share your sample code. Are you using Aspose.Cells.GridJs?

3

@gpaolano
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSAPP-2599

You can obtain Paid Support services if you need support on a priority basis, along with the direct access to our Paid Support management team.

4

Yes, we are using Aspose.Cells.GridJs and loading the Json data from server-side.

fetch('/api/wbjson/' + _fileId + '/')
                .then((response) => {
                    return response.json();
                })
                .then((wbjson) => {                        
                    xs = x_spreadsheet('#gridjs',
                        {
                            showToolbar: false,
                            mode: 'read',
                            local: 'en',
                            showContextmenu: true,
                            contextMenuItems: {
                                usedefault: false,
                                customItems: [
                                    (Some context menu items here)
                                ]
                            }
                        }).loadData(wbjson.data);

     (...does some other initialization stuff)
5

@gpaolano

Thanks for your feedback. We have logged it in our internal issue tracking system.

6

@gpaolano It has been fixed in the v23.2 release ,please try update your package through nuget update

7

Thank you very much!

8

@gpaolano,

You are welcome.