You’re offline. This is a read only version of the page.
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 😉
#1
WarrenBelz
146,635
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
