KAPOW

Welcome to the Kapow forum. Here you can get help, use your skills to help others and enjoy hanging out in the company of other Kapow Robot Developers.


Writing Excel File

Share

ManHouw

Posts : 4
Points : 45
Join date : 2018-08-13

Writing Excel File

Post by ManHouw on Fri Aug 24, 2018 1:18 pm

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
avatar
pavel.vraj

Posts : 70
Points : 757
Join date : 2016-11-04
Location : Prague, Czech Republic

Re: Writing Excel File

Post by pavel.vraj on Fri Aug 24, 2018 3:12 pm

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

ManHouw

Posts : 4
Points : 45
Join date : 2018-08-13

Re: Writing Excel File

Post by ManHouw on Fri Aug 24, 2018 3:16 pm

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
avatar
pavel.vraj

Posts : 70
Points : 757
Join date : 2016-11-04
Location : Prague, Czech Republic

Re: Writing Excel File

Post by pavel.vraj on Fri Aug 24, 2018 3:18 pm

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

ManHouw

Posts : 4
Points : 45
Join date : 2018-08-13

Re: Writing Excel File

Post by ManHouw on Fri Aug 24, 2018 3:35 pm

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
avatar
pavel.vraj

Posts : 70
Points : 757
Join date : 2016-11-04
Location : Prague, Czech Republic

Re: Writing Excel File

Post by pavel.vraj on Mon Aug 27, 2018 9:35 pm

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

ManHouw

Posts : 4
Points : 45
Join date : 2018-08-13

Re: Writing Excel File

Post by ManHouw on Wed Aug 29, 2018 8:50 am

Hi Pavel,

Thanks for the effort.

I am using 10.2.0.4

My bot is writing 22 columns instead of 3.


Sponsored content

Re: Writing Excel File

Post by Sponsored content


    Current date/time is Sat Sep 22, 2018 3:31 am