How to create a script in Excel for the web At this point, you have a conceptual idea of what Office Scripts and TypeScript are, so let’s move on and create a script in Excel for the Web.

To count the number of words in an Excel sheet, you have to count each cell and add them together to get a final count of the whole sheet. Read: How to use the DGET function in Microsoft Excel.

In this case, if we count the occurrences manually, it will take more time. Moreover, if we have a huge dataset in Excel, calculating the occurrences of a text is almost impossible.