C#2.0 读word的多个表格到DataGridView或是其它控件 XP Vista

 1  #region  DataTalbe 要考虑第一行是表头,第二行开始为数据
 2 
 3               try
 4              {
 5                   // tablePos表格序号,就是查找word文档几个表格的自动给的序号
 6                   for  ( int  tablePos  =   1 ; tablePos  <=  oDoc.Tables.Count; tablePos ++ )
 7                  {
 8 
 9                       string  t  =  tablePos.ToString();
10                      DataSet ds  =   new  DataSet();
11                      DataTable dt  =   new  DataTable(t);
12                       //  DataGridView dgv = new DataGridView();
13                      ds.Tables.Add(dt);
14 
15                      Word.Table nowTable  =  oDoc.Tables.Item(tablePos);
16                      DataRow dr;
17 
18                       // 取得第一行标题值
19                       for  ( int  rowPos  =   1 ; rowPos  <=  nowTable.Rows.Count; rowPos ++ )
20                      {
21                           // 第一行值                               
22                           if  (rowPos  ==   1 )
23                          {
24                               for  ( int  columPos  =   1 ; columPos  <=  nowTable.Columns.Count; columPos ++ )
25                              {
26                                   string  tableMessage  =  nowTable.Cell(rowPos, columPos).Range.Text;
27                                  tableMessage  =  tableMessage.Remove(tableMessage.Length  -   2 2 ).Trim(); ;
28                                   // 只求到了第一行值  
29                                  dt.Columns.Add(tableMessage);
30 
31 
32 
33                              }
34                          }
35                           else
36                          {
37                               // 第二行值
38                              dr  =  dt.NewRow();
39                               for  ( int  columPos  =   1 ; columPos  <=  nowTable.Columns.Count; columPos ++ )
40                              {
41                                   string  tableMessage  =  nowTable.Cell(rowPos, columPos).Range.Text;
42                                  tableMessage  =  tableMessage.Remove(tableMessage.Length  -   2 2 ).Trim();
43                                  dr[columPos  -   1 =  tableMessage;
44 
45                              }
46                              dt.Rows.Add(dr);
47 
48                          }
49                      }
50 
51                      dataGridView1.DataSource  =  ds.Tables[t].DefaultView;
52                     
53                  }
54 
55 
56              }
57               catch  (Exception ex)
58              {
59                   // throw;
60                  MessageBox.Show( " 你选择的文档不是表格格式不对 " " 提示 " );
61              }
62              oReadOnly  =   true ;
63              Cursor  =  Cursors.Default;
64               #endregion
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
可以通过使用 Microsoft.Office.Interop.Excel 库来实现在 C# Winform 中导入多个 Excel 文件到 DataGridView 件中。 以下是一个简单的示例代码,可以实现将多个 Excel 文件的数据导入到一个 DataGridView 中: ```csharp using System; using System.Collections.Generic; using System.Data; using System.IO; using System.Runtime.InteropServices; using System.Windows.Forms; using Excel = Microsoft.Office.Interop.Excel; namespace ExcelToDataGridView { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void btnImport_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Multiselect = true; openFileDialog.Filter = "Excel Files|*.xls;*.xlsx;*.xlsm"; if (openFileDialog.ShowDialog() == DialogResult.OK) { List<DataTable> dataTables = new List<DataTable>(); foreach (string fileName in openFileDialog.FileNames) { DataTable dataTable = ReadExcelFile(fileName); dataTables.Add(dataTable); } dataGridView1.DataSource = MergeDataTables(dataTables); } } private DataTable ReadExcelFile(string fileName) { Excel.Application excelApp = new Excel.Application(); Excel.Workbook workbook = null; Excel.Worksheet worksheet = null; DataTable dataTable = new DataTable(); try { workbook = excelApp.Workbooks.Open(fileName); worksheet = workbook.Sheets[1]; int rowCount = worksheet.UsedRange.Rows.Count; int colCount = worksheet.UsedRange.Columns.Count; for (int i = 1; i <= colCount; i++) { Excel.Range range = worksheet.Cells[1, i]; dataTable.Columns.Add(range.Value.ToString()); } for (int i = 2; i <= rowCount; i++) { DataRow dataRow = dataTable.NewRow(); for (int j = 1; j <= colCount; j++) { Excel.Range range = worksheet.Cells[i, j]; dataRow[j - 1] = range.Value != null ? range.Value.ToString() : ""; } dataTable.Rows.Add(dataRow); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (worksheet != null) Marshal.ReleaseComObject(worksheet); if (workbook != null) workbook.Close(); if (excelApp != null) excelApp.Quit(); Marshal.ReleaseComObject(excelApp); } return dataTable; } private DataTable MergeDataTables(List<DataTable> dataTables) { DataTable mergedDataTable = new DataTable(); foreach (DataTable dataTable in dataTables) { mergedDataTable.Merge(dataTable); } return mergedDataTable; } } } ``` 在上述代码中,通过 OpenFileDialog 对话框选择多个 Excel 文件后,分别通过 ReadExcelFile 方法取每个 Excel 文件中的数据,然后将取的数据通过 MergeDataTables 方法合并成一个 DataTable,并绑定到 DataGridView 件中显示。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值