How to Set Authorization Token for Internal API Calls in Aspose.Cells GridJs Spreadsheet

Aspose.Cells Product Family
1

Hi Aspose Team,

We are using Aspose.Cells GridJs Spreadsheet in our web application and it’s working well for displaying Excel files.

However, we are facing an issue with internal API calls, specifically when loading images via xs.setImageInfo(imageGetActionUrl, imageAddByUploadActionUrl, imageAddByUrlActionUrl, imageCopyActionUrl, zindex, loadingGif) or any other internal request made by GridJs. Our API is protected by a middleware that requires an Authorization token in the request headers.

Since GridJs seems to make direct client-side calls (e.g., setting img.src or issuing fetch/XHR), we cannot attach custom headers like Authorization: Bearer <token>.

Is there a built-in or recommended way in GridJs to set custom headers (e.g., Authorization token) for internal resource requests (such as images or data fetching)?

Alternatively, is there a way to intercept these requests or override the fetch logic so we can manually add the headers?

Any guidance or workaround (such as server-side proxying) that fits into the GridJs architecture would also be appreciated.

Thanks in advance for your help!

Best regards,
Mohamed Salahudeen

2

@salah010,

It seems you’re encountering Authorization token (issue) when integrating Aspose.Cells GridJs Spreadsheet into your web application. GridJs makes direct client-side requests (e.g., img.src, fetch, or XMLHttpRequest) for internal resources like images, which may bypass the ability to attach custom headers such as Authorization: Bearer <token>. We will check if you could implement server-side proxy endpoints that could handle these internal requests. While GridJs might not natively support setting custom headers for internal requests, you may configure the base URL for image fetching. We will evaluate other options and may get back to you with details.

3

@salah010
We’ll add a new option token to load options:
We’ll add refreshToken method to support refreshing the token

xs.refreshToken(token)

to support set authorization token in request headers.

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): CELLSGRIDJS-1620

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

Also, we currently have a valid Aspose.Total license for our project.

Can you please let us know if this qualifies us for any priority support or if we need a separate paid support subscription to get advanced technical help (especially for GridJs-spreadsheet customization like this)?

Looking forward to your response.

Thanks again!

5

@salah010
Thank you for your feedback. When you have a valid license to use Aspose products normally, the saved file does not have an evaluation page or evaluation information. And it is not limited by the evaluation version. However, the created ticket still provides normal support. If you need to upgrade support for the ticket, you need to purchase priority services.

In normal support here, we deal with issues on a first come, first served basis. We believe this is the fairest and most appropriate way to meet the needs of our customers.

Please check our paid support option where issues are prioritized and posses highest priority if your issue is a real blocker.

6

@salah010
If you have any additional customization requirements, feel free to bring them up. We will analyze/investigate one by one . Subsequently, we will incorporate them into our product version cycles based on the development progress. If your requirements have a more urgent time constraint, you may opt to purchase our priority service. In that case, we will fulfill your needs according to the level of priority assigned.
for the above ticket:
CELLSGRIDJS-1620
We 've planed to support it in v25.5 version which is expected to be published next month.

7

We also noticed that the “search functionality” (with a search icon) is built into the GridJs plugin UI. However, we want to “trigger and control the search programmatically” from our Angular application — for example, from a custom input field or button “outside” the GridJs-spreadsheet interface.

Could you please provide:

  • The public method (if available) to “trigger a search” in the loaded spreadsheet
  • How to programmatically go to the “next” or “previous” match
  • Any examples or usage patterns for integrating this with a custom UI

This would help us better integrate the spreadsheet experience into our existing UI.

Thanks once again!

8

@salah010
For a UI operation ,search feature is yet not designed as open APIs,however we can encapsulated it and provide as open APIs.

9

@salah010
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): CELLSGRIDJS-1622

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.

10

Hi Aspose Team,

Is there any event or callback provided by GridJs that triggers when the active sheet changes?

We would like to hook into this event to perform custom logic (e.g., log analytics, update UI components, or trigger other application behaviors) whenever the sheet changes.

If this event is not available out of the box, is there any suggested workaround or a way to track this through the GridJs instance?

Thank you!

11

@salah010,

I think you may try to use Aspose.Cells.GridJs’ sheet-selected event that triggers when the active sheet changes. You can use the sheet-selected event to detect when a user switches between sheets. This event provides both the sheet ID and name, allowing you to perform custom logic accordingly. See the following threads for your complete reference.
https://forum.aspose.com/t/gridjs-spreadsheet-event-for-object-selection/263456/6
https://forum.aspose.com/t/accessing-additional-sheets-in-gridjs/264128/19

Hope, this helps a bit.

12

@salah010
You can use

sheet-selected

or

sheet-loaded

event.

when clicking worksheet, it will raise sheet-selected event .
when worksheet is loaded, especially for images/shapes in the sheet were loaded, it will raise sheet-loaded event .

xs.on('sheet-selected', (id,name) => {
                console.log('sheet selected id:', id, ', name: ',name);
            }).on('sheet-loaded', (id,name) => {
                console.log('sheet load finished:', id, ', name: ',name);
            })

Please check the below document,
https://docs.aspose.com/cells/net/aspose-cells-gridjs/how-to-use-gridjs-client-api/#event-call-back

13

@salah010
Please update to the latest v25.5 release,
the client js.
the server side dll.
we now have supported the below api in the client js.

xs.refreshToken

1 Like
14

The issues you have found earlier (filed as CELLSGRIDJS-1620) have been fixed in this update. This message was posted using Bugs notification tool by leoluo

15

Thank you for your support

16

@salah010,

You are welcome. If you have any additional questions or feedback, please do not hesitate to reach out to us.

17

we would like to request support for multi-color highlighting in GridJs spreadsheet.

Currently, it appears that cell highlighting supports only a single color.

Would it be possible to:

  • Support multiple highlight colors per selection type or condition?
  • Allow programmatic control over highlight color styles for different cell ranges?

This would greatly improve the user experience in use cases like comparing data, indicating validation status, or categorizing input zones.

18

@salah010,

We would appreciate the opportunity to understand your requirements better. Could you kindly share additional details, screenshots, and any relevant resource files on multi-color highlighting feature to help us assess your needs? We will then look into them promptly.

19

@salah010
let me guess your scenario

1.add the highlight color in range {sri,sci,eri,eci}

xs.sheet.addHighlightRange(sri,sci,eri,eci,style)
 
 // the parameter is:
 style: the style for highlight ,currently only support color
 for example: {'color':'rgba(85, 57, 47, 0.08)'}

2.update the highlight color in range {sri,sci,eri,eci}

xs.sheet.updateHighlightRange(sri,sci,eri,eci,style)
 
 // the parameter is:
 style: the style for highlight ,currently only support color
 for example: {'color':'rgba(85, 57, 47, 0.08)'}

are these APIs ok?
or please provide detail scenairo and requirements.

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): CELLSGRIDJS-1666,CELLSGRIDJS-1667

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.

20

Hi Aspose Team,

We have a scenario where we need to highlight multiple cell ranges using different colors at the same time—for example, to indicate various statuses or categories within the same sheet.

However, it seems that GridJs only supports a single highlight color at a time, or that setting a new highlight overrides the previous one.

Our Questions:

  1. Does GridJs currently support applying multiple highlight colors simultaneously to different cell ranges?
  2. If not, is there a recommended workaround (e.g., using custom cell styles or overlays) to achieve this effect?
  3. Is there any planned support for this feature in upcoming versions of GridJs?
  4. is it possible to somehow use different colors for each specific added highlight text?

exmple :
sheet.addHighlightText(1,1,1,2,{color: ‘somecolor’} )
sheet.addHighlightText(1,2,1,2,{color: ‘secondcolor’} )
sheet.showHighlights()

This functionality would be very useful in scenarios involving data comparison, validation, or user-guided workflows.

Thanks in advance for your help and guidance!