Notice: Undefined index: HTTP_ACCEPT_ENCODING in C:\server\web\www.showyounger.com\s-system.php on line 2
Java读取Excel | 小样儿(ShowYounger)
小样儿,顶呱呱!!![http://www.showyounger.com]
- import java.io.File;
- import java.sql.Connection;
- import javax.servlet.ServletContext;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
-
- import jxl.Cell;
- import jxl.CellType;
- import jxl.DateCell;
- import jxl.NumberCell;
- import jxl.Sheet;
- import jxl.Workbook;
-
- import com.xxx.exception.SystemException;
- import com.xxx.web.IAction;
-
- public class CaseQueryAction implements IAction{
-
- public CaseQueryAction() {
-
- }
-
- public void perform(
- HttpServletRequest request,
- HttpServletResponse response,
- ServletContext context,
- Connection connection)
- throws ServletException, SystemException {
-
- Workbook workbook = null;
-
- try {
- workbook = Workbook.getWorkbook(new File("d:\\temp\\TestRead.xls"));
- } catch (Exception e) {
- try {
- throw new Exception("file to import not found!");
- } catch (Exception e1) {
- e1.printStackTrace();
- }
- }
-
- Sheet sheet = workbook.getSheet(0);
- Cell cell = null;
-
- int columnCount=3;
- int rowCount=sheet.getRows();
- for (int i = 0; i <rowCount; i++) {
- for (int j = 0; j <columnCount; j++) {
-
- cell=sheet.getCell(j, i);
-
- if(cell.getType()==CellType.NUMBER){
- System.out.print(((NumberCell)cell).getValue());
- }else if(cell.getType()==CellType.DATE){
- System.out.print(((DateCell)cell).getDate());
- }else{
- System.out.print(cell.getContents());
- }
-
- System.out.print("\t");
- }
- System.out.print("\n");
- }
-
- workbook.close();
- }
- }