Create Excel file in java using PoI
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
|
package com.howto;
import java.io.File;
import java.io.FileOutputStream;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
/*
* Here we will learn how to create Excel file and header for the same.
*/
public class CreateExcelFile {
int rownum = 0;
HSSFSheet firstSheet;
Collection<File> files;
HSSFWorkbook workbook;
File exactFile;
{
workbook = new HSSFWorkbook();
firstSheet = workbook.createSheet("FIRST SHEET");
Row headerRow = firstSheet.createRow(rownum);
headerRow.setHeightInPoints(40);
}
public static void main(String args[]) throws Exception {
List<String> headerRow = new ArrayList<String>();
headerRow.add("Employee No");
headerRow.add("Employee Name");
headerRow.add("Employee Address");
List<String> firstRow = new ArrayList<String>();
firstRow.add("1111");
firstRow.add("Gautam");
firstRow.add("India");
List<List> recordToAdd = new ArrayList<List>();
recordToAdd.add(headerRow);
recordToAdd.add(firstRow);
CreateExcelFile cls = new CreateExcelFile(recordToAdd);
cls.createExcelFile();
}
void createExcelFile(){
FileOutputStream fos = null;
try {
fos=new FileOutputStream(new File("ExcelSheet.xls"));
HSSFCellStyle hsfstyle=workbook.createCellStyle();
hsfstyle.setBorderBottom((short) 1);
hsfstyle.setFillBackgroundColor((short)245);
workbook.write(fos);
} catch (Exception e) {
e.printStackTrace();
}
}
CreateExcelFile(List<List> l1) throws Exception {
try {
for (int j = 0; j < l1.size(); j++) {
Row row = firstSheet.createRow(rownum);
List<String> l2= l1.get(j);
for(int k=0; k<l2.size(); k++)
{
Cell cell = row.createCell(k);
cell.setCellValue(l2.get(k));
}
rownum++;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
}
}
}
|
PoI Jar will be required. Jar can be downloaded from Apache website.
浙公网安备 33010602011771号