I was in the same boat, it's such a different way of approaching the Object model compared to VBA. Glad to hear that people are finding it easy to understand!
Alex, you Hard Refresh the Run pane to fix the bug you see. Though, your video is almost 2 years old so, perhaps, Script Lab didn't have Hard Refresh then! I am confused by the .load method. My following script works fine without .load: const sheet = context.workbook.worksheets.getItem("Sheet1"); var range = sheet.getRange("C3"); range.values = [[5]]; As you can see I am using the range object values property yet I didn't use the .load method. Any ideas?
Great videos! Do you know how to reference a workbook by name, either by full UNC path or URL? Like if I were to pull in data from another workbook either on a local network, or a SharePoint site? I can't quite seem to figure that part out.
can you create like a sub workbook in the taskpane? For example lets say you load in data from a separate source, it fills it in like a mini excel sheet in your taskpane, then you can click insert with a cell selected and it puts it in the main workbook?
The answer is probably yes, but it's going to be a relatively complex process depending on how fancy/interactive you want to make this "task pane workbook". I do have a series planned where we will build an Excel Add-In using the new API from start to finish. The first series will be the simplest version we can possibly build, and then we will expand from there. I would call this a moderately complex add-in just because of the functionality we want to incorporate in the task pane. However, I will say that I like the idea where you're trying to make it interactive. I'll try to find a way to incorporate something similar to this in the "moderate" example. I'm envisioning it being something where we pull data from an API, show it all to the User, and then choose what they want to "import".
Well, the goal is to make it where you can automate office across multiple platforms. The problem is that because they need to be able to write it for Excel online, they decided to go with JavaScript/TypeScript. I personally, hear mixed reviews with JavaScript and I can see why. I'm hoping over time that it becomes a little less "awkward" using it, but it could be I'm just not as familiar with it as python.
Why I've found your channel that late... great video! Also I really like your style of teaching things, really cool approach.
It's what happens when you go down to the lower levels of RUclips :)
Very good videos. I have looked at this topic a number of times before. This is the first time I have begun to understand it. Thank you.
I was in the same boat, it's such a different way of approaching the Object model compared to VBA. Glad to hear that people are finding it easy to understand!
This series is great! Font size is fine.
I can read the font size just fine. Thanks!
great video, thank you
Alex, you Hard Refresh the Run pane to fix the bug you see. Though, your video is almost 2 years old so, perhaps, Script Lab didn't have Hard Refresh then!
I am confused by the .load method. My following script works fine without .load:
const sheet = context.workbook.worksheets.getItem("Sheet1");
var range = sheet.getRange("C3");
range.values = [[5]];
As you can see I am using the range object values property yet I didn't use the .load method. Any ideas?
Hi very good thanks, do you know how to conect sql server DB or API using this typescript office?
Great videos! Do you know how to reference a workbook by name, either by full UNC path or URL? Like if I were to pull in data from another workbook either on a local network, or a SharePoint site? I can't quite seem to figure that part out.
What if I wanted to access all items in column b?
Thanks
can you create like a sub workbook in the taskpane? For example lets say you load in data from a separate source, it fills it in like a mini excel sheet in your taskpane, then you can click insert with a cell selected and it puts it in the main workbook?
The answer is probably yes, but it's going to be a relatively complex process depending on how fancy/interactive you want to make this "task pane workbook". I do have a series planned where we will build an Excel Add-In using the new API from start to finish.
The first series will be the simplest version we can possibly build, and then we will expand from there. I would call this a moderately complex add-in just because of the functionality we want to incorporate in the task pane. However, I will say that I like the idea where you're trying to make it interactive. I'll try to find a way to incorporate something similar to this in the "moderate" example.
I'm envisioning it being something where we pull data from an API, show it all to the User, and then choose what they want to "import".
a dumb question is that what's the catch of replacing VBA with JS?! to me it looks like eating soup with a fork.🤔
Well, the goal is to make it where you can automate office across multiple platforms. The problem is that because they need to be able to write it for Excel online, they decided to go with JavaScript/TypeScript. I personally, hear mixed reviews with JavaScript and I can see why. I'm hoping over time that it becomes a little less "awkward" using it, but it could be I'm just not as familiar with it as python.