---
title: "excel清单打印"
author: "microjava"
date: "2010-07-06T15:32:52Z"
tags: []
categories: ["行业应用"]
slug: "excel"
draft: false
lastmod: "2011-04-13T16:28:33Z"
id: 706654
url: "https://microjava.iteye.com/blog/706654"
---

1.excel直接打印（按照文件现有格式打印）
ps：设置excel首行相应列属性为自动换行

动作执行后事件

```java

$BkFileType = "txt";
$BkFileDel = "_#&";

if((!"".equals($BkFileName))&&($BkFileName!=null)){
 $HB_PrintDataLocalFileName=com.adtec.client.print.XlsModelFix.xlsExport_new("","907049_0_1.xls",0,"");
}

```


页面数据元素
HB_PrintDataLocalFileName printExlObj

js

```js

<script>
function print_selection_TS_F9_907049_01()
{
	var obj = confirm("是否打印清单?");
        if(obj == true) 
        { 

          printExcel(document.@FormName@.printExlObj);
        }			
        return;
}

</script>

```


2.票据打印


```java

if((!"".equals($BkFileName))&&($BkFileName!=null)){ $HB_PrintDataLocalFileName=com.adtec.client.print.XlsModelFix.ticketExport("800031.xls",0,7,10);
}

```


3.打印多页票据

```java

$BkFileType="TXT";

if((!"".equals($BkFileName))&&($BkFileName!=null))
{
  List list=com.adtec.client.print.XlsModelFix.ticketExport_with_pagecut("91603100_1_2.xls",0,52,1,"");
  com.adtec.client.util.DataPoolTool.setInfoToDataPool("HB_PrintDataLocalFileName",0,list.get(0));  
}

```