You’re offline. This is a read only version of the page.
Announcements
84
I have a Excel file in SharePoint library where data was not in table format or rows, column format.
I want to read data from particular cells in the excel file , is this possible?
You can use Office Scripts. The script is written in Typescript, albeit Excel (Online) comes with a recording tool to make your life easier.
https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel
I've a few demo videos here https://www.youtube.com/playlist?list=PLzq6d1ITy6c2_qM_ocYDtEaENrqi92YmM including how to read and write to Excel without Tables.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉
Share
Report
All responses (
Answers (
