Read range large excel as database

Help Activities
, ,
1

I am trying to read range large excel (740k rows) as database to make it easier for me to query on the values that I want. The sequence as follows:

For loop (different value type for query)
Kill excel process > connect db excel > execute query > disconnect DB > write
range > proceed next value to query

I have checked that the excel is not corrupted and I receive error as follows:
System.Exception: Job stopped with an unexpected exit code: 0xE0434352

2

Hi @aqiffm ,

To check for potential errors or issues in your code, you can follow these steps:

  1. Review your code: Go through your UiPath workflow and carefully examine the activities, variables, and expressions used. Look for any potential syntax errors, missing or wrong configurations, or logical mistakes.

  2. Use debugging tools: UiPath provides debugging options that allow you to step through your workflow and track the execution flow. You can set breakpoints, check variable values, and identify the point of failure.

  3. Check the error message: The error message “System.Exception: Job stopped with an unexpected exit code: 0xE0434352” may provide additional details about the specific issue. Analyze the message to understand the nature of the error and try to pinpoint the potential cause.

  4. Consult UiPath forums or documentation: Reach out to the UiPath community through forums or consult the official UiPath documentation for more guidance. Other users may have encountered similar issues and could have shared solutions or workarounds.

  5. Experiment with different approaches: Consider trying alternative methods for reading large Excel files, such as using the Excel VBO (Visual Basic for Applications) package or splitting the file into smaller chunks before processing.

By following these steps, you can troubleshoot and understand the cause of the issue, and then make necessary adjustments to your workflow to overcome it

Thanks,

3

Hi @aqiffm

check if there is excel running in the background before executing the code in the task manager.if yes,Please close and execute.

or

Check the below thread

Hope it helps!!

4

i have kill process when it starts. therefore, it is impossible for excel to run at the background

1 Like
5

I have resolved this. Use and develop in Windows project since Windows legacy have limited RAM usage.

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.