How can I control the Input position in Excel?

Question

HiI use two colum in Excel.Colum A is inputted from web data.Colum B is inputted by tester.&nbsp;When executing testcase, the web data is inputted to Excel(Column A) and then the values in Column A and B are comparied in Testcomplete.But I input the test data to Column B, and then testcase executs...result is the following.&nbsp;I think, the issue script is the following,------------------------var rowCount = sheet.UsedRange.Rows.Count+1;------------------------&nbsp;But I don't know.&nbsp;Please let me know how can I that.Thanks.

tanyayatskovska · Answer

Hi Hskim,
&nbsp;
Please check if my suggestion given in another thread you've started helps you:
http://community.smartbear.com/t5/Functional-Web-Testing/Compare-value-from-Excel/m-p/112727
&nbsp;

djadhav · Answer

If you are using rowCount for output row number then

rowCount = 1 should do it for you. From there you can keep incrementing it.

In case that is not true, please paste some code where you are writing the values to Excel.

hskim · Answer

I tried to fix the value like 'rowCount = 1'.

And then the result is written at that just one time.

After that 2rd result is written same position the 1th result is gone.

I want to writ the 1th result from 1 position and 2rd result must be written the bottom.

djadhav · Answer

I agree, that's what would happen. We need to use it this way&nbsp;rowCount = 1&nbsp;&nbsp;- Begin writing to excel&nbsp;Get value of rowCountWrite to excelincrement value of rowCount&nbsp;- End writing to ExcelLoop from - Begin to - End as many times as required&nbsp;If you post some of your code then it'll be easier.

hskim · Answer

Over here this is my code&nbsp;I want to write the result(data)&nbsp;'rowCount=2' and then new result must be written the&nbsp;bottom.The new result(data) will be gotten&nbsp; twice a minute.&nbsp;---------------------------------------function WriteExcelSheet(fname, sheetName){&nbsp; var maxcol = 1, maxrow = 1;&nbsp;&nbsp;&nbsp;&nbsp; var app = Sys.OleObject("Excel.Application");&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var book = app.Workbooks.Open(fname);&nbsp; var sheet = book.Sheets(sheetName);&nbsp; // app.DisplayAlerts = false;&nbsp;&nbsp; //-------------------------------&nbsp; var TimeValue, NowValue, StringTimeValue, StringNowValue, VariantTimeValue, VariantNowValue;&nbsp; TimeValue=aqDateTime.Time();&nbsp; NowValue=aqDateTime.Now();&nbsp;&nbsp; StringTimeValue = aqConvert.DateTimeToStr(TimeValue);&nbsp; StringNowValue = aqConvert.DateTimeToStr(NowValue);&nbsp;var rowCount = getRowCount(sheet);&nbsp;// var rowCount = 2;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+1, 7) = StringNowValue;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+1, 1) = Project.Variables.ChID001;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+2, 1) = Project.Variables.ChID002;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+3, 1) = Project.Variables.ChID003;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+4, 1) = Project.Variables.ChID004;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+5, 1) = Project.Variables.ChID005;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+6, 1) = Project.Variables.ChID006;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+7, 1) = Project.Variables.ChID007;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+8, 1) = Project.Variables.ChID008;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+9, 1) = Project.Variables.ChID009;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+10, 1) = Project.Variables.ChID010;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+11, 1) = Project.Variables.ChID011;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+12, 1) = Project.Variables.ChID012;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+13, 1) = Project.Variables.ChID013;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+14, 1) = Project.Variables.ChID014;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+15, 1) = Project.Variables.ChID015;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+16, 1) = Project.Variables.ChID016;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// var rowCountb = sheet.UsedRange.Rows.Count+1;&nbsp;// for(var rowb = rowCountb; rowb &lt; rowCountb + 1; rowb++)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+1, 3) = Project.Variables.Value001;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+2, 3) = Project.Variables.Value002;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+3, 3) = Project.Variables.Value003;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+4, 3) = Project.Variables.Value004;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+5, 3) = Project.Variables.Value005;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+6, 3) = Project.Variables.Value006;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+7, 3) = Project.Variables.Value007;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+8, 3) = Project.Variables.Value008;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+9, 3) = Project.Variables.Value009;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+10, 3) = Project.Variables.Value010;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+11, 3) = Project.Variables.Value011;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+12, 3) = Project.Variables.Value012;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+13, 3) = Project.Variables.Value013;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+14, 3) = Project.Variables.Value014;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+15, 3) = Project.Variables.Value015;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheet.Cells(rowCount+16, 3) = Project.Variables.Value016;&nbsp;&nbsp; book.Save();&nbsp; app.Quit();}

Forum Discussion

How can I control the Input position in Excel?

6 Replies

Related Content

The current row position is already beyond the table

Controls highlight position is offset from real position

Excel-Write value

Workspace Window Position

Edit property checkpoint dropdown list changed position

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