- 3
- 4 004
Automating Excel with Javascript
Приєднався 31 гру 2021
This channel focuses on how to automate Excel with JavaScript--instead of VBA. In 2013, Microsoft introduced the Excel JavaScript API that allows you to manipulate Excel using JavaScript. However, they have only presented it as a way to create add-ins--not as a way for power users of Excel to automate their workflows. In 2021, I wrote an Excel add-in that allows you to work with JavaScript in much the same way you work with VBA. That is, you store your code directly in the workbook. But the great thing is, it does not have to be a macro-enabled workbook. Yep, you can write this code in a regular non-macro-enabled, .xlsx workbook. The add-in is available in the add-in store form inside Excel. It is called the JavaScript Automation Development Environment (JADE). It's free.
A walkthrough of using the JavaScript Automation Development Environment (JADE) add-in for Excel.
JADE allows you to automate your Excel workflows using JavaScript. Save your code in non-macro-enabled workbook files!
More details and the codes you need to follow along are at blog.jsvba.com/2021/12/a-walk-through-of-using-jade.html
More details and the codes you need to follow along are at blog.jsvba.com/2021/12/a-walk-through-of-using-jade.html
Переглядів: 2 788
Відео
Installing the JavaScript Automation Development Environment (JADE) on Excel Online
Переглядів 8162 роки тому
This video just shows how to install JADE, an add-in for Excel Online that allows you to automate your workflow using JavaScript as a replacement for VBA. More information at the blog: blog.jsvba.com/2021/12/introduction.html
Installing the JavaScript Automation Development Environment (JADE) on Office 365 for Windows
Переглядів 4002 роки тому
This video just shows how to install JADE, an add-in for Excel that allows you to automate your workflow using JavaScript as a replacement for VBA. More information at the blog: blog.jsvba.com/2021/12/introduction.html
Nice !!! i've been trying JADE but i have some questions: Can you delete a module ? can you call functions from a module A into a module B ?
Will this allow office script codes or typescript codes?
very nice. I have a few questions: 1, Can this do all the operations that the VBA code does? 2. It will be very usefull if you target the different areas that a VBA code operates and demonstrate here, what the alternative would look like with js. 3. How do you target specific cells, do varous loops, deal with arrays, collections, dictionaries ? 3. where to find other GIST IDs?
I cannot see JADE in my installation list. What do I do? Thanks.
I cannot see the jade option on my 365 on PC.