is there a way to remove rows in a datatable at once? (Highlighted in yellow) The rows always have the same cell notation:
- "Vormontage: Bandmotoren,
- Vormontage: Gestell + A-Box GLM-Ievo
- Vormontage: Halter Bottom + Eti Bottom
- Inbetriebnahme: GLM-Ievo
So, if the cells exist they should be removed from the data table.
Additionally, the column “Dauer der Bearbeitung” has to be sumed up.
Do I need to save the Datatable in Excel? The Datatable is extracted from SAP and if it’s possible I don’t want to save it in Excel.
Thanks a lot for helping!
Try with filter datatable by giving
“Vormontage:*” as your value
Try as below for the removing rows which has the notations you listed
You can add as many notations according to your use case
make sure that Remove rows are selected
For sum all values check below post
Hope this will help you
For your requirement invoke code is the best solution. We can write vb.net code to filter the rows with the specific word and delete them at a single shot.
Atlast we can use write cell activity to insert sum formula to sum the values.
In the above case no need to insert data table into Excel. Datatable concept will not come into picture. Thanks.
thanks to all of you for the input Removing the rows by filtering worked perfectly!
Glad, My inputs helped you
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.