Need to read excel binary file which is having lakhs of data

Help Activities
, ,
1

Hi mates,

We are having excel binary file which is having lakhs of data. When I am using read range bot is failing with some Unexpected exit code error.

It is not taking time to read file immediately failing.I have used excel application scope and read range activity for this.

Let me know any possible solution to overcome this.

Thanks and Regards,
Jagadeesh G

2

Hello @JagadeeshG, try this:

lookupDataTable = Read Lookup File

folderFiles = Get List of Files in Folder

foreach row in lookupDataTable:
filename = row[“Filename”].ToString()
if folderFiles contains filename:
Remove filename from folderFiles

if folderFiles is not empty:
Log "Additional files found in folder: " + folderFiles
else:
Log “All expected files found in folder.”

Hope it helps,
Cheers! :slight_smile:

3

Hi,

we can split the data and read them.

  1. Build DataTable activity:

    • Output: Finaldt (DataTable)
    • Define the structure of the datatable (same columns as in Excel)

  2. Clear DataTable activity:

    • Input: Finaldt

  3. Excel Application Scope:

    • Use this scope to read data from the Excel file.

    Inside the scope:

    1. Read Range activity:

      • Output: dt1 (DataTable)
      • Range: “A1:H1000000”
      • Add Headers: Enabled

    2. Read Range activity:

      • Output: dt2 (DataTable)
      • Range: “A1000001”

    3. For Each Row activity:

      • Input: dt2

      Inside the loop:

      1. Add Data Row activity:
        • ArrayRow: row.ItemArray
        • DataTable: Finaldt

  4. Merge Data Table activity:

    • Source: dt1
    • Destination: Finaldt

So Finaldt will be our datatable with all records from excel.

4

Thanks @neha.upase for the solution, do we have any other solution without splitting.