Last Time I faced issue on Excel due to full number of rows. I solved by reading chunks of data.
The error code 0xE0434352 typically indicates an exception or error within the .NET framework. This error can occur for various reasons, including issues with the macro code, memory limitations, or conflicts with other applications or dependencies.
Here are a few steps you can try to troubleshoot and resolve the issue:
Check the Macro Code: Review the macro code in your Excel file and ensure that it does not contain any errors or problematic statements. Make sure that the macro runs successfully when executed directly in Excel without using UiPath.
Memory Limitations: The large size of the macro file (47MB) might be consuming significant memory during execution, especially if it contains complex calculations or data operations. Ensure that the machine running the process has enough available memory to handle the macro execution. If necessary, consider increasing the available memory or optimizing the macro code to reduce memory usage.
Update Dependencies: Ensure that you have the latest versions of dependencies, such as the .NET framework and the UiPath activities package. Outdated or incompatible versions can sometimes cause unexpected errors. Updating these dependencies may help resolve the issue.
Close other Applications: Close any unnecessary applications running in the background to free up system resources. Conflicts or resource limitations caused by other applications can sometimes lead to unexpected errors during execution.
Break the Process into Smaller Steps: If the macro processing is too resource-intensive or complex, consider breaking it down into smaller steps or separate workflows. This approach can help distribute the workload and reduce memory usage during execution.
Can you delete all excel processes from task Manager first and then run your workflow and if still doesn’t work may be the file is corrupted copy the same file information in another excel and then run and see if you are still receiving the error