The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:




Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Testing Tools >> HP / Mercury WinRunner

Pages: 1
zak3966
Newbie


Reged: 05/27/08
Posts: 2
trouble writing data to excel
      #486320 - 05/27/08 10:42 AM

i am a newbie, so this could be a simple goofup...

I am capturing data from a website and writing the data to a excel. the data to name and details of persons listed in a table. i use dtd_open and write to first row, this goes fine. the first row is the column names and the data goes into the second row.
now when i loop and come to second person details , it writes to the same row (overwrites). i have tried set row comamand and said the active row should be the thrid does nto work. place dtd_next_row function in the lopp still does not work ???

Any idea what i am doing work here ???

Thanks for the comments and answers ...


Post Extras: Print Post   Remind Me!   Notify Moderator  
bpolitzerModerator
Moderator


Reged: 06/25/02
Posts: 2053
Loc: Cupertino, CA, USA
Re: trouble writing data to excel [Re: zak3966]
      #486397 - 05/27/08 04:11 PM

Please paste your code.

Post Extras: Print Post   Remind Me!   Notify Moderator  
kamalpreet
Newbie


Reged: 12/17/07
Posts: 6
Re: trouble writing data to excel [Re: bpolitzer]
      #486555 - 05/28/08 03:49 AM

Hi,

i think you may try this loop given below:

ddt_get_row_count(table,row_count)
ddt_open("default.xls",DDT_READWRITEMODE);

for( x= 2;x<= row_count;x++)
{
ddt_set_row(table,x);
ddt_set_val_by_row(table,x,"value",appln_val);
ddt_save(table);
}

I hope this solves ur problem, but in case its not working then please paste the code so that we can get better understanding and solve in a better way.

Thanks and Regards,
Kamalpreet


Post Extras: Print Post   Remind Me!   Notify Moderator  
zak3966
Newbie


Reged: 05/27/08
Posts: 2
Re: trouble writing data to excel [Re: kamalpreet]
      #489874 - 06/09/08 01:25 AM

thx for the help, issue resolved...

Post Extras: Print Post   Remind Me!   Notify Moderator  
Fastpoint
Junior Member


Reged: 09/11/02
Posts: 4
Re: trouble writing data to excel [Re: zak3966]
      #531136 - 11/12/08 09:49 AM

fixed:

ddt_get_row_count(table,row_count)
ddt_open("default.xls",DDT_READWRITEMODE);

for( x= 2;x<= row_count;x++)
{
ddt_set_row(table,x);
ddt_set_val_by_row(table,x,"value",appln_val);
}

ddt_save(table);


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1



Extra information
0 registered and 20 anonymous users are browsing this forum.

Moderator:  Peter Ruscoe, bpolitzer 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 2623

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5