using?System;
using?System.Collections.Generic;
using?System.Data;
using?System.IO;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;

namespace?WinExport
{
????class?CSCClass
????{
????????///?

????????///?將DataTable中數(shù)據(jù)寫入到CSV文件中
????????///?

????????///?提供保存數(shù)據(jù)的DataTable
????????///?CSV的文件路徑
????????public?static?bool?SaveCSV（DataTable?dt?string?fullPath）
????????{
????????????try
????????????{
????????????????FileInfo?fi?=?new?FileInfo（fullPath）;
????????????????if?（!fi.Directory.Exists）
????????????????{
????????????????????fi.Directory.Create（）;
????????????????}
????????????????FileStream?fs?=?new?FileStream（fullPath?System.IO.FileMode.Create?System.IO.FileAccess.Write）;
????????????????//StreamWriter?sw?=?new?StreamWriter（fs?System.Text.Encoding.Default）;
????????????????StreamWriter?sw?=?new?StreamWriter（fs?System.Text.Encoding.UTF8）;
????????????????string?data?=?““;
????????????????//寫出列名稱
????????????????for?（int?i?=?0;?i?????????????????{
????????????????????data?+=?“\““?+?dt.Columns[i].ColumnName.ToString（）?+?“\““;
????????????????????if?（i?????????????????????{
????????????????????????data?+=?““;
????????????????????}
????????????????}
????????????????sw.WriteLine（data）;
????????????????//寫出各行數(shù)據(jù)
????????????????for?（int?i?=?0;?i?????????????????{
????????????????????data?=?““;
????????????????????for?（int?j?=?0;?j?????????????????????{
????????????????????????string?str?=?dt.Rows[i][j].ToString（）;
????????????????????????str?=?string.Format（“\“{0}\““?str）;
????????????????????????data?+=?str;
????????????????????????if?（j?????????????????????????{
????????????????????????????data?+=?““;
????????????????????????}
????????????????????}
????????????????????sw.WriteLine（data）;
????????????????}
????????????????sw.Close（）;
????????????????fs.Close（）;
????????????????return?true;
????????????}
????????????catch
????????????{
????????????????return?false;
????????????}
????????}
????????///?

????????///?讀取CSV文件到DataTable中
????????///?

????????///?CSV的文件路徑
????????///?
????????public?static?DataTable?ReadCSV（string?filePath）
????????{
????????????DataTable?dt?=?new?DataTable（）;
????????????int?lineNumber?=?0;
????????????using?（CsvFileReader?reader?=?new?CsvFileReader（filePath））
????????????{
????????????????CsvRow?row?=?new?CsvRow（）;
????????????????while?（reader.ReadRow（row））
????????????????{

????????????????????if?（0?==?lineNumber）
????????????????????{
????????????????????????foreach?（string?s?in?row）
????????????????????????{
????????????????????????????//Encoding?ss?=?Encoding.GetEncoding（““）;
???????????????????????????//?byte[]?aa?=?ss.GetBytes（s）;
???????????????

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-10-25?17:53??WinExport\
?????目錄???????????0??2018-10-25?17:53??WinExport\.vs\
?????目錄???????????0??2018-10-25?17:53??WinExport\.vs\WinExport\
?????目錄???????????0??2018-10-25?17:53??WinExport\.vs\WinExport\v14\
?????文件???????69120??2018-11-04?09:13??WinExport\.vs\WinExport\v14\.suo
?????目錄???????????0??2018-11-03?18:39??WinExport\WinExport\
?????文件?????????184??2018-10-25?20:14??WinExport\WinExport\App.config
?????文件????????7237??2018-10-25?21:47??WinExport\WinExport\CSCClass.cs
?????目錄???????????0??2018-10-26?14:00??WinExport\WinExport\DLL\
?????文件??????355328??2017-07-26?11:16??WinExport\WinExport\DLL\NPOI.OOxml.dll
?????文件???????78336??2017-07-26?11:16??WinExport\WinExport\DLL\NPOI.Openxml4Net.dll
?????文件?????1314816??2017-07-26?11:16??WinExport\WinExport\DLL\NPOI.OpenxmlFormats.dll
?????文件?????1678848??2017-07-26?11:16??WinExport\WinExport\DLL\NPOI.dll
?????文件??????155280??2013-08-13?00:19??WinExport\WinExport\DLL\System.Data.OracleClient.dll
?????文件?????????219??2017-07-26?11:16??WinExport\WinExport\DLL\vssver2.scc
?????文件????????6933??2018-10-25?19:07??WinExport\WinExport\ExcelHelper.cs
?????文件????????6181??2018-10-25?19:48??WinExport\WinExport\ExcelUnitty.cs
?????文件???????16900??2018-10-26?11:44??WinExport\WinExport\Excelout.cs
?????文件????????3699??2018-10-25?18:54??WinExport\WinExport\Form1.Designer.cs
?????文件???????29723??2018-11-03?18:39??WinExport\WinExport\Form1.cs
?????文件????????6023??2018-10-25?18:54??WinExport\WinExport\Form1.resx
?????文件?????????197??2018-10-26?11:34??WinExport\WinExport\GridViewExportUtil.cs
?????文件?????????521??2018-10-25?17:53??WinExport\WinExport\Program.cs
?????目錄???????????0??2018-10-25?17:53??WinExport\WinExport\Properties\
?????文件????????1344??2018-10-25?17:53??WinExport\WinExport\Properties\AssemblyInfo.cs
?????文件????????2858??2018-10-25?20:14??WinExport\WinExport\Properties\Resources.Designer.cs
?????文件????????5612??2018-10-25?17:53??WinExport\WinExport\Properties\Resources.resx
?????文件????????1109??2018-10-25?20:14??WinExport\WinExport\Properties\Settings.Designer.cs
?????文件?????????249??2018-10-25?17:53??WinExport\WinExport\Properties\Settings.settings
?????文件????????4624??2018-10-26?11:57??WinExport\WinExport\WinExport.csproj
?????目錄???????????0??2018-10-25?17:53??WinExport\WinExport\bin\
............此處省略31個(gè)文件信息