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;
//其他操作
//...
}
}
}