标准型->企业级->电信级多种解决方案,1000多个成功案例,“平台+业务+服务”一站式服务，是值得信任的专业厂商。" />
首页
新闻中心
最新消息
每一次小的进步，都是下一次跳跃的储备
媒体报道
了解行业动态，把握时代脉搏
信息发布
用产品赢得信赖，是我们发出的最强音
专家论坛
专家解惑，分享感悟和经验
在线咨询
呼叫中心
云客服
心理援助热线
行业方案
呼叫中心专栏
智能办公
SaaS云客服
AI智能
服务e
公司简介
当前位置:
首页
>
新闻中心
>
转载：使用“WPS表格”导出Excel文档
转载：使用“WPS表格”导出Excel文档
2011-12-16
bet体育365官网正规
供稿
浏览量：549
关键字：
bet体育365官网正规
呼叫中心
客户关系管理系统
CRM
CTI
PMSI
摘要：
使用“WPS表格”导出Excel文档，非常实用的例子，希望更多的人看到，可以帮助到大家。
<p> 非常实用的例子，希望更多的人看到：</p><p> 下面代码中的ET就是WPS的表格，你导入WPS表格的COM组建后，就可以看到这个命名空。</p><p> 程序使用.net 2.0/c#<span class="scayt-misspell">开发，代码（省略Design部分代码）：</span><br />using System;<br />using System.Collections.Generic;<br />using System.ComponentModel;<br />using System.Data;<br />using System.Drawing;<br />using System.Text;<br />using System.Windows.Forms;<br />using System.Xml;</p><p> <span class="scayt-misspell">namespace</span> <span class="scayt-misspell">ExportWPS</span><br />{<br /> public partial class <span class="scayt-misspell">Form1</span> : Form<br /> {<br /> ET.Application <span class="scayt-misspell">objApp</span> = null;<br /> ET._Workbook <span class="scayt-misspell">objWorkBook</span> = null;<br /> ET.Worksheet <span class="scayt-misspell">objWorkSheet</span> = null;</p><p> public <span class="scayt-misspell">Form1</span>()<br /> {<br /> <span class="scayt-misspell">InitializeComponent</span>();<br /> }</p><p> private void <span class="scayt-misspell">button1_Click</span>(object sender, <span class="scayt-misspell">EventArgs</span> e)<br /> {<br /> DateTime dt = DateTime.Now;</p><p> try<br /> {<br /> objApp = new ET.Application();</p><p> XmlDocument doc = new XmlDocument();<br /> doc.Load(@"c:\members.xml");</p><p> XmlElement root = doc.DocumentElement;<br /> XmlNodeList nodes = root.SelectNodes("member");</p><p> <br /> foreach (XmlElement memberElement in nodes)<br /> {<br /> ExportMember(memberElement);<br /> }<br /> }<br /> finally<br /> {<br /> ReleaseComObject(objApp);<br /> }</p><p> TimeSpan ts = DateTime.Now - dt;<br /> MessageBox.Show(ts.ToString());<br /> }</p><p> private void ExportMember(XmlElement memberElement)<br /> {<br /> object missing = Type.Missing;<br /> ET.Range objRange = null;</p><p> try<br /> {</p><p> objWorkBook = objApp.Workbooks.Add(Type.Missing);<br /> objWorkSheet = objWorkBook.ActiveSheet;<br /> <br /> //设置标题<br /> objWorkSheet.get_Range("A1", "G1").Merge(true); //先进行单元合并<br /> objRange = objWorkSheet.get_Range("A1", "A1");<br /> objRange.Value2 = "表 格 示 例"; //设置合并后的单元格的文本<br /> objRange.RowHeight = 40; //设置行高<br /> //设置字体<br /> objRange.Font.Name = "宋体";<br /> objRange.Font.Size = 20;<br /> objRange.Font.Bold = true;<br /> objRange.HorizontalAlignment = ET.ETHAlign.etHAlignCenter; //设置字体对其方向</p><p> objRange = objWorkSheet.get_Range("A2", "G7");<br /> objRange.Borders.LineStyle = ET.ETLineStyle.etContinuous;<br /> objRange.Borders.Weight = ET.ETBorderWeight.etThin;<br /> objRange.RowHeight = 17;<br /> objRange.Borders.Color = 0; //设置边框的颜色，颜色的值可以按照B,G,R的方式合成<br /> //设置表格的外边框，加粗<br /> objRange.Borders[ET.ETBorderIndex.etEdgeBottom].Weight = ET.ETBorderWeight.etMedium;<br /> objRange.Borders[ET.ETBorderIndex.etEdgeLeft].Weight = ET.ETBorderWeight.etMedium;<br /> objRange.Borders[ET.ETBorderIndex.etEdgeRight].Weight = ET.ETBorderWeight.etMedium;<br /> objRange.Borders[ET.ETBorderIndex.etEdgeTop].Weight = ET.ETBorderWeight.etMedium;<br /> objRange.HorizontalAlignment = ET.ETHAlign.etHAlignCenter;<br /> objRange.Font.Name = "宋体";<br /> objRange.Font.Size = 10;</p><p> string name = memberElement.SelectSingleNode("name").ChildNodes[0].Value;</p><p> objWorkSheet.get_Range("A2", "A2").Value2 = "姓 名";<br /> objWorkSheet.get_Range("A2", "A2").ColumnWidth = 60;</p><p> objWorkSheet.get_Range("B2", "B2").ColumnWidth = 75;<br /> objWorkSheet.get_Range("B2", "B2").Value2 = name;</p><p> objWorkSheet.get_Range("C2", "C2").Value2 = "性 别";<br /> objWorkSheet.get_Range("C2", "C2").ColumnWidth = 60;</p><p> objWorkSheet.get_Range("D2", "D2").ColumnWidth = 75;<br /> objWorkSheet.get_Range("D2", "D2").Value2 = memberElement.SelectSingleNode("sex").ChildNodes[0].Value;</p><p> objWorkSheet.get_Range("E2", "E2").Value2 = "出生年月";<br /> objWorkSheet.get_Range("E2", "E2").ColumnWidth = 60;</p><p> objWorkSheet.get_Range("F2", "F2").ColumnWidth = 75;<br /> objWorkSheet.get_Range("F2", "F2").Value2 = memberElement.SelectSingleNode("birthday").ChildNodes[0].Value;</p><p> objWorkSheet.get_Range("G2", "G7").Merge(false);<br /> objWorkSheet.get_Range("G2", "G2").ColumnWidth = 80;<br /> objWorkSheet.get_Range("G2", "G2").Value2 = "照片";</p><p> objWorkSheet.get_Range("A3", "A3").Value2 = "民 族";<br /> objWorkSheet.get_Range("B3", "B3").Value2 = memberElement.SelectSingleNode("nationality").ChildNodes[0].Value;</p><p> objWorkSheet.get_Range("C3", "C3").Value2 = "政治面貌";<br /> objWorkSheet.get_Range("D3", "D3").Value2 = memberElement.SelectSingleNode("political_status").ChildNodes[0].Value;</p><p> objWorkSheet.get_Range("E3", "E3").Value2 = "籍 贯";<br /> objWorkSheet.get_Range("F3", "F3").Value2 = memberElement.SelectSingleNode("native_place").ChildNodes[0].Value;</p><p> objWorkSheet.get_Range("A4", "A4").Value2 = "学 历";<br /> objWorkSheet.get_Range("B4", "B4").Value2 = memberElement.SelectSingleNode("qualification").ChildNodes[0].Value;</p><p> objWorkSheet.get_Range("C4", "C4").Value2 = "固定电话";<br /> objWorkSheet.get_Range("D4", "D4").Value2 = memberElement.SelectSingleNode("telephone").ChildNodes[0].Value;</p><p> objWorkSheet.get_Range("E4", "E4").Value2 = "移动电话";<br /> objWorkSheet.get_Range("F4", "F4").Value2 = memberElement.SelectSingleNode("mobile").ChildNodes[0].Value;</p><p> objWorkSheet.get_Range("A5", "A5").Value2 = "毕业院校";<br /> objWorkSheet.get_Range("B5", "F5").Merge(false);<br /> objWorkSheet.get_Range("B5", "B5").Value2 = memberElement.SelectSingleNode("graduating_school").ChildNodes[0].Value;</p><p> objWorkSheet.get_Range("A6", "A6").Value2 = "家庭住址";<br /> objWorkSheet.get_Range("B6", "F6").Merge(false);<br /> objWorkSheet.get_Range("B6", "B6").Value2 = memberElement.SelectSingleNode("address").ChildNodes[0].Value;</p><p> objWorkSheet.get_Range("A7", "A7").Value2 = "Email";<br /> objWorkSheet.get_Range("B7", "F7").Merge(false);<br /> objWorkSheet.get_Range("B7", "B7").Value2 = memberElement.SelectSingleNode("email").ChildNodes[0].Value;</p><p> objWorkBook.SaveAs(string.Format("c:\\{0}.xls", name), missing, missing, missing, missing, missing, ET.ETSaveAsAccessMode.etExclusive, missing, missing, missing, missing);<br /> objWorkBook.Close(missing, missing, missing);<br /> }<br /> finally<br /> {<br /> ReleaseComObject(objRange);<br /> ReleaseComObject(objWorkSheet);<br /> ReleaseComObject(objWorkBook);<br /> }<br /> }</p><p> private void ReleaseComObject(object obj)<br /> {<br /> if (obj != null)<br /> {<br /> System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);<br /> obj = null;<br /> }<br /> }<br /> }<br />}</p><p> <br />表示成员信息的xml文档（保存在c:\members.xml供下面的代码调用）内容如下：<br /><?xml version="1.0" encoding="utf-8"?><br /><members><br /> <member><br /> <name>张三</name><br /> <sex>男</sex><br /> <birthday>1980年12月4日</birthday><br /> <nationality>汉</nationality><br /> <political_status>党员</political_status><br /> <native_place>江苏南京</native_place><br /> <qualification>本科</qualification><br /> <telephone>025-8000000</telephone><br /> <mobile>138138*****</mobile><br /> <graduating_school>南京大学</graduating_school><br /> <address>南京市中山东路*******</address><br /> <email>zhang.san@sample.com</email><br /> </member><br /> <member><br /> <name>李四</name><br /> <sex>男</sex><br /> <birthday>1981年9月12日</birthday><br /> <nationality>汉</nationality><br /> <political_status>团员</political_status><br /> <native_place>江苏苏州</native_place><br /> <qualification>本科</qualification><br /> <telephone>025-8000000</telephone><br /> <mobile>138138*****</mobile><br /> <graduating_school>东南大学</graduating_school><br /> <address>南京市某某路*******</address><br /> <email>li.si@sample.com</email><br /> </member><br /> <member><br /> <name>小美</name><br /> <sex>女</sex><br /> <birthday>1982年1月18日</birthday><br /> <nationality>汉</nationality><br /> <political_status>团员</political_status><br /> <native_place>安徽黄山</native_place><br /> <qualification>本科</qualification><br /> <telephone>025-8000000</telephone><br /> <mobile>138138*****</mobile><br /> <graduating_school>南京理工大学</graduating_school><br /> <address>南京市某某路*******</address><br /> <email>xiao.mei@sample.com</email><br /> </member><br /> <member><br /> <name>王二</name><br /> <sex>男</sex><br /> <birthday>1981年4月14日</birthday><br /> <nationality>汉</nationality><br /> <political_status>团员</political_status><br /> <native_place>山东烟台</native_place><br /> <qualification>研究生</qualification><br /> <telephone>025-8000000</telephone><br /> <mobile>138138*****</mobile><br /> <graduating_school>南京航空航天大学</graduating_school><br /> <address>南京市某某路*******</address><br /> <email>wan.er@sample.com</email><br /> </member><br /> <member><br /> <name>小莉</name><br /> <sex>女</sex><br /> <birthday>1982年3月18日</birthday><br /> <nationality>汉</nationality><br /> <political_status>党员</political_status><br /> <native_place>江苏常熟</native_place><br /> <qualification>研究生</qualification><br /> <telephone>025-8000000</telephone><br /> <mobile>138138*****</mobile><br /> <graduating_school>南京大学</graduating_school><br /> <address>南京市某某路*******</address><br /> <email>xiao.li@sample.com</email><br /> </member><br /> <member><br /> <name>Jack</name><br /> <sex>男</sex><br /> <birthday>1980年12月4日</birthday><br /> <nationality>汉</nationality><br /> <political_status>党员</political_status><br /> <native_place>江苏南京</native_place><br /> <qualification>本科</qualification><br /> <telephone>025-8000000</telephone><br /> <mobile>138138*****</mobile><br /> <graduating_school>南京大学</graduating_school><br /> <address>南京市中山东路*******</address><br /> <email>jack@sample.com</email><br /> </member><br /> <member><br /> <name>Joe</name><br /> <sex>男</sex><br /> <birthday>1981年9月12日</birthday><br /> <nationality>汉</nationality><br /> <political_status>团员</political_status><br /> <native_place>江苏苏州</native_place><br /> <qualification>本科</qualification><br /> <telephone>025-8000000</telephone><br /> <mobile>138138*****</mobile><br /> <graduating_school>东南大学</graduating_school><br /> <address>南京市某某路*******</address><br /> <email>jeo@sample.com</email><br /> </member><br /> <member><br /> <name>Katty</name><br /> <sex>女</sex><br /> <birthday>1982年1月18日</birthday><br /> <nationality>汉</nationality><br /> <political_status>团员</political_status><br /> <native_place>安徽黄山</native_place><br /> <qualification>本科</qualification><br /> <telephone>025-8000000</telephone><br /> <mobile>138138*****</mobile><br /> <graduating_school>南京理工大学</graduating_school><br /> <address>南京市某某路*******</address><br /> <email>Katty@sample.com</email><br /> </member><br /> <member><br /> <name>Scott</name><br /> <sex>男</sex><br /> <birthday>1981年4月14日</birthday><br /> <nationality>汉</nationality><br /> <political_status>团员</political_status><br /> <native_place>山东烟台</native_place><br /> <qualification>研究生</qualification><br /> <telephone>025-8000000</telephone><br /> <mobile>138138*****</mobile><br /> <graduating_school>南京航空航天大学</graduating_school><br /> <address>南京市某某路*******</address><br /> <email>scott@sample.com</email><br /> </member><br /> <member><br /> <name>Lily</name><br /> <sex>女</sex><br /> <birthday>1982年3月18日</birthday><br /> <nationality>汉</nationality><br /> <political_status>党员</political_status><br /> <native_place>江苏常熟</native_place><br /> <qualification>研究生</qualification><br /> <telephone>025-8000000</telephone><br /> <mobile>138138*****</mobile><br /> <graduating_school>南京大学</graduating_school><br /> <address>南京市某某路*******</address><br /> <email>Lily@sample.com</email><br /> </member><br /></members></p>
相关新闻
呼叫中心战略制定
呼叫中心主动式服务
bet体育365官网正规助力尚德（面授）双机热备上线
吴忠政务服务中心使用bet体育365官网正规的呼叫中心系统
ARP呼叫中心在服务中的作用
扫描二维码分享