import
java.io.File;
import
org.apache.poi.ss.usermodel.Cell;
import
org.apache.poi.xssf.usermodel.XSSFRow;
import
org.apache.poi.xssf.usermodel.XSSFSheet;
import
org.apache.poi.xssf.usermodel.XSSFWorkbook;
import
java.io.FileOutputStream;
import
java.util.Map;
import
java.util.Set;
import
java.util.TreeMap;
public
class
WriteDataToExcel {
public
static
void
main(String[] args)
throws
Exception
{
XSSFWorkbook workbook =
new
XSSFWorkbook();
XSSFSheet spreadsheet
= workbook.createSheet(
" Student Data "
);
XSSFRow row;
Map<String, Object[]> studentData
=
new
TreeMap<String, Object[]>();
studentData.put(
"1"
,
new
Object[] {
"Roll No"
,
"NAME"
,
"Year"
});
studentData.put(
"2"
,
new
Object[] {
"128"
,
"Aditya"
,
"2nd year"
});
studentData.put(
"3"
,
new
Object[] {
"129"
,
"Narayana"
,
"2nd year"
});
studentData.put(
"4"
,
new
Object[] {
"130"
,
"Mohan"
,
"2nd year"
});
studentData.put(
"5"
,
new
Object[] {
"131"
,
"Radha"
,
"2nd year"
});
studentData.put(
"6"
,
new
Object[] {
"132"
,
"Gopal"
,
"2nd year"
});
Set<String> keyid = studentData.keySet();
int
rowid =
0
;
for
(String key : keyid) {
row = spreadsheet.createRow(rowid++);
Object[] objectArr = studentData.get(key);
int
cellid =
0
;
for
(Object obj : objectArr) {
Cell cell = row.createCell(cellid++);
cell.setCellValue((String)obj);
}
}
FileOutputStream out =
new
FileOutputStream(
new
File(
"C:/savedexcel/GFGsheet.xlsx"
));
workbook.write(out);
out.close();
}
}