Excel sheet keeps getting corrupted after i run my bot

Help Studio
, ,
1

my bot creates a data table, the extracts from pdfs and inputs the data into a excel sheet, where there are formulas in some columns to sort things out. every time I did this the excel became corrupted or broken. please help

1 Like
2

Hi @Shazid_Rahman,

Is the data retrieved not in proper format? also try using the workbook activities also if you can show us the data/code so that we can help.

Thanks

4

One thing to check - does your excel file have any comments or notes in it? That always breaks my files.

5

no it only has formulas in the coulnm

6

Are you using Workbook or Excel activities?

If you are using Workbook activities, try using Excel ones.

If you are using Excel activities, try using Workbook ones.

Also, do those tests using a brand new file.