I am handling a number of projects and making Gantt charts to track their progress.
The data for these charts are stored in MS Excel sheets on my local drive. It becomes cumbersome to manually import the dates and numbers to update the Gantt chart. I want to know, if there is way I can circumvent this problem.
I was thinking if writing a code to read and write from my Excel files to update the Gantt charts would be possible so that, every time a change is made in the excel sheet, the Gantt chart gets updated.
Since Smartsheet is a cloud based platform, I would have to save my Excel sheets in Onedrive or Dropbox write? Or is it possible to link my Excel sheet when it is present in my Local C Drive ?
I am relatively amateur at coding, so I am having difficulties understanding the terms in this link: https://smartsheet-platform.github.io/api-docs/
Please let me know if APIs can be used to solve this problem.