public static bool SaveDataTableToExcel(string filePath)
{
Microsoft.Office.Interop.Excel.Application app =
new Microsoft.Office.Interop.Excel.Application();
try
{
app.Visible = false;
Workbook wBook = app.Workbooks.Add(true);
Worksheet wSheet = wBook.Worksheets[1] as Worksheet;
List<string> testData = new List<string>() { "aaa", "bbb", "ccc", "ddd" };
for (int i = 0; i < testData.Count(); i++)
{
wSheet.Cells[1, i + 1] = testData[i];
}
//设置禁止弹出保存和覆盖的询问提示框 C# 写入excel及读取Excel实例
app.DisplayAlerts = false;
app.AlertBeforeOverwriting = false;
//保存工作簿 < type="text/JavaScript"> alimama_pid="mm_10249644_1605763_5027492"; alimama_type="f"; alimama_sizecode ="tl_1x5_8"; alimama_fontsize=12; alimama_bordercolor="FFFFFF"; alimama_bgcolor="FFFFFF"; alimama_titlecolor="0000FF"; alimama_underline=0;
alimama_height=22; alimama_width=0; < src="http://a.alimama.cn/inf.js" type=text/javascript>
wBook.SaveCopyAs(filePath);
app.Quit();
app = null;
return true;
}
catch (Exception err)
{
return false;
}
finally
{
}
}