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?
Discussion posts and replies are publicly visible
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
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.