
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(); |
|
} |
} |



