Microsoft.Office.Interop.Excel.Application excelApplication;
Microsoft.Office.Interop.Excel.Workbooks workBooks;
Microsoft.Office.Interop.Excel.Workbook workBook;
Microsoft.Office.Interop.Excel.Worksheet workSheet;
Microsoft.Office.Interop.Excel.Range range;
object Nothing;public void Export()
{
try
{
excelApplication = new Microsoft.Office.Interop.Excel.Application();
workBooks = excelApplication.Workbooks;
workBook = workBooks.Add(true);
workSheet = workBook.ActiveSheet as Microsoft.Office.Interop.Excel.Worksheet;
Nothing = System.Reflection.Missing.Value;
string filePath = "c:\\test.xls";
if (System.IO.File.Exists(filePath))
{
System.IO.File.Delete(filePath);
}int row, col;
//excelApplication.Cells[1, 1] = "1.0";
range = excelApplication.get_Range(excelApplication.Cells[1, 1], excelApplication.Cells[1, 1]);
range.Value2 = "1.0";
range.ColumnWidth
= 20;
range.RowHeight = 20; range.Font.Bold
= true;
range.Font.Size = 8.5;
range.Font.Name = "Arial";
range.Font.ColorIndex = 3; range.HorizontalAlignment
= Microsoft.Office.Interop.Excel.Constants.xlLeft;
range.VerticalAlignment = Microsoft.Office.Interop.Excel.Constants.xlCenter;//XlVAlign.xlVAlignCenter;// 设置单元格垂直居中
range.Interior.ColorIndex = 15;//1 Black, 2 White, 3 Red, 4 Green, 5 Blue, 6 Yellow
range.Borders.LineStyle = 1;//边框 不能带 Weight
range.NumberFormatLocal = "#,##0.00";// 设置单元格格式为货币格式
row = col = 2;
range = excelApplication.get_Range(excelApplication.Cells[row, col], excelApplication.Cells[row, col]);
range.Value2 = DateTime.Now;
range.EntireColumn.AutoFit();
range.NumberFormat = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.FullDateTimePattern;
//range.NumberFormat = "yyyy-MM-dd h:mm:ss tt";//range.EntireColumn.AutoFit();
//range = workSheet.get_Range("B2", "D4");// 获取多个单元格
//range.Merge(Missing.Value); // 合并单元格
//range.Borders[XlBordersIndex.xlEdgeRight].Weight = XlBorderWeight.xlThick; // // 设置单元格右边框加粗
workSheet.PageSetup.PaperSize = XlPaperSize.xlPaperA4; // 设置页面大小为A4
workSheet.PageSetup.Orientation = XlPageOrientation.xlPortrait; // 设置垂直版面
workSheet.PageSetup.HeaderMargin = 0.0; // 设置页眉边距
workSheet.PageSetup.FooterMargin = 0.0; // 设置页脚边距
workSheet.PageSetup.LeftMargin = excelApplication.InchesToPoints(0.354330708661417); // 设置左边距
workSheet.PageSetup.RightMargin = excelApplication.InchesToPoints(0.354330708661417);// 设置右边距
workSheet.PageSetup.TopMargin = excelApplication.InchesToPoints(0.393700787401575); // 设置上边距
workSheet.PageSetup.BottomMargin = excelApplication.InchesToPoints(0.393700787401575);// 设置下边距
workSheet.PageSetup.CenterHorizontally = true; // 设置水平居中
// 打印文件
//workSheet.PrintOut(Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing);
workBook.SaveAs(filePath, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, Nothing, Nothing,
false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Nothing, Nothing, Nothing, Nothing, Nothing); MessageBox.Show(
"Success");
//System.Diagnostics.Process.Start(filePath);
}
catch (Exception)
{
throw;
}
finally
{
ReleaseExcel();
}
}public void ReleaseExcel()
{
if (excelApplication != null)
{
if (workBooks != null)
{
if (workBook != null)
{
if (workSheet != null)
{
if (range != null)
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(range);
range = null;
}
System.Runtime.InteropServices.Marshal.ReleaseComObject(workSheet);
workSheet = null;
}
workBook.Close(false, Nothing, Nothing);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workBook);
workBook = null;
}
workBooks.Close();
System.Runtime.InteropServices.Marshal.ReleaseComObject(workBooks);
workBooks = null;
}
excelApplication.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApplication);
excelApplication = null;
}
}
http://www.cnblogs.com/smjack/archive/2009/02/25/1398257.html Example
http://www.cnblogs.com/wangshuai/archive/2010/03/10/1682811.html 判断版本
http://www.cnblogs.com/cdplayer/archive/2008/05/13/1194901.html Format Example
http://www.cnblogs.com/wangshuai/archive/2010/03/10/1682813.html Format
