Hello,
I'm trying to import an Excel coming from an external system with one sheet. The first two rows contain no relevant data so these have to be removed.
I'm trying to remove them by using the following steps:
Where the Row_Delete having StartRowNumber 1 and NumberOfRows 2. The only problem is that the first two rows of the relevant data are being removed. So rows 4 and 5 are removed instead of rows nl 1 and two. Am I doing something wrong? any help is appreciated.
gr,
Frank
Hi Frank,
Are you using advanced excel forge, if yes then you can go through this Link.
Hi Abdul,
Yes I'm using the advanced excel forge component. When I'm just just ExcelToRecordlist I get the following error
The same error occures when I have the flow the same as above without the delete step.
If I manually remove the first two rows there is no problem.
So I have to somehow remove the first two rows....
have you checked this:
https://www.outsystems.com/forums/discussion/52462/manually-read-excel-rows-skip-first-rows-and-place-the-data-rows-in-a-record-lis/
I'm checking it but if I understand it correctly, the idea is to use this cell read action to actually read all the individual cells in the excel sheet starting on row 4 in my case? Then assign these values to the desired structure and append them to the list?
right
Quite a bit cumbersome especially since it seems to be possible to do the import of the binary and read the relevant data skipping the first two lines containing the irrelevant data (in my case the first two rows) if you use the "Row_Delete" action and delete some rows. But if you actually don't want to delete any of the relevant data you have do the steps described above. In my opinion there is room for improving the component.