csv file have value in A1 and A2
pl. guide me how to automate it.?
Dont do we have any kind of video tutorials?
csv file have value in A1 and A2
pl. guide me how to automate it.?
Dont do we have any kind of video tutorials?
its 17 days over and this post seems not come in your eyes.
Requesting you to look in it and guide me please.
Thanks
Guide me how to open a2 a3 b2 b3 c2 c3
If you start the macro with the LOOP button, it will read a new CSV line with each loop
Does this answer the question?
No.
Let me cut short the question.
see,
Just to clarify, so you need
A1
A2
A3
and then
B1
B2
B3
…and so on?
you understood it correctly.
Thanks
I can understand that you are very busy. As you are masters so it does not take your more then 10 min, but it will solve the problem and days for others.
May I request you again Please.
The “trick” here is to use !csvReadLineNumber
to reset the read position to the first line. You can use the DemoCsvReadWithWhile macro that ships with Kantu as starting point.
csvRead | ReadCSVTestData.csv
while | ${!csvReadStatus} == "OK"
echo | ${!col1}
csvRead | ReadCSVTestData.csv
- read value of next row (if any)endWhile
store | 1 | !csvReadLineNumber
- reset CSV read position to top of file
csvRead | ReadCSVTestData.csv
while | ${!csvReadStatus} == "OK"
echo | ${!col2}
- same code as above, but now we use column 2
csvRead | ReadCSVTestData.csv
endWhile
Thank you for reply BUT i am sorry, you did not reply what i need for.
see this pic again.
Not LEFT to Right
I hope i am clear now.
This is what my code will do. It first reads all entries in column A, and then in column B (starting again at the top).
Many thanks for your reply and patience,
I think its easy and clear for others but for me its not. Let me rephrase the question.
Only I need
A1
A2
A3
Guide me pl.
…but if you only need A1 to A3, then this is normal CSV reading sequence. Please see the DemoCsvReadWithWhile macro that ships with Kantu - it does exactly this.
Can we do it without using any loop?
I hope there must be simple and easy way available with you guys.