c# ExcelToXml

最新推荐文章于 2024-03-09 00:08:29 发布

ZhaoLuoss

最新推荐文章于 2024-03-09 00:08:29 发布

阅读量1k

点赞数

分类专栏：工具

本文链接：https://blog.csdn.net/ZhaoLuoss/article/details/80197335

版权

工具专栏收录该内容

2 篇文章 0 订阅

订阅专栏

static XmlDocument ExcelToXml(string excelFilePath)
{

XmlDocument excelData = new XmlDocument();
DataSet excelTableDataSet = new DataSet();
StreamReader excelContent = new StreamReader(excelFilePath, System.Text.Encoding.Default);
FileInfo file = new FileInfo(excelFilePath);
string str = file.Extension;
string stringConnectToExcelFile = "";
switch (str)
{
case ".xls":
stringConnectToExcelFile = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + excelFilePath + ";" + "Extended Properties=Excel 8.0;";
break;
case ".xlsx":
stringConnectToExcelFile = "provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFilePath + ";Extended Properties=Excel 12.0;";
break;
default:
break;
}
System.Data.OleDb.OleDbConnection oleConnectionToExcelFile = new System.Data.OleDb.OleDbConnection(stringConnectToExcelFile);
System.Data.OleDb.OleDbDataAdapter oleDataAdapterForGetExcelTable = new System.Data.OleDb.OleDbDataAdapter(string.Format("select * from [Sheet1$]"), oleConnectionToExcelFile);
try
{
oleDataAdapterForGetExcelTable.Fill(excelTableDataSet);
}
catch
{
return null;
}
// string excelOutputXml = Path.GetTempFileName();
string excelOutputXml = "F:/test01.xml";
excelTableDataSet.WriteXml(excelOutputXml);
Console.WriteLine("转换成功");
//excelData.Load(excelOutputXml);
//File.Delete(excelOutputXml);
return excelData;
}