teyssir1
(Rosa)
September 23, 2019, 10:05am
1
Hello All,
I want to read a column starting from the First Value Till the last non empty cell in that column.
I have user Read column but when the column contains only one value in the begining it is not taking it into account.
Any suggestions Please!
Thanks in advance
vishal.kp
(vishal)
September 23, 2019, 10:07am
2
Can you screenshot the workflow?
teyssir1
(Rosa)
September 23, 2019, 10:20am
4
Thank you for you answer ,
I want to use each variable of that column.
i user for each item in ReadColumnOutput, and uset a log message to print the item but it is giving me a wrong value
HareeshMR
(Hareesh Madasi)
September 23, 2019, 10:22am
5
You mean, is it writing the value of different index or a value which doesn’t exist?
teyssir1
(Rosa)
September 23, 2019, 10:23am
6
read column (from D2 to dt.rows.count)
for each (item in ColumnOutput)
type into (item.tostring).
teyssir1
(Rosa)
September 23, 2019, 10:23am
7
it is giving me the name of the column
HareeshMR
(Hareesh Madasi)
September 23, 2019, 10:24am
8
Can you post the screenshots of your excel and the workflow how you are looping?
1 Like
teyssir1
(Rosa)
September 23, 2019, 10:32am
9
PhoneNumbers is the Output of the Read Column Activity
HareeshMR
(Hareesh Madasi)
September 23, 2019, 10:47am
10
Can you please change the read range activity range from “A1” to “” which will read all the data and then check @teyssir1 ?
teyssir1
(Rosa)
September 23, 2019, 11:03am
11
I got Always the saùe result ( the name of the column)
HareeshMR
(Hareesh Madasi)
September 23, 2019, 11:06am
12
Attach the workflow and excel , will check and let you know
teyssir1
(Rosa)
September 23, 2019, 12:21pm
13
Config.xlsx (9.8 KB) test.xaml (81.5 KB)
jitendra_123
(Jitendra Ughade)
September 23, 2019, 12:32pm
14
Hello @teyssir1
Just check once you are selecting correct file in Excel application scope
Then Check you are Reading correct sheet in Read Range also In the Read Column .
teyssir1
(Rosa)
September 23, 2019, 12:38pm
15
I have checked and i am using the same sheet name and i am selecting the correct file.
i am always getting the name of the column as output
HareeshMR
(Hareesh Madasi)
September 23, 2019, 12:45pm
16
You have a row in the excel which is other than the column name @teyssir1
Can you try to iterate only the phone numbers variable by removing all the attach window activities inside?
And why don’t you use for each row activity to do the same? you can get the values in that by passing as row(“Phone numbers”).tostring
jitendra_123
(Jitendra Ughade)
September 23, 2019, 12:47pm
17
@teyssir1
In Read Column we have to provide only Starting cell so after that it takes the whole Column. Because you are using Count in Read Column It is taking all Columns After D according to Count. So Remove that Count and provide Range as only “D1” In Read Column.
I hope this will work for you.
1 Like
Luis261980
(Luis Nunes)
September 23, 2019, 1:51pm
18
Why are you reading the range and the column ?
Use read range only and replace “A1” to “” → if you just need column A
use for **each row ** and not a for each
replace item.tostring replace to row(0).tostring
you will get your results
teyssir1
(Rosa)
September 23, 2019, 2:05pm
19
Thank you for your answers , it works with the for each row !
1 Like
system
(system)
Closed
September 26, 2019, 2:05pm
20
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.