Hi! I want to find the empty cells in a excel file and replace it with a 0, but i don’t know what to put in the Value to find.
Thx for your answers
Hi! I want to find the empty cells in a excel file and replace it with a 0, but i don’t know what to put in the Value to find.
Thx for your answers
Main.xaml (9.2 KB)
Test1.xlsx (8.8 KB)
Here are the excel and xaml file im using.
as you are lookin for “” Empty string it will not catch a space
The provided Excel contains space on the cellls which are looking blank
it is risky but you can try
When doing this on Datatable level, then you would have a better control on it, as you can use the trim method and would not harm spaces within texts
i try with " “;”";0;“0”. Didn’t work, ty
this work, thank u!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.