Day: September 3, 2012

Percentage Calculation in Java

MallikLeave a comment

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;

public final class Percent {

public static void main(String[] args) throws IOException {
BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
System.out.println(“enter the total no.of sub”);
int n = Integer.parseInt(br.readLine());
int marks[] = new int[n];
int i, tot = 0;
for (i = 0; i < n; i++) {
System.out.println(“enter ur marks”);
marks[i] = Integer.parseInt(br.readLine());
tot = tot + marks[i];
}
System.out.println(“total marks: ” + tot);
System.out.println(“percentage of marks: ” + (float) tot / n);
}
}

How to Create Excel file in Java using POI API

Mallik1 Comment


import java.io.FileOutputStream;


import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;


public class CreateExcelFile {

public static final String FILE_NAME = “D:\\test.xls”;


 public void createExcelFile(String filename) {

try {

HSSFWorkbook hwb = new HSSFWorkbook();

HSSFSheet sheet = hwb.createSheet(“Sheet1”);

 

HSSFRow rowhead = sheet.createRow((short) 0);

rowhead.createCell((short) 0).setCellValue(“S.No.”);

rowhead.createCell((short) 1).setCellValue(“Emp ID”);

rowhead.createCell((short) 2).setCellValue(“EMP Name”);

rowhead.createCell((short) 3).setCellValue(“Dept”);

 

rowhead = sheet.createRow((short) 1);

rowhead.createCell((short) 0).setCellValue(“1”);

rowhead.createCell((short) 1).setCellValue(“EMP1”);

rowhead.createCell((short) 2).setCellValue(“Mallik”);

rowhead.createCell((short) 3).setCellValue(“Java”);


FileOutputStream fileOut = new FileOutputStream(filename);

hwb.write(fileOut);

fileOut.close();

System.out.println(“Your excel file has been generated!”);


 } catch (Exception ex) {

System.out.println(ex);

ex.printStackTrace();

}

}

public static void main(String[] args) {

CreateExcelFile excelFile = new CreateExcelFile();

excelFile.createExcelFile(FILE_NAME);

}

}