Read specific range in csv

Help
1

Hi,

For excel we have read range to read specific cell.

How about csv? If we want to read specific cell in csv?

Thanks

1 Like
2

@mashy2

For CSV, we don’t have any activities to do that. But you can do one thing use Read CSV activity and will give you output as dataTable then use Write Range activity to write into Excel file and then follow normal procedure.

3

hi @mashy2

Its possible
Once after converting the csv to datatable with read csv activity with get row item we can get the specific cell value
here you go a sample xaml
specificceelll.zip (2.2 KB)

and it worked see

image
image1213×539 41.8 KB

Cheers

2 Likes
4

did that work @mashy2

5

Thanks @Palaniyappan,

How about if i want to get the whole data starting from A7?

1 Like
6

here you go a xaml for that
specificceelll.zip (11.4 KB)

Cheers @mashy2

2 Likes
7

did that work @mashy2
Cheers

1 Like
8

any issues still @mashy2

1 Like
9

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