{"id":214,"date":"2011-12-29T13:27:06","date_gmt":"2011-12-29T13:27:06","guid":{"rendered":"ca46c1b9512a7a8315fa3c5a946e8265"},"modified":"2011-12-29T13:27:06","modified_gmt":"2011-12-29T13:27:06","slug":"","status":"publish","type":"post","link":"https:\/\/www.xiaobo.li\/notes\/archives\/214","title":{"rendered":"\u5c06DataTable\u5bfc\u51fa\u4e3aExcel (XML Spreadsheet)"},"content":{"rendered":"

\u7ed3\u679c\u5bfc\u51fa\u6210Excel\u6587\u4ef6. \u7528\u51e0\u4e2a\u4e0d\u540c\u7684\u529e\u6cd5\u505a\u4e86\u51fa\u6765. \u6700\u540e\u90e8\u7f72\u65f6\u53d1\u73b0: \u7528COM+\u7ec4\u4ef6\u884c\u4e0d\u901a, \u670d\u52a1\u5668\u4e0a\u6ca1\u88c5OFFICE; \u7528OWC\u4e5f\u4e0d\u884c, \u56e0\u4e3a\u670d\u52a1\u5668\u662f64\u4f4d\u7684, OWC\u4e0d\u652f\u6301; \u5bfc\u51fa\u6210Excel2003\u652f\u6301\u7684xml, \u8fd9\u62db\u6700\u7075\u6d3b, \u4e5f\u662f\u4e00\u4e2a\u7b80\u5355\u53ef\u884c\u7684\u529e\u6cd5.<\/p>\n

\u9996\u5148\u7528Excel 2003\u65b0\u5efa\u4e00\u4e2a\u7a7a\u767dWookbook, \u7136\u540e\u4fdd\u5b58\u4e3aXML Spreadsheet. \u7136\u540e\u6253\u5f00\u770b\u5b83\u751f\u6210\u7684XML\u4ee3\u7801\u5c31\u80fd\u4e86\u89e3XML Spreadsheet\u7684\u57fa\u672c\u7ed3\u6784\u4e86.
\n\u6211\u5148\u628aDataTable\u751f\u6210XML\u6570\u636e, \u518d\u4f7f\u7528\u4e00\u4e2aXLS\u628aXML\u6570\u636e\u8f6c\u6362\u6210XML Spreadsheet\u7684\u7ed3\u6784.<\/p>\n

 <\/p>\n

using<\/span> System;using<\/span> System.Collections.Generic;<\/pre>\n
using<\/span> System.Data;<\/pre>\n
using<\/span> System.IO;<\/pre>\n
using<\/span> System.Reflection;<\/pre>\n
using<\/span> System.Text;<\/pre>\n
using<\/span> System.Xml;<\/pre>\n
using<\/span> System.Xml.Xsl;<\/pre>\n
namespace<\/span> AProject\r\n{\r\n    public<\/span> class<\/span> ExcelHelper\r\n    {\r\n        public<\/span> static<\/span> string<\/span> ExportAsTempFile(DataTable dataTable, bool<\/span> appendColumnNames)\r\n        {\r\n            if<\/span>(dataTable == null<\/span>)\r\n            {\r\n                return<\/span> null<\/span>;\r\n            }\r\n\r\n            return<\/span> ExportAsTempFile(new<\/span> DataTable[] { dataTable }, appendColumnNames);\r\n        }\r\n\r\n        public<\/span> static<\/span> string<\/span> ExportAsTempFile(DataSet dataSet, bool<\/span> appendColumnNames)\r\n        {\r\n            string<\/span> fileName = Path.GetTempFileName();\r\n\r\n            if<\/span>(ExportFile(dataSet, fileName, appendColumnNames))\r\n            {\r\n                return<\/span> fileName;\r\n            }\r\n\r\n            return<\/span> null<\/span>;\r\n        }\r\n\r\n        public<\/span> static<\/span> string<\/span> ExportAsTempFile(DataTable[] dataTables, bool<\/span> appendColumnNames)\r\n        {\r\n            string<\/span> fileName = Path.GetTempFileName();\r\n\r\n            if<\/span>(ExportFile(dataTables, fileName, appendColumnNames))\r\n            {\r\n                return<\/span> fileName;\r\n            }\r\n\r\n            return<\/span> null<\/span>;\r\n        }\r\n\r\n        public<\/span> static<\/span> bool<\/span> ExportFile(DataTable dataTable, string<\/span> fileName, bool<\/span> appendColumnNames)\r\n        {\r\n            if<\/span>(dataTable == null<\/span>)\r\n            {\r\n                return<\/span> false<\/span>;\r\n            }\r\n\r\n            return<\/span> ExportFile(new<\/span> DataTable[] { dataTable }, fileName, appendColumnNames);\r\n        }\r\n\r\n        public<\/span> static<\/span> bool<\/span> ExportFile(DataSet dataSet, string<\/span> fileName, bool<\/span> appendColumnNames)\r\n        {\r\n            if<\/span>(dataSet == null<\/span>)\r\n            {\r\n                return<\/span> false<\/span>;\r\n            }\r\n\r\n            DataTable[] dataTables = new<\/span> DataTable[dataSet.Tables.Count];\r\n            dataSet.Tables.CopyTo(dataTables, 0);\r\n            return<\/span> ExportFile(dataTables, fileName, appendColumnNames);\r\n        }\r\n\r\n        public<\/span> static<\/span> bool<\/span> ExportFile(DataTable[] dataTables, string<\/span> fileName, bool<\/span> appendColumnNames)\r\n        {\r\n            if<\/span>(dataTables == null<\/span> || dataTables.Length == 0 || string<\/span>.IsNullOrEmpty(fileName))\r\n            {\r\n                return<\/span> false<\/span>;\r\n            }\r\n\r\n            XmlDocument xmlDoc = GetXmlDataTables(dataTables, appendColumnNames);\r\n            XmlDocument xlsDoc = TransformXml(xmlDoc);\r\n\r\n            try<\/span>             {\r\n                xlsDoc.Save(fileName);\r\n                return<\/span> true<\/span>;\r\n            }\r\n            catch<\/span>             {\r\n                return<\/span> false<\/span>;\r\n            }\r\n        }\r\n\r\n        private<\/span> static<\/span> XmlDocument GetXmlDataTables(DataTable[] dataTables, bool<\/span> appendColumnNames)\r\n        {\r\n            if<\/span>(dataTables == null<\/span>)\r\n            {\r\n                return<\/span> null<\/span>;\r\n            }\r\n\r\n            XmlDocument xmlDoc = new<\/span> XmlDocument();\r\n            XmlElement rootNode = xmlDoc.CreateElement(\"DTS\"<\/span>);\r\n            XmlElement tableNode;\r\n            XmlElement rowNode;\r\n            XmlElement colNode;\r\n            DataTable dt;\r\n\r\n            for<\/span>(int<\/span> i = 0; i < dataTables.Length; i++)\r\n            {\r\n                dt = dataTables[i];\r\n\r\n                if<\/span>(dt == null<\/span>)\r\n                {\r\n                    break<\/span>;\r\n                }\r\n\r\n                if<\/span>(dt.TableName.Trim() == string<\/span>.Empty)\r\n                {\r\n                    dt.TableName = \"DataTable\"<\/span> + i.ToString();\r\n                }\r\n\r\n                tableNode = xmlDoc.CreateElement(\"DT\"<\/span>);\r\n                tableNode.SetAttribute(\"N\"<\/span>, dt.TableName);\r\n\r\n                if<\/span>(appendColumnNames)\r\n                {\r\n                    rowNode = xmlDoc.CreateElement(\"DR\"<\/span>);\r\n\r\n                    foreach<\/span>(DataColumn dc in<\/span> dt.Columns)\r\n                    {\r\n                        colNode = xmlDoc.CreateElement(\"DC\"<\/span>);\r\n                        colNode.SetAttribute(\"N\"<\/span>, dc.ColumnName);\r\n                        colNode.SetAttribute(\"T\"<\/span>, \"String\"<\/span>);\r\n                        colNode.AppendChild(xmlDoc.CreateTextNode(dc.ColumnName));\r\n                        rowNode.AppendChild(colNode);\r\n                    }\r\n\r\n                    tableNode.AppendChild(rowNode);\r\n                }\r\n\r\n\r\n                foreach<\/span>(DataRow dr in<\/span> dt.Rows)\r\n                {\r\n                    rowNode = xmlDoc.CreateElement(\"DR\"<\/span>);\r\n\r\n                    foreach<\/span>(DataColumn dc in<\/span> dt.Columns)\r\n                    {\r\n                        colNode = xmlDoc.CreateElement(\"DC\"<\/span>);\r\n                        colNode.SetAttribute(\"N\"<\/span>, dc.ColumnName);\r\n                        colNode.SetAttribute(\"T\"<\/span>, GetDataType(dc.DataType));\r\ncolNode.AppendChild(xmlDoc.CreateTextNode(GetTextValue(dc.DataType, dr[dc.ColumnName])));\r\n                        rowNode.AppendChild(colNode);\r\n                    }\r\n\r\n                    tableNode.AppendChild(rowNode);\r\n                }\r\n\r\n                rootNode.AppendChild(tableNode);\r\n            }\r\n\r\n            xmlDoc.AppendChild(rootNode);\r\n            return<\/span> xmlDoc;\r\n        }\r\n\r\n        private<\/span> static<\/span> string<\/span> GetTextValue(Type type, object<\/span> value<\/span>)\r\n        {\r\n            string<\/span> text;\r\n\r\n            if<\/span>(type == typeof<\/span>(DateTime))\r\n            {\r\n                text = ((DateTime)value<\/span>).ToString(\"yyyy-MM-ddTHH:mm:ssZ\"<\/span>);\r\n            }\r\n            else<\/span>             {\r\n                text = value<\/span>.ToString();\r\n            }\r\n\r\n            return<\/span> text;\r\n        }\r\n\r\n        private<\/span> static<\/span> string<\/span> GetDataType(Type type)\r\n        {\r\n            string<\/span> dataType;\r\n\r\n            if<\/span>(type == typeof<\/span>(string<\/span>))\r\n            {\r\n                dataType = \"String\"<\/span>;\r\n            }\r\n            else<\/span> if<\/span>(type == typeof<\/span>(DateTime))\r\n            {\r\n                dataType = \"DateTime\"<\/span>;\r\n            }\r\n            else<\/span> if<\/span>(type == typeof<\/span>(bool<\/span>))\r\n            {\r\n                dataType = \"Boolean\"<\/span>;\r\n            }\r\n            else<\/span>             {\r\n                dataType = \"Number\"<\/span>;\r\n            }\r\n\r\n            return<\/span> dataType;\r\n        }\r\n\r\n        private<\/span> static<\/span> XmlDocument TransformXml(XmlDocument xmlDoc)\r\n        {\r\n            XmlDocument xlsDoc = new<\/span> XmlDocument();\r\n            XslCompiledTransform xslt = new<\/span> XslCompiledTransform();\r\n            Assembly assembly = Assembly.GetExecutingAssembly();\r\n\r\n            using<\/span>(Stream s = assembly.GetManifestResourceStream(\"AProject.Resources.XmlSpreadsheet.xsl\"<\/span>))\r\n            {\r\n                if<\/span>(s != null<\/span>)\r\n                {\r\n                    xslt.Load(XmlReader.Create(s));\r\n                    MemoryStream output = new<\/span> MemoryStream();\r\n                    XmlTextWriter xmlWriter = new<\/span> XmlTextWriter(output, Encoding.UTF8);\r\n                    xslt.Transform(xmlDoc, xmlWriter);\r\n                    output.Position = 0;\r\n                    xlsDoc.Load(output);\r\n                    xlsDoc.PrependChild(xlsDoc.CreateXmlDeclaration(\"1.0\"<\/span>, null<\/span>, null<\/span>));\r\n                    output = null<\/span>;\r\n                }\r\n            }\r\n\r\n            return<\/span> xlsDoc;\r\n        }\r\n    }\r\n}<\/pre>\n
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/p>\n
<?xml version=\"1.0\" ?>
\n<xsl:stylesheet version=\"1.0\" xmlns:xsl=\"http:\/\/www.w3.org\/1999\/XSL\/Transform<\/a>\" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\">
\n    <xsl:output method='xml' version='1.0'\/>
\n    <xsl:template match=\"DTS\">
\n        <ss:Workbook >
\n            <ss:Styles>
\n                <ss:Style ss:ID=\"Default\">
\n                    <ss:NumberFormat ss:Format=\"General\"\/>
\n                <\/ss:Style>
\n                <ss:Style ss:ID=\"DateTime\">
\n                    <ss:NumberFormat ss:Format=\"General Date\"\/>
\n                <\/ss:Style>
\n            <\/ss:Styles>
\n            <xsl:apply-templates select=\"DT\" \/>
\n        <\/ss:Workbook>
\n    <\/xsl:template><\/p>\n
    <xsl:template match=\"DT\">
\n        <ss:Worksheet>
\n            <xsl:attribute  name=\"ss:Name\">
\n                <xsl:value-of select=\"@N\"\/>
\n            <\/xsl:attribute>
\n            <ss:Table>
\n                <xsl:apply-templates select=\"DR\" \/>
\n            <\/ss:Table>
\n        <\/ss:Worksheet>
\n    <\/xsl:template><\/p>\n
    <xsl:template match=\"DR\">
\n        <ss:Row>
\n            <xsl:apply-templates select=\"DC\" \/>
\n        <\/ss:Row>
\n    <\/xsl:template><\/p>\n
    <xsl:template match=\"DC\">
\n        <ss:Cell>
\n            <xsl:choose>
\n                <xsl:when test=\"@T = 'DateTime'\">
\n                    <xsl:attribute name=\"ss:StyleID\">
\n                        <xsl:text>DateTime<\/xsl:text>
\n                    <\/xsl:attribute>
\n                <\/xsl:when>
\n            <\/xsl:choose>
\n            <ss:Data>
\n                <xsl:attribute name=\"ss:Type\">
\n                    <xsl:value-of select=\"@T\"\/>
\n                <\/xsl:attribute>
\n                <xsl:choose>
\n                    <xsl:when test=\"@T = 'String'\">
\n                        <xsl:text disable-output-escaping=\"yes\">&lt;![CDATA[<\/xsl:text>
\n                        <xsl:value-of  select=\".\"\/>
\n                        <xsl:text disable-output-escaping=\"yes\">]]&gt;<\/xsl:text>
\n                    <\/xsl:when>
\n                    <xsl:otherwise>
\n                        <xsl:value-of select=\".\"\/>
\n                    <\/xsl:otherwise>
\n                <\/xsl:choose>
\n            <\/ss:Data>
\n        <\/ss:Cell>
\n    <\/xsl:template>
\n----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/p>\n
\n
public class DataSetToExcel
\n    {
\n        \/\/\/ <summary> 
\n        \/\/\/ \u751f\u6210EXCEL 
\n        \/\/\/ <\/summary> 
\n        public DataSetToExcel()
\n        { }<\/p>\n
        \/\/\/ <summary>\u521b\u5efa\uff25\uff58\uff43\uff45\uff4c\u7684\uff58\uff4d\uff4c\u6587\u4ef6
\n        \/\/\/ 
\n        \/\/\/ <\/summary>
\n        \/\/\/ <param name=\"DS\">\u6570\u636e<\/param>
\n        \/\/\/ <param name=\"fileName\">\u6587\u4ef6\u540d<\/param>
\n        public DataSetToExcel(DataSet DS, string fileName)
\n        {
\n            CreateXmlExcelFile(DS, fileName);
\n        }
\n        \/\/\/ <summary> \u521b\u5efa\uff25\uff58\uff43\uff45\uff4c\u7684\uff58\uff4d\uff4c\u6587\u4ef6
\n        \/\/\/ 
\n        \/\/\/ <\/summary>
\n        \/\/\/ <param name=\"DS\">\u6570\u636e<\/param>
\n        \/\/\/ <param name=\"fileName\">\u6587\u4ef6\u540d<\/param>
\n        public void CreateXmlExcelFile(DataSet DS, string fileName)
\n        {
\n            string foldName = fileName;<\/p>\n
            #region \u540c\u540d\u6587\u4ef6\u5220\u9664
\n            FileInfo FI = new FileInfo(foldName);
\n            if (FI.Exists)
\n            {
\n                FI.Delete();
\n            }
\n            #endregion<\/p>\n
            #region \u521b\u5efaXML\u5bf9\u8c61\uff0c\u4e8c\u7ef4\u6570\u7ec4\u5199\u5165\u5e76\u4fdd\u5b58
\n            \/\/\u521b\u5efa\u4e00\u4e2aXML\u6587\u6863 
\n             
\n            XmlDocument xmldoc = new XmlDocument();
\n            XmlNode xmldc = xmldoc.CreateNode(XmlNodeType.XmlDeclaration, \"\", \"\");<\/p>\n
            xmldoc.AppendChild(xmldc);<\/p>\n
            XmlProcessingInstruction xmlpi = xmldoc.CreateProcessingInstruction(\"mso-application\", \"progid=\/\"Excel.Sheet\/\"\");
\n            xmldoc.AppendChild(xmlpi);<\/p>\n
\n            \/\/\u521b\u5efa\u4e00\u4e2a\u5de5\u4f5c\u7c3f 
\n            XmlElement xmlwb = xmldoc.CreateElement(\"Workbook\");
\n            xmlwb.SetAttribute(\"xmlns\", \"urn:schemas-microsoft-com:office:spreadsheet\");
\n            xmlwb.SetAttribute(\"xmlns:o\", \"urn:schemas-microsoft-com:office:office\");
\n            xmlwb.SetAttribute(\"xmlns:x\", \"urn:schemas-microsoft-com:office:excel\");
\n            xmlwb.SetAttribute(\"xmlns:ss\", \"urn:schemas-microsoft-com:office:spreadsheet\");
\n            xmlwb.SetAttribute(\"xmlns:html\", \"http:\/\/www.w3.org\/TR\/REC-html40<\/span><\/a>\");<\/p>\n
            xmldoc.AppendChild(xmlwb);<\/p>\n
            XmlElement xmlsts = xmldoc.CreateElement(\"Styles\");
\n            xmlwb.AppendChild(xmlsts);<\/p>\n
            XmlElement xmlst = xmldoc.CreateElement(\"Style\");
\n            XmlAttribute xmlarr = xmldoc.CreateAttribute(\"ss:ID\", \"urn:schemas-microsoft-com:office:spreadsheet\");
\n            xmlarr.Value = \"s21\";
\n            xmlst.Attributes.Append(xmlarr);
\n            xmlsts.AppendChild(xmlst);<\/p>\n
            XmlElement xmlnf = xmldoc.CreateElement(\"NumberFormat\");
\n            xmlarr = xmldoc.CreateAttribute(\"ss:Format\", \"urn:schemas-microsoft-com:office:spreadsheet\");
\n            xmlarr.Value = \"Short Date\";
\n            xmlnf.Attributes.Append(xmlarr);
\n            xmlst.AppendChild(xmlnf);<\/p>\n
            foreach (DataTable DT in DS.Tables)
\n            {
\n                XmlElement xmlws = xmldoc.CreateElement(\"Worksheet\");
\n                xmlarr = xmldoc.CreateAttribute(\"ss:Name\", \"urn:schemas-microsoft-com:office:spreadsheet\");
\n                xmlarr.Value = DT.TableName.Replace(\"\/\", \"\"); 
\n                xmlws.Attributes.Append(xmlarr);
\n                xmlwb.AppendChild(xmlws);<\/p>\n
                XmlElement xmltb = xmldoc.CreateElement(\"Table\");
\n                xmlws.AppendChild(xmltb);<\/p>\n
                XmlElement xmlrw = xmldoc.CreateElement(\"Row\");
\n                xmltb.AppendChild(xmlrw);
\n                foreach (DataColumn DC in DT.Columns)
\n                {
\n                    XmlElement xmlcl = xmldoc.CreateElement(\"Cell\");
\n                    xmlrw.AppendChild(xmlcl);<\/p>\n
                    XmlElement xmldt = xmldoc.CreateElement(\"Data\");
\n                    xmlarr = xmldoc.CreateAttribute(\"ss:Type\", \"urn:schemas-microsoft-com:office:spreadsheet\");
\n                    xmlarr.Value = \"String\";
\n                    xmldt.Attributes.Append(xmlarr);<\/p>\n
                    XmlText xmltxt = xmldoc.CreateTextNode(DC.ColumnName);
\n                    xmldt.AppendChild(xmltxt);<\/p>\n
                    xmlcl.AppendChild(xmldt);
\n                }<\/p>\n
                foreach (DataRow DR in DT.Rows)
\n                {
\n                    xmlrw = xmldoc.CreateElement(\"Row\");
\n                    xmltb.AppendChild(xmlrw);
\n                    foreach (DataColumn DC in DT.Columns)
\n                    {
\n                        XmlElement xmlcl = xmldoc.CreateElement(\"Cell\");
\n                        XmlElement xmldt = xmldoc.CreateElement(\"Data\");
\n                        XmlText xmltxt;
\n                        switch (DC.DataType.Name.ToLower())
\n                        {
\n                            case \"int32\":
\n                            case \"decimal\":
\n                            case \"double\":<\/p>\n
                                xmlarr = xmldoc.CreateAttribute(\"ss:Type\", \"urn:schemas-microsoft-com:office:spreadsheet\");
\n                                xmlarr.Value = \"Number\";
\n                                xmldt.Attributes.Append(xmlarr);<\/p>\n
                                xmltxt = xmldoc.CreateTextNode(DR[DC.ColumnName].ToString().Trim());
\n                                break;
\n                            case \"datetime\":
\n                            case \"smalldatetime\":
\n                                xmlarr = xmldoc.CreateAttribute(\"ss:StyleID\", \"urn:schemas-microsoft-com:office:spreadsheet\");
\n                                xmlarr.Value = \"s21\";
\n                                xmlcl.Attributes.Append(xmlarr);<\/p>\n
                                xmlarr = xmldoc.CreateAttribute(\"ss:Type\", \"urn:schemas-microsoft-com:office:spreadsheet\");
\n                                xmlarr.Value = \"DateTime\";
\n                                xmldt.Attributes.Append(xmlarr);<\/p>\n
                                xmltxt = xmldoc.CreateTextNode(Convert.ToDateTime(DR[DC.ColumnName]).ToString(\"yyyy-MM-ddTHH:mm:ss\").Trim());<\/p>\n
                                break;
\n                            default:<\/p>\n
                                xmlarr = xmldoc.CreateAttribute(\"ss:Type\", \"urn:schemas-microsoft-com:office:spreadsheet\");
\n                                xmlarr.Value = \"String\";
\n                                xmldt.Attributes.Append(xmlarr);<\/p>\n
                                xmltxt = xmldoc.CreateTextNode(DR[DC.ColumnName].ToString().Trim());
\n                                break;
\n                        }<\/p>\n
                        xmldt.AppendChild(xmltxt);<\/p>\n
                        xmlcl.AppendChild(xmldt);
\n                        xmlrw.AppendChild(xmlcl);
\n                    }
\n                }<\/p>\n
            }
\n            xmldoc.Save(foldName);
\n            System.Diagnostics.Process.Start(foldName);<\/p>\n
            #endregion
\n        }<\/p>\n
\n    }<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
\u7ed3\u679c\u5bfc\u51fa\u6210Excel\u6587\u4ef6. \u7528\u51e0\u4e2a\u4e0d\u540c\u7684\u529e\u6cd5\u505a\u4e86\u51fa\u6765. \u6700\u540e\u90e8\u7f72\u65f6\u53d1\u73b0: \u7528COM+\u7ec4\u4ef6\u884c\u4e0d\u901a, \u670d\u52a1\u5668\u4e0a\u6ca1\u88c5OFFICE; \u7528OWC\u4e5f\u4e0d\u884c, \u56e0\u4e3a\u670d\u52a1\u5668\u662f64\u4f4d\u7684, OWC\u4e0d\u652f\u6301; \u5bfc\u51fa\u6210Excel2003\u652f\u6301\u7684xml, \u8fd9\u62db\u6700\u7075\u6d3b, \u4e5f\u662f\u4e00\u4e2a\u7b80\u5355\u53ef\u884c\u7684\u529e\u6cd5.<\/p>\n
\u9996\u5148\u7528Excel 2003\u65b0\u5efa\u4e00\u4e2a\u7a7a\u767dWookbook, \u7136\u540e\u4fdd\u5b58\u4e3aXML Spreadsheet. \u7136\u540e\u6253\u5f00\u770b\u5b83\u751f\u6210\u7684XML\u4ee3\u7801\u5c31\u80fd\u4e86\u89e3XML Spreadsheet\u7684\u57fa\u672c\u7ed3\u6784\u4e86.
\n\u6211\u5148\u628aDataTable\u751f\u6210XML\u6570\u636e, \u518d\u4f7f\u7528\u4e00\u4e2aXLS\u628aXML\u6570\u636e\u8f6c\u6362\u6210XML Spreadsheet\u7684\u7ed3\u6784.<\/p>\n
 <\/p>\n
using<\/span> System;...<\/span><\/pre>\n
 \u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[273],"tags":[66],"class_list":["post-214","post","type-post","status-publish","format-standard","hentry","category-article","tag-excel"],"_links":{"self":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts\/214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/comments?post=214"}],"version-history":[{"count":0,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts\/214\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/media?parent=214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/categories?post=214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/tags?post=214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}