using System;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
namespace ExcelAddIn01
{
public partial class frmExcel_Data : Form
{
public frmExcel_Data()
{
InitializeComponent();
}
private void frmExcel_Data_Load(object sender, EventArgs e)
{
read_Excel_File_into_DataGridView();
}
#region --Methods--
//===================< Methods >===================
public void read_Excel_File_into_DataGridView()
{
//----------------< read_Excel_File_into_DataGridView() >------------
//< init >
Worksheet worksheet = Globals.ThisAddIn.Application.ActiveSheet;
DataGridView dataGridView = dataGrid_Excel;
//</ init >
Range usedRange = worksheet.UsedRange;
int nColumnsMax = 0;
String sText = "";
if (usedRange.Rows.Count > 0)
{
//----< Read_Header >----
for (int iColumn = 1; iColumn <= usedRange.Columns.Count; iColumn++)
{
Microsoft.Office.Interop.Excel.Range cell = usedRange.Cells[1, iColumn] as Range;
String sValue = cell.Value2.ToString();
if (sValue == "") break;
dataGridView.Columns.Add("column_" + iColumn, sValue);
nColumnsMax = iColumn;
}
//----</ Read_Header >----
//----< Read_DataRows >----
for (int iRow = 2; iRow <= usedRange.Rows.Count; iRow++)
{
//< add_Row >
int iNewRow = dataGridView.Rows.Add(new DataGridViewRow());
DataGridViewRow newRow = dataGridView.Rows[iNewRow];
//</ add_Row >
for (int iColumn = 1; iColumn <= nColumnsMax; iColumn++)
{
Microsoft.Office.Interop.Excel.Range cell = usedRange.Cells[iRow, iColumn] as Range;
String sValue = cell.Value2.ToString();
newRow.Cells[iColumn-1].Value = sValue;
}
}
//----</ Read_DataRows >----
}
//----------------</ read_Excel_File_into_DataGridView() >------------
}
//===================</ Methods >===================
#endregion --/Methods--
}
}
|