KMota
(karina)
September 9, 2019, 6:58pm
1
hi team,
I have a stream that saves web documents and need to write to Excel the hour and date
that he was downloaded.
Includes after the Salvar PDF the Excel Scope to add in a new column the date and time each file was downloaded but it is not working.
should enter in column “E” row 8 the date and time
after
should enter in column “E” row 7 the date and time
Can someone help me
Extract.xlsx (8.9 KB)
sandeep13
(Sandeep Pathak)
September 9, 2019, 7:01pm
2
@KMota
What problem you faced .??
Have any error you get??
1 Like
carmen
September 9, 2019, 7:05pm
3
Hi @KMota Could you try to explain better what are you trying to do … and what is your problem?
KMota
(karina)
September 9, 2019, 7:06pm
4
In fact, nothing happens. the date and time are not writings and flow stop
carmen
September 9, 2019, 7:08pm
5
Are you using Add Data Row to add a row in the excel? well I guess thats is your problem. You should use Append Range instead. Let me know is that works for you.
KMota
(karina)
September 9, 2019, 7:46pm
6
@carmen
I don’t know how to apply or append range to my stream so I needed to search and found this code
Instead of dt_InsertData I need to write the current date and time and I don’t know how
carmen
September 9, 2019, 7:53pm
7
You are doing good. As you wanna write the date in that cell instead to put the Datatable you should put the data that you wanna write in the excel. In this case should be the actual date and time right?
KMota
(karina)
September 9, 2019, 7:57pm
8
@carmen
Yes,that’s right but the argument is incorrect
I Tried
DateTime.Now.ToString but cannot be converted
carmen
September 9, 2019, 8:00pm
9
try with write cell activity …
KMota
(karina)
September 9, 2019, 8:21pm
10
the write cell was able to pass the data parameter and the current time, but I’m having trouble reading range
I had to insert the excel scope there stopped working the read range
8 hours of my day and nothing to make it work lol
carmen
September 9, 2019, 8:25pm
11
but that was working right? Do you have your excel close or open?
KMota
(karina)
September 9, 2019, 8:29pm
12
it was working,
I’ve checked and it’s not open
is you issue resolved mam???
carmen
September 9, 2019, 8:35pm
14
I was trying this … see if this works for youWriteCell.zip (20.7 KB)
KMota
(karina)
September 9, 2019, 8:48pm
15
I believe this will work, but I’m past my hour lol
Tomorrow I will try to include in my code and I say if it worked
thank you @carmen
1 Like
KMota
(karina)
September 11, 2019, 12:11pm
16
Hello @carmen , I was allocated to another project yesterday, but I just tested the suggested code and worked perfectly. Very happy lol … thank you very much
1 Like
system
(system)
Closed
September 14, 2019, 12:11pm
17
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.