We may have ERP, CRM, and even Business Intelligence tools, at one point we often find ourselves in Excel with data 🛠️ to analyze, process, verify or format for a report!

​

Whether for sales, purchasing or finance, Excel gives us unparalleled freedom to manipulate data. 🎖️

​

The problem presented to us by our client's management is the astronomic number of searches 🔍 and tab changes that somewhat complex Excel tables often require. Hours of clicking everywhere and doing CTRL-F to navigate the information ...

​

We were at the beginning a little perplexed because Excel is not necessarily our preferred platform, but our sense of service was the strongest and we found the miracle solution ... embedding a web page in Excel!   🤖 💥

Thanks to the Excel Script Lab add-in, it becomes possible to integrate a Web page with JavaScript code in Excel . Thus the user has directly under his eyes all the purchases & sales concerning the item being selected. And when the user changes line, the web page refreshes instantly 💢

​

​

​

​

​

The Excel Script Lab add-in provides access, via APIs, to all Excel functionalities. Thus, with this technology, it becomes possible to:

​

• read and write in all Excel tabs

• do research, extremely fast calculations

• display data in web interfaces, tables ...

• react to all user events: change of line, tab, modifications, etc.

• generate new data or graphs in tabs

• call external APIs in the IS or on the web

​

Thus the Web window becomes a real intelligent assistant 🧠 which explores the data and helps the user in all his data intensive tasks, avoiding him to waste hours browsing the tabs and doing research. 🌌

​

We then used this same technology to generate article data import files in the format required by the Shopify eCommerce site.