Re: Deleting Columns in excel using Power Automate Cloud
Hi @Harshavardhan ,
I've made a test for your reference for your reference:
1\My Excel file (Excel Online)
2\New Script
function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getWorksheet("Sheet1");
// Delete range E:E on selectedSheet
selectedSheet.getRange("E:E").delete(ExcelScript.DeleteShiftDirection.left);
}
3\My flow
4\Result
Column5 has been deleted .
Best Regards,
Bof
