vb中输出到excel后如何控制页面边距?

2002-10-28 01:33:09 121 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

完美解决 mysql 报错ERROR 1524 (HY000): Plugin ‘mysql_native_password‘ is not loaded mysql 报错ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded 阅读详情

Set zsbexcel = New Excel.Application
zsbexcel.Visible = True
zsbexcel.SheetsInNewWorkbook = 1
Set zsbworkbook = zsbexcel.Workbooks.Add

zsbexcel.ActiveSheet.Rows.HorizontalAlignment = xlVAlignCenter '水平居中

zsbexcel.ActiveSheet.Rows.VerticalAlignment = xlVAlignCenter '垂直居中
----------------------------------------------------
以上是控制对齐方式,请问如何控制边距?比如将左右边距改为0.5?

...全文