資源簡介
C#實現excel中獲取指定列下中數據查重(公司工具)
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.IO;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
namespace?CKDZ_check1._3
{
????class?CsvReader
????{
????????private?static?char?quotechar?=?‘‘;??
????????public?static?List?ReadCSV(string?filePathName)
????????{
????????????FileStream?fs?=?new?FileStream(filePathName?FileMode.Open?FileAccess.Read?FileShare.ReadWrite);
????????????//StreamReader?sr?=?new?StreamReader(fs?System.Text.Encoding.Default);
????????????StreamReader?fileReader?=?new?StreamReader(fs?Encoding.Default);
????????????string?rowStr?=?fileReader.ReadLine();
????????????//?“a1“bc?????//?“\“a1\“\“b12\“\“ccc\“ddd“
????????????List?rowList?=?new?List();
????????????while?
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
????..A..H.?????45056??2017-08-04?11:45??CKDZ_check1.3\.vs\CKDZ_check1.3\v15\.suo
?????文件????????189??2017-08-03?14:35??CKDZ_check1.3\CKDZ_check1.3\App.config
?????文件??????14848??2017-08-04?11:45??CKDZ_check1.3\CKDZ_check1.3\bin\Debug\CKDZ_check1.3.exe
?????文件????????189??2017-08-03?14:35??CKDZ_check1.3\CKDZ_check1.3\bin\Debug\CKDZ_check1.3.exe.config
?????文件??????30208??2017-08-04?11:45??CKDZ_check1.3\CKDZ_check1.3\bin\Debug\CKDZ_check1.3.pdb
?????文件????1276720??2009-08-31?02:00??CKDZ_check1.3\CKDZ_check1.3\bin\Debug\Microsoft.Office.Interop.Excel.dll
?????文件????1124349??2010-01-10?22:10??CKDZ_check1.3\CKDZ_check1.3\bin\Debug\Microsoft.Office.Interop.Excel.xm
?????文件??????64288??2009-08-31?02:00??CKDZ_check1.3\CKDZ_check1.3\bin\Debug\Microsoft.Vbe.Interop.dll
?????文件?????416544??2009-08-31?02:00??CKDZ_check1.3\CKDZ_check1.3\bin\Debug\office.dll
?????文件?????647452??2010-01-10?22:10??CKDZ_check1.3\CKDZ_check1.3\bin\Debug\office.xm
?????文件??????32408??2017-07-25?15:01??CKDZ_check1.3\CKDZ_check1.3\bin\Debug\stdole.dll
?????文件???????3810??2017-08-03?15:54??CKDZ_check1.3\CKDZ_check1.3\CKDZ_check1.3.csproj
?????文件???????3133??2017-08-03?16:12??CKDZ_check1.3\CKDZ_check1.3\CsvReader.cs
?????文件???????7651??2017-08-04?11:40??CKDZ_check1.3\CKDZ_check1.3\Form1.cs
?????文件???????6483??2017-08-04?11:37??CKDZ_check1.3\CKDZ_check1.3\Form1.Designer.cs
?????文件???????5817??2017-08-04?11:37??CKDZ_check1.3\CKDZ_check1.3\Form1.resx
?????文件???????1343??2017-08-04?09:44??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\CKDZ_check1.3.csproj.FileListAbsolute.txt
?????文件???????1012??2017-08-04?11:37??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\CKDZ_check1.3.csproj.GenerateResource.Cache
?????文件??????16523??2017-08-03?14:37??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\CKDZ_check1.3.csprojResolveAssemblyReference.cache
?????文件??????14848??2017-08-04?11:45??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\CKDZ_check1.3.exe
?????文件??????30208??2017-08-04?11:45??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\CKDZ_check1.3.pdb
?????文件????????180??2017-08-04?11:37??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\CKDZ_check1._3.Form1.resources
?????文件????????180??2017-08-03?15:54??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\CKDZ_check1._3.Properties.Resources.resources
?????文件?????????42??2017-08-03?15:50??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\CoreCompileInputs.cache
?????文件???????1464??2017-08-03?16:10??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件???????7341??2017-08-03?15:50??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件??????????0??2017-08-03?14:35??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
?????文件??????????0??2017-08-03?14:35??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
?????文件??????????0??2017-08-03?14:35??CKDZ_check1.3\CKDZ_check1.3\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
?????文件????????526??2017-08-03?14:35??CKDZ_check1.3\CKDZ_check1.3\Program.cs
............此處省略21個文件信息
評論
共有 條評論