• jxl生成和解析Excel


    生成Excle

    package com.jmz.java;
    
    import java.io.File;
    
    import jxl.Workbook;
    import jxl.write.Label;
    import jxl.write.WritableSheet;
    import jxl.write.WritableWorkbook;
    
    public class WriteExcelUseJXL {
    
        /**
         * @param args
         */
        public static void main(String[] args) {
            String title[] = {"id","name","sex"};
            File file = new File("d:\jxl.xls");
            try {
                file.createNewFile();
                //创建工作簿
                WritableWorkbook workbook = Workbook.createWorkbook(file);
                //创建sheet页
                WritableSheet sheet = workbook.createSheet("sheet1",0);
                //创建label
                Label label = null;
                //添加表头
                for (int i = 0; i < title.length; i++) {
                    //列,行,内容
                    label = new Label(i, 0, title[i]);
                    sheet.addCell(label);
                }
                //添加内容
                for (int i = 1; i < 10; i++) {
                    label = new Label(0, i, "a"+i);
                    sheet.addCell(label);
                    label = new Label(1, i, "jim"+i);
                    sheet.addCell(label);
                    label = new Label(2, i, "男");
                    sheet.addCell(label);
                }
                workbook.write();
                workbook.close();
                
                
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
    
        }
    
    }

    解析Excle

    package com.jmz.java;
    
    import java.io.File;
    import java.io.IOException;
    
    import jxl.Cell;
    import jxl.Sheet;
    import jxl.Workbook;
    import jxl.read.biff.BiffException;
    
    public class GetExclUseJXL {
    
        /**
         * @param args
         */
        public static void main(String[] args) {
            // TODO Auto-generated method stub
            File file = new File("d:\jxl.xls");
            try {
                //获取workbook
                Workbook workbook = Workbook.getWorkbook(file);
                //获取sheet页
                Sheet sheet = workbook.getSheet(0);
                //循环行
                for (int i = 0; i < sheet.getRows(); i++) {
                    //循环列
                    for (int j = 0; j < sheet.getColumns(); j++) {
                        //创建cell
                        Cell cell = sheet.getCell(j, i);
                        //打印
                        System.out.print(cell.getContents()+" ");
                    }
                    System.out.println();
                }
                //关闭
                workbook.close();
            } catch (BiffException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (IOException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            
        }
    
    }
  • 相关阅读:
    了解xss
    kail Windows10 远程连接解决办法
    信息收集二级域名或ip收集
    mpvue引用Echarts不渲染问题
    IIS状态码
    apicloud的tapmode用法
    JavaScript交换两个变量值的七种解决方案
    IIS express 服务的开启, 支持多个iis express
    asp.net解决跨域访问问题
    Flex 布局
  • 原文地址:https://www.cnblogs.com/84126858jmz/p/5693497.html
Copyright © 2020-2023  润新知