基本操作--创建excel文档

[java]代码库

package s0505创建excel文档;

import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

//要先导入poi的jar包
public class Main {
 public static void main(String[] args) throws IOException{
	 
			//在桌面创建一个excel文档
			 Workbook wb = new HSSFWorkbook();
			 //创建一个工作表
			 Sheet sheet1 = wb.createSheet("new sheet");
			 Row row = sheet1.createRow(2);           //sheet1.createRow(x)操作下标为x的行,x=0表示第一行
			 Cell cell = row.createCell(0);           // row.createCell(y)创建第x行的下标为y的单元,y从0开始
			 cell.setCellValue("是电话费");            //给x行下标为y的单元赋值,任意值均可以
			    
			 FileOutputStream fileOut = new FileOutputStream("C:/Users/Administrator/Desktop/java生成excel.xls");
			 wb.write(fileOut);
			 fileOut.close();

	  
 }
}