【潛盾機】避免Excel開啟CSV時截掉左補零的小工具

using System;

using System.Linq;

using System.Windows.Forms;

using System.IO;

using System.Text;

using System.Diagnostics;

namespace NumCsvOpener

{

    static class Program

    {

        #region 偵測Encoding

        static Encoding big5Enc = Encoding.GetEncoding(950);

        //偵測檔案否為BIG5編碼, REF: http://blog.darkthread.net/post-2012-04-11-detect-big5-encoding.aspx

        public static bool IsBig5Encoding(string file)

        {

            if (!File.Exists(file)) return false;

            byte[] data = File.ReadAllBytes(file);

            return data.Length == 

                big5Enc.GetByteCount(big5Enc.GetString(data));

        }

        #endregion

        [STAThread]

        static void Main()

        {

            try

            {

                //由使用者挑選CSV檔

                OpenFileDialog ofd = new OpenFileDialog();

                ofd.Filter = "*.csv|*.csv";

                if (ofd.ShowDialog() == DialogResult.OK)

                {

                    string fn = ofd.FileName;

                    //偵測檔案編碼再決定要用BIG5或UTF-8

                    Encoding enc =

                        IsBig5Encoding(fn) ? big5Enc : Encoding.UTF8;

                    using (StreamReader sr = new StreamReader(fn, enc))

                    {

                        StringBuilder sb = new StringBuilder();

                        string line;

                        while ((line = sr.ReadLine()) != null)

                        {

                            string[] p = line.Split(',');

                            sb.AppendLine(string.Join(",",

                                //重新組裝成="...."的格式

                                p.Select(o => string.Format("=\"{0}\"", o)).ToArray()

                                ));

                        }

                        //調整結果另存為同目錄下*.fixed.csv檔

                        string fixedFile = Path.Combine(

                            Path.GetDirectoryName(fn), 

                            Path.GetFileNameWithoutExtension(fn) + ".fixed.csv");

                        File.WriteAllText(fixedFile, sb.ToString(), enc);

                        //開啟CSV

                        Process proc = new Process();

                        proc.StartInfo = new ProcessStartInfo(fixedFile);

                        proc.Start();

                    }

                }

            }

            catch (Exception ex)

            {

                MessageBox.Show("Error: " + ex.Message);

            }

        }

    }

}