Anyone has idea on retrieving the selected text from excel access web part in SharePoint using javascript API?
Requirement: I have an Excel sheet which has a big matrix (multiple rows and columns). Based on user selection (range or cells or column) we should be able to show the data related to the selected text, below in another web part. Means we have code that takes the selected text as input and go and get data using other rest api's and will load content on the page. As we are unable to replicate the same UI using HTML/CSS (more complex and more maintenance) I am planning to use the excel directly.
Throw some ideas if there are any workarounds. Thanks in advance.