将数据从datagridview中导出到excel中,导出完毕后自动保存到给定的路径中。该怎么办
将数据从datagridview中导出到excel中,导出完毕后自动保存到给定的路径中。该怎么处理
在此基础之上要加的代码实现自动保存!!!!求代码!!!
string strSql = "select * from S";
DataTable dt = new DataTable();
dt = this.dbconn(strSql);
Microsoft.Office.Interop.Word.Application wordApp = new Microsoft.Office.Interop.Word.Application();
Microsoft.Office.Interop.Word.Document document;
Microsoft.Office.Interop.Word.Table wordTable;
Microsoft.Office.Interop.Word.Selection wordSelection;
object wordObj = System.Reflection.Missing.Value;
document = wordApp.Documents.Add(ref wordObj, ref wordObj, ref wordObj, ref wordObj);
wordSelection = wordApp.Selection;
//显示word文档
wordApp.Visible = true;
if (wordApp == null)
{
MessageBox.Show("本地Word程序无法启动!请检查您的Microsoft Office正确安装并能正常使用", "提示");
return;
}
document.Select();
wordTable = document.Tables.Add(wordSelection.Range, dataGridView1.Rows.Count + 1, dataGridView1.Columns.Count, ref wordObj, ref wordObj);
//设置列宽
wordTable.Columns.SetWidth(50.0F, Microsoft.Office.Interop.Word.WdRulerStyle.wdAdjustSameWidth);
//标题数据
for (int i = 0; i < dt.Columns.Count; i++)
{
wordTable.Cell(1, i + 1).Range.InsertAfter(dt.Columns[i].ColumnName);
}
//输出表中数据
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Rows[i][j] != null)
{
wordTable.Cell(i + 2, j + 1).Range.InsertAfter(dt.Rows[i][j].ToString());
}
}
}
------解决方案--------------------
在此基础之上要加的代码实现自动保存!!!!求代码!!!
string strSql = "select * from S";
DataTable dt = new DataTable();
dt = this.dbconn(strSql);
Microsoft.Office.Interop.Word.Application wordApp = new Microsoft.Office.Interop.Word.Application();
Microsoft.Office.Interop.Word.Document document;
Microsoft.Office.Interop.Word.Table wordTable;
Microsoft.Office.Interop.Word.Selection wordSelection;
object wordObj = System.Reflection.Missing.Value;
document = wordApp.Documents.Add(ref wordObj, ref wordObj, ref wordObj, ref wordObj);
wordSelection = wordApp.Selection;
//显示word文档
wordApp.Visible = true;
if (wordApp == null)
{
MessageBox.Show("本地Word程序无法启动!请检查您的Microsoft Office正确安装并能正常使用", "提示");
return;
}
document.Select();
wordTable = document.Tables.Add(wordSelection.Range, dataGridView1.Rows.Count + 1, dataGridView1.Columns.Count, ref wordObj, ref wordObj);
//设置列宽
wordTable.Columns.SetWidth(50.0F, Microsoft.Office.Interop.Word.WdRulerStyle.wdAdjustSameWidth);
//标题数据
for (int i = 0; i < dt.Columns.Count; i++)
{
wordTable.Cell(1, i + 1).Range.InsertAfter(dt.Columns[i].ColumnName);
}
//输出表中数据
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Rows[i][j] != null)
{
wordTable.Cell(i + 2, j + 1).Range.InsertAfter(dt.Rows[i][j].ToString());
}
}
}
------解决方案--------------------
private void OutWord_Load(object sender, EventArgs e)
{
string sql = "select * from mrgw limit 0,10";
DataTable dt = TaoBaoDBHelperMySQL.GetDataSet(sql).Tables[0];
ExportToWord(dt,"D://aaa");
}
/// <summary>
/// 将数据表导出到word
/// </summary>
/// <param name="dt">数据表</param>
/// <param name="isShowWord">是否显示word</param>