/// <summary>
/// 打开excel文件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void menuOpenExcel_Click(object sender, EventArgs e)
{
ExcelReadForm frmExcel = new ExcelReadForm();
frmExcel.MdiParent = this;
OpenFileDialog filedialog = new OpenFileDialog();
string FileName = "";
if (filedialog.ShowDialog() == DialogResult.OK)
{
FileName = filedialog.FileName;
//先判断工作表中有几个sheet
System.Data.DataTable dt = GetExcelDataTable(FileName);
if (dt.Rows.Count > 1)
{
string str = string.Format("您所打开的工作簿中共有{0}张表，我们为您打开了第一张",
dt.Rows.Count);
MessageBox.Show(str, "提醒", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
frmExcel.fileName = FileName;
frmExcel.isHaveManySheet = true;
frmExcel.sheetNum = dt.Rows.Count;
//打开excel文件
OpenExcel(frmExcel, FileName, "[Sheet1$]");
frmExcel.Show();
}
}
/// <summary>
/// 新建一个excel文件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void menuNewExcel_Click(object sender, EventArgs e)
{
ExcelReadForm frmExceel = new ExcelReadForm(5);
frmExceel.MdiParent = this;
frmExceel.Show();
}