偶然的机会,在使用hibernate查询数据库的数据,通过poi的方式导出到excel列表中。
但是由于poi中的cell.setCellValue只能是boolean,double,string,Calendar等类型,无法将Object[]进行循环设置到cell里面。
因此在网络上搜索了很多的办法,尝试了多种方法,自己也思考了很久!
终于想到了一个好方法,既然cell.setCellValue可以设置string类型的数据;那么就将List中的Object[]转化为String[]
方法如下:
List<Object[]> objList = query.list();
List<String[]> dataList = new ArrayList<String[]>();
//迭代处理list中的Object[]
Iterator iter = objList.iterator();
while(iter.hasNext()){
Object[] obj = (Object[]) iter.next();
String[] str = new String[obj.length];//每次都创建一个string数组匹配obj数据
for(int i=0;i<obj.length;i++){
if(obj[i]==null)//如果数据库中存在空值,应该转成""
obj[i] = "";
//System.out.println("结果:"+i+":"+obj[i].toString());
str[i] = obj[i].toString();
}
dataList.add(str);
}
最终的List<Object[]> 成功转成了List<String[]> ,就可以通过循环设置cell中的值了。
分享到:
相关推荐
基于新版本的POI编写的读取Excel文件数据的工具类,可根据绝对路径、File对象、InputSteam对象读取解析Excel文件内容,并返回List<List<String>>格式结果,其中包含对单元格公式的处理。
<groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.17</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-examples</artifactId> ...
POI的JAR,里面有POI的3.7的JAr <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>3.7</version> </dependency> <dependency> <groupId>org.apache.poi</groupId...
-<dependency> <groupId>com.microsoft.sqlserver</groupId> <artifactId>mssql-jdbc</artifactId> <version>6.2.0.jre8</version> <scope>runtime</scope> </dependency> <!-- 百度人工智能 --> -...
<groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.15</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>...
可将List<Bean>导出成Excel,或读取Excel成List<Bean>、Map<String,Object>,很方便,可配置日期格式,可识别数字,经过企业级测试有效. <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</...
<groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.9</version> <type>pom</type> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml-...
<groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.8</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>...
<groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.17</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>...
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>读入 <br><br>import org.apache.poi.hssf.usermodel.*;<br>import org.apache.poi.poifs.filesystem.*;<br>import java.io....
<groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.13</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>...
at org.apache.poi.POIXMLDocumentPart.<init>(POIXMLDocumentPart.java:91) at org.apache.poi.POIXMLDocument.<init>(POIXMLDocument.java:56) at org.apache.poi.xwpf.usermodel.XWPFDocument.<init>...
<groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.13-beta1</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> ...
spring-hibernate-dwr做的AJAX操作CRUD实例<br>...1.3.jar<br>poi-2.5.1.jar<br>cos.jar<br>velocity-1.5.jar<br>velocity-tools-view-1.3.jar<br>commons-codec.jar<br>dwr-2.0.rc2.jar<br>asm.jar<br>files.lst<br>
api.jar<br>jxl.jar<br>itext-1.3.jar<br>poi-2.5.1.jar<br>cos.jar<br>velocity-1.5.jar<br>velocity-tools-view-1.3.jar<br>commons-codec.jar<br>antlr.jar<br>commons-beanutils.jar<br>commons-digester.jar<br...
<groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.9</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>...
引用: import org.apache.poi.hssf.usermodel.*; maven依赖: <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>RELEASE</version> </dependency> ...
at org.apache.poi.openxml4j.opc.internal.marshallers.PackagePropertiesMarshaller.<clinit>(PackagePropertiesMarshaller.java:41) at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:161) ...
<artifactId>easyexcel</artifactId> <version>2.2.6</version> <exclusions> <exclusion> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> </exclusion> </exclusions> </...
<groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>4.1.0</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version...