Answered

How to remove extra columns from datatable added automatically

(1) Share

Report

Posted on by kanha123_456

hi ,

i have 11 columns in my excel sheet but when i am using read data from excel sheet the extra columns added automatically ..like column 1 , column 2 like that in datatable .

How to remove these extra columns which added randomly

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

mathiaskjeldsen 224 on at

Like (0)

Report

Hey Kanha

Can you share a picture of what you are experiencing?

Best regards

Mathias Kjeldsen

Was this reply helpful? Yes No
Verified answer

VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (0)

Report
Hey Hi,

Please find the solution.

Code:

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Desktop\\Power Automate Desktop\\Practice\\Excel\\input.xlsx''' Visible: True ReadOnly: False Instance=> Input_ExcelInstance Excel.ReadFromExcel.ReadAllCells Instance: Input_ExcelInstance ReadAsText: False FirstLineIsHeader: False RangeValue=> Input_ExcelData SET ColumnValue TO 0 LOOP FOREACH CurrentItem_InputData IN Input_ExcelData[0] IF IsEmpty(CurrentItem_InputData) THEN Variables.DeleteColumnFromDataTable.DeleteColumnWithIndex DataTable: Input_ExcelData ColumnIndex: ColumnValue ELSE Variables.IncreaseVariable Value: ColumnValue IncrementValue: 1 END END

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards

Vishnu Reddy

Was this reply helpful? Yes No