excel表格怎么导入java

1.java导入excel怎么导入?

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 ExcelTo {

public static void main(String[] args) {

String fileToBeRead = "g:\\Salary\\Salary.xls";

try {

HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileToBeRead)）； // 创建对Excel工作簿文件的引用

HSSFSheet sheet = workbook.getSheet（"员工表"）； // 创建对工作表的引用

int rows = sheet.（)；//获取表格的

for (int r = 0; r < rows; r++) { //循环遍历表格的行

String value = "";

HSSFRow row = sheet.getRow(r)； //获取单元格中指定的行对象

if (row != null) {

int cells = row.（)；//获取单元格中指定列对象

for (short c = 0; c < cells; c++) { //循环遍历单元格中的列

HSSFCell cell = row.getCell((short) c）； //获取指定单元格中的列

if (cell != null) {

if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING） { //判断单元格的值是否为字符串类型

value += cell.getStringCellValue() + ",";

} else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC） { //判断单元格的值是否为数字类型

value += cell.getNumericCellValue() + ",";

} else if (cell.getCellType() == HSSFCell.CELL_TYPE_BOOLEAN） { //判断单元格的值是否为布尔类型

value += cell.getStringCellValue() + ",";

}

}

}

}

String[] str = value.split(",");

System.out.println(value);

}

} catch (Exception e) {

e.printStackTrace();

}

}

}

2.excel往java中导入怎么解决

1、加入依赖的jar文件：123引用：*mysql的jar文件 *Spring_HOME/lib/poi/*.jar2、编写数据库链接类 com.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、编写数据库操作类 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表格实体类 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、编写主键生成方法 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操作类 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 { private HSSFWorkbook workbook; private String tableName; private Class type; private String sheetName; public OperExcel(File excelFile, String tableName, Class type, String sheetName) throws FileNotFoundException, IOException { workbook = new HSSFWorkbook(new FileInputStream(excelFile)); this.tableName = tableName; this.type = type; this.sheetName = sheetName; InsertData（)； } // 向表中写入数据 public void InsertData() { System.out.println("yyy"); ExcuteData excuteData = new ExcuteData(); List 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 List getDatasInSheet(String sheetName) { List result = new ArrayList<。

3.java导入excel怎么导入

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 ExcelTo { public static void main(String[] args) { String fileToBeRead = "g:\\Salary\\Salary.xls"; try { HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileToBeRead)）； // 创建对Excel工作簿文件的引用 HSSFSheet sheet = workbook.getSheet（"员工表"）； // 创建对工作表的引用 int rows = sheet.（)；//获取表格的 for (int r = 0; r < rows; r++) { //循环遍历表格的行 String value = ""; HSSFRow row = sheet.getRow(r)； //获取单元格中指定的行对象 if (row != null) { int cells = row.（)；//获取单元格中指定列对象 for (short c = 0; c < cells; c++) { //循环遍历单元格中的列 HSSFCell cell = row.getCell((short) c）； //获取指定单元格中的列 if (cell != null) { if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING） { //判断单元格的值是否为字符串类型 value += cell.getStringCellValue() + ","; } else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC） { //判断单元格的值是否为数字类型 value += cell.getNumericCellValue() + ","; } else if (cell.getCellType() == HSSFCell.CELL_TYPE_BOOLEAN） { //判断单元格的值是否为布尔类型 value += cell.getStringCellValue() + ","; } } } } String[] str = value.split(","); System.out.println(value); } } catch (Exception e) { e.printStackTrace(); } }}。