Output while reading excel file

[kadiravan_kalidoss (Kadiravan K)]

@office_work

Could not write the data table starting with cell A1.

Hi @office_work ,

Please check these suggestions below:

Excel append range gives UiPath.Excel.ExcelException: Could not write the data table DataTable starting with cell A1

Please check the data in your excel. In my case the error is caused by ‘=’ or ‘==’ symbol in one of the row. I noticed this by running it multiple time and saw the robot always stuck at the same row. In my case i can filter the data as it is not required and proceed with write range/append range activity.

Excel append range gives UiPath.Excel.ExcelException: Could not write the data table DataTable starting with cell A1

Hey, Im not sure if you have already fixed your issue, But I was having the same error as you and I realised it was because there was a cell in the dateable that somehow started with a “=” even thought it wasn’t a formula. You could check if that is the case for you. I fixed this by using a for each row, assign the cell value to " ’ " + Original Cell Value, The " ’ " is used in excel to combat excel formatting and is not visible in the output. Hope this helps you and others having the same is…

Excel append range gives UiPath.Excel.ExcelException: Could not write the data table DataTable starting with cell A1

Check data to be written in excel file, the data might contain special characters, formulas etc bad data which results in failure while writing to excel file. Alternative solution, use workbook write range

Thanks!