创建和设置exel的格式等简单程序,里面有详细说明:
import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.DataFormat;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class WriteExcel
{
public static void main(String[] args) throws Exception
{
// 创建新的excel文件
FileOutputStream out = new FileOutputStream("workbook.xls");
// 创建一个workbook
Workbook wb = new HSSFWorkbook();
// 新建一个sheet
Sheet s = wb.createSheet();
// 声明一个行对象引用
Row r = null;
// 声明一个cell对象引用
Cell c = null;
// 新建3个cell风格
CellStyle cs = wb.createCell