Question

C#操作Excel如何设置页边距

Answer 1

using Spire.Xls;


namespace ExcelMargins
{
    class Program
    {
        static void Main(string[] args)
        {
            //实例化Workbook对象
            Workbook workbook = new Workbook();
            //加载Excel文档
            workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\学生成绩表.xlsx");
            //获取第一个工作表
            Worksheet sheet = workbook.Worksheets[0];
            //设置上下左右页边距
            sheet.PageSetup.TopMargin = 20;
            sheet.PageSetup.BottomMargin = 20;
            sheet.PageSetup.LeftMargin = 20;
            sheet.PageSetup.RightMargin = 20;
            //其他操作
            //...
        }
    }
}