需引入Microsoft Excel 11.0 object library
private void button1_Click(object sender, EventArgs e)
{
string fileName = "";
SaveFileDialog sfDialog = new SaveFileDialog();
sfDialog.DefaultExt = "xls";
sfDialog.AddExtension = true;
sfDialog.Filter = "Excel 文件(*.xls)|*.xls|所有文件(*.*)|*.*";
if (sfDialog.ShowDialog() == DialogResult.OK)
{
fileName = sfDialog.FileName;
}
else
{
MessageBox.Show("无法保存文件!");
return;
}
Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
excelApp.Visible = true;
Excel.Workbook book = excelApp.Workbooks.Add(true);
//Excel.Worksheet sheet = (Excel.Worksheet)book.Sheets.Add(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
Excel.Worksheet sheet = (Excel.Worksheet)book.Sheets[1];
sheet.Name = "Test";
//设置头部格式
sheet.get_Range("A1", "D1").HorizontalAlignment = Excel.Constants.xlCenter;
//sheet.get_Range("A1", "D1").Font.Color = Color.Red;
sheet.get_Range("A1", "D1").Font.Bold = true;
sheet.get_Range("A1", "D1").Font.Size = 20;
sheet.get_Range("A1", "D1").Font.ColorIndex = 18;
sheet.get_Range("A1", "D1").RowHeight = 40;
sheet.get_Range("A1", "D1").Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
sheet.get_Range("A1", "D1").Interior.ColorIndex = 36;
sheet.get_Range("A1", Type.Missing).Value2 = "A1";
sheet.get_Range("B1", Type.Missing).Value2 = "B1";
sheet.get_Range("C1", Type.Missing).Value2 = "C1";
sheet.get_Range("D1", Type.Missing).Value2 = "D1";
Excel.Range range = sheet.get_Range("A2",Type.Missing);
range.Value2 = "value2";
//excelApp.Save(fileName);
book.Save().SaveAs(fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
//sheet.SaveAs(fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}
转自:http://hi.baidu.com/luoyuonline/blog/item/0f65d51083d713c1a7ef3f9d.html