Write the file type in the excel Column

Help Studio
, ,
1

Hi Developers,

Actually I try to Write the file type in the excel Column

image
image1036×295 16.6 KB

In the column one File_path type want to write the in the Cell 2

like Pdf, Jpg

Process Work Flow:

image
image896×782 30.3 KB

image
image1474×895 57.2 KB

image
image1920×393 14.9 KB

in_dt_Count value is “0”

2

Hi,

Try filepath.Split("."c)(1) for file extension.

3

Actually i know How to write the cell value in cell string

image
image1184×390 34.6 KB

4

@krishnapriya_Anu

I guess you need to use index property in for loop to change the cell number dynamically

cheers

5

CAN you plz explain briefly

6

Hi @krishnapriya_Anu ,

Can you please try Path.GetExtension to get the extension type.

Please refer screenshot below, you can give index in For each loop,

image

above image, it’s index+2, not 1.

Thanks,
Sandhiya P

8

Index is a structure type and type and can’t be used as a expression

image
image1231×264 18 KB

9

Hi @krishnapriya_Anu

Check out the XAML file

16.10.2023_Forum_1.xaml (10.4 KB)

image
image718×687 21.9 KB

10

@krishnapriya_Anu

Please open the properties of for loop…and you would see an index property there…assign an integer to it and use that …the index property basically is the row index or the item index in the loop which starts from 0 by default

Hope this clarifies

Cheers

11

Hi @krishnapriya_Anu ,

We can create a variable of type Index, in the properties of For each.

Can you please check and let me know if you face any issue.

Thanks,
Sandhiya P