Re: Untitled

From Edgy Butterfly, 7 Years ago, written in Java.

This paste is a reply to Untitled from Gracious Wigeon - go back

Embed

Viewing differences between Untitled and Re: Untitled

package com.mysite.inmarsat;

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

/**
* Created by gmlynarczy001 on 2016-09-14.
*/
public class Xwriter {

    String filename = "INFO.xls";
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet uat = workbook.createSheet("UAT");
    HSSFSheet dht = workbook.createSheet("DHT");
    int n = 0;

0;


    FileOutputStream fileOut;
    private void getFileStream() {
      if (fileOut == null) {
        fileOut = new FileOutputStream(filename);
      }
      return fileOut;
    }



        public void saveExcelMC(String mc){
            try {

                if (EnvAndDP.DP.equals("SHARE")) {
                    n = 1;
                } else if (EnvAndDP.DP.equals("1090")) {
                    n = 2;
                } else if (EnvAndDP.DP.equals("1180")) {
                    n = 3;
                }

                if (EnvAndDP.ENV.equals("UAT")) {
                    HSSFRow head = uat.createRow((short) 0);
                    head.createCell(0).setCellValue("TYPE");
                    head.createCell(1).setCellValue("SHARE");
                    head.createCell(2).setCellValue("1090X");
                    head.createCell(3).setCellValue("1180X");

                    HSSFRow rowMC = uat.createRow((short) 1);
                    rowMC.createCell(0).setCellValue("Major Corporate");
                    rowMC.createCell(n).setCellValue(mc);

                } else if (EnvAndDP.ENV.equals("DHT")) {
                    HSSFRow head = dht.createRow((short) 0);
                    head.createCell(0).setCellValue("TYPE");
                    head.createCell(1).setCellValue("SHARE");
                    head.createCell(2).setCellValue("1090X");
                    head.createCell(3).setCellValue("1180X");

                    HSSFRow rowMC = dht.createRow((short) 1);
                    rowMC.createCell(0).setCellValue("Major Corporate");
                    rowMC.createCell(n).setCellValue(mc);
                }

                }

                FileOutputStream fileOut = ~~new FileOutputStream(filename);~~
getFileStream();
                workbook.write(fileOut);
                fileOut.close();

write(fileOut);

            }catch (IOException e){
                e.printStackTrace();
            }
        }
        public void saveExcelVess(String vess){
            try {

                if (EnvAndDP.DP.equals("SHARE")) {
                    n = 1;
                } else if (EnvAndDP.DP.equals("1090")) {
                    n = 2;
                } else if (EnvAndDP.DP.equals("1180")) {
                    n = 3;
                }

                if (EnvAndDP.ENV.equals("UAT")) {
                    HSSFRow head = uat.createRow((short) 0);
                    head.createCell(0).setCellValue("TYPE");
                    head.createCell(1).setCellValue("SHARE");
                    head.createCell(2).setCellValue("1090X");
                    head.createCell(3).setCellValue("1180X");

                    HSSFRow rowVess = uat.createRow((short) 2);
                    rowVess.createCell(0).setCellValue("Vessel");
                    rowVess.createCell(n).setCellValue(vess);

                } else if (EnvAndDP.ENV.equals("DHT")) {
                    HSSFRow head = dht.createRow((short) 0);
                    head.createCell(0).setCellValue("TYPE");
                    head.createCell(1).setCellValue("SHARE");
                    head.createCell(2).setCellValue("1090X");
                    head.createCell(3).setCellValue("1180X");

                    HSSFRow rowVess = dht.createRow((short) 2);
                    rowVess.createCell(0).setCellValue("Vessel");
                    rowVess.createCell(n).setCellValue(vess);
                }

                FileOutputStream fileOut = ~~new FileOutputStream(filename);~~
getFileStream();
                workbook.write(fileOut);
                fileOut.close();

write(fileOut);

            }catch (IOException e){
                e.printStackTrace();
            }
        }
}

Author

Title

Language

Your paste - Paste your paste here

package com.mysite.inmarsat;

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

/**
 * Created by gmlynarczy001 on 2016-09-14.
 */
public class Xwriter {

String filename = &quot;INFO.xls&quot;;
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet uat = workbook.createSheet(&quot;UAT&quot;);
    HSSFSheet dht = workbook.createSheet(&quot;DHT&quot;);
    int n = 0;
  
  
    FileOutputStream fileOut;
    private void getFileStream() {
      if (fileOut == null) {
        fileOut = new FileOutputStream(filename);
      }
      return fileOut;
    }

public void saveExcelMC(String mc){
            try {

if (EnvAndDP.DP.equals(&quot;SHARE&quot;)) {
                    n = 1;
                } else if (EnvAndDP.DP.equals(&quot;1090&quot;)) {
                    n = 2;
                } else if (EnvAndDP.DP.equals(&quot;1180&quot;)) {
                    n = 3;
                }

if (EnvAndDP.ENV.equals(&quot;UAT&quot;)) {
                    HSSFRow head = uat.createRow((short) 0);
                    head.createCell(0).setCellValue(&quot;TYPE&quot;);
                    head.createCell(1).setCellValue(&quot;SHARE&quot;);
                    head.createCell(2).setCellValue(&quot;1090X&quot;);
                    head.createCell(3).setCellValue(&quot;1180X&quot;);

HSSFRow rowMC = uat.createRow((short) 1);
                    rowMC.createCell(0).setCellValue(&quot;Major Corporate&quot;);
                    rowMC.createCell(n).setCellValue(mc);

} else if (EnvAndDP.ENV.equals(&quot;DHT&quot;)) {
                    HSSFRow head = dht.createRow((short) 0);
                    head.createCell(0).setCellValue(&quot;TYPE&quot;);
                    head.createCell(1).setCellValue(&quot;SHARE&quot;);
                    head.createCell(2).setCellValue(&quot;1090X&quot;);
                    head.createCell(3).setCellValue(&quot;1180X&quot;);

HSSFRow rowMC = dht.createRow((short) 1);
                    rowMC.createCell(0).setCellValue(&quot;Major Corporate&quot;);
                    rowMC.createCell(n).setCellValue(mc);
                }
		
                FileOutputStream fileOut = getFileStream();
                workbook.write(fileOut);

}catch (IOException e){
                e.printStackTrace();
            }
        }
        public void saveExcelVess(String vess){
            try {

HSSFRow rowVess = uat.createRow((short) 2);
                    rowVess.createCell(0).setCellValue(&quot;Vessel&quot;);
                    rowVess.createCell(n).setCellValue(vess);

HSSFRow rowVess = dht.createRow((short) 2);
                    rowVess.createCell(0).setCellValue(&quot;Vessel&quot;);
                    rowVess.createCell(n).setCellValue(vess);
                }

FileOutputStream fileOut = getFileStream();
                workbook.write(fileOut);

}catch (IOException e){
                e.printStackTrace();
            }
        }
}

Private - Private paste aren't shown in recent listings.

Delete After - When should we delete your paste?

Spam protection -

{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}

Reply to "Re: Untitled"