Read from Excel worksheet places rows into a data-table variable. Write to Excel worksheet writes the supplied rows to a chosen destination. In the workplace these actions operate through an Excel instance, and opening the right workbook and worksheet matters. The local fixture represents those worksheet ranges as named tables so you can practice the row handling without running Excel.
Keep source and destination separate unless the task explicitly asks for replacement. A clean output table should not accidentally overwrite the raw input. When data arrives as text, convert the quantity fields used in calculations while preserving text identifiers. An empty worksheet range can be a legitimate input, and the output should then contain zero rows. Inspect the data-table variable after reading and after filtering; a final row count alone cannot prove that the right columns were written.