Import Json to excel and export excel to Json
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…
Category: Coding Tutorials
XmlHttpRequest – Http requests in Excel VBA
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…
Best practices of scraping website data for beginners
In the previous – article, I’ve explained how to scrape a website using selenium VBA and also mentioned that using selenium is not the best…
Develop Facebook chat bot using Javascript – Part 2
Continued from Develop Facebook chat bot using Javascript – Part 1
Develop Facebook messenger bot using Javascript – Part 1
Last month Facebook launched their messenger platform (beta) which provides API and tools to create a chat bot for facebook messenger. Since then many developers…
Scrape 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…
Android app development using web technologies
Android apps are all the rage now! Demand for Android apps isn’t going down anytime soon. Because of that demand every code enthusiast wants to…
Alexa rank checker with email notifications in Google sheets
Alexa rank is considered as one of the key factors in deciding a website’s standard. Right now google.com is the site with rank 1 followed…
Send Email from Google sheets with one line of code
Google sheets has been gaining a lot of popularity due to its collaborative features which is very good for small teams to work on data…
Browser 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…