Poi read and write excel and word

Source: Internet
Author: User

If you want to import excel data to a database or export the data in the database as excel, POI is a good choice. Apache POI is an open-source library of the Apache Software Foundation. POI provides APIs for Java programs to read and write Microsoft Office files.
HSSF-provides the ability to read and write Microsoft Excel files.
XSSF-provides the ability to read and write files in Microsoft Excel OOXML format.
HWPF-read and write Microsoft Word files.
HSLF-supports reading and writing Microsoft PowerPoint files.
HDGF-read and write Microsoft Visio files.
The following two demos read and write excel and word respectively:
Read xls data:
View plaincopy to clipboardprint?
Package poi.xls;
 
Import org. apache. poi. hssf. usermodel. HSSFWorkbook;
Import org. apache. poi. hssf. usermodel. HSSFSheet;
Import org. apache. poi. hssf. usermodel. HSSFRow;
Import org. apache. poi. hssf. usermodel. HSSFCell;
Import java. io. FileInputStream;
 
/**
* Use POI to read content from excel
*/
Public class XLSReader {

Public static String fileToRead = "c:/test.xls ";
 
Public static void main (String args []) throws Exception {
// Create a reference to an Excel Workbook File
HSSFWorkbook workbook = new HSSFWorkbook (new FileInputStream (fileToRead ));
 
// HSSFSheet sheet = workbook. getSheet ("first page ");
HSSFSheet sheet = workbook. getSheetAt (0 );

// Read the value of the specified index row
HSSFRow row = sheet. getRow (1 );
// Read the value of the specified index.
HSSFCell id = row. getCell (short) 0 );
HSSFCell name = row. getCell (short) 1 );
HSSFCell password = row. getCell (short) 2 );

// Read data
System. out. println ("id:" + id. getNumericCellValue ());
System. out. println ("name:" + name. getRichStringCellValue ());
System. out. println ("password:" + password. getRichStringCellValue ());
}
}
Package poi.xls;
Import org. apache. poi. hssf. usermodel. HSSFWorkbook;
Import org. apache. poi. hssf. usermodel. HSSFSheet;
Import org. apache. poi. hssf. usermodel. HSSFRow;
Import org. apache. poi. hssf. usermodel. HSSFCell;
Import java. io. FileInputStream;
/**
* Use POI to read content from excel
*/
Public class XLSReader {

Public static String fileToRead = "c:/test.xls ";
Public static void main (String args []) throws Exception {
// Create a reference to an Excel Workbook File
HSSFWorkbook workbook = new HSSFWorkbook (new FileInputStream (fileToRead ));
// HSSFSheet sheet = workbook. getSheet ("first page ");
HSSFSheet sheet = workbook. getSheetAt (0 );

// Read the value of the specified index row
HSSFRow row = sheet. getRow (1 );
// Read the value of the specified index.
HSSFCell id = row. getCell (short) 0 );
HSSFCell name = row. getCell (short) 1 );
HSSFCell password = row. getCell (short) 2 );

// Read data
System. out. println ("id:" + id. getNumericCellValue ());
System. out. println ("name:" + name. getRichStringCellValue ());
System. out. println ("password:" + password. getRichStringCellValue ());
}
}
Create an xls file:
View plaincopy to clipboardprint?
Package poi.xls;
 
Import java. io. FileOutputStream;
 
Import org. apache. poi. hssf. usermodel. HSSFRichTextString;
Import org. apache. poi. hssf. usermodel. HSSFWorkbook;
Import org. apache. poi. hssf. usermodel. HSSFSheet;
Import org. apache. poi. hssf. usermodel. HSSFRow;
Import org. apache. poi. hssf. usermodel. HSSFCell;
 
/**
* Using POI to write content to excel
*/
Public class XLSWriter {

Public static String fileToWrite = "c:/test.xls ";

Public static void main (String [] args) throws Exception {
 
// Create a new Excel Workbook
HSSFWorkbook workbook = new HSSFWorkbook ();
 
// Create a worksheet in an Excel worksheet named the default value
HSSFSheet sheet = workbook. createSheet ("first page ");
// HSSFSheet sheet = workbook. createSheet ();
 
// Create a row at the specified index
HSSFRow row = sheet. createRow (short) 0 );
 
// Create a cell in the specified index
HSSFCell id = row. createCell (short) 0 );
// Define cells as strings
Id. setCellType (HSSFCell. CELL_TYPE_NUMERIC );
// Enter some content in the cell. HSSFRichTextString can solve the garbled problem.
HSSFRichTextString idContent = new HSSFRichTextString ("User ID ");
Id. setCellValue (idContent );
 
HSSFCell name = row. createCell (short) 1 );
Name. setCellType (HSSFCell. CELL_TYPE_STRING );
HSSFRichTextString nameContent = new HSSFRichTextString ("username ");
Name. setCellValue (nameContent );
 
HSSFCell password = row. createCell (short) 2 );
Password. setCellType (HSSFCell. CELL_TYPE_STRING );
HSSFRichTextString passwordContent = new HSSFRichTextString ("User Password ");
Password. setCellValue (passwordContent );
 
// Create an output file stream
FileOutputStream out = new FileOutputStream (fileToWrite );
// Save the corresponding Excel Workbook
Workbook. write (out );
Out. flush ();
// The operation ends. close the file.
Out. close ();
 
System. out. println ("file generation..." + fileToWrite );
}
}
Package poi.xls;
Import java. io. FileOutputStream;
Import org. apache. poi. hssf. usermodel. HSSFRichTextString;
Import org. apache. poi. hssf. usermodel. HSSFWorkbook;
Import org. apache. poi. hssf. usermodel. HSSFSheet;
Import org. apache. poi. hssf. usermodel. HSSFRow;
Import org. apache. poi. hssf. usermodel. HSSFCell;
/**
* Using POI to write content to excel
*/
Public class XLSWriter {

Public static String fileToWrite = "c:/test.xls ";

Public static void main (String [] args) throws Exception {
// Create a new Excel Workbook
HSSFWorkbook workbook = new HSSFWorkbook ();
// Create a worksheet in an Excel worksheet named the default value
HSSFSheet sheet = workbook. createSheet ("first page ");
// HSSFSheet sheet = workbook. createSheet ();
// Create a row at the specified index
HSSFRow row = sheet. createRow (short) 0 );
// Create a cell in the specified index
HSSFCell id = row. createCell (short) 0 );
// Define cells as strings
Id. setCellType (HSSFCell. CELL_TYPE_NUMERIC );
// Enter some content in the cell. HSSFRichTextString can solve the garbled problem.
HSSFRichTextString idContent = new HSSFRichTextString ("User ID ");
Id. setCellValue (idContent );
HSSFCell name = row. createCell (short) 1 );
Name. setCellType (HSSFCell. CELL_TYPE_STRING );
HSSFRichTextString nameContent = new HSSFRichTextString ("username ");
Name. setCellValue (nameContent );
HSSFCell password = row. createCell (short) 2 );
Password. setCellType (HSSFCell. CELL_TYPE_STRING );
HSSFRichTextString passwordContent = new HSSFRichTextString ("User Password ");
Password. setCellValue (passwordContent );
// Create an output file stream
FileOutputStream out = new FileOutputStream (fileToWrite );
// Save the corresponding Excel Workbook
Workbook. write (out );
Out. flush ();
// The operation ends. close the file.
Out. close ();
System. out. println ("file generation..." + fileToWrite );
}
}
Read the word content:
View plaincopy to clipboardprint?
Package poi.doc;
 
/**
* Use POI to read content from word
*/
Import java. io. FileInputStream;
 
Import org. apache. poi. hwpf. extractor. WordExtractor;
 
Public class DOCReader {

Public static String fileToRead = "c:/test.doc ";

Public static void main (String [] args) throws Exception {
// Create an input stream to read the DOC file
FileInputStream in = new FileInputStream (fileToRead );

// Create a WordExtractor
WordExtractor extractor = new WordExtractor (in );

// Extract the DOC file
String text = extractor. getText ();
 
System. out. println (text );
}
 
}
Package poi.doc;
/**
* Use POI to read content from word
*/
Import java. io. FileInputStream;
Import org. apache. poi. hwpf. extractor. WordExtractor;
Public class DOCReader {

Public static String fileToRead = "c:/test.doc ";

Public static void main (String [] args) throws Exception {
// Create an input stream to read the DOC file
FileInputStream in = new FileInputStream (fileToRead );

// Create a WordExtractor
WordExtractor extractor = new WordExtractor (in );

// Extract the DOC file
String text = extractor. getText ();
System. out. println (text );
}
}
Create a word file:
View plaincopy to clipboardprint?
Package poi.doc;
 
Import java. io. ByteArrayInputStream;
Import java. io. FileOutputStream;
 
Import org. apache. poi. poifs. filesystem. POIFSFileSystem;
 
/**
* Using POI to write content to word
*/
Public class DOCWriter {
 
Public static String fileToWrite = "c:/test.doc ";
 
Public static void main (String [] args) throws Exception {
String content = "test data, will be written to the document ";

Byte B [] = content. getBytes ();
 
ByteArrayInputStream bais = new ByteArrayInputStream (B );
 
POIFSFileSystem fs = new POIFSFileSystem ();

FileOutputStream ostream = new FileOutputStream (fileToWrite );
 
Fs. writeFilesystem (ostream );
 
Bais. close ();

Ostream. close ();
 
}
}
Package poi.doc;
Import java. io. ByteArrayInputStream;
Import java. io. FileOutputStream;
Import org. apache. poi. poifs. filesystem. POIFSFileSystem;
/**
* Using POI to write content to word
*/
Public class DOCWriter {
Public static String fileToWrite = "c:/test.doc ";
Public static void main (String [] args) throws Exception {
String content = "test data, will be written to the document ";
 
Byte B [] = content. getBytes ();
ByteArrayInputStream bais = new ByteArrayInputStream (B );
POIFSFileSystem fs = new POIFSFileSystem ();
 
FileOutputStream ostream = new FileOutputStream (fileToWrite );
Fs. writeFilesystem (ostream );
Bais. close ();
 
Ostream. close ();
}
}
The above are a few small examples. To use more complex applications, you can refer to the poi api.

Author: "tnjun123456"
 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.