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

  • 大小: 708KB
    文件類型: .rar
    金幣: 2
    下載: 1 次
    發(fā)布日期: 2021-06-19
  • 語言: C#
  • 標簽: C#??導(dǎo)入exce??

資源簡介

C# 導(dǎo)入excel到datagridview 在項目引用NuGet中安裝Microsoft.Office.Interop.Excel

資源截圖

代碼片段和文件信息

using?System;
using?System.Linq;
using?System.Windows.Forms;
using?System.Reflection;
using?Excel?=?Microsoft.Office.Interop.Excel;
using?System.Diagnostics;

namespace?WindowsFormsApplication1
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1()
????????{
????????????InitializeComponent();
????????}

????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
????????????//選擇文件
????????????openFileDialog1.Filter?=?“XLS文件|*.xls|XLSX文件|*.xlsx“;//篩選文件類型
????????????openFileDialog1.FileName?=?““;
????????????if?(openFileDialog1.ShowDialog()?==?DialogResult.OK)
????????????{
????????????????OpenExcel(openFileDialog1.FileName);
????????????}
????????????openFileDialog1.Dispose();
????????}

????????private?void?OpenExcel(string?strFileName)
????????{
????????????object?missing?=?Missing.Value;
????????????Excel.Application?excel?=?new?Excel.Application();//啟動excel程序
????????????try
????????????{
????????????????if?(excel?==?null)
????????????????{
????????????????????MessageBox.Show(“無法訪問Excel程序,請重新安裝Microsoft?Office?Excel。“);
????????????????}
????????????????else
????????????????{
????????????????????excel.Visible?=?false;//設(shè)置調(diào)用引用的Excel文件是否可見
????????????????????excel.UserControl?=?true;//設(shè)置調(diào)用引用的Excel是由用戶創(chuàng)建或打開的
????????????????????//?以只讀的形式打開EXCEL文件(工作簿)想了解這堆參數(shù)請訪問https://msdn.microsoft.com/zh-cn/library/office/microsoft.office.interop.excel.workbooks.open.aspx
????????????????????Excel.Workbook?wb?=?excel.Application.Workbooks.Open(strFileName?missing?true?missing?missing?missing
?????????????????????missing?missing?missing?true?missing?missing?missing?missing?missing);
????????????????????//取得第一個工作表
????????????????????Excel.Worksheet?ws?=?(Excel.Worksheet)wb.Worksheets[1];//索引從1開始?
????????????????????//取得總記錄行數(shù)(包括標題列)??
????????????????????int?rowCount?=?ws.UsedRange.Cells.Rows.Count;?//得到行數(shù)?
????????????????????int?colCount?=?ws.UsedRange.Cells.Columns.Count;//得到列數(shù)
????????????????????//初始化datagridview1
????????????????????dataGridView1.Rows.Clear();
????????????????????dataGridView1.Columns.Clear();
????????????????????//取得第一行,生成datagridview標題列(下標是從1開始的)
????????????????????for?(int?i?=?1;?i?<=?colCount;?i++)
????????????????????{
????????????????????????if?(ws.Cells[1?i].Value2?==?null)
????????????????????????{?break;?}
????????????????????????string?cellStr?=?ws.Cells[1?i].Value2.ToString().Trim();
????????????????????????dataGridView1.Columns.Add(“column“?+?i?cellStr);
????????????????????}
????????????????????//取得數(shù)據(jù)(不包括標題列)
????????????????????for?(int?i?=?2;?i?<=?rowCount;?i++)
????????????????????{//循環(huán)行
????????????????????????int?index?=?dataGridView1.Rows.Add();
????????????????????????if?(ws.Rows[i]?!=?null)
????????????????????????{
????????????????????????????for?(int?j?=?1;?j?<=?colCount;?j++)
????????????????????????????{//循環(huán)列
????????????????????????????????if?(ws.Cells[i?j].Value2?==?null)
?????????????????????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

????..A..H.?????44544??2019-04-11?14:46??WindowsFormsApplication1\.vs\WindowsFormsApplication1\v14\.suo

?????文件???????9475??2018-10-18?23:49??WindowsFormsApplication1\packages\Microsoft.Office.Interop.Excel.15.0.4795.1000\.signature.p7s

?????文件????1638128??2016-03-10?16:14??WindowsFormsApplication1\packages\Microsoft.Office.Interop.Excel.15.0.4795.1000\lib\net20\Microsoft.Office.Interop.Excel.dll

?????文件?????449414??2019-04-11?14:45??WindowsFormsApplication1\packages\Microsoft.Office.Interop.Excel.15.0.4795.1000\Microsoft.Office.Interop.Excel.15.0.4795.1000.nupkg

?????文件????????189??2019-04-11?14:42??WindowsFormsApplication1\WindowsFormsApplication1\App.config

?????文件???????9014??2019-04-11?12:09??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\123456.xls

?????文件??????17920??2019-04-11?14:46??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.exe

?????文件????????189??2019-04-11?14:42??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.exe.config

?????文件??????22016??2019-04-11?14:46??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.pdb

?????文件??????22696??2019-04-11?14:46??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.vshost.exe

?????文件????????189??2019-04-11?14:42??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.vshost.exe.config

?????文件????????490??2018-04-12?07:35??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.vshost.exe.manifest

?????文件???????4304??2019-04-11?14:46??WindowsFormsApplication1\WindowsFormsApplication1\Form1.cs

?????文件???????3203??2019-04-11?14:45??WindowsFormsApplication1\WindowsFormsApplication1\Form1.Designer.cs

?????文件???????6020??2019-04-11?14:45??WindowsFormsApplication1\WindowsFormsApplication1\Form1.resx

?????文件????????868??2019-04-11?14:42??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????7724??2019-04-11?14:45??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件??????????0??2019-04-11?14:42??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

?????文件??????????0??2019-04-11?14:42??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

?????文件??????????0??2019-04-11?14:42??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

?????文件???????1401??2019-04-11?14:46??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.csproj.FileListAbsolute.txt

?????文件???????1012??2019-04-11?14:46??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.csproj.GenerateResource.Cache

?????文件???????5878??2019-04-11?14:46??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.csprojResolveAssemblyReference.cache

?????文件??????17920??2019-04-11?14:46??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.exe

?????文件????????180??2019-04-11?14:46??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.Form1.resources

?????文件??????22016??2019-04-11?14:46??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.pdb

?????文件????????180??2019-04-11?14:46??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.Properties.Resources.resources

?????文件????????167??2019-04-11?14:45??WindowsFormsApplication1\WindowsFormsApplication1\packages.config

?????文件????????536??2019-04-11?14:42??WindowsFormsApplication1\WindowsFormsApplication1\Program.cs

?????文件???????1356??2019-04-11?14:42??WindowsFormsApplication1\WindowsFormsApplication1\Properties\AssemblyInfo.cs

............此處省略24個文件信息

評論

共有 條評論