Re: Apache POI, ExcelSheet & Jar...

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