Scrape CSV web data with Excel Office Scripts

preview_player
Показать описание
Microsoft recently announced new Get Data functionality for Excel Online. It is being rolled out this year 2022. In the meantime you can use Office Scripts to perform webscraping to obtain data from online resources like GitHub. In this video I demo Office Scripts code that uses the Fetch function to obtain a csv file without using an Interface – an artifice that structures returned data.

Рекомендации по теме
Комментарии
Автор

Thanks a lot for the example, worked good for me!

KrossAvDemoner