有没有人知道如何在使用C#代码生成的Excel表格中包含或输入页面编号?我使用Microsoft.Office.Interop.Excel中可用的库来生成文件。但是默认情况下,输出中看不到页面编号。我知道可以通过Excel选项(查看->页眉和页脚...)启用此功能,但我想通过C#自动化此过程。如果可能,请分享相应的代码片段。谢谢!
ActiveSheet.PageSetup.CenterFooter = "Page &P of &N"
ws.PageSetup.CenterFooter = "&[Pages]/&[Pages]"; // This did not work
ws.PageSetup.CenterFooter = "&P/&N"; // This worked correctly
当我输入文件名和日期时,发现了同样的情况。
ws.PageSetup.LeftHeader = "&[File]"; // This did not work
ws.PageSetup.RightHeader = "&[Date]"; // This did not work
ws.PageSetup.LeftHeader = "&F"; // This worked correctly
ws.PageSetup.RightHeader = "&D"; // This worked correctly