C# Json文件批量转成Excel文件

Json文件批量转Excel文件

都是策划自己的锅，为了大家的工作进度，还是帮他们吧。毕竟大家都挺不容易的。不说废话了。

 static void Main(string[] args)
        {
            string path_newJson = System.Environment.CurrentDirectory + "\\JosnNew";                //新的json数据目录
            string path_newXml = System.Environment.CurrentDirectory + "\\outputXmlNew\\";            //输出新的目录

            var newJsonfiles = Directory.GetFiles(path_newJson);
            foreach (var file in newJsonfiles)
            {
                string strJson = string.Empty;
                var ext = Path.GetExtension(file);
                if (ext.Equals(".json"))
                {
                    strJson = File.ReadAllText(file, Encoding.UTF8);
                    //读出文本文件
                    strJson = strJson.Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", "");//去除空行
                    strJson = strJson.Replace("*", "×");
                    string name = Path.GetFileNameWithoutExtension(file);
                    DataTable table = JsonToObj(strJson, name);
                    string PathName = path_newXml + name + "Els.xls";
                    dataTableToCsv(table, PathName);
                }
            }
            Console.ReadLine();
        }

        public static DataTable JsonToObj(string strJson, string name)
        {
            DataTable tb = null;
            //提取json的数据项
            JArray arrays = (JArray)JsonConvert.DeserializeObject(strJson);
            for (int i = 0; i < arrays.Count; i++)
            {
                string strData = arrays[i].ToString();
                strData = strData.Replace("  ", "").Replace(" ", "").Replace("\r\n", "").Replace(",\"", "*\"").Replace("\":", "\"#").ToString();
                strData = strData.Remove(0, 1);
                strData = strData.Remove(strData.Length - 1);
                string[] strRows = strData.Split('*');
                //创建表   
                if (tb == null)
                {
                    tb = new DataTable();
                    tb.TableName = name;
                    foreach (string str in strRows)
                    {
                        var dc = new DataColumn();
                        string[] strCell = str.Split('#');
                        if (strCell[0].Substring(0, 1) == "\"")
                        {
                            int a = strCell[0].Length;
                            dc.ColumnName = strCell[0].Substring(1, a - 2);
                        }
                        else
                        {
                            dc.ColumnName = strCell[0];
                        }
                        tb.Columns.Add(dc);
                    }
                    tb.AcceptChanges();
                }
                //增加内容   
                DataRow dr = tb.NewRow();
                for (int r = 0; r < strRows.Length; r++)
                {
                    if (strRows[r].Length > 1)
                    {
                        dr[r] = strRows[r].Split('#')[1].Trim().Replace("，", ",").Replace("：", ":").Replace("\"", "");
                    }
                }
                tb.Rows.Add(dr);
                tb.AcceptChanges();
            }
            return tb;
        }

        //转Excel
        public static void dataTableToCsv(DataTable table, string file)
        {
            if (table == null)
            {
                Console.WriteLine("表格出错了！！！！" + file);
                return;
            }
            Console.WriteLine("转Excel...");
            string title = "";
            FileStream fs = new FileStream(file, FileMode.OpenOrCreate);

            StreamWriter sw = new StreamWriter(new BufferedStream(fs), System.Text.Encoding.Default);
            for (int i = 0; i < table.Columns.Count; i++)
            {

                title += table.Columns[i].ColumnName + "\t"; //栏位：自动跳到下一单元格
            }

            title = title.Substring(0, title.Length - 1) + "\n";

            sw.Write(title);

            foreach (DataRow row in table.Rows)
            {
                string line = "";
                for (int i = 0; i < table.Columns.Count; i++)
                {
                    line += row[i].ToString().Trim() + "\t"; //内容：自动跳到下一单元格
                }
                line = line.Substring(0, line.Length - 1) + "\n";
                sw.Write(line);
            }
            sw.Close();
            fs.Close();
            Console.WriteLine("转Excel完成...");
        }

其实也不算难，只要理解如何对json处理，我的想法是，把每一个{ }里面的数据当成一个对象理解。也就是：

然后读取每个json对象的信息，最后写入Excel中，

插件下载链接：Json 批量 转 Excel工具