cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Emac44
Helper II
Helper II

Read data from excel worksheet display error on power automate desktop

Does this mean I cannot import more than 16384 rows from excel on power automate desktop?

 

a1.PNG

 

 

System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: The column number must be greater than 1 or less than 16384.
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.GetExcelColumnName(Int32 columnNumber)
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.ReadFromExcel(Variant excelInstance, Variant startCol, Variant startRow, Variant endCol, Variant endRow, Variant& finalResult, Int32 readMode, Boolean getCellContentsAsText, Boolean firstLineContainsColumnNames)
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ReadFromExcel.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

2 REPLIES 2
Henrik_M
Super User
Super User

It means that you're trying to read more columns than Excel's maximum.

 

Check your input values.

VJR
Super User
Super User

 

Does this mean I cannot import more than 16384 rows from excel on power automate desktop?

 

It is about columns not rows.

 

Excel column limit is 16384, but are you really using those many? Check your column parameter.

 

https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-2...

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,104)