Category "excel-online"

Edit many sheets in same time - Excel online No VBA or Power automate or else

My team had to move to Office365 and we cannot use anymore our former MS Excel with his VBA or our former G Sheets with his Scripts. I already redo the workbook

If cell contains ["text"], return ["text2"], else...leave it alone

I am using a shared spreadsheet from my company's Sharepoint site, so it's the "online" version of Excel. Basically, If text in column G equals "Classical", I n

TypeScript: Code to sum values in one column based on the value in another column in Excel

I am new to TypeScript and my goal today, would be to sum up all the cell values in a column in an Excel file, based on the cell values in an another column. In

How to find out the current group level of a range in excel for web using office-script

I am trying to find out how to identify the current group level of a range in office-script. Based on the documentation I was only able to find the group or ung