Extract all file names in a folder and need to write in an excel

[JOBIN_JOSE (John_)]

I need to extract all file names in a folder and need to write in an excel , and also i need the total count of files in that folder

[Gokul001 (Gokul Balaji)]

HI @JOBIN_JOSE

Check out the XAML file

19.10.2023_Forum_1.xaml (11.0 KB)

Regards
Gokul

[JOBIN_JOSE (John_)]

i am a beginner could uou please help me with what you have written in that array row field ?

[Gokul001 (Gokul Balaji)]

In the Array it will get the file name without the extension

{Path.GetFileNameWithoutExtension(CurrentFile.ToString)}

[JOBIN_JOSE (John_)]

sorry for the confusion am gettin error on write range

[Gokul001 (Gokul Balaji)]

You need to pass the Data table variable here.

@Gokul001

Check out the XAML file

19.10.2023_Forum_1.xaml (11.0 KB)

Have you download and check this XAML file? @JOBIN_JOSE

[JOBIN_JOSE (John_)]

tried

[Gokul001 (Gokul Balaji)]

@Gokul001

image480×784 27.5 KB

Check this image build the workflow.

1. Build data table → Create an variable called DtInput

[JOBIN_JOSE (John_)]

Test.xaml (10.9 KB)
i have tried but it is now showing obj ref

[JOBIN_JOSE (John_)]

[Shiva_Nikhil]

@JOBIN_JOSE

you have not pass the output variable for build datatable activity

[JOBIN_JOSE (John_)]

yes that was the mistake