91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 3.59MB
    文件類型: .zip
    金幣: 2
    下載: 0 次
    發布日期: 2023-11-09
  • 語言: C#
  • 標簽: .NET??

資源簡介

我是新手一枚，做了個winform導入Excel到數據庫的小東西，分享給大家，請大家指點下。 文件里面有我的導入的Excel文件，估計只能導這樣的吧。不過改改還是能導別的數據的。

資源截圖

代碼片段和文件信息 

using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.IO;
using?System.Data;
using?System.Text.Regularexpressions;
using?NPOI.SS.UserModel;
using?NPOI.XSSF.UserModel;
using?NPOI.HSSF.UserModel;

namespace?KQ
{
????class?Excel?:?IDisposable
????{

????????private?string?fileName?=?null;
????????private?IWorkbook?workbook?=?null;
????????private?FileStream?fs?=?null;
????????private?bool?disposed;

????????public?Excel（string?fileName）
????????{
????????????this.fileName?=?fileName;
????????????disposed?=?false;

????????}


????????///?
????????///?將excel中的數據導入到DataTable中
????????///?
????????///?excel工作薄sheet的名稱
????????///?第一行是否是DataTable的列名
????????///?返回的DataTable
????????public?DataTable?ExcelToDataTable（string?sheetName?bool?isFirstRowColumn）
????????{

????????????ISheet?sheet?=?null;
????????????DataTable?data?=?new?DataTable（）;
????????????int?startRow?=?0;
????????????try
????????????{
????????????????fs?=?new?FileStream（fileName?FileMode.Open?FileAccess.Read）;
????????????????if?（fileName.IndexOf（“.xlsx“）?>?0）?//?2007版本
????????????????????workbook?=?new?XSSFWorkbook（fs）;
????????????????else?if?（fileName.IndexOf（“.xls“）?>?0）?//?2003版本
????????????????????workbook?=?new?HSSFWorkbook（fs）;

????????????????if?（sheetName?!=?null）
????????????????{
????????????????????sheet?=?workbook.GetSheet（sheetName）;
????????????????????if?（sheet?==?null）
????????????????????{
????????????????????????sheet?=?workbook.GetSheetAt（0）;//如果沒有找到指定的sheetName對應的sheet，則嘗試獲取第一個sheet
????????????????????}
????????????????}
????????????????else
????????????????{
????????????????????sheet?=?workbook.GetSheetAt（0）;
????????????????}

????????????????//獲取并顯示設置?列
????????????????if?（sheet?!=?null）
????????????????{
????????????????????//獲取第一行，并設置為列
????????????????????IRow?firstRow?=?sheet.GetRow（0）;
????????????????????int?cellCount?=?firstRow.LastCellNum;//一行最后一個cell的編號?即總的列數
????????????????????if?（isFirstRowColumn）
????????????????????{
????????????????????????for?（int?i?=?firstRow.FirstCellNum;?i?????????????????????????{
??????????????????????????ICell?cell?=?firstRow.GetCell（i）;
????????????????????????????if?（cell?!=?null）
????????????????????????????{
????????????????????????????????string?cellValue?=?cell.StringCellValue;
????????????????????????????????if?（cellValue?!=?null）
????????????????????????????????{
????????????????????????????????????string[]?s?=?Regex.Replace（cellValue.Trim（）?“\\s+“?“?“）.Split（‘?‘）;//將多余的空格轉成一個空格，然后變成數組
????????????????????????????????????for?（int?a?=?0;?a?????????????????????????????????????{
????????????????????????????????????????if?（s[a].ToString（）?!=?null?&&?s[a].ToString（）.Length?!=?0）
????????????????????????????????????????{
?????????????????????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????39936??2016-07-04?14:17??CCCC3.xls
?????目錄???????????0??2016-07-06?16:38??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\
?????目錄???????????0??2016-07-06?16:37??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\
?????目錄???????????0??2016-07-06?16:31??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\
?????目錄???????????0??2016-07-06?16:31??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\
?????文件??????200704??2015-01-30?13:33??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\ICSharpCode.SharpZipLib.dll
?????文件?????1606144??2015-02-22?18:14??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\NPOI.dll
?????文件??????423936??2015-02-22?18:17??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\NPOI.OOxml.dll
?????文件??????425038??2015-02-22?18:17??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\NPOI.OOxml.xml
?????文件???????85504??2015-02-22?18:14??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\NPOI.Openxml4Net.dll
?????文件??????153267??2015-02-22?18:14??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\NPOI.Openxml4Net.xml
?????文件?????1902592??2015-02-22?18:14??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\NPOI.OpenxmlFormats.dll
?????文件?????2137432??2015-02-22?18:14??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\NPOI.xml
?????文件???????13312??2016-07-06?16:37??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\WindowsFormsApplication59.exe
?????文件???????38400??2016-07-06?16:37??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\WindowsFormsApplication59.pdb
?????文件???????11600??2016-07-06?16:38??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\WindowsFormsApplication59.vshost.exe
?????文件?????????490??2012-06-06?02:06??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\bin\Debug\WindowsFormsApplication59.vshost.exe.manifest
?????目錄???????????0??2016-07-06?16:31??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\dll\
?????文件??????200704??2015-01-30?13:33??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\dll\ICSharpCode.SharpZipLib.dll
?????文件?????1606144??2015-02-22?18:14??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\dll\NPOI.dll
?????文件??????423936??2015-02-22?18:17??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\dll\NPOI.OOxml.dll
?????文件??????425038??2015-02-22?18:17??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\dll\NPOI.OOxml.xml
?????文件???????85504??2015-02-22?18:14??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\dll\NPOI.Openxml4Net.dll
?????文件??????153267??2015-02-22?18:14??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\dll\NPOI.Openxml4Net.xml
?????文件?????1902592??2015-02-22?18:14??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\dll\NPOI.OpenxmlFormats.dll
?????文件?????2137432??2015-02-22?18:14??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\dll\NPOI.xml
?????文件????????5733??2016-07-06?11:54??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\Excel.cs
?????文件???????????3??2016-07-06?08:25??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\Excel_2.cs
?????文件????????4395??2016-07-06?16:39??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\Form1.cs
?????文件????????3607??2016-07-06?16:31??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\Form1.Designer.cs
?????文件????????5817??2016-07-06?16:31??最新C#winform導入excel到DataTable里拆分好格式再導入SQL里\WindowsFormsApplication59\Form1.resx
............此處省略26個文件信息

評論

共有 條評論