JSON (Javascript Object Notation) is the most used data exchange format nowadays. Microsoft Excel doesn’t have built-in support for importing JSON to excel or exporting…
View More Import Json to excel and export excel to Json (Updated 2022)Tag: Excel
XmlHttpRequest – Http requests in Excel VBA (Updated 2022)
Excel is a powerful and most popular tool for data analysis! HTTP requests in VBA gives additional capabilities to Excel. XmlHttpRequest object is used to…
View More XmlHttpRequest – Http requests in Excel VBA (Updated 2022)Parse HTML in Excel VBA – Learn by parsing hacker news home page (Updated 2022)
Why parse HTML in Excel VBA? There may be different cases where we need to parse HTML in Excel. Few cases are generating multiple HTML…
View More Parse HTML in Excel VBA – Learn by parsing hacker news home page (Updated 2022)Apps script to delete resolved comments in google sheets? | Answering viewers questions
This is a new series called “Answering viewers coding questions”. Someone has requested me for an answer on Quora – “What is an apps script…
View More Apps script to delete resolved comments in google sheets? | Answering viewers questionsConvert Json to csv and csv to Json in Excel VBA
I recently received a query on how to convert JSON to CSV. Usually, If the JSON file is small or has a simple structure then…
View More Convert Json to csv and csv to Json in Excel VBAHow to build a simple weather app in Excel VBA
One of our readers posted a question on forum asking how to get weather data using VBA. So I created a very simple weather app…
View More How to build a simple weather app in Excel VBAScrape website using Selenium VBA
This post is continuation to Browser automation in Excel using Selenium VBA. Have a look at that post first as it explains how to get…
View More Scrape website using Selenium VBABrowser automation in Excel VBA using Selenium
When it comes to browser automation tasks in Excel VBA like filling a web form, login to a website etc. most of them use Internet…
View More Browser automation in Excel VBA using Selenium