I updated local studio enviroment community edition and it seems Read Range activity is fluctuating and doesn’t allow to set value of output. Also it is giving errors in reading excel sheet as my SharePoint sheet has ColumnNames and it’s reading as A.B C. I am not able to change any value on property as it always move to Default. It also generating DataTables as TypedDataTable1, 2 etc for each type you add. This also making iterating over the output as it’s not standard DataTable now. It was working fine till yesterday and suddenly throwing errors like: Read Range: Column names or order do not match. Individual errors: at index 0: expected: Column A but got Surname, at index 1: expected: Column B but got FirstName, at index 2: expected: Column C but got MiddleName, at index 3: expected: Column D but got ApplicantName, at index 4: expected: Column E but got ApplicantAddress. Something very serious has been introduced as ut has stopped all SharePoint excel sheets processing
{
“message”: “Read Range: Column names or order do not match. Individual errors: at index 0: expected: Column A but got License, at index 1: expected: Column B but got ApplicantName, at index 2: expected: Column C but got prevRegisterNumber, at index 3: expected: Column D but got newRegisterNumber, at index 4: expected: Column E but got isRecordNCPType\r\nin Main.xaml\r\n at ReadRangeConnections`1 "Read Range"\r\n at Sequence "Process Food Act Update and Add process for all pending licenses"\r\n at Sequence "Main Sequence"\r\n at Main "Main"\r\n”,
“level”: “Error”,
“logType”: “Default”,
“timeStamp”: “07:30:09”,
“fileName”: “Main”,
“jobId”: “f7ee5052-c9eb-4ba0-ab63-80aaa6ca65d7”,
"
“robotVersion”: “26.0.191-cloud.22694”,
“userKey”: “40f48f10-0cdd-44a3-af39-2e95c3a00ca4”,
“processVersion”: “1.0.0”,
“”
}
Hi @alokverma75
Please try this approach
1 Delete and re add Read Range activity
2 Enable “Use First Row as Headers
3 Change output variable type to System.Data.DataTable
4 Reinstall or downgrade UiPath.Excel.Activities package
5 Try using Use Excel File (Modern) or test with local file
If solution works for you please mark as solution
Thanks
Same issue. Read range is malfunctioning. It is moving to a new value called ‘default’ in has headers. So a workflow which worked till yesterday is not running anymore.
hi @alokverma75 , thank you for flagging this, I’ve raised a bug on our side and we are working on providing a fix for this.
Ths issue is when you are using SharepPoint excel file using online M365 connection and there is no such property which you mentioned. Actually, it keeps on fluctuating and every time you set it to Add Headers it switches back to default and it just don’t allow to set output values too. Seems it’s a bug introduced in the last update as acknowledged. As a work around I am downloading file locally and working but it’s additional step required unnecessarily as I have to uploaded excel sheet to SharePoint again.
Many thanks for prompt action as it’s really very basic activity which should not have broken, It seems with every connection is creates a Typed datatable with a new value like 1,2 3, 4 and it keeps on fluctuating making it unusable. I tried auto-pilot too for the solution but that agreed it’s a bug afer a marathon 5 hours efforts. Hope this can be resolved shortly.
Hi @Raluca_Laic , Any tentative timeline for this fix as it seems reverting to previous versions too didn’t solve the issue. Is there any particular package which I can revert to make this work till that time?
hi @alokverma75 , the fix has been delivered through Studio. What version are you currently using, the version 26.0.191-cloud.22696 is the one containing the fix.
Great. I am using 2026.0.191 STS community edition Studio desktop
Is the issue remediated? You can check the exact version you have by navigating backstage to Help and click on Copy info.
Yes, all working fine now. I have tested all my workflows. Superb. Many thanks as Community editions too got update for 3.8.11 M365 package.