Record information in Excel spreadsheet

Question

I'm trying to&nbsp;store data in&nbsp;Excel spreadsheet,&nbsp;can anyone help me&nbsp;with that?NOTE: I have&nbsp;something similar to&nbsp;capture&nbsp;data from a spreadsheetEX: function&nbsp;Test (){&nbsp;&nbsp;&nbsp;var value;&nbsp;&nbsp;&nbsp;/&nbsp;/ Initialize the&nbsp;iterator&nbsp;&nbsp;&nbsp;Project.Variables.DBVar1.Reset&nbsp;();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/&nbsp;/&nbsp;Iterate&nbsp;through&nbsp;rows&nbsp;&nbsp;&nbsp;while (!&nbsp;Project.Variables.DBVar1.IsEOF&nbsp;())&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/&nbsp;/&nbsp;Retrieve&nbsp;the&nbsp;value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project.Variables.DBVar1.Value&nbsp;value =&nbsp;("ColumnName");&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/&nbsp;/ ...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/&nbsp;/&nbsp;Use the&nbsp;value&nbsp;needed&nbsp;in the&nbsp;way&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/&nbsp;/ ...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/&nbsp;/&nbsp;Forward the&nbsp;iterator&nbsp;to&nbsp;the&nbsp;next&nbsp;row&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project.Variables.DBVar1.Next&nbsp;();&nbsp;&nbsp;&nbsp;}}

guillaume · Answer

You should take a look at :    http://smartbear.com/support/viewarticle/9046/ - Compare Excel files    http://smartbear.com/support/viewarticle/20878/ - Write data to MS Excel

Forum Discussion

Record information in Excel spreadsheet

1 Reply

Related Content

How to hide Model Information

Using DDT.CurrentDriver.Value and updating spreadsheet

reading and writing to spreadsheet

Upload Test Cycle Information

Reading Setup Information .inf extension file

Recent Discussions

Floating window bleep overlapping window takes longer time (~10 min) to click the button on it.

Test case randomly fails with "parent object was not found"

Does TC have a .within() method similar to Cypress.io?

SessionCreator /Timeout option not firing EventControl_OnTimeout

testcomplete feature Intelligent Quality Add Ons