Convert Selenium IDE HTML TC in to HTML format
so we can run excel in Keyword driven Framework..
Src Given Below jst Add apache poi jars to ur Eclipse Project.
import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.IOException;
import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;
import java.util.ListIterator;
import javax.script.*;
import javax.swing.JFileChooser;
import javax.swing.JOptionPane;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ExportToExcel {
/**
* @param args
* @throws IOException
*/
int Stepno=0;
String str="";
String temp="";
static String Outputfile="";
List <String> Action=new LinkedList<String>();
List <String> Locator=new LinkedList<String>();
List <String> Value=new LinkedList<String>();
int i=4;
public void Export(String path) throws ScriptException, IOException
{
/*ScriptEngineManager manager = new ScriptEngineManager();
ScriptEngine engine = manager.getEngineByName("javascript");*/
File f=new File(path);
BufferedReader br = new BufferedReader(new FileReader(f));
try {
StringBuilder sb = new StringBuilder();
String line = br.readLine();
while (line != null) {
sb.append(line);
sb.append('\n');
line = br.readLine();
}
str += sb.toString();
//str="<td>aman</td>";
String a[]=str.split("<td>");
for (i=1;i<a.length;i=i+3)
{
temp=a[i].substring(0, a[i].indexOf('<'));
Action.add(temp);
}
for (i=2;i<a.length;i=i+3)
{
temp=a[i].substring(0, a[i].indexOf('<'));
Locator.add(temp);
}
for (i=3;i<a.length;i=i+3)
{
temp=a[i].substring(0, a[i].indexOf('<'));
Value.add(temp);
}
System.out.println("Action List is : "+Action);
System.out.println("Locator List is : "+Locator);
System.out.println("Value List is : "+Value);
} finally {
br.close();
}
}
public void writetoExcel(String excelFileName) throws InvalidFormatException, IOException
{
//String excelFileName = "";//name of excel file
String sheetName = "Sheet1";//name of sheet
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet = wb.createSheet(sheetName) ;
XSSFRow r1 = sheet.createRow(0);
XSSFCell Srnocell = r1.createCell(0);
Srnocell.setCellValue("Srno");
XSSFCell actioncell = r1.createCell(1);
actioncell.setCellValue("Action");
XSSFCell loccell = r1.createCell(2);
loccell.setCellValue("Locator");
XSSFCell valuecell = r1.createCell(3);
valuecell.setCellValue("Value");
for (int r=1;r <4; r++ )
{
XSSFRow row = sheet.createRow(r);
Stepno++;
//iterating c number of columns
XSSFCell cell = row.createCell(0);
cell.setCellValue(Stepno);
XSSFCell cell1 = row.createCell(1);
cell1.setCellValue(Action.get(r-1));
System.out.println(Action.get(r-1));
XSSFCell cell2 = row.createCell(2);
cell2.setCellValue(Locator.get(r-1));
System.out.println(Locator.get(r-1));
XSSFCell cell3 = row.createCell(3);
cell3.setCellValue(Value.get(r-1));
System.out.println(Value.get(r-1));
}
FileOutputStream fileOut = new FileOutputStream(excelFileName);
//write this workbook to an Outputstream.
wb.write(fileOut);
fileOut.flush();
fileOut.close();
System.out.println("Your excel file has been generated!");
JOptionPane.showMessageDialog(null,excelFileName+" is generated successfully");
}
public static void main(String[] args) throws ScriptException, IOException, InvalidFormatException {
// TODO Auto-generated method stub
ExportToExcel e=new ExportToExcel();
JFileChooser chooser=new JFileChooser();
int returnVal = chooser.showOpenDialog(null);
if(returnVal == JFileChooser.APPROVE_OPTION)
{
//File f = chooser.getSelectedFile();
String filename=chooser.getSelectedFile().getPath();
if (filename.endsWith(".html")){
Outputfile=filename.replace(".html", ".xlsx");
e.Export(filename);
e.writetoExcel(Outputfile);
}
else
{
JOptionPane.showMessageDialog(null, "Pls select only Recorded HTML file");
//System.exit(0);
}
}
}}
