コード例 #1
0
ファイル: Dist.cs プロジェクト: JeremyShih/-1
 public Dist(string city, string distn,string villa, string year, cont[] cont)
 {
     this.city = city;
     this.distn = distn;
     this.villa = villa;
     this.year = year;
     this.cont = cont;
 }
コード例 #2
0
ファイル: Program.cs プロジェクト: JeremyShih/-1
        static void Main(string[] args)
        {
            string docname = "filename_Zhongzheng.txt";
            StreamReader input = new StreamReader(docname, System.Text.Encoding.Default); //指定字元編碼方式(中文)
            int leng = 30; string[] list = new string[leng];
            for (int i = 0; i < leng; i++)
            {
                string line = input.ReadLine();
                list[i] = line;
            }
            int len = list.Length;
            Dist[] Daan = new Dist[len];
            //int k = 3;
            for (int k = 0; k < len; k++)
            {
                string strfile = "D:\\CP\\" + list[k] + ".xls",
                    outfile = "D:\\CP\\" + list[k] + ".json";
                string nam = list[k].Replace("經費收支結算表", "");
                string distname = nam.Substring(0, 3);
                string villname = nam.Substring(3, 3);
                string strFilePath = string.Format(@strfile);// D:\CP
                HSSFWorkbook wk;
                using (FileStream fs = new FileStream(strFilePath, FileMode.Open))
                {
                    wk = new HSSFWorkbook(fs);
                }

                //取得sheet名稱
                HSSFSheet hst;
                hst = (HSSFSheet)wk.GetSheetAt(0);
                string strSheetname = hst.SheetName;

                //單行單行的取得sheet理的資料
                HSSFRow hr;
                hr = (HSSFRow)hst.GetRow(0);
                string head = hr.Cells[0].ToString();
                head = head.Trim(' ');
                head = head.Replace(" ", "").Replace(" ", "");
                Console.WriteLine(head);
                string year = head.Substring(head.IndexOf("1"), 3);
                hr = (HSSFRow)hst.GetRow(2);
                int n = hr.LastCellNum;
                string[] header = new string[15];
                for (int i = 1; i < n - 1; i++)
                {
                    string b = hr.Cells[i].ToString();
                    int test = b.IndexOf("\n");
                    if (test > 0) { b = b.Remove(test, 1); }
                    header[i] = b;
                }

                hr = (HSSFRow)hst.GetRow(3);
                string[] plan = new string[15];
                for (int i = 1; i < n - 1; i++)
                {
                    string b;
                    if (hr.Cells[i].ToString().Length > 1)
                    {
                        b = hr.Cells[i].ToString().Replace("*", "").Replace(" ", "").Replace("$", "").Replace("元", "").Replace("NT", "");
                    }
                    else { b = "0"; }
                    int value2 = (int)decimal.Parse(b);// 96,765.00 --> 96765
                    b = Convert.ToString(value2);
                    plan[i] = b;
                }

                hr = (HSSFRow)hst.GetRow(4);
                string[] res = new string[15];
                for (int i = 1; i < n - 1; i++)
                {
                    string b;
                    if (hr.Cells[i].ToString().Length > 1)
                    {
                        b = hr.Cells[i].ToString().Replace("*", "").Replace(" ", "").Replace("$", "").Replace("元", "").Replace("NT", "");
                    }
                    else { b = "0"; }
                    int value2 = (int)decimal.Parse(b);// 96,765.00 --> 96765
                    b = Convert.ToString(value2);
                    //b = string.Format("{0:C}", value2); // 96765 --> NT$96,765.00
                    //b = string.Format("{0:NT$#,0}", value2); // 96765 --> NT$96,765
                    res[i] = b;
                }

                cont[] cont = new cont[n - 2];
                string jsonoutstr = "";
                for (int i = 1; i < n - 1; i++)
                {
                    cont[i - 1] = new cont(header[i], plan[i], res[i]);
                    string jsonout = JsonConvert.SerializeObject(cont[i - 1]);
                    jsonoutstr += jsonout + "\n";
                }
                Console.WriteLine(jsonoutstr);
                Daan[k] = new Dist("台北市", distname, villname, year, cont);
                //Console.WriteLine(JsonConvert.SerializeObject(Daan[k]) + "\n");
                // System.IO.File.WriteAllText(@outfile, jsonoutstr);
                //Console.ReadLine();
            }
            string jo = JsonConvert.SerializeObject(Daan);
            // Console.WriteLine(jo);
            string refile = "D:\\CP\\" + "Zhongzhengdistfonddata" + ".json";
            System.IO.File.WriteAllText(@refile, jo);
            //Console.ReadLine();
        }