运用CodeSmith代码生引擎生成XML报表文件

王朝other·作者佚名  2006-11-24
窄屏简体版  字體: |||超大  

前段时间做WEB项目时接到一个任务,报表都导出EXCEL。不能用第三方的报表工具,那只能操作EXCEL Library来解决了。

第一种:在服务端调用COM写EXCEL发关到客户端;这样不太可行因为系统的用户数量也很多,C#操作Excel(COM)效率不高,还很消耗服务器资源。

第二种:就是通过JSCRIPT来操作ActiveX,原理和第一种一样;只是操作数据操作放到客户端进行。

这两种方法操作和维护都很烦琐,而且效率也不高。

正在烦恼的时间突然想到了Excel到底能不能打开XML呢?试了一下发现是可以,然后在Excel画了一些表格另存为XML;打开后看了一下,笑了我可以通过动态生成XML不就可以啦。动态生成XML?就那些标记的组合就够烦,那会有直接操作COM来得方便直接?这里就要提一个工具了CodeSmith,它是一个基于模板的代码生成,模板的语法和ASP差不多,如果写过ASP一看就知道他的原理。这个工具在这里就不多介绍,有兴趣的朋友可以去了解一下。(当然还有其他代码生成工具,原理一样)

注意:Excel必须是XP或更高版本

HFSoft.Exports都是我自己封装的类

先来看下模NorthWind数据客户信息模板吧

==========================================

<%--

Name:

Author:

Description:

%>

<%@ CodeTemplate Language="C#" TargetLanguage="Text" Src="" Inherits="" Debug="False" Description="Template description here." %>

<%@ Assembly Name="System.Data" %>

<%@ Import Namespace="System.Data" %>

<%@ Assembly Name ="HFSoft.Exports" %>

<%@ Import Namespace="HFSoft.Exports"%>

<%@ Property Name="DataSource" Type="System.Data.DataSet" Optional="False" Category="Strings" Description="This is a sample string property." %>

<%

OnInit();

%>

<?xml version="1.0" encoding="GB2312"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

xmlns:o="urn:schemas-microsoft-com:office:office"

xmlns:x="urn:schemas-microsoft-com:office:excel"

xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"

xmlns:html="http://www.w3.org/TR/REC-html40">

<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">

<Author>HFSoft-Henry</Author>

<LastAuthor>HFSoft-Henry</LastAuthor>

<Created>2005-01-16T10:24:48Z</Created>

<Company>HFSoft</Company>

<Version>10.2625</Version>

</DocumentProperties>

<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">

<DownloadComponents/>

<LocationOfComponents HRef="file:///H:officeOfficeXPOfficeXP"/>

</OfficeDocumentSettings>

<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">

<WindowHeight>9450</WindowHeight>

<WindowWidth>12780</WindowWidth>

<WindowTopX>480</WindowTopX>

<WindowTopY>15</WindowTopY>

<ProtectStructure>False</ProtectStructure>

<ProtectWindows>False</ProtectWindows>

</ExcelWorkbook>

<Styles>

<Style ss:ID="Default" ss:Name="Normal">

<Alignment ss:Vertical="Center"/>

<Borders/>

<Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/>

<Interior/>

<NumberFormat/>

<Protection/>

</Style>

<Style ss:ID="m15730010">

<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>

<Borders>

<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>

<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>

<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>

</Borders>

<Font ss:FontName="宋体" x:CharSet="134" ss:Size="14" ss:Color="#FFFFFF"

ss:Bold="1"/>

<Interior ss:Color="#008080" ss:Pattern="Solid"/>

</Style>

<Style ss:ID="m15730020">

<Alignment ss:Horizontal="Left" ss:Vertical="Center"/>

<Borders>

<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>

<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>

</Borders>

</Style>

<Style ss:ID="m15730030">

<Alignment ss:Horizontal="Left" ss:Vertical="Center"/>

<Borders>

<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

</Borders>

</Style>

<Style ss:ID="m15741120">

<Alignment ss:Horizontal="Left" ss:Vertical="Center"/>

<Borders>

<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

</Borders>

</Style>

<Style ss:ID="m15741130">

<Alignment ss:Horizontal="Left" ss:Vertical="Center"/>

<Borders>

<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>

<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

</Borders>

</Style>

<Style ss:ID="m15741140">

<Alignment ss:Horizontal="Left" ss:Vertical="Center"/>

<Borders>

<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>

<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

</Borders>

</Style>

<Style ss:ID="s21">

<Font ss:FontName="宋体" x:CharSet="134" ss:Size="12" ss:Color="#FF0000"/>

</Style>

<Style ss:ID="s40">

<Borders>

<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

</Borders>

<Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>

</Style>

<Style ss:ID="s45">

<Borders>

<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>

<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weig

[1] [2] [3] 下一页

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航