Can anyone help with .xaml file to replace exel blank with zeros

Sreedas_Sreedharan · January 21, 2020, 1:26pm

Column starting from Amount to Amount30.Attached output sheet as well
Can anyone help
test1.xlsx (9.3 KB)

Palaniyappan · January 21, 2020, 1:35pm

here you go with an xaml
BlankP.zip (17.9 KB)

Sreedas_Sreedharan · January 21, 2020, 1:50pm

@Palaniyappan
Thanks Its working fine

system · January 24, 2020, 1:50pm

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Filling zeros in empty cells Community question , community	1	1029	October 21, 2021
How to make the entire column in an excel with empty values Help	14	1423	May 30, 2019
Find/replace Value: I want to find empty cellls in a excel file and replace with 0 Activities excel , activities , question	7	2481	February 16, 2022
Adding Values to New Data Column Help	2	707	August 28, 2019
Inserting empty row StudioX studiox , question	10	469	July 15, 2023