public void ImproExcel( )
{
SaveFileDialog sdfExport = new SaveFileDialog();
sdfExport.Filter = "Excel 97-2003文件|*.xls|Excel 2007文件|*.xlsx";
if (sdfExport.ShowDialog() != DialogResult.OK)
{
return;
}
String filename = sdfExport.FileName;
String tableName = "";
NPOIExcelOutGoing NPOIexcel = new NPOIExcelOutGoing();
DataTable tabl = new DataTable();
tabl = GetDgvToTable(this.dgvMyNoumber);
tableName = "My_Noumber";
NPOIexcel.ExcelWrite(filename, tabl, tableName);//excelhelper写出
if (MessageBox.Show("导出成功，文件保存在" + filename.ToString() + ",是否打开此文件？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (File.Exists(filename)) //文件是否存在
{
Process.Start(filename); //执行打开导出的文件
}
else
{
MessageBox.Show("文件不存在！", "提示");
}
}
}
public void ImproExcel(int tcIndex)
{
SaveFileDialog sdfExport = new SaveFileDialog();
sdfExport.Filter = "Excel 97-2003文件|*.xls|Excel 2007文件|*.xlsx";
// sdfExport.ShowDialog();
if (sdfExport.ShowDialog() != DialogResult.OK)
{
return;
}
String filename = sdfExport.FileName;
String tableName = "";
NPOIExcelOutGoing NPOIexcel = new NPOIExcelOutGoing();
DataTable tabl = new DataTable();
if (tcIndex < 0)
{
return;
}
if (tcIndex == 0)
{
tabl = GetDgvToTable(this.dgvDirectoryFiles);
tableName = "dgvOutgoingTable";
}
if (tcIndex == 1)
{
tabl = GetDgvToTable(this.dgvDirectoryFiles);
tableName = "dgvOutCount";
}
// DataTable dt = (StyleCodeInfodataGridView.DataSource as DataTable);
NPOIexcel.ExcelWrite(filename, tabl, tableName);//excelhelper写出
if (MessageBox.Show("导出成功，文件保存在" + filename.ToString() + ",是否打开此文件？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (File.Exists(filename)) //文件是否存在
{
Process.Start(filename); //执行打开导出的文件
}
else
{
MessageBox.Show("文件不存在！", "提示");
}
}
}
