JavaScript to read cells from an excel worksheet

Question

JavaScript to read cells from an excel worksheet

Jeff Huber 1

Hello,

I manage a webpage that is running on a fileserver. The webpage opens various reports. I have a nice drop down menu using CSS. In the middle of the page I have some JPEG images of Excel charts that change when the user moves the mouse over a different button.

What I would like to do is the following:
When the user moves the cursor over the button, I would like a popup window showing a preview of the actual excel chart instead of the JPEG image. There should also be a link to the excel file in the popup window.

I appreciate ay assistance.

Jiping Shi 1 Reputation point

2022-02-24T02:49:07.483+00:00

You can try displayDialogAsync API to show dialog, details https://learn.microsoft.com/en-us/office/dev/add-ins/develop/dialog-api-in-office-add-ins, as for how to get the preview of actual excel chart, you can try to find the shape, chart is also one kind of shape, and then use shape.getAsImage() to get the preview of the chart, hope this help.

Your answer

Jiping Shi 1 Reputation point

2022-02-24T02:49:07.483+00:00

You can try displayDialogAsync API to show dialog, details https://learn.microsoft.com/en-us/office/dev/add-ins/develop/dialog-api-in-office-add-ins, as for how to get the preview of actual excel chart, you can try to find the shape, chart is also one kind of shape, and then use shape.getAsImage() to get the preview of the chart, hope this help.

Share via

JavaScript to read cells from an excel worksheet

Your answer