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

namespace?WriteExcel
{
????class?ExcelHelper
????{
????????private?OleDbConnection?conn?=?null;
????????private?OleDbCommand?cmd?=?null;
????????private?OleDbDataReader?sdr?=?null;

????????///?

????????///?數(shù)據(jù)表鏈接
????????///?

????????public?ExcelHelper（）
????????{
????????????string?xlsPath?=?“D:\\溫濕度記錄\\“?+?DateTime.Now.ToString（“yyyy-MM-dd“）?+?“.xls“;?//?絕對物理路徑
????????????string?connStr?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?xlsPath?+?“;Extended?Properties?=‘Excel?8.0‘“;
????????????conn?=?new?OleDbConnection（connStr）;
????????}

????????///?

????????///?打開數(shù)據(jù)庫
????????///?

????????///?
????????private?OleDbConnection?GetConn（）
????????{
????????????if?（conn.State?==?ConnectionState.Closed）
????????????{
????????????????conn.Open（）;
????????????}
????????????return?conn;
????????}

????????///?

????????///?執(zhí)行增刪改SQL語句
????????///?

????????///?SQL語句
????????///?返回?cái)?shù)值為被執(zhí)行影響的行數(shù)
????????public?int?ExecuteNonQuery（string?cmdText）//返回?cái)?shù)值為被執(zhí)行影響的行數(shù)
????????{
????????????int?res;
????????????try
????????????{
????????????????cmd?=?new?OleDbCommand（cmdText?GetConn（））;
????????????????cmd.CommandType?=?CommandType.Text;
????????????????res?=?cmd.ExecuteNonQuery（）;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????throw?ex;
????????????}
????????????finally
????????????{
????????????????if?（conn.State?==?ConnectionState.Open）
????????????????{
????????????????????conn.Close（）;//關(guān)閉數(shù)據(jù)庫連接
????????????????}
????????????}
????????????return?res;
????????}

????????///?

????????///?執(zhí)行查詢SQL語句
????????///?

????????///?SQL語句
????????///?
????????public?System.Data.DataTable?ExecuteQuery（string?cmdText）
????????{
????????????System.Data.DataTable?dt?=?new?System.Data.DataTable（）;
????????????cmd?=?new?OleDbCommand（cmdText?GetConn（））;
????????????cmd.CommandType?=?CommandType.Text;
????????????using?（sdr?=?cmd.ExecuteReader（CommandBehavior.CloseConnection））
????????????{
????????????????dt.Load（sdr）;
????????????}
????????????return?dt;
????????}

????????///?

????????///?根據(jù)Excel物理路徑獲取Excel文件中所有表名
????????///?

????????///?EXCEL文件名
????????///?
????????public?String[]?GetExcelSheetNames（string?excelFile）
????????{
????????????System.Data.DataTable?dt?=?null;
????????????try
????????????{
????????????????dt?=?GetConn（）.GetOleDbSchemaTable（OleDbSchemaGuid.Tables?null）;
????????????????if?（dt?==?null）
????????????????{
????????????????????return?new?string[0];
????????????????}
????????????????String[]?excelSheets?=?ne

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????1705??2020-10-23?08:46??WriteExcel.sln

?????文件????????189??2020-10-22?22:39??WriteExcel\App.config

?????文件??????17408??2020-10-23?09:00??WriteExcel\bin\Debug\WriteExcel.exe

?????文件????????189??2020-10-22?22:39??WriteExcel\bin\Debug\WriteExcel.exe.config

?????文件??????28160??2020-10-23?09:00??WriteExcel\bin\Debug\WriteExcel.pdb

?????文件??????22696??2020-10-23?09:00??WriteExcel\bin\Debug\WriteExcel.vshost.exe

?????文件????????189??2020-10-22?22:39??WriteExcel\bin\Debug\WriteExcel.vshost.exe.config

?????文件??????16896??2020-10-23?09:00??WriteExcel\bin\Release\WriteExcel.exe

?????文件????????189??2020-10-22?22:39??WriteExcel\bin\Release\WriteExcel.exe.config

?????文件??????26112??2020-10-23?09:00??WriteExcel\bin\Release\WriteExcel.pdb

?????文件??????22696??2020-10-23?09:00??WriteExcel\bin\Release\WriteExcel.vshost.exe

?????文件????????189??2020-10-22?22:39??WriteExcel\bin\Release\WriteExcel.vshost.exe.config

?????文件????????490??2015-10-22?09:54??WriteExcel\bin\Release\WriteExcel.vshost.exe.manifest

?????文件???????3879??2020-10-23?08:14??WriteExcel\ExcelHelper.cs

?????文件???????3638??2020-10-23?08:48??WriteExcel\MSN.ICO

?????文件????????868??2020-10-22?22:39??WriteExcel\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????7448??2020-10-23?08:46??WriteExcel\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件?????430592??2020-10-23?09:00??WriteExcel\obj\Debug\Interop.Microsoft.Office.Core.dll

?????文件??????????0??2020-10-22?22:39??WriteExcel\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

?????文件??????????0??2020-10-22?22:39??WriteExcel\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

?????文件??????????0??2020-10-22?22:39??WriteExcel\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

?????文件???????1364??2020-10-23?09:00??WriteExcel\obj\Debug\WriteExcel.csproj.FileListAbsolute.txt

?????文件???????1017??2020-10-23?09:00??WriteExcel\obj\Debug\WriteExcel.csproj.GenerateResource.Cache

?????文件???????1058??2020-10-23?09:00??WriteExcel\obj\Debug\WriteExcel.csproj.ResolveComReference.cache

?????文件??????17408??2020-10-23?09:00??WriteExcel\obj\Debug\WriteExcel.exe

?????文件??????28160??2020-10-23?09:00??WriteExcel\obj\Debug\WriteExcel.pdb

?????文件????????180??2020-10-23?09:00??WriteExcel\obj\Debug\WriteExcel.Properties.Resources.resources

?????文件????????180??2020-10-23?09:00??WriteExcel\obj\Debug\WriteExcel.WriteExcel.resources

?????文件???????7503??2020-10-23?08:48??WriteExcel\obj\Release\DesignTimeResolveAssemblyReferencesInput.cache

?????文件?????430592??2020-10-23?09:00??WriteExcel\obj\Release\Interop.Microsoft.Office.Core.dll

............此處省略73個(gè)文件信息