android中生成excel

来源：互联网发布：首席财务官知乎编辑：程序博客网时间：2024/06/11 04:22

初始化数据

首先我们要先造下测试数据，这里我把数据写死在一个常量类Const中，如下：

<code class="hljs cs has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;"><span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">class</span> Const {    <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">interface</span> OrderInfo{        <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">static</span> final String[][] orderOne = <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">new</span> String[][] {{ <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"123"</span>, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"九龙"</span>, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"13294352311"</span>,            <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"武汉市关山口"</span> },{ <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"124"</span>, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"咱家"</span>, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"13294352312"</span>,            <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"武汉市水果湖"</span> },{ <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"125"</span>, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"陈家"</span>, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"13294352315"</span>,            <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"武汉市华师"</span> },{ <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"126"</span>, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"李"</span>, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"13294352316"</span>,            <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"武汉市杨家湾"</span> }};    }}</code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li></ul>

理论上这些数据是从后台读过来的。
本文模拟打印订单的信息，所以这里还需要一个订单Model类：

<code class="hljs java has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;"><span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">public</span> <span class="hljs-class" style="box-sizing: border-box;"><span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">class</span> <span class="hljs-title" style="color:#66066;box-sizing: border-box;">Order</span> <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">implements</span> <span class="hljs-title" style="color:#66066;box-sizing: border-box;">Serializable</span> {</span>    <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">public</span> String id;    <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">public</span> String restPhone;    <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">public</span> String restName;    <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">public</span> String receiverAddr;    <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">public</span> <span class="hljs-title" style="box-sizing: border-box;">Order</span>(String id,String restPhone, String restName, String receiverAddr) {        <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">this</span>.id = id;        <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">this</span>.restPhone = restPhone;        <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">this</span>.restName = restName;        <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">this</span>.receiverAddr = receiverAddr;    }}</code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li><li style="box-sizing: border-box; padding: 0px 5px;">11</li><li style="box-sizing: border-box; padding: 0px 5px;">12</li><li style="box-sizing: border-box; padding: 0px 5px;">13</li><li style="box-sizing: border-box; padding: 0px 5px;">14</li><li style="box-sizing: border-box; padding: 0px 5px;">15</li><li style="box-sizing: border-box; padding: 0px 5px;">16</li><li style="box-sizing: border-box; padding: 0px 5px;">17</li><li style="box-sizing: border-box; padding: 0px 5px;">18</li><li style="box-sizing: border-box; padding: 0px 5px;">19</li></ul>

存内存卡

接下来我们要判断一下内存卡是否存在，内存是否足够大。先获取指定目录下内存的大小：

<code class="hljs java has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;">    <span class="hljs-javadoc" style="color:#8800;box-sizing: border-box;">/** 获取SD可用容量 */</span>    <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">private</span> <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">static</span> <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">long</span> <span class="hljs-title" style="box-sizing: border-box;">getAvailableStorage</span>(Context context) {        String root = context.getExternalFilesDir(<span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">null</span>).getPath();        StatFs statFs = <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">new</span> StatFs(root);        <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">long</span> blockSize = statFs.getBlockSize();        <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">long</span> availableBlocks = statFs.getAvailableBlocks();        <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">long</span> availableSize = blockSize * availableBlocks;        <span class="hljs-comment" style="color:#8800;box-sizing: border-box;">// Formatter.formatFileSize(context, availableSize);</span>        <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">return</span> availableSize;    }</code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li></ul>

这里用到的路径是getExternalFilesDir，它指定的是SDCard/Android/data/你的应用的包名/files/ 目录这个目录，它用来放一些长时间保存的数据，当应用被卸载时，会同时会删除。类似这种情况的还有getExternalCacheDir方法，只是它一般用来存放临时文件。之后通过StatFs来计算出可用容量的大小。
接下来在写入excel前对内存进行判断，如下：

<code class="hljs avrasm has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;">if(!Environment<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.getExternalStorageState</span>()<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.equals</span>(Environment<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.MEDIA</span>_MOUNTED)&&getAvailableStorage()><span class="hljs-number" style="color:#06666;box-sizing: border-box;">1000000</span>) {            Toast<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.makeText</span>(context, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"SD卡不可用"</span>, Toast<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.LENGTH</span>_LONG)<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.show</span>()<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>            return<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        }        File file<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        File dir = new File(context<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.getExternalFilesDir</span>(null)<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.getPath</span>())<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        file = new File(dir, fileName + <span class="hljs-string" style="color:#0880;box-sizing: border-box;">".xls"</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        if (!dir<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.exists</span>()) {            dir<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.mkdirs</span>()<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        }</code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li></ul>

如果内存卡不存在或内存小于1M，不进行写入，然后创建相应的文件夹并起名字。接下来重点看下如何写入excel。

生成写入excel

导入相关包
这里需要导入jxl包，它主要就是用于处理excel的，这个包我会附在项目放在github中，后面会给出链接。
生成excel工作表
以下代码是在指定路径下生成excel表，此时只是一个空表。

<code class="hljs lua has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;">WritableWorkbook wwb;        OutputStream <span class="hljs-built_in" style="color:#66066;box-sizing: border-box;">os</span> = new FileOutputStream(file);        wwb = Workbook.createWorkbook(<span class="hljs-built_in" style="color:#66066;box-sizing: border-box;">os</span>);</code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li></ul>

添加sheet表
熟悉excel操作的都知道excel可以新建很多个sheet表。以下代码生成第一个工作表，名字为“订单”：

<code class="hljs avrasm has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;">WritableSheet sheet = wwb<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.createSheet</span>(<span class="hljs-string" style="color:#0880;box-sizing: border-box;">"订单"</span>, <span class="hljs-number" style="color:#06666;box-sizing: border-box;">0</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span></code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li></ul>

添加excel表头
添加excel的表头，这里可以自定义表头的样式，先看代码：

<code class="hljs cs has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;">String[] title = { <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"订单"</span>, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"店名"</span>, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"电话"</span>, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"地址"</span> };Label label;        <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">for</span> (<span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">int</span> i = <span class="hljs-number" style="color:#06666;box-sizing: border-box;">0</span>; i < title.length; i++) {            <span class="hljs-comment" style="color:#8800;box-sizing: border-box;">// Label(x,y,z) 代表单元格的第x+1列，第y+1行, 内容z</span>                        <span class="hljs-comment" style="color:#8800;box-sizing: border-box;">// 在Label对象的子对象中指明单元格的位置和内容</span>            label = <span class="hljs-keyword" style="color:#0088;box-sizing: border-box;">new</span> Label(i, <span class="hljs-number" style="color:#06666;box-sizing: border-box;">0</span>, title[i], getHeader());            <span class="hljs-comment" style="color:#8800;box-sizing: border-box;">// 将定义好的单元格添加到工作表中</span>            sheet.addCell(label);        }</code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li></ul>

这里表头信息我写死了。表的一个单元格对应一个Label，如label(0,0,”a”)代表第一行第一列所在的单元格信息为a。getHeader()是自定义的样式，它返回一个 WritableCellFormat 。来看看如何自定义样式：

<code class="hljs avrasm has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;">    public static WritableCellFormat getHeader() {        WritableFont font = new WritableFont(WritableFont<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.TIMES</span>, <span class="hljs-number" style="color:#06666;box-sizing: border-box;">10</span>,                WritableFont<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.BOLD</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;// 定义字体</span>        try {            font<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.setColour</span>(Colour<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.BLUE</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;// 蓝色字体</span>        } catch (WriteException e1) {            e1<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.printStackTrace</span>()<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        }        WritableCellFormat format = new WritableCellFormat(font)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        try {            format<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.setAlignment</span>(jxl<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.format</span><span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.Alignment</span><span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.CENTRE</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;// 左右居中</span>            format<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.setVerticalAlignment</span>(jxl<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.format</span><span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.VerticalAlignment</span><span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.CENTRE</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;// 上下居中</span>             format<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.setBorder</span>(Border<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.ALL</span>, BorderLineStyle<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.THIN</span>,             Colour<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.BLACK</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;// 黑色边框</span>             format<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.setBackground</span>(Colour<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.YELLOW</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;// 黄色背景</span>        } catch (WriteException e) {            e<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.printStackTrace</span>()<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        }        return format<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>    }</code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li><li style="box-sizing: border-box; padding: 0px 5px;">11</li><li style="box-sizing: border-box; padding: 0px 5px;">12</li><li style="box-sizing: border-box; padding: 0px 5px;">13</li><li style="box-sizing: border-box; padding: 0px 5px;">14</li><li style="box-sizing: border-box; padding: 0px 5px;">15</li><li style="box-sizing: border-box; padding: 0px 5px;">16</li><li style="box-sizing: border-box; padding: 0px 5px;">17</li><li style="box-sizing: border-box; padding: 0px 5px;">18</li><li style="box-sizing: border-box; padding: 0px 5px;">19</li><li style="box-sizing: border-box; padding: 0px 5px;">20</li></ul>

看上面代码就很清楚了，通过获得WritableFont 来自定义字体的一些样式，如颜色大小等，通过WritableCellFormat 来设置文本框的样式，可以设置边框底色等。具体的可以查api文档，这里只给出例子。

添加excel内容。

<code class="hljs avrasm has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;">for (int i = <span class="hljs-number" style="color:#06666;box-sizing: border-box;">0</span><span class="hljs-comment" style="color:#8800;box-sizing: border-box;">; i < exportOrder.size(); i++) {</span>            Order order = exportOrder<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.get</span>(i)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>            Label orderNum = new Label(<span class="hljs-number" style="color:#06666;box-sizing: border-box;">0</span>, i + <span class="hljs-number" style="color:#06666;box-sizing: border-box;">1</span>, order<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.id</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>            Label restaurant = new Label(<span class="hljs-number" style="color:#06666;box-sizing: border-box;">1</span>, i + <span class="hljs-number" style="color:#06666;box-sizing: border-box;">1</span>, order<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.restName</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>            Label nameLabel = new Label(<span class="hljs-number" style="color:#06666;box-sizing: border-box;">2</span>,i+<span class="hljs-number" style="color:#06666;box-sizing: border-box;">1</span>,order<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.restPhone</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>            Label address = new Label(<span class="hljs-number" style="color:#06666;box-sizing: border-box;">3</span>, i + <span class="hljs-number" style="color:#06666;box-sizing: border-box;">1</span>, order<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.receiverAddr</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>            sheet<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.addCell</span>(orderNum)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>            sheet<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.addCell</span>(restaurant)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>            sheet<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.addCell</span>(nameLabel)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>            sheet<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.addCell</span>(address)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>            Toast<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.makeText</span>(context, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"写入成功"</span>, Toast<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.LENGTH</span>_LONG)<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.show</span>()<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        }</code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li><li style="box-sizing: border-box; padding: 0px 5px;">11</li><li style="box-sizing: border-box; padding: 0px 5px;">12</li><li style="box-sizing: border-box; padding: 0px 5px;">13</li><li style="box-sizing: border-box; padding: 0px 5px;">14</li><li style="box-sizing: border-box; padding: 0px 5px;">15</li></ul>

这就再简单不过了，就是获取order信息然后一个个写入。

主类

这个demo布局很简单就是一个按钮点击来生成excel，这里就不贴出来了，MainActivity的代码如下：

<code class="hljs avrasm has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;">protected void onCreate(Bundle savedInstanceState) {        super<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.onCreate</span>(savedInstanceState)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        setContentView(R<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.layout</span><span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.activity</span>_main)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        int length = Const<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.OrderInfo</span><span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.orderOne</span><span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.length</span><span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        for(int i = <span class="hljs-number" style="color:#06666;box-sizing: border-box;">0</span><span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;i < length;i++){</span>            Order order = new Order( Const<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.OrderInfo</span><span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.orderOne</span>[i][<span class="hljs-number" style="color:#06666;box-sizing: border-box;">0</span>],  Const<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.OrderInfo</span><span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.orderOne</span>[i][<span class="hljs-number" style="color:#06666;box-sizing: border-box;">1</span>],  Const<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.OrderInfo</span><span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.orderOne</span>[i][<span class="hljs-number" style="color:#06666;box-sizing: border-box;">2</span>],  Const<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.OrderInfo</span><span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.orderOne</span>[i][<span class="hljs-number" style="color:#06666;box-sizing: border-box;">3</span>])<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>            orders<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.add</span>(order)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        }        btn = (Button)super<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.findViewById</span>(R<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.id</span><span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.btn</span>)<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>        btn<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.setOnClickListener</span>(new OnClickListener() {            @Override            public void onClick(View v) {                // TODO Auto-generated method stub                try {                    ExcelUtil<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.writeExcel</span>(MainActivity<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.this</span>,                            orders, <span class="hljs-string" style="color:#0880;box-sizing: border-box;">"excel_"</span>+new Date()<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.toString</span>())<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>                } catch (Exception e) {                    // TODO Auto-generated catch block                    e<span class="hljs-preprocessor" style="color:#444444;box-sizing: border-box;">.printStackTrace</span>()<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>                }            }        })<span class="hljs-comment" style="color:#8800;box-sizing: border-box;">;</span>    }</code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li><li style="box-sizing: border-box; padding: 0px 5px;">11</li><li style="box-sizing: border-box; padding: 0px 5px;">12</li><li style="box-sizing: border-box; padding: 0px 5px;">13</li><li style="box-sizing: border-box; padding: 0px 5px;">14</li><li style="box-sizing: border-box; padding: 0px 5px;">15</li><li style="box-sizing: border-box; padding: 0px 5px;">16</li><li style="box-sizing: border-box; padding: 0px 5px;">17</li><li style="box-sizing: border-box; padding: 0px 5px;">18</li><li style="box-sizing: border-box; padding: 0px 5px;">19</li><li style="box-sizing: border-box; padding: 0px 5px;">20</li><li style="box-sizing: border-box; padding: 0px 5px;">21</li><li style="box-sizing: border-box; padding: 0px 5px;">22</li><li style="box-sizing: border-box; padding: 0px 5px;">23</li><li style="box-sizing: border-box; padding: 0px 5px;">24</li><li style="box-sizing: border-box; padding: 0px 5px;">25</li><li style="box-sizing: border-box; padding: 0px 5px;">26</li></ul>

这里我把上面生成excel的代码封装到一个工具类ExcelUtil中，以后使用就直接调用。MainActivity就是将数组组装到Order中调用ExcelUtil来写入。到此android实现excel功能就实现了。
源码地址

0 0