Excel with Pivot table opens and then crashes



I am using a UIPath sequence that scrapes data from a web application.The scraped data is written using Python script on the excel sheet. UIPath is used to generate a pivot table through excel. The binary table is created in the next step on the same sheet using pivot data. The execution works fine and the excel is generated. When I try to open the excel file containing pivot data after execution. The excel file crashes. The file size generated is 37Kb.

Also checked with the microsoft excel portals on the same but failed to get a response.

The link contains the following:
"## Check whether your file is being generated by a third party

Sometimes Excel files are generated by a third-party application. In this case, the files may be generated incorrectly, and some features may not work properly when you open the files in Excel. If this occurs, test the features in new files outside the third-party application. If the features work correctly, you should make sure that the third party is aware of the issue.

If your issue is not resolved after you test it outside the third-party application, continue on to the next item on the list."


Hi @pratosha.hegde

It would be awesome if you could prepare a sample project for us to investigate. It should ideally reproduce the faulty behaviour on each run. If it is a bug that we can fix, it will be done :slight_smile: