package info.doesystem.tutorial.poi;
import java.io.FileOutputStream;
import java.util.Calendar;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ExcelDateValueFormat {
public static void main(String[] args) {
try (
Workbook wb = new XSSFWorkbook();
FileOutputStream fileOut = new FileOutputStream("D://Blog/Temp File/workbook.xlsx")
){
// create sheet
Sheet sheet = wb.createSheet("new sheet");
// create row
Row row = sheet.createRow(0);
// set Date value to cell
row.createCell(0).setCellValue(Calendar.getInstance());
row.createCell(1).setCellValue(Calendar.getInstance().getTime());
// set Date value Format
CreationHelper createHelper = wb.getCreationHelper();
CellStyle cellStyle = wb.createCellStyle();
cellStyle.setDataFormat(createHelper.createDataFormat().getFormat("m/d/yy h:mm"));
Cell cell2 = row.createCell(2);
cell2.setCellValue(Calendar.getInstance());
cell2.setCellStyle(cellStyle);
Cell cell3 = row.createCell(3);
cell3.setCellValue(Calendar.getInstance().getTime());
cell3.setCellStyle(cellStyle);
wb.write(fileOut);
System.out.println("SUCCESS");
} catch (Exception ex) {
System.out.println("Exception " + ex);
}
}
}
package info.doesystem.tutorial.poi;
import java.io.FileOutputStream;
import java.util.Calendar;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class NewCell {
public static void main(String[] args) {
try (
Workbook wb = new XSSFWorkbook();
FileOutputStream fileOut = new FileOutputStream("D://Blog/Temp File/workbook.xlsx")
){
// create sheet
Sheet sheet = wb.createSheet("new sheet");
// create row
Row row = sheet.createRow(0);
// create cell
Cell cell = row.createCell(0);
// set value to cell
cell.setCellValue(1);
// other example
row.createCell(1).setCellValue("Test");
row.createCell(2).setCellValue(Calendar.getInstance());
row.createCell(3).setCellValue(Calendar.getInstance().getTime());
CreationHelper createHelper = wb.getCreationHelper();
row.createCell(4).setCellValue(createHelper.createRichTextString("This is a string"));
wb.write(fileOut);
System.out.println("SUCCESS");
} catch (Exception ex) {
System.out.println("Exception " + ex);
}
}
}
public static final String createSafeSheetName(String nameProposal) {
return createSafeSheetName(nameProposal, ' ');
}
public static final String createSafeSheetName(String nameProposal,
char replaceChar) {
if (nameProposal == null) {
return "null";
}
if (nameProposal.length() < 1) {
return "empty";
}
int length = Math.min(31, nameProposal.length());
String shortenname = nameProposal.substring(0, length);
StringBuilder result = new StringBuilder(shortenname);
for (int i = 0; i < length; ++i) {
char ch = result.charAt(i);
switch (ch) {
case '\0':
case '\3':
case '*':
case '/':
case ':':
case '?':
case '[':
case '\\':
case ']':
result.setCharAt(i, replaceChar);
break;
case '\'':
if ((i == 0) || (i == length - 1)) {
result.setCharAt(i, replaceChar);
}
}
}
return result.toString();
}
package info.doesystem.tutorial.poi;
import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class NewSheet {
public static void main(String[] args) {
try (
Workbook wb = new XSSFWorkbook();
FileOutputStream fileOut = new FileOutputStream("D://Blog/Temp File/workbook.xlsx")
){
Sheet sheet1 = wb.createSheet("new sheet 1111111111111111111111111111111111111111111111111");
Sheet sheet2 = wb.createSheet("new sheet 2:2");
wb.write(fileOut);
System.out.println("SUCCESS");
} catch (Exception ex) {
System.out.println("Exception " + ex);
}
}
}
package info.doesystem.tutorial.poi;
import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class NewSheet {
public static void main(String[] args) {
try (
Workbook wb = new XSSFWorkbook();
FileOutputStream fileOut = new FileOutputStream("D://Blog/Temp File/workbook.xlsx")
){
Sheet sheet1 = wb.createSheet("new sheet 1");
Sheet sheet2 = wb.createSheet("new sheet 2");
wb.write(fileOut);
System.out.println("SUCCESS");
} catch (Exception ex) {
System.out.println("Exception " + ex);
}
}
}
package info.doesystem.tutorial.poi;
import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Workbook;
public class NewWorkbook {
public static void main(String[] args) {
try (
Workbook wb = new HSSFWorkbook();
FileOutputStream fileOut = new FileOutputStream("D://Blog/Temp File/workbook.xls");
){
wb.write(fileOut);
System.out.println("SUCCESS");
} catch (Exception ex) {
System.out.println("Exception " + ex);
}
}
}
package info.doesystem.tutorial.poi;
import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class NewWorkbook {
public static void main(String[] args) {
try (
Workbook wb = new XSSFWorkbook();
FileOutputStream fileOut = new FileOutputStream("D://Blog/Temp File/workbook.xlsx");
){
wb.write(fileOut);
System.out.println("SUCCESS");
} catch (Exception ex) {
System.out.println("Exception " + ex);
}
}
}
<link rel="prev" href="http://www.doesystem.info/page/1"> <link rel="next" href="http://www.doesystem.info/page/3">
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/poi/wp/usermodel/Paragraph at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631) at java.lang.ClassLoader.defineClass(ClassLoader.java:615) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141) at java.net.URLClassLoader.defineClass(URLClassLoader.java:283) at java.net.URLClassLoader.access$000(URLClassLoader.java:58) at java.net.URLClassLoader$1.run(URLClassLoader.java:197) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:247) at org.apache.poi.xwpf.usermodel.XWPFTableCell.เมื่อลองค้นหาวิธีการแก้ไขก็ได้ว่าต้องแก้ไขโดยการไปดาวน์โหลด Library อื่นมาเพิ่มเติมซึ่งขาดอยู่นั่นกคือ hamcrest-core-xxx.jar(XWPFTableCell.java:93) at org.apache.poi.xwpf.usermodel.XWPFTableRow.getTableCells(XWPFTableRow.java:160) at org.apache.poi.xwpf.usermodel.XWPFTableRow. (XWPFTableRow.java:48) at org.apache.poi.xwpf.usermodel.XWPFTable. (XWPFTable.java:109) at org.apache.poi.xwpf.usermodel.XWPFDocument.createTable(XWPFDocument.java:865) at helpwork.SpecWord.createTableForBean(SpecWord.java:36) at helpwork.SpecWord.main(SpecWord.java:22) Caused by: java.lang.ClassNotFoundException: org.apache.poi.wp.usermodel.Paragraph at java.net.URLClassLoader$1.run(URLClassLoader.java:202) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:247) ... 19 more
@XmlSchemaType(name = "datetime")
@XmlSchemaType(name = "dateTime")
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
import javax.xml.datatype.DatatypeFactory;
import javax.xml.datatype.XMLGregorianCalendar;
public class DoesystemInfo {
public static void main(String[] args) {
try{
Date mydate = Calendar.getInstance().getTime();
GregorianCalendar gCalendar = new GregorianCalendar();
gCalendar.setTime(mydate);
XMLGregorianCalendar xmlCalendar = DatatypeFactory.newInstance().newXMLGregorianCalendar(gCalendar);
System.out.println(xmlCalendar);
}
catch(Exception ex){
System.out.println("Exception When Convert Date to XMLGregorianCalendar By Doesystem.info");
}
}
}
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
import javax.xml.datatype.DatatypeFactory;
import javax.xml.datatype.XMLGregorianCalendar;
public class DoesystemInfo {
public static void main(String[] args) {
try{
Date mydate = Calendar.getInstance().getTime();
GregorianCalendar gCalendar = new GregorianCalendar();
gCalendar.setTime(mydate);
XMLGregorianCalendar xmlCalendar = DatatypeFactory.newInstance().newXMLGregorianCalendar(gCalendar);
System.out.println(xmlCalendar);
// Convert XMLGregorianCalendar to Date
Date xmlToDate = xmlCalendar.toGregorianCalendar().getTime();
System.out.println(xmlToDate);
}
catch(Exception ex){
System.out.println("Exception When Convert Date to XMLGregorianCalendar By Doesystem.info");
}
}
}
<?php
class PDOConnect{
private $host;
private $userhost;
private $passhost;
private $database;
private $pdo;
public function __construct(){
$this->host = "localhost";
$this->userhost = "root";
$this->passhost = "doesysteminfo";
$this->database = "doesysteminfo";
}
public function getConnect(){
try {
$this->pdo = new PDO("mysql:host={$this->host};dbname={$this->database};charset=UTF8", $this->userhost, $this->passhost);
$this->pdo->exec("set names utf8");
} catch (Exception $e) {
echo $e;
}
return $this->pdo;
}
}
?>
แค่นี้เราก็สามารถติดต่อฐานข้อมูลเป็นภาษาไทยได้แล้ว