Asp.net 2.0 装载XML文件中数据到Excel文件中(示例代码下载)

最新推荐文章于 2025-12-11 23:29:47 发布

最新推荐文章于 2025-12-11 23:29:47 发布 · 123 阅读

·

0

·

文章标签：

#ASP.net #Excel #XML #.net #ASP

本文提供了一段C#代码示例，展示了如何从XML文件读取数据并将其转换为Excel文件的过程。代码中详细说明了创建Excel文件的每一个步骤，包括设置文件属性、生成表格结构及填充数据。

(一). 概要

从读取XML文件数据,生成Excel文件.

(二).运行效果图示例

1. 要转换数据的XML文件

2. 生成的Excel文件显示效果

(三). 代码

1

try
2

{
3

//要转换的XML文件
4

stringXMLFileName=Path.Combine(Request.PhysicalApplicationPath,"book.xml");
5

DataSetdsBook=newDataSet();
6

dsBook.ReadXml(XMLFileName);
7

introws=dsBook.Tables[0].Rows.Count+1;
8

intcols=dsBook.Tables[0].Columns.Count;
9

10

//将要生成的Excel文件
11

stringExcelFileName=Path.Combine(Request.PhysicalApplicationPath,"book.xls");
12

if(File.Exists(ExcelFileName))
13

{
14

File.Delete(ExcelFileName);
15

}
16

StreamWriterwriter=newStreamWriter(ExcelFileName,false);
17

writer.WriteLine("<?xmlversion=\"1.0\"?>");
18

writer.WriteLine("<?mso-applicationprogid=\"Excel.Sheet\"?>");
19

writer.WriteLine("<Workbookxmlns=\"urn:schemas-microsoft-com:office:spreadsheet\"");
20

writer.WriteLine("xmlns:o=\"urn:schemas-microsoft-com:office:office\"");
21

writer.WriteLine("xmlns:x=\"urn:schemas-microsoft-com:office:excel\"");
22

writer.WriteLine("xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\"");
23

writer.WriteLine("xmlns:html=\"http://www.w3.org/TR/REC-html40/\">");
24

writer.WriteLine("<DocumentPropertiesxmlns=\"urn:schemas-microsoft-com:office:office\">");
25

writer.WriteLine("<Author>AutomatedReportGeneratorExample</Author>");
26

writer.WriteLine(string.Format("<Created>{0}T{1}Z</Created>",DateTime.Now.ToString("yyyy-mm-dd"),DateTime.Now.ToString("HH:MM:SS")));
27

writer.WriteLine("<Company>YourCompanyHere</Company>");
28

writer.WriteLine("<Version>11.6408</Version>");
29

writer.WriteLine("</DocumentProperties>");
30

writer.WriteLine("<ExcelWorkbookxmlns=\"urn:schemas-microsoft-com:office:excel\">");
31

writer.WriteLine("<WindowHeight>8955</WindowHeight>");
32

writer.WriteLine("<WindowWidth>11355</WindowWidth>");
33

writer.WriteLine("<WindowTopX>480</WindowTopX>");
34

writer.WriteLine("<WindowTopY>15</WindowTopY>");
35

writer.WriteLine("<ProtectStructure>False</ProtectStructure>");
36

writer.WriteLine("<ProtectWindows>False</ProtectWindows>");
37

writer.WriteLine("</ExcelWorkbook>");
38

writer.WriteLine("<Styles>");
39

writer.WriteLine("<Styless:ID=\"Default\"ss:Name=\"Normal\">");
40

writer.WriteLine("<Alignmentss:Vertical=\"Bottom\"/>");
41

writer.WriteLine("<Borders/>");
42

writer.WriteLine("<Font/>");
43

writer.WriteLine("<Interior/>");
44

writer.WriteLine("<Protection/>");
45

writer.WriteLine("</Style>");
46

writer.WriteLine("<Styless:ID=\"s21\">");
47

writer.WriteLine("<Alignmentss:Vertical=\"Bottom\"ss:WrapText=\"1\"/>");
48

writer.WriteLine("</Style>");
49

writer.WriteLine("</Styles>");
50

writer.WriteLine("<Worksheetss:Name=\"MyReport\">");
51

writer.WriteLine(string.Format("<Tabless:ExpandedColumnCount=\"

{0}\"ss:ExpandedRowCount=\"

{1}\"x:FullColumns=\"1\"",cols.ToString(),rows.ToString()));
52

writer.WriteLine("x:FullRows=\"1\">");
53

54

//生成标题行
55

writer.WriteLine("<Row>");
56

foreach(DataColumneachCloumnindsBook.Tables[0].Columns)
57

{
58

writer.Write("<Cellss:StyleID=\"s21\"><Datass:Type=\"String\">");
59

writer.Write(eachCloumn.ColumnName.ToString());
60

writer.WriteLine("</Data></Cell>");
61

}
62

writer.WriteLine("</Row>");
63

64

//生成数据记录行
65

foreach(DataRoweachRowindsBook.Tables[0].Rows)
66

{
67

writer.WriteLine("<Row>");
68

for(intcurrentRow=0;currentRow!=cols;currentRow++)
69

{
70

writer.Write("<Cellss:StyleID=\"s21\"><Datass:Type=\"String\">");
71

writer.Write(eachRow[currentRow].ToString());
72

writer.WriteLine("</Data></Cell>");
73

}
74

writer.WriteLine("</Row>");
75

}
76

writer.WriteLine("</Table>");
77

writer.WriteLine("<WorksheetOptionsxmlns=\"urn:schemas-microsoft-com:office:excel\">");
78

writer.WriteLine("<Selected/>");
79

writer.WriteLine("<Panes>");
80

writer.WriteLine("<Pane>");
81

writer.WriteLine("<Number>3</Number>");
82

writer.WriteLine("<ActiveRow>1</ActiveRow>");
83

writer.WriteLine("</Pane>");
84

writer.WriteLine("</Panes>");
85

writer.WriteLine("<ProtectObjects>False</ProtectObjects>");
86

writer.WriteLine("<ProtectScenarios>False</ProtectScenarios>");
87

writer.WriteLine("</WorksheetOptions>");
88

writer.WriteLine("</Worksheet>");
89

writer.WriteLine("<Worksheetss:Name=\"Sheet2\">");
90

writer.WriteLine("<WorksheetOptionsxmlns=\"urn:schemas-microsoft-com:office:excel\">");
91

writer.WriteLine("<ProtectObjects>False</ProtectObjects>");
92

writer.WriteLine("<ProtectScenarios>False</ProtectScenarios>");
93

writer.WriteLine("</WorksheetOptions>");
94

writer.WriteLine("</Worksheet>");
95

writer.WriteLine("<Worksheetss:Name=\"Sheet3\">");
96

writer.WriteLine("<WorksheetOptionsxmlns=\"urn:schemas-microsoft-com:office:excel\">");
97

writer.WriteLine("<ProtectObjects>False</ProtectObjects>");
98

writer.WriteLine("<ProtectScenarios>False</ProtectScenarios>");
99

writer.WriteLine("</WorksheetOptions>");
100

writer.WriteLine("</Worksheet>");
101

writer.WriteLine("</Workbook>");
102

writer.Close();
103

Response.Write("<scriptlanguage=\"javascript\">"+"alert('"+"转换成功!转换后的Excel文件名为:"+ExcelFileName+"')"+"</script>");
104

}
105

catch (Exceptionex)
106

{
107

Response.Write("<scriptlanguage=\"javascript\">"+"alert('"+"操作失败!出错信息:"+ex.Message+"')"+"</script>");
108

}

(四). 示例代码下载

http://www.cnblogs.com/Files/ChengKing/XMLChangeToExcel.rar

评论

被折叠的条评论为什么被折叠?

到【灌水乐园】发言

查看更多评论

添加红包

成就一亿技术人!

hope_wisdom

发出的红包

实付元

使用余额支付

点击重新获取

扫码支付

钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。