EXCEL 转换成 XML 工具类
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using System.Xml;
using System.IO;
namespace xML
{
class Program
{
static Dictionary<string,DataTable> DtList= new Dictionary<string,DataTable>();
static Dictionary<string, XmlNode> xmlNodelist = new Dictionary<string, XmlNode>();//数据类型节点
static string basePath = AppDomain.CurrentDomain.BaseDirectory;
static string excelPath = basePath + @"\Excel";
static string xmlPath = basePath + "Xml";
static void Main(string[] args)
{
DirectoryInfo folder = new DirectoryInfo(excelPath);
FileInfo[] file = folder.GetFiles("*.xlsx*",SearchOption.TopDirectoryOnly);
foreach (var f in file)
{
Start(f.FullName);
}
Console.ReadKey();
}
static void Start(string excelPath)
{
bool flag = ExcelToDS(excelPath);
if (flag)
{
foreach (KeyValuePair<string, DataTable> pair in DtList)
{
XmlDocument xmlDocument = new XmlDocument();
XmlNode declaration = xmlDocument.CreateXmlDeclaration("1.0", "utf-8", "");
xmlDocument.AppendChild(declaration);
XmlNode content = xmlDocument.CreateComment(pair.Key);
xmlDocument.AppendChild(content);
XmlNode Root = XmlOperationUtil.AppendElement(xmlDocument, "Root");
//标题 取得Excel表的第二行 作为属性值
List<string> titleList = new List<string>();
try
{
int rowLength = pair.Value.Rows.Count;
int columnLength = pair.Value.Columns.Count;
for (int i = 0; i < columnLength; i++)
{