package com.intel.alex.Utils;

/**
 * Created by root on 3/7/16.
 */
public class ExcelUtil {
}

@@ -28,69 +28,2240 @@
 s;%0A%0A
-/**%0A * Created by root on 3/7/16.%0A */%0Apublic class ExcelUtil %7B
+%0Aimport jxl.Workbook;%0A%0Aimport jxl.write.*;%0A%0Aimport java.io.*;%0Aimport java.lang.*;%0A%0A/**%0A * Created by root on 3/7/16.%0A */%0Apublic class ExcelUtil %7B%0A    private final String logDir;%0A%0A    public ExcelUtil(String logDir) %7B%0A        this.logDir = logDir;%0A    %7D%0A%0A    public void csv2Excel() %7B%0A        File csvFile = new File(logDir + %22/run-logs/BigBenchTimes.csv%22);%0A        FileReader fileReader;%0A        try%7B%0A            WritableWorkbook book;//%0A            File excFile = new File(%22/home/BigBenchTimes.xls%22);//%0A            book = Workbook.createWorkbook(excFile);//%0A            int num = book.getNumberOfSheets();%0A            WritableSheet sheet0 = book.createSheet(%22BigBenchTimes%22,num);%0A            WritableSheet sheet1 = book.createSheet(%22PowerTestTime%22,num+1); //1 is needed to change%0A            WritableSheet sheet2 = book.createSheet(%22ThroughPutTestTime_allstreams%22,num+2);%0A%0A            fileReader = new FileReader(csvFile);%0A            BufferedReader br = new BufferedReader(fileReader);%0A            int i=0;%0A            int p=0;%0A            int t=0;%0A            String line ;%0A            while ((line=br.readLine())!=null)%7B%0A                String s%5B%5D= line.split(%22;%22);%0A                if(s.length %3E 3)%7B%0A                    for(int j=0; j%3C s.length; j++)%7B%0A                        Label label = new Label(j, i, s%5Bj%5D);%0A                        sheet0.addCell(label);%0A                    %7D%0A                    if(s%5B1%5D.equals(%22POWER_TEST%22))%7B%0A                        for(int j =0; j%3C s.length; j++)%7B%0A                            Label label =new Label(j,p,s%5Bj%5D);%0A                            sheet1.addCell(label);%0A                        %7D%0A                        p++;%0A                    %7D%0A                    if(s%5B1%5D.equals(%22THROUGHPUT_TEST_1%22))%7B%0A                        for(int j =0; j%3C s.length; j++)%7B%0A                            Label label =new Label(j,t,s%5Bj%5D);%0A                            sheet2.addCell(label);%0A                        %7D%0A                        t++;%0A                    %7D%0A                %7D%0A                i++;%0A            %7D%0A            br.close();%0A            fileReader.close();%0A            book.write();%0A            book.close();%0A        %7D catch (Exception e) %7B%0A            e.printStackTrace();%0A        %7D%0A%0A%0A    %7D
 %0A%7D%0A

Add the function of generating excel file.