I have this live excel worksheet in share point. I want to update the contents of the file in that excel sheet using data scraped from a website. So I am done with the data scraping part.
Things I wanted to do:
Getting into sharepoint and opening the particular excel sheet link to update it
In excel worksheet. It has 8 columns. I wanted to update only 6 columns. Rest of the 2 columns should be untouched
I wanted to know how to make these above 2 things happen. A little guidance would be helpful