using Microsoft.Office.Core;
using Microsoft.Office.Interop.Excel;
using System.IO;
using System.Reflection;

Application app = new Application();
Workbooks wbks = app.Workbooks;
_Workbook _wbk = wbks.Add(xxx);

Sheets shs = _wbk.Sheets;

//i是要取得的sheet的index
_Worksheet _wsh = (_Worksheet)shs.get_Item(i)

//删除sheet必须的设置
app.DisplayAlerts = false;
_wsh.Delete();

/a(before)，b(after)：确定添加位置；c：数目；d：类型
app.Worksheets.Add(a，b，c，d);

_wsh.Name = "xxx";

((Range)_wsh.Rows[3, Missing.Value]).Delete(XlDeleteShiftDirection.xlShiftUp);

_wsh.get_Range(
_wsh.Cells[1, 2], 
_wsh.Cells[_wsh.Rows.Count, 2]).Delete(XlDeleteShiftDirection.xlShiftToLeft
);

((Range)_wsh.Rows[11, Missing.Value])
.Insert(Missing.Value, XlInsertFormatOrigin.xlFormatFromLeftOrAbove);

_wsh.get_Range(
_wsh.Cells[1, 1], _wsh.Cells[_wsh.Rows.Count, 1])
.Insert(Missing.Value, XlInsertShiftDirection.xlShiftToRight);

//获得单元格对象
_wsh.Cells[row, cell]

//在对应的单元格输入公式即可
_wsh.Cells[row, cell] = "=Sum(A1/B1)";　

((Range)_wsh.Rows[1, Missing.Value]).Merge(Missing.Value);

((Range)_wsh.Rows[3, Missing.Value]).RowHeight = 5;
((Range)_wsh.Rows[3, Missing.Value]).ColumnWidth = 5;

((Range)_wsh.Rows[1, Missing.Value]).Interior.ColorIndex = 3;

((Range)_wsh.Cells[1, "B"]).Font.Size = 8;

((Range)_wsh.Rows[1, Missing.Value]).Font.Bold = false;

((Range)_wsh.Cells[2, 1]).HorizontalAlignment = XlVAlign.xlVAlignCenter;

((Range)_wsh.Cells[3, 3]).Borders.LineStyle = 3;

//左
_wsh.get_Range(
_wsh.Cells[2, 1], _wsh.Cells[2, 2])
.Borders[XlBordersIndex.xlEdgeLeft].Weight = XlBorderWeight.xlThick;//
 
//右
_wsh.get_Range(
_wsh.Cells[2, 1], _wsh.Cells[2, 2])
.Borders[XlBordersIndex.xlEdgeRight].Weight = XlBorderWeight.xlThick;//
 
//上
_wsh.get_Range(
_wsh.Cells[2, 1], _wsh.Cells[2, 2])
.Borders[XlBordersIndex.xlEdgeTop].Weight = XlBorderWeight.xlThick;//下
 
//下
_wsh.get_Range(
_wsh.Cells[2, 1], _wsh.Cells[2, 2])
.Borders[XlBordersIndex.xlEdgeBottom].Weight = XlBorderWeight.xlThick;

_Worksheet _wsh = (_Worksheet)shs.get_Item(1);//复制选中区域的内容
 
Range range = _wsh.get_Range(_wsh.Cells[7, 1], _wsh.Cells[10, _wsh.Columns.Count]);
 
range.Select();
range.Copy(Type.Missing);
 
//选中粘贴的起始位置
Range test = ((Range)_wsh.Cells[11, 1]);
test.Select();
 
//屏蔽掉Alert，默认确定粘贴
app.DisplayAlerts = false;
test.Parse(Missing.Value, Missing.Value);

//屏蔽掉系统跳出的Alert
app.AlertBeforeOverwriting = false;
 
//保存到指定目录
SaveAs(filePath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

//_wbk.Close(null, null, null);
//wbks.Close();
app.Quit();
 
//释放掉多余的excel进程
System.Runtime.InteropServices.Marshal.ReleaseComObject(app); 
app = null;

//这里的“1，2，3”设置的就是下拉框的值
((Range)_wsh.Cells[2, 1])
.Validation.Modify(XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertStop, Type.Missing, "1,2,3", Type.Missing);

((Range)_wsh.Cells[2, 1])
.Validation.Add(XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertStop, Type.Missing,"1,2,3", Type.Missing);

string strValue = ((Range)_wsh.Cells[2, 1]).Validation.Formula1;

_wsh.get_Range(_wsh.Cells[19, 1], _wsh.Cells[22, 1]).EntireRow.Hidden = true;

_wsh.get_Range(_wsh.Cells[1, 1], _wsh.Cells[_wsh.Rows.Count, 1])
.EntireColumn.Hidden = true;