Question

Getting RecordFormatException while updating the record in excel file.

Forum|Forum|3 years ago
January 17, 2023
3 replies
0 views

Getting "RecordFormatException" while updating the record in excel file.

Used apache poi with the version 4.0.0 for reading and writing to the excel file.

Can any one help on this issue?

jesusdaviniop8124

Hi,

As a first step, could you try the same functionally that you want to achieve with this plugin.

community.appian.com/.../rpa-excel-low-code-methods

please let me know the results. This library was Build using POI as well.

Thanks

Jesus

rakhiv392811Author

We have used java code with Appian RPA, So please suggest with that approach.

The recommended Appian RPA approach is to use Low Code Actions to create your robotic processes.

In this case, I also recommended you to try to read/write your excel file using that plugin from the App Market (valid for xls and xlsx files). This library is based on POI.

On the other hand, the exception that you have in your process, is a pure java exception when POI is trying to interact with your Excel file. It is not related to the Appian RPA platform. I am afraid that I can not offer you any suggestions Maybe you are trying to interact with a very large Excel file.