ç»ä½ äºå°ä¾åï¼ç¨çæ¯poi
package com;
import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class CreateXL {
/**
* å¶å®EXCELè¦åæ¾çæ件ä½ç½®ï¼åå®å¨Dççtestç®å½ä¸
*/
public static String outputFile="C:/Users/chentx/Desktop/test.xls";
public static void main(String[] args) {
try {
//å建æ°çExcelå·¥ä½è
HSSFWorkbook workbook = new HSSFWorkbook();
//å¨Excelä¸å»ºä¸ä¸ªå·¥ä½è¡¨,å
¶å为é»è®¤å¼
//å¦æ建é ä¸å¼ 为"ucapå段"çå·¥ä½è¡¨ï¼é£ä¹è¯å¥å°±æ¯HSSFSheet sheet =workbook.createSheet("ucapå段");
HSSFSheet sheet =workbook.createSheet();
//å¨ç´¢å¼0çä½ç½®å建è¡ï¼æ顶端çè¡ï¼
HSSFRow row = sheet.createRow(0);
//å¨ç´¢å¼0çä½ç½®å建åå
æ ¼ï¼å·¦ä¸ç«¯ï¼
HSSFCell cell = row.createCell(0);
//å®ä¹åå
æ ¼ä¸ºå符串类å
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
//å¨åå
æ ¼ä¸è¾å
¥ä¸äºå
容
cell.setCellValue("field1");
//begin,设置åå
æ ¼æ ¼å¼-----------------------------------
HSSFFont font = workbook.createFont();
font.setColor(HSSFFont.COLOR_RED);//设置红è²
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);//设置ç²ä½
//åå»ºæ ¼å¼
HSSFCellStyle cellStyle = workbook.createCellStyle();
cellStyle.setFont(font);
//åºç¨æ ¼å¼
cell.setCellStyle(cellStyle); //è®¾ç½®æ ¼å¼
cell.setCellType(HSSFCell.CELL_TYPE_STRING);//å®ä¹åå
æ ¼ä¸ºå符串类å
cell.setCellValue("é天ç¿é¸æ°");//设置ææ¬å
容
//end,------------------------------------------------
//è¾åºæ件æµ
FileOutputStream fOut = new FileOutputStream(outputFile);
//æç¸åºçexcelå·¥ä½è¡¨ä¿åå°ç¡¬çä¸
workbook.write(fOut);
fOut.flush();
fOut.close();//å
³éæ件ï¼æä½ç»æ
System.out.println("æ件çæå®æ¯....");
} catch (Exception e) {
System.out.println("å·²è¿è¡åºé" + e);
}
}
}
/*******************************************************************************************************/
package com;
import java.io.FileInputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class ReadXL {
public static String fileToBeRead="C:/Users/chentx/Desktop/test.xls";
public static void main(String[] args) {
try {
//å建对excelå·¥ä½è¡¨æ件çå¼ç¨
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileToBeRead));
/* å建对工ä½è¡¨çå¼ç¨ï¼æ¬ä¾æåå¼ç¨(å·¥ä½ç°¿åSheet0)
* HSSFSheet sheet = workbook.getSheet("Sheet0");
* æè
æç´¢å¼å¼ç¨
* HssfSheet sheet = workbook.getSheetAt(0);
*/
HSSFSheet sheet = workbook.getSheetAt(0);
//读åå·¦ä¸ç«¯åå
HSSFRow row = sheet.getRow(0);
HSSFCell cell = row.getCell(0);
//æ¿å°è¯»åºçå
容
String mes = cell.getStringCellValue();
System.out.println("æ¿å°çä¿¡æ¯ï¼" + mes);
} catch (Exception e) {
e.printStackTrace();
}
}
}
温馨提示:答案为网友推荐,仅供参考