import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Date;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFCreationHelper;
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;
public class HSSFTest {
public static void main(String[] args) {
//Excel Calisma Kitabini Olustur
HSSFWorkbook workbook = new HSSFWorkbook();
//Excel Sayfasi Olustur
HSSFSheet sheet = workbook.createSheet("Java4Fun");
HSSFCreationHelper createHelper = workbook.getCreationHelper();
HSSFCellStyle cellStyle = workbook.createCellStyle();
cellStyle.setDataFormat(createHelper.createDataFormat().getFormat("m/d/yy h:mm"));
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellValue(new Date());
cell.setCellStyle(cellStyle);
//Olusturulan Workbook nesnesini dosyaya yaz
try
{
FileOutputStream out = new FileOutputStream(new File("K:\\test.xls"));
workbook.write(out);
out.close();
}
catch (FileNotFoundException e) {
e.printStackTrace();
}
catch (IOException e) {
e.printStackTrace();
}
}
}
10 Mayıs 2014 Cumartesi
Apache POI - Java İle Excelde Sistem Tarihini Belirlenen Formatta Hücreye Yazmak
Etiketler:
Java İle Excel İşlemleri
Kaydol:
Kayıt Yorumları (Atom)
Java4Fun Copyright © 2011 | Template created by O Pregador | Powered by Templates de luxo
0 yorum:
Yorum Gönder