I have a problem
and I read an excel through , and then through I extract the value that interests me with , then through I check if my data that I extracted with < get row item> have a certain value, for example I will put it “has ruc” in any case if it detects if there is this value and removes it from the excel by means of> delete rows>
but before that I want to save it in another excel, I just can’t find a way to do it
Do you have any suggestions?
please post a sample data excel and description of expected output
Currently I dont understand all requirements from your description
Clientes.xlsx (13.4 KB)
I want to delete the value called “TIENE RUC”, and at the same time I want to save that data in a separate excel
@borismh you can do as follows:
System>File>Workbook> Read Range to read your excel sheet
Here you enter full path+ file name of your Excel file, SheetName and leave “” to read the whole Sheet. You also need to create a datatable variable in the Output, and click Add Headers.
Step 2 is to filter the datatable,
Step 3 is to System>File>Workbook>Write your filtered datatable to a new Excel file
Try this and see if this is what you’re looking for.
All the best!
Core Task is implemented. Writing to Excel you can incorporate with write range activities
I don’t understand your workflow very well
could you explain me
See the attached…copyRowDataAndDelete.xaml (25.7 KB)
- Add the same file location to Excel Application Scope - Clients Read (initial read) and Excel Application Scope - Clients Saved (Overwrite)
- Add a file location to Excel Application Scope - Client Removed (Removed)
You can remove the
assign count from the workflow, was used for testing =D
- Deleting a datarow while iterating with a for each row will throw an error, due the sequence of datarows is changed
- CopytoDataTable will throw an error, if no rows are returned by the statement
In general your requirement could be done with two filter statements as well. I used for second part dataset method except
Filter all rows containing TIENE RUC in the column Comentarios
dtData.AsEnumerable.Where(function ® r(“Comentarios”).ToString.Contains(“TIENE RUC”)).ToList
returning a list(Of DataRow) - Variable: drTieneRuc
with a check if Datatrows are returned: drTieneRuc.Count >0
we do create a datatable: dtTieneRuc = drTieneRuc.CopyToDataTable
Now we want to retrieve all rows from the origin datatable that are not containing TIENE RUC in the column Comentarios
here we used the except statement:
dtData.AsEnumerable.Except(drTieneRuc).ToList and returning a list of datarows
same as above we do check if datarows were returned and if Yes we copy it to a datatable:
dtFiltered = drFiltered.CopyToDataTable
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.