How can I print specific Excel data?

Help
1

Hello Community,
I need assistant. I have a excel file and it’s have data like
dff.txt
iff.txr
tt.txt
fff.txt
. I need to print first word like dff one by one.
Sample image: image

Thanks,

2

Hi @razu91

Based on substring try to extract

Thanks
Ashwin S

3

Thanks, Can upload any sample code?

4

Hi @razu91

Check this xaml
Main.xaml (13.4 KB)

This should work

Thanks
Ashwin S

1 Like
5

Again thanks,
Can you check again for image .
Suppose i have few name like
Robin_box1.xlsx,
Fragmandue.xlsx
Jack.xlsx,
Methue.xlsx,

in this cases i need to crop only the first name without .xlsx, Please give the solution.
Thanks

6

hi @razu91

take substring(0,10)

Thanks
Ashwin.S

7

@razu91

split column values based on delimiter as dot “.”

Str = “Robin_box1.xlsx”

Str.Split("."c)(0)

8

Hello, If I use substring(0,10) then it’s print first 10 characters. But I need to deduction file extension. should to keep name only before .anything. Please check it.

9

@razu91

Try above expression and it will give output as filename without extension.

10

Thanks,
Split.zip (7.5 KB)

It’s doesn’t work.Please check my code and give me solution. I need to print one by one without .extension.

11

Hello,
Split.zip (7.5 KB)

It’s doesn’t work.Please check my code and give me solution. I need to print one by one without .extension.

12

@razu91

Check attached workflow.

Split.zip (7.9 KB)

1 Like
13

Thank you so much

1 Like
14

Again thanks,Please tell me, if I want to use column “D” value without header name. Then Should to change here?
image
If I change this then show me following error.
image

15

@razu91

First Uncheck AddHeaders option in Read Range Activity and then try like this.

row.Item(3).Tostring

1 Like
16

Hello @lakshman @Palaniyappan @AshwinS2
I need to select single column like

image
image217×595 5.13 KB

This is not working
image

17

Hi @razu91

Please mention the range as "A2:A+dt.rows.count.ToString

Thanks
Ashwin.S

18

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