xml到csv格式的文件 [英] xml to csv format files

问题描述

海，


我正在将xml文件转换为csv格式，但是在将其转换为csv之后，这些值的格式不正确.这意味着csv中的值没有以正确的方式进行声明.如何解决此问题.//下面是一个示例代码.

Hai,


I am converting the xml files into csv format.But after i converting it into csv the values are not in proper manner.This means values in csv are not in alligned in proper way.How can I solve this.//Below is a sample code for this.

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using DataStreams.Xml;
using System.Text;
using DataStreams.Csv;


namespace csvtoxml
{
    public partial class xmltocsv : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            using (CsvWriter writer = new CsvWriter("C:/XMLFile1.csv"))
            using (XmlRecordReader reader = new XmlRecordReader("C:/XMLFile1.xml", "CATALOG/PLANT"))
            {
                reader.Columns.Add("COMMON", "COMMON");
                reader.Columns.Add("BOTANICAL", "BOTANICAL");
                reader.Columns.Add("ZONE", "ZONE");
                reader.Columns.Add("LIGHT", "LIGHT");
                reader.Columns.Add("PRICE", "PRICE");
                reader.Columns.Add("AVAILABILITY", "AVAILABILITY");




                writer.Write("COMMON");
                writer.Write("BOTANICAL");
                writer.Write("ZONE");
                writer.Write("LIGHT");
                writer.Write("PRICE");
                writer.Write("AVAILABILITY");
               
                
                writer.EndRecord();

                while (reader.ReadRecord())
                {
                    writer.Write(reader["COMMON"]);
                    writer.Write(reader["BOTANICAL"]);
                    writer.Write(reader["ZONE"]);
                    writer.Write(reader["LIGHT"]);
                    writer.Write(reader["PRICE"]);
                    writer.Write(reader["AVAILABILITY"]);
                  
                    
                    writer.EndRecord();
                }

                reader.Close();
                writer.Close();
            }
        }
    }
}

推荐答案

请转到该网站以查找您要搜索的内容: http://www.csvreader.com/ [ ^ ].他们负责构建这些东西，因此您应该在那里获得更好的帮助.
他们也有论坛: http://groups.google.com/group/CSVChat/ [

Please go to this site to find what you are searching for: http://www.csvreader.com/[^]. They build the stuff so you should get better help there.
They also have forums: http://groups.google.com/group/CSVChat/[^].

Best Regards,

这篇关于xml到csv格式的文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！