Question

请问各位大虾，在C# winform中怎样设置excel的 页边距，代码怎样写？

Answer 1

using Excel = Microsoft.Office.Interop.Excel;

/// <summary>
/// 页面设置
/// </summary>
/// <param name="xlPagerSize">页面大小</param>
/// <param name="xlPageOrientation">垂直还是水平</param>
/// <param name="headerMargin">页眉大小</param>
/// <param name="footerMargin">页脚大小</param>
/// <param name="leftMargin">左边距</param>
/// <param name="rightMargin">右边距</param>
/// <param name="topMargin">上边距</param>
/// <param name="bottomMargin">下边距</param>
public void PageSetup(XlPaperSize xlPagerSize, XlPageOrientation xlPageOrientation, double headerMargin, double footerMargin, double leftMargin, double rightMargin, double topMargin, double bottomMargin)
{
Excel.Worksheet worksheet = (Excel.Worksheet)myExcel.ActiveSheet;
worksheet.PageSetup.PaperSize = xlPagerSize;
worksheet.PageSetup.Orientation = xlPageOrientation;
worksheet.PageSetup.HeaderMargin = headerMargin;
worksheet.PageSetup.FooterMargin = footerMargin;
worksheet.PageSetup.LeftMargin = leftMargin;
worksheet.PageSetup.RightMargin = rightMargin;
worksheet.PageSetup.TopMargin = myExcel.InchesToPoints(topMargin);
worksheet.PageSetup.BottomMargin = myExcel.InchesToPoints(bottomMargin);
worksheet.PageSetup.CenterHorizontally = true;
}

追问

谢谢你！
另外我还想问一下，我想在excel工作簿中建立两个工作表，用C#代码怎么写

追答

Excel.Worksheet newWorksheet;
newWorksheet = (Excel.Worksheet)Globals.ThisWorkbook.Worksheets.Add(
missing, missing, missing, missing);

Answer 2

自己在EXCEL中做个宏来看看代码就知道了

追问

这个我更加不懂，可以提供C#的代码吗？