1. java怎么导出excel表格
通过这个例子,演示以下如何用java生成excel文件:
import org.apache.poi.hssf.usermodel.*;
import java.io.FileOutputStream;
import java.io.IOException;
publicclass CreateCells
{
publicstaticvoid main(String[] args)
throws IOException
{
HSSFWorkbook wb = new HSSFWorkbook();//建立新HSSFWorkbook对象
HSSFSheet sheet = wb.createSheet("new sheet");//建立新的sheet对象
// Create a row and put some cells in it. Rows are 0 based.
HSSFRow row = sheet.createRow((short)0);//建立新行
// Create a cell and put a value in it.
HSSFCell cell = row.createCell((short)0);//建立新cell
cell.setCellValue(1);//设置cell的整数类型的值
// Or do it on one line.
row.createCell((short)1).setCellValue(1.2);//设置cell浮点类型的值
row.createCell((short)2).setCellValue("test");//设置cell字符类型的值
row.createCell((short)3).setCellValue(true);//设置cell布尔类型的值
HSSFCellStyle cellStyle = wb.createCellStyle();//建立新的cell样式
cellStyle.setDataFormat(HSSFDataFormat.getFormat("m/d/yy h:mm"));//设置cell样式为定制的日期格式
HSSFCell dCell =row.createCell((short)4);
dCell.setCellValue(new Date());//设置cell为日期类型的值
dCell.setCellStyle(cellStyle); //设置该cell日期的显示格式
HSSFCell csCell =row.createCell((short)5);
csCell.setEncoding(HSSFCell.ENCODING_UTF_16);//设置cell编码解决中文高位字节截断
csCell.setCellValue("中文测试_Chinese Words Test");//设置中西文结合字符串
row.createCell((short)6).setCellType(HSSFCell.CELL_TYPE_ERROR);//建立错误cell
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
wb.write(fileOut);
fileOut.close();
}
}
2. 怎么用java poi生成word表格
rt java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
public class XwpfTUtil {
/*String filePath = "/sta.docx";
InputStream is;
XWPFDocument doc;
Mapparams = new HashMap();
{
params.put("${name}", "xxx");
params.put("${sex}", "男");
params.put("${political}", "共青团员");
params.put("${place}", "sssss");
params.put("${classes}", "3102");
params.put("${id}", "213123123");
params.put("${qq}", "213123");
params.put("${tel}", "312313213");
params.put("${oldJob}", "sadasd");
params.put("${swap}", "是");
params.put("${first}", "asdasd");
params.put("${second}", "综合事务部");
params.put("${award}", "asda");
params.put("${achievement}", "完成科协网站的开发");
params.put("${advice}", "没有建议");
3. java怎么导出excel表格
可以使用POI开源的api:1.首先下载poi-3.6-20091214.jar,下载地址如下:.zzg.db; import java.sql.Connection; import java.sql.DriverManager; public class DbUtils { private static Connection conn; static { try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost/test","root","123456"); } catch (Exception e) { e.printStackTrace(); } } public static Connection getConn() { return conn; } public static void setConn(Connection conn) { DbUtils.conn = conn; } }3,编写数据库操作类 package com.zzg.db; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; public class ExcuteData { private PreparedStatement pstmt; public boolean ExcuData(String sql) { Connection conn = DbUtils.getConn(); boolean flag=false; try { pstmt = conn.prepareStatement(sql); flag=pstmt.execute(); } catch (SQLException e) { e.printStackTrace(); } return flag; } } 4,编写的Excel表格实体类 package com.zzg.model; public class TableCell { private String _name; private String _value; public String get_name() { return _name; } public void set_name(String _name) { this._name = _name; } public String get_value() { return _value; } public void set_value(String _value) { this._value = _value; } } 5,编写主键生成方法 package com.zzg.util; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Random; public class GenericUtil { public static String getPrimaryKey() { String primaryKey; primaryKey = new SimpleDateFormat("yyyyMMddHHmmss").format(new Date()); Random r = new Random(); primaryKey +=r.nextInt(100000)+100000; return primaryKey; } } 6,编写的Excel操作类 package com.zzg.deployData; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.Serializable; import java.util.ArrayList; import java.util.List; 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; import com.zzg.db.ExcuteData; import com.zzg.model.TableCell; import com.zzg.util.GenericUtil; public class OperExcel
//java生成简单的Excel文件 package beans.excel; import java.io.IOException; import java.io.OutputStream; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import jxl.write.WriteException; public class SimpleExcelWrite { public void createExcel(OutputStream os) throws WriteException,IOException{ //创建工作薄 WritableWorkbook workbook = Workbook.createWorkbook(os); //创建新的一页 WritableSheet sheet = workbook.createSheet("First Sheet",0); //创建要显示的内容,创建一个单元格,第一个参数为列坐标,第二个参数为行坐标,第三个参数为内容 Label xuexiao = new Label(0,0,"学校"); sheet.addCell(xuexiao); Label zhuanye = new Label(1,0,"专业"); sheet.addCell(zhuanye); Label jingzhengli = new Label(2,0,"专业竞争力"); sheet.addCell(jingzhengli); Label qinghua = new Label(0,1,"清华大学"); sheet.addCell(qinghua); Label jisuanji = new Label(1,1,"计算机专业"); sheet.addCell(jisuanji); Label gao = new Label(2,1,"高"); sheet.addCell(gao); Label beida = new Label(0,2,"北京大学"); sheet.addCell(beida); Label falv = new Label(1,2,"法律专业"); sheet.addCell(falv); Label zhong = new Label(2,2,"中"); sheet.addCell(zhong); Label ligong = new Label(0,3,"北京理工大学"); sheet.addCell(ligong); Label hangkong = new Label(1,3,"航空专业"); sheet.addCell(hangkong); Label di = new Label(2,3,"低"); sheet.addCell(di); //把创建的内容写入到输出流中,并关闭输出流 workbook.write(); workbook.close(); os.close(); } } 转载请注明出处51数据库 » java中导出word表格数据 datas = getDatasInSheet(this.sheetName); // 向表中添加数据之前先删除表中数据 String strSql = "delete from " + this.tableName; excuteData.ExcuData(strSql); // 拼接sql语句 for (int i = 1; i < datas.size();="" i++)="" {="" strsql="insert into " +="" this.tablename="" +="" "(";="" list="" row="datas.get(i);" for="" (short="" n="0;" n="">< row.size();="" n++)="" {="" tablecell="" excel="(TableCell)" row.get(n);="" if="" (n="" !="row.size()" -="" 1)="" strsql="" +="excel.get_name()" +="" ",";="" else="" strsql="" +="excel.get_name()" +="" ")";="" }="" strsql="" +=" values (" ;="" for="" (short="" n="0;" n="">< row.size();="" n++)="" {="" tablecell="" excel="(TableCell)" row.get(n);="" try="" {="" if="" (n="" !="row.size()" -="" 1)="" {="" strsql="" +="getTypeChangeValue(excel)" +="" ",";="" }="" else="" strsql="" +="getTypeChangeValue(excel)" +="" ")";="" }="" catch="" (runtimeexception="" e)="" {="" e.printstacktrace();="" }="" catch="" (exception="" e)="" {="" e.printstacktrace();="" }="" }="" 执行sql="" excutedata.excudata(strsql);="" }="" }="" *="" *="" 获得表中的数据="" *="" @param="" sheetname="" 表格索引(excel="" 是多表文档,所以需要输入表索引号)="" *="" @return="" 由list构成的行和表="" */="" public="">
getDatasInSheet(String sheetName) { List
result = new ArrayList
(); // 获得指定的表 HSSFSheet sheet = workbook.getSheet(sheetName); // 获得数据总行数 int rowCount = sheet.getLastRowNum(); if (rowCount < 1)="" {="" return="" result;="" }="" 逐行读取数据="" for="" (int="" rowindex="0;" rowindex="">< rowcount;="" rowindex++)="" {="" 获得行对象="" hssfrow="" row="sheet.getRow(rowIndex);" if="" (row="" !="null)" {="">
5. java怎样输出excel文件