Writing Excel File

Hi all,

Am trying to write an Excel file. Understand its a fairly simple thing, but I am writing over 10k lines in two different sheets. The speed gets slower and slower. It has been running for 6 hours and not yet completed.

Data is from Query Database.

Any advice is much appreciated. 

Thanks!

Regards,
MH

Hi,
can you describe, how did you designed the process? Are you saving the file for every line, or are you using varibale and filling it and then saving at the end? Very good thing for sppeding up is to use global excel variable, because Kapow then doesn't need to remember every state of the variable. Using non global variable could also cause very huge memory consumpsion of the Studio and could cause crash.
Best regards,
Pavel

pavel.vraj wrote:Hi,
can you describe, how did you designed the process? Are you saving the file for every line, or are you using varibale and filling it and then saving at the end? Very good thing for sppeding up is to use global excel variable, because Kapow then doesn't need to remember every state of the variable. Using non global variable could also cause very huge memory consumpsion of the Studio and could cause crash.
Best regards,
Pavel

Hi Pavel, 

Thanks for the reply. 

The design is simple, Query Database --> Set Content

After that, one branch below to Write File.

Am storing to a Global Excel Variable and writing it at the end of the flow.

Regards,
MH

Hi,
where is the speed slowing down, in Design Studio in design, or during Debug, or in Management console?
BR, Pavel

pavel.vraj wrote:Hi,
where is the speed slowing down, in Design Studio in design, or during Debug, or in Management console?
BR, Pavel

Hi,

I am running it on Management Console.

It was fast at first, writing 50 lines at every blink. Then it gets slower when it reaches 2k lines.

Regards,
MH

Hi,

I did simple test. I made a robot, which created blank excel in global variable, then it "Query Database", inserted new line into the excel and saved 3 values from the db. I made 10.000 records. After that I saved the Excel file to the file system. In Debug mode it took 234 seconds to finish this. In Management Console the robot run took 326 seconds. It was slower, but it took about 5 minutes.

Here are some screenshots:




I'm using 10.3.0.4 version. What version are you using?

BR, Pavel

Hi Pavel,

Thanks for the effort.

I am using 10.2.0.4

My bot is writing 22 columns instead of 3.

Did you find a solution to this problem? Writing 3,000 rows consisting of 26 columns took 1927 seconds. What will happen with 10,000 afraid to submit.
I am using 10.5.0.0

It could be that KCU is slowing you down.
Could you please check KCU wait time, during running.

Also, don't forget that the alternative is to go into a table and extract in CSV which will take significantly less, you should be using the systems correctly and not simply replacing everything with RPA steps.