18 January 2026:

This forum is now archived and is in read-only mode. Please continue discussions on our improved new Sahi Pro Community forum.

is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.

How to set data in a excel in a particular cell

prashant

prashant Members

April 2018 in Sahi Pro

i want to set a value in a excel, say in the the row 25 column 4, how can i set the value using SAHI

Comments

Pratik Anand Shah Moderators

April 2018 edited April 2018
Hi Prashant,

Yes, you can set the value in excel at any position using the _getExcel() API.

var $excel = _getExcel("D:\\poiTest.xls","Sheet1"); //Set Cell Value at cell position 25,5 var $excelData=$excel.set(25,4,"444-444-4444");

Please refer the following link for more information on _getExcel();
http://sahipro.com/docs/sahi-apis/excel-apis.html#_getExcel

or Register to comment.