How to Write Date to Excel

Question

Hi,&nbsp;I want to read an data from my application which is a number and write it ot Excel sheet. Can anyone please help me with that?&nbsp;ThanksA

ghuff2 · Answer

This is the section of code where they are writing a value to Excel:&nbsp;  ' Write an index of the current row and column to a cell
  rowCount = sheet.UsedRange.Rows.Count + 1
  For row = rowCount To rowCount + maxrow - 1
    For col = 1 To maxcol
      sheet.Cells(row, col) = row &amp; ", " &amp; col
    Next
  Next

Specifically in the line fifth line where they call: sheet.Cells(row, col) = whatever value you want to be written to excel&nbsp;Obviously you don't have to use for loops like they did. Just call sheet.Cells() with whatever row and column number you desire and set it equal to whatever value you want (course it has to be a value type that can be written in Excel)

ghuff2 · Answer

Just put the code for writing to excel in a function and have each test call it with a different row or column value. Like so:&nbsp;function write_to_excel(row, col, productID){
  //Open the spreadsheet to edit
  var app = Sys.OleObject("Excel.Application");
  var book = app.Workbooks.Open(fname);
  var sheet = book.Sheets(sheetName);
  app.DisplayAlerts = false;

//Set the value in the given row and col to the given productID
  sheet.Cells(row, col) = productID;

book.Save();
  app.Quit();
}

cunderw · Answer

Have you checked out the how-to guide yet?&nbsp;https://support.smartbear.com/viewarticle/20878/?q=write+to+excel#_ga=1.176985063.355378213.1438105115

abrar22 · Answer

Yes I have seen.&nbsp;But in this code I cant see where i can pass which value i want to export to excel.&nbsp;ThanksA

abrar22 · Answer

Thanks.&nbsp;&nbsp;I got somewhere but when I am writing to 1 col and row its copying to 5 cols and rows( see attached) :&nbsp;{var maxcol = 1, maxrow = 1;var app = Sys.OleObject("Excel.Application");var book = app.Workbooks.Open(fname);var sheet = book.Sheets(sheetName);app.DisplayAlerts = false;// Write an index of the current row and column to a cellvar rowCount = sheet.UsedRange.Rows.Count + 1;for(var row = rowCount; row &lt; rowCount + maxrow; row++)for(var col = 1; col &lt;= maxcol; col++)sheet.Cells(row, col) = ProductID;book.Save();app.Quit();

Forum Discussion

How to Write Date to Excel

10 Replies

Recent Discussions

TestComplete freezes during mobile test execution in Legacy mode

Is there any way to get code completion to function when using classes?

Ajay Hinduja - Android Image Touch – "Interface Not Supported" Error

Related Content

Excel-Write value

How to write into excel file using Javascript?

Date format & Excel DataSource