I’d like to read all the data from a specified sheet using the Read Range activity within an Excel Process Scope, but only some of the data gets stored. (It always stops reading at the same point.)
The process itself doesn’t stop; it continues with only part of the data stored, which is causing problems.
I’d be grateful if you could share any possible solutions.
Hello,
How have you configured the activity when loading the file?
Also, are there any specific conditions in the part of the Excel file that becomes unreadable?
The locations in the Excel file where the data becomes unreadable are generally consistent,
but when I apply a filter to the source data, for example, the same issue occurs in different cells within the same column.
Also, the cell contents themselves are only read partway through.
For example: Cell contents: あいうえお Read contents: あいう
That’s what it looks like.
Sorry if I’m mistaken, but could you confirm whether the activity settings match what’s shown in the image below?
The activities are Excel Process Scope → Use Excel File → Read Range.
Hello,
As one step in troubleshooting, could you check whether turning off “Visible rows only” and setting “Read value format” to RawValue resolves the issue?
Hello,
There may be invalid data in the worksheet, such as a mismatch between the content and formatting.
To narrow down the cause, try deleting the rows around the area where you suspect the data may be problematic (near where the loading stops), then check whether that resolves the issue.