MVC导出EXCEL，设置打印边距

評論
11 views


在</ss:Worksheet></ss:Workbook>之前加如下代码<WorksheetOptionsxmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Headerx:Margin="0.26"/><Footerx:Margin="0.28"x:Data="第&amp;P页，共&amp;N页"/><PageMarginsx:Bottom="0.2"x:Left="0.19685039370078741"x:Right="0.19685039370078741"x:Top="0.39370078740157483"/></PageSetup><Print><ValidPrinterInfo/><PaperSizeIndex>9</PaperSizeIndex><HorizontalResolution>600</HorizontalResolution><VerticalResolution>0</VerticalResolution></Print><Selected/></WorksheetOptions>文章来源，CC影音http://www.cczoe.net