import
java.io.File;
import
java.io.FileOutputStream;
import
java.util.Date;
import
org.apache.poi.ss.usermodel.CellStyle;
import
org.apache.poi.ss.usermodel.CreationHelper;
import
org.apache.poi.xssf.usermodel.XSSFCell;
import
org.apache.poi.xssf.usermodel.XSSFRow;
import
org.apache.poi.xssf.usermodel.XSSFSheet;
import
org.apache.poi.xssf.usermodel.XSSFWorkbook;
public
class
GFG {
public
static
void
main(String[] args)
throws
Exception
{
XSSFWorkbook workbook =
new
XSSFWorkbook();
CreationHelper creationHelper
= workbook.getCreationHelper();
XSSFSheet spreadsheet
= workbook.createSheet(
"CellTypesSheet"
);
XSSFRow noOfRows = spreadsheet.createRow((
short
)
2
);
noOfRows.createCell(
0
).setCellValue(
"Cell Types"
);
noOfRows.createCell(
1
).setCellValue(
"Cell Value"
);
noOfRows = spreadsheet.createRow((
short
)
3
);
noOfRows.createCell(
0
).setCellValue(
"Cell Type-BLANK"
);
noOfRows.createCell(
1
);
noOfRows = spreadsheet.createRow((
short
)
4
);
noOfRows.createCell(
0
).setCellValue(
"Cell Type-BOOLEAN"
);
noOfRows.createCell(
1
).setCellValue(
true
);
noOfRows = spreadsheet.createRow((
short
)
5
);
noOfRows.createCell(
0
).setCellValue(
"Cell Type-ERROR"
);
noOfRows.createCell(
1
).setCellValue(
XSSFCell.CELL_TYPE_ERROR);
noOfRows = spreadsheet.createRow((
short
)
6
);
CellStyle cellStyle = workbook.createCellStyle();
cellStyle.setDataFormat(
creationHelper.createDataFormat().getFormat(
"d/m/y h:mm"
));
noOfRows.createCell(
0
).setCellValue(
"Cell Type-DATE-TIME"
);
noOfRows.createCell(
1
).setCellValue(
new
Date());
noOfRows.getCell(
1
).setCellStyle(cellStyle);
noOfRows = spreadsheet.createRow((
short
)
7
);
noOfRows.createCell(
0
).setCellValue(
"Cell Type-Numeric"
);
noOfRows.createCell(
1
).setCellValue(
35
);
noOfRows = spreadsheet.createRow((
short
)
8
);
noOfRows.createCell(
0
).setCellValue(
"Cell Type-String"
);
noOfRows.createCell(
1
).setCellValue(
"GeeksForGeeks"
);
FileOutputStream out =
new
FileOutputStream(
new
File(
"GfgTypesOfCells.xlsx"
));
workbook.write(out);
out.close();
System.out.println(
"GFG.xlsx Created Successfully"
);
}
}