在Visual Studio的套件管理器主控台輸入Install-Package FileHelpers
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWqP0jugwYX1d0mSygc-m8kQWOJBrIB_qOWQr0MGQpHDbbKqBPyoDyVziYhvGdth_UdGi14hzd_RY1vFuYA1hCC5e8EP1mkEtz8tps0geOqknGFy8n2zTuPQbgcQhArzP_cA22nF2g7p4/s320/%25E6%259C%25AA%25E5%2591%25BD%25E5%2590%258D.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgpIxy1ufWk_qMf2UubONPML5T_-MavfEWDCpacIt6zYqyn7teJWMD-mvOs_MuVa2-feyRUZWM0JpdFKCxa3dPhaPMI1PLtpePK2_U6ikH8mf8YZTG9eOBt42ILUAUkvlDq8kh-dI9fOM/s320/%25E6%259C%25AA%25E5%2591%25BD%25E5%2590%258D2.jpg)
可以下載編譯好的DLL: FileHelpers_3.1.5_Build.zip (目前最新版本)
原始碼可以到該專案的Github下載
需要建立一個對映的Record Mapping Class
如果csv檔不符合對映就會出FileHelpers.BadUsageException
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgN_D3o1WZf5Dlf2rm_jg2XUqB4Cg3b1Ov2SziHAyYV5oKOW3h9pLczpKro7PsjpGdne-SNlKHRRwYTriKpvMnBa8FrHNadZ1E66kZCKMc5IPI6_fFP7fsGOa5-SFbpnYYCS5Xgh7qucXA/s320/%25E6%259C%25AA%25E5%2591%25BD%25E5%2590%258D3.jpg)
另一種處理CSV工具:CsvHelper
使用 CsvHelper - Part.2 資料讀取
http://kevintsengtw.blogspot.tw/2015/04/csvhelper-part2.html
REF:
How to validate a .csv file before storage in C#?
http://stackoverflow.com/questions/16608486/how-to-validate-a-csv-file-before-storage-in-c
How to validate CSV in C#?
http://stackoverflow.com/questions/24765492/how-to-validate-csv-in-c
沒有留言:
張貼留言