I HAVE EXCEL FILTERED WITH TABLE FILTER HOW CAN I WRITE IT IN ANOTHER EXCEL
REGARDS
I HAVE EXCEL FILTERED WITH TABLE FILTER HOW CAN I WRITE IT IN ANOTHER EXCEL
REGARDS
Hi @Manoli_Puente
You can use Write range activity if you want to write it down the filtered dattable in new excel.
cheers
Happy learning
Use Read Range and save it in variable :------ Datatable1
Use Filter Datatable Activity and Give Input as Datatable1 and assign output variable as OutDatatable
In Filter Datatable activity give column name in which you want to filter ----say if Column name “ID”=5 then keep those data
then in column write column name as “ID” and then operator for condition and value say “5”
then by using write range you can write filtered data into another sheet.
with this activity filter datatable, of an excel with # N / A, how do we put the condition The name of the column “ID” not equal to # N / D?
Thank you
You can use not contain “#N/A”
we get it with assing “readExcelBI.Select (” [columnName]> = ‘0’ "). CopyToDatatable
regards
Hi
-in select method we can filter that condition and get the output datatable back
for more details on that
–then use write range activity and mention the datatable variable as input and enable add headers property in the property panel of write range activity
hope this would help you
Cheers @Manoli_Puente
exceeded filtered by
leerExcelBI.Select (“[EPÍGRAFE TM1] >= ‘0’”). CopyToDatatable
another question…
If the cell where you have to write varies each month, how to solve it …
greetings and thanks
not worked