Share
ReportHi All,
How to delete the columns in excel using power automate cloud.
Regards,
Harsha.
Categories:
You’re offline. This is a read only version of the page.
Announcements
15
Hi All,
How to delete the columns in excel using power automate cloud.
Regards,
Harsha.
Hi @Harshavardhan ,
The solution can only delete the certain column . If you want to delete an empty column , I'm afraid that is not available.
Best Regards,
Bof
Hi @v-bofeng-msft ,
I have a column with header, My scenario is to identify the empty column and to delete it. Is there any solution?
Regards,
Harsha
Hi @Harshavardhan ,
I've made a test for your reference for your reference:
1\My Excel file (Excel Online)
2\New Script
All responses (
Answers (
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
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
