我们如何通过Excel文件创建xml文件！ [英] How we create xml file through Excel file!

问题描述

我们如何通过Excel文件创建xml文件！

How we create xml file through Excel file!

推荐答案

// Connect to Excel files
   System.Data.OleDb.OleDbConnection MyConnection ;
   System.Data.DataSet ds ;
   System.Data.OleDb.OleDbDataAdapter MyCommand ;
   MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='D:\\18.xls';Extended Properties=Excel 8.0;");
  MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1

"，MyConnection中选择*； MyCommand.TableMappings.Add(" ，" 产品")； ds = 新 System.Data.DataSet(); MyCommand.Fill(ds); MyConnection.Close(); // 写入xml ds.WriteXml(" )

", MyConnection); MyCommand.TableMappings.Add("Table", "Product"); ds = new System.Data.DataSet(); MyCommand.Fill(ds); MyConnection.Close(); // Write to xml ds.WriteXml("Product.xml")

使用 Excel Data Reader 关于Codeplex的开源项目怎么样?对我来说，从Excel工作表中导出数据确实非常有效.

FileStream流= File.Open(filePath，FileMode.Open，FileAccess.Read);

//1.从二进制Excel文件(''97 -2003格式; *.xls)中读取
IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
//2.从OpenXml Excel文件读取(2007格式； *.xlsx)
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
//3.数据集-每个电子表格的结果都将在结果中创建.表
DataSet resultDS = excelReader.AsDataSet();

字符串文件名="myXmlDoc.xml";
//创建要写入的FileStream.
System.IO.FileStream myFileStream =新的System.IO.FileStream
(文件名，System.IO.FileMode.Create)；
//使用fileStream创建一个XmlTextWriter.
System.Xml.XmlTextWriter myXmlWriter =
新的System.Xml.XmlTextWriter(myFileStream，System.Text.Encoding.Unicode);
//使用WriteXml方法写入文件.
resultDS.WriteXml(myXmlWriter);
myXmlWriter.Close();

What about using Excel Data Reader an open source project on codeplex? Its works really well for me to export data from excel sheets.

FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read);

//1. Reading from a binary Excel file (''97-2003 format; *.xls)
IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
//2. Reading from a OpenXml Excel file (2007 format; *.xlsx)
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
//3. DataSet - The result of each spreadsheet will be created in the result.Tables
DataSet resultDS = excelReader.AsDataSet();

string filename = "myXmlDoc.xml";
// Create the FileStream to write with.
System.IO.FileStream myFileStream = new System.IO.FileStream
(filename, System.IO.FileMode.Create);
// Create an XmlTextWriter with the fileStream.
System.Xml.XmlTextWriter myXmlWriter =
new System.Xml.XmlTextWriter(myFileStream, System.Text.Encoding.Unicode);
// Write to the file with the WriteXml method.
resultDS.WriteXml(myXmlWriter);
myXmlWriter.Close();

这篇关于我们如何通过Excel文件创建xml文件！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！