jxls 操作excel案例

最新推荐文章于 2024-08-16 11:30:00 发布

weixin_33841722

最新推荐文章于 2024-08-16 11:30:00 发布

阅读量239

点赞数

文章标签： java 人工智能

原文链接：https://my.oschina.net/lxping/blog/38010

版权

为什么80%的码农都做不了架构师？>>>

需要的jar包：

excel里面的配置信息：

<jx:forEach items="${departments}" var="department" varStatus="status">
    <jx:if test="${department.line==0}" >
    ${status.index}        ${department.testNumber}
    </jx:if>
    <jx:if test="${department.line==1}">
    ${status.index}        ${department.testNumber}
    </jx:if>
</jx:forEach>

java代码:

public class bean extends BaseReportbean {
    public String testNumber;

    public String getTestNumber() {
        return testNumber;
    }

    public void setTestNumber(String testNumber) {
        this.testNumber = testNumber;
    }
}

package test;

import java.io.BufferedInputStream;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import net.sf.jxls.transformer.XLSTransformer;

import org.apache.commons.lang.RandomStringUtils;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;

public class exportExcel {

    public static void main(String[] args) throws Exception {
        XLSTransformer transformer = new XLSTransformer();
        String xlsFileName = "E:/templates/beandata.xls";
        Map beans = new HashMap();
        List<bean> list=new ArrayList<bean>();
        for (int i = 0; i < 20; i++) {
            bean model=new bean();
            model.setTestNumber(Math.random()+"");
            list.add(model);

        }
        beans.put("departments", list);
        try {
            int count=1;
            String id=RandomStringUtils.random(18,"qwertyuioplkjhgfdsazxcvbnm1234567890QWERTYUIOPLKJHGFDSAZXCVBNM");
            transformer.transformXLS(xlsFileName, beans, "D:/"+id+".xls");
            InputStream is = new BufferedInputStream(new FileInputStream("E:/QQPCmgr/Desktop/2011.11.02.xls"));
            Workbook workbook = WorkbookFactory.create(is);
            Sheet sheet = workbook.getSheetAt(1);
            System.out.println(sheet.getSheetName());
            System.out.println(sheet.getLastRowNum());
            int lastrows = sheet.getLastRowNum();
            for (int i = 0; i < lastrows; i++) {
                Row rows = sheet.getRow(i);
                int lastcell = rows.getLastCellNum();
                for (int j = 0; j < lastcell; j++) {
                    Cell cell = rows.getCell(j);
                    if (cell == null) {
                        continue;
                    }
                    if (cell.toString() == "") {
                        continue;
                    }
                    System.out.println(count+":"+cell);
                    count++;
                }
            }
            System.out.println(id);
        } catch (Exception e) {
            e.printStackTrace();
        }

    }
}