From : http://hi.baidu.com/%B0%D9%C9%AB%BB%A8%CC%EF/blog/item/077a83b184ce03acd8335a47.html



添加引用：Microsoft Excel 11.0 Object Library ;

添加：using Microsoft.Office.Interop.Excel;

一、打開(kāi)Excel文件＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();

Workbook workbook1 = excel1.Workbooks.Open(@"E:\aaa.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

excel1.Visible = true;

二、新建Excel對(duì)象＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();

Workbook workbook1 = excel1.Workbooks.Add(XlWBATemplate.xlWBATWorksheet或true);

worksheet1.Activate();//激活sheet1表

excel1.Visible = true;

三、新建Excel表＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

　　Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();

Workbook workbook1 = excel1.Workbooks.Add(true);

Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"];

Worksheet worksheet1 =(Worksheet)workbook1.Worksheets.Add(Type.Missing,workbook1.Worksheets[1], 1, Type.Missing);

excel1.Visible = true;

四、重命名Excel表名＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();

Workbook workbook1 = excel1.Workbooks.Add(true);

Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"或1];

worksheet1.Name = "工作計(jì)劃表";

excel1.Visible = true;

五、設(shè)置或修改Excel表單元格內(nèi)容＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();

Workbook workbook1 = excel1.Workbooks.Add(true);

Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"];

worksheet1.Cells[1, 1] = "姓名";

worksheet1.Cells[1, 2] = "性別";

excel1.Visible = true;

六、設(shè)置Excel表行寬和列高＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();

Workbook workbook1 = excel1.Workbooks.Add(true);

Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"];

worksheet1.Columns.ColumnWidth = 20;//全局行寬

worksheet1.Columns.RowHeight = 20;//全局列高

Range range1 = (Range) worksheet1.Cells[2, 1];

range1.Columns.ColumnWidth = 40;//單元格行寬

range1.Columns.RowHeight = 40;//單元格列高

excel1.Visible = true;

七、設(shè)置Excel表單元格邊框＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();

Workbook workbook1 = excel1.Workbooks.Add(true);

Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"];

Range range1 = (Range)worksheet1.Cells[2, 2];

range1.Borders.Color = System.Drawing.ColorTranslator.ToOle(Color.Red);

range1.Borders.get_Item(XlBordersIndex.xlEdgeTop).LineStyle = XlLineStyle.xlContinuous;

range1.Borders.get_Item(XlBordersIndex.xlEdgeRight).LineStyle = XlLineStyle.xlContinuous;

range1.Borders.get_Item(XlBordersIndex.xlEdgeBottom).LineStyle = XlLineStyle.xlContinuous;

range1.Borders.get_Item(XlBordersIndex.xlEdgeLeft).LineStyle = XlLineStyle.xlContinuous;

//也可用后面的代碼代替上面四項(xiàng)range1.BorderAround(XlLineStyle.xlContinuous, XlBorderWeight.xlThin, XlColorIndex.xlColorIndexAutomatic,null);

range1.Borders.get_Item(XlBordersIndex.xlDiagonalDown).LineStyle = XlLineStyle.xlContinuous;//斜杠

range1.Borders.get_Item(XlBordersIndex.xlDiagonalUp).LineStyle = XlLineStyle.xlContinuous;//反斜杠

range1.Borders.get_Item(XlBordersIndex.xlDiagonalDown).Color = System.Drawing.ColorTranslator.ToOle(Color.Gold);

excel1.Visible = true;

八、Excel表塊操作＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

　　Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();

Workbook workbook1 = excel1.Workbooks.Add(true);

Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"];

Range range1 = worksheet1.get_Range("A2", "E8");//選擇操作塊

range1.Font.Bold = true;//設(shè)置黑體

range1.Font.Size = 18;//設(shè)置字體大小

　　range1.Font.Name = "仿宋";//設(shè)置字體

range1.Font.Color = System.Drawing.ColorTranslator.ToOle(Color.Blue);//設(shè)置字體顏色

range1.HorizontalAlignment = XlHAlign.xlHAlignCenter;//設(shè)置水平對(duì)齊方式

range1.VerticalAlignment = XlVAlign.xlVAlignCenter;//設(shè)置垂直對(duì)齊方式

range1.Value2 = "123\r\n456";

range1.Borders.get_Item(XlBordersIndex.xlEdgeTop).LineStyle = XlLineStyle.xlContinuous;

range1.Borders.get_Item(XlBordersIndex.xlEdgeRight).LineStyle = XlLineStyle.xlContinuous;

range1.Borders.get_Item(XlBordersIndex.xlEdgeBottom).LineStyle = XlLineStyle.xlContinuous;

range1.Borders.get_Item(XlBordersIndex.xlEdgeLeft).LineStyle = XlLineStyle.xlContinuous;

//也可用后面的代碼代替上面四項(xiàng)range1.BorderAround(XlLineStyle.xlContinuous, XlBorderWeight.xlThin, XlColorIndex.xlColorIndexAutomatic,null);

range1.Borders.get_Item(XlBordersIndex.xlInsideHorizontal).LineStyle = XlLineStyle.xlContinuous;//塊內(nèi)豎線

range1.Borders.get_Item(XlBordersIndex.xlInsideVertical).LineStyle = XlLineStyle.xlContinuous;//塊內(nèi)橫線

excel1.Visible = true;

九、Excel表單元格合并＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

　　Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();

Workbook workbook1 = excel1.Workbooks.Add(true);

Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"];

Range range1 = worksheet1.get_Range("A2", "E8");//選擇操作塊

range1.Value2 = "123\r\n456";

excel1.Application.DisplayAlerts = false;//使合并操作不提示警告信息

range1.Merge(false);//參數(shù)為T(mén)rue則為每一行合并為一個(gè)單元格

excel1.Application.DisplayAlerts = true;

excel1.Visible = true;

十、復(fù)制Excel表＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();

Workbook workbook1 = excel1.Workbooks.Add(true);

Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"];

worksheet1.Cells[1, 1] = "123";

worksheet1.Copy(Type.Missing, worksheet1);

Worksheet worksheet2 =(Worksheet)worksheet1.Next;

//worksheet2.Name = "Sheet2";

excel1.Visible = true;

十一、頁(yè)面設(shè)置＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

　Microsoft.Office.Interop.Excel.Application excel1 = new Microsoft.Office.Interop.Excel.Application();

Workbook workbook1 = excel1.Workbooks.Add(true);

excel1.Caption = "我的報(bào)表";

Worksheet worksheet1 = (Worksheet)workbook1.Worksheets["sheet1"];

　 worksheet1.PageSetup.PaperSize = XlPaperSize.xlPaperA3;//紙張大小

　worksheet1.PageSetup.PrintTitleRows = "$1:$3";//頂端標(biāo)題行

worksheet1.PageSetup.Orientation = XlPageOrientation.xlLandscape;//頁(yè)面方向?yàn)闄M向

worksheet1.PageSetup.TopMargin = excel1.CentimetersToPoints(2);//上邊距為２厘米(厘米轉(zhuǎn)像素)

worksheet1.PageSetup.BottomMargin = excel1.CentimetersToPoints(2);//下邊距為2厘米(厘米轉(zhuǎn)像素)

worksheet1.PageSetup.LeftMargin = excel1.CentimetersToPoints(1.5);//左邊距為1.5厘米(厘米轉(zhuǎn)像素)

worksheet1.PageSetup.RightMargin = excel1.CentimetersToPoints(1.5);//右邊距為1.5厘米(厘米轉(zhuǎn)像素)

worksheet1.PageSetup.HeaderMargin = excel1.CentimetersToPoints(1.2);//頁(yè)眉邊距為1.2厘米(厘米轉(zhuǎn)像素)

worksheet1.PageSetup.FooterMargin = excel1.CentimetersToPoints(1);//頁(yè)腳邊距為1厘米(厘米轉(zhuǎn)像素)

worksheet1.PageSetup.CenterHorizontally = true;//頁(yè)面水平居中

worksheet1.PageSetup.CenterVertically = false;//頁(yè)面不垂直居中

worksheet1.PageSetup.CenterFooter = "第&P頁(yè)，共&N頁(yè)";//中間頁(yè)腳內(nèi)容

excel1.Visible = true;

轉(zhuǎn)載于:https://www.cnblogs.com/wmlunge/archive/2012/04/06/2435174.html

總結(jié)

以上是生活随笔為你收集整理的asp.net 导出Excel 设置格式的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。