Answers

• gaveyom Members

  January 2013 edited January 2013

  Hi Gayathri,
  
  
  we need to pass 2 dimensional array for "writeCSVFile()" method, below is the example code
  
  

  
  "writeCSVFile($array, "CSVFileName.csv")" method
  

  
  array[$i][$j], $i represents row and $j represents column
  
  
  Below is the code to write a data into specific cell of csv file, hope this code will help for u
  

  
  
  var $writeData = [];
  
  try {
  
  	for(var $cnt_Row=0; $cnt_Row<10; $cnt_Row++) {
  	
  		$writeData[$cnt_Row] = [];
  		for(var $cnt_Clm=0; $cnt_Clm<10; $cnt_Clm++) {
  
  			$writeData[$cnt_Row][$cnt_Clm] = $cnt_Row +", "+ $cnt_Clm;
  		}
  	}
  }catch($e) {
  	_logExceptionAsFailure("Exception: "+ $e);
  }
  
  _writeCSVFile($writeData, "csv_write.csv", true);
  
  

  
  
  
• Gayathri Members

  January 2013

  The above code writes the data in each cell as an array. However, I want to write a specific value in any cell (in the .CSV file).
  
  For example, I want to write the text 'Success' in cell 'D1'. Similarly, my script should write specific values in the required column.
  
  Please help.
• Gayathri Members

  January 2013

  Team,
  
  This is still not answered completely. Please open up the loop.
• Gayathri Members

  January 2013

  Naveen,
  
  Are you trying to answer my question? I guess this response to be a wrong post.
• tejas269 Members

  January 2013

  You can try to use sahi call back functions, onScriptFailure(), onScriptError(), onScriptEnd()
• narayan Administrators

  January 2013

  Hi Gayathri,
  
  As gaveyom mentioned, you need to read the csv file into a 2D array, change the particular array item value and then write it back.
  
  For example,
  

  // Read the data in to array
  var $data = _readCSVFile("my.csv");
  // Set the value where required
  $data[0][3] = "myvalue"; // 0 is row 1, 3 is column D
  // Write back the data
  _writeCSVFile($data , "my.csv");
  

  
  Having said this, Sahi Pro already has the ability to take a CSV file as a suite, execute it, and update the file along with a link to output.
  
  Regards,
  Narayan