Apache POI, ExcelSheet & Jar...

From:

"julielaurek@gmail.com" <julielaurek@gmail.com>

Newsgroups:

comp.lang.java.programmer

Date:

Thu, 12 Jul 2007 22:30:11 -0000

Message-ID:

<1184279411.680201.66350@g4g2000hsf.googlegroups.com>

Hey guys!

So I have his modified code to create an excel sheet and when I run
it, it does create one, although I have to manually go open the
sheet;

//import java.awt.List;
import java.io.FileOutputStream;
import java.io.IOException;
import java.lang.Double;
import java.lang.String;
import java.util.*;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class SimpleSpreadsheetTest{
    //SerialDemo serialDemo ;
    //public static String[] serialOutput;
    public static String[] serialOutput = {"1","M","43423",
"2","B","50608", "3","M","53478", "4","B","55853"};
    public static Double myDoubleObject = null;
    public static String myStringObject;

    public static Double getTheString(Double someDouble, String
someString){
        return someDouble.valueOf(someString);
    }

    public static double getTheDouble(int i){
        if (serialOutput.length != 0){
            ArrayList tempList = new ArrayList(Arrays.asList(serialOutput));
            String myStringObject = (String) tempList.get(i);
            myDoubleObject = getTheString(myDoubleObject, myStringObject);
            //return myDoubleObject.doubleValue();
        }
        return myDoubleObject.doubleValue();
    }
    public static void main(String[] args) throws IOException{
          HSSFWorkbook wb = new HSSFWorkbook();
          HSSFSheet sheet = wb.createSheet("sheetAttemptOne...Work!");
          HSSFRow row ;

          if (serialOutput.length % 3 != 0){
              System.out.println("Insufficient Data!");
          }
          else
          {
              row = sheet.createRow(0);
              HSSFCell hssfCell = row.createCell((short)0);
              hssfCell.setCellValue("Event Number");
              hssfCell = row.createCell((short)1);
              hssfCell.setCellValue("Event Type");
              hssfCell = row.createCell((short)2);
              hssfCell.setCellValue("Time");

                  for (int i=0; i<(serialOutput.length) ; i = i + 3){
                      row = sheet.createRow(1 + (i/3));

                      hssfCell = row.createCell((short)0);
                      hssfCell.setCellValue(getTheDouble(i));
                      hssfCell = row.createCell((short)1);
                      hssfCell.setCellValue(serialOutput[i+1]);
                      hssfCell = row.createCell((short)2);
                      hssfCell.setCellValue(getTheDouble(i+2));
                  }
                  FileOutputStream fileOut = new
FileOutputStream("workbookAttempt8.xls");
                    wb.write(fileOut);
                    fileOut.close();
              }
          }
}

/* HSSFCell hssfCell = row.createCell((short)0);
          hssfCell.setCellValue("Product");
          hssfCell = row.createCell((short)1);
          hssfCell.setCellValue("Sales");
          hssfCell = row.createCell((short)2);
          hssfCell.setCellValue("Price");
          hssfCell = row.createCell((short)3);
          hssfCell.setCellValue("Total");

          row = sheet.createRow(1);

          hssfCell = row.createCell((short)0);
          hssfCell.setCellValue("Pens");
          hssfCell = row.createCell((short)1);
          hssfCell.setCellValue(120.00);
          hssfCell = row.createCell((short)2);
          hssfCell.setCellValue(0.25);
          hssfCell = row.createCell((short)3);
          hssfCell.setCellFormula("B2*C2");

            FileOutputStream fileOut = new
FileOutputStream("workbookAttempt1.xls");
            wb.write(fileOut);
            fileOut.close();
    }

}*/

So I wanted to make this executable and I have successfully exported
it as a jar file. I am still learning so bear with my question if it's
stupid O:-) but why doesn't the excel sheet get created anymore when I
launch the jar file?

Thanks

JL