Hello Everyone,
I am experiencing an issue with the an Excel function. Below is how my data looks like(Sorry i was not allowed to attach the Excel file since I am an new user):
17% 13% 6% 4% Others
TaxableAmt 100 100 100 100 100
Tax 17 13 6 4 7
I used the “read range” function and made sure I selected the “Add Header” selection. Then i used the function datatable.rows(1).item(“17%”), expecting to get the number 17. But it has been trhowing the error “Column ‘17%’ does not belong to table”. It seems that Uipath couldn’t recognize “17%” as a column name while “Others” was recognized.(And i was able to get the number ‘7’, which i expected)
I have double checked everything. But for a process so small and simple, I could not find anything that could go wrong.
Can anyone help? Any input is appreciated!
Thank you so much.