ExlApp.DisplayAlerts = false; WB = ExlApp.Workbooks.Open(EXLPath, MissVal, MissVal, MissVal, MissVal, MissVal, MissVal, MissVal, MissVal, MissVal, MissVal, MissVal, MissVal, MissVal, MissVal); WB.Activate(); Microsoft.Office.Interop.Excel.Worksheet WS = (Microsoft.Office.Interop.Excel.Worksheet)WB.ActiveSheet; WS.PageSetup.Orientation = Microsoft.Office.Interop.Excel.XlPageOrientation.xlPortrait; WS.PageSetup.PaperSize = Microsoft.Office.Interop.Excel.XlPaperSize.xlPaperA4; WS.PageSetup.Zoom = false; WS.PageSetup.FitToPagesWide = 1; WS.PageSetup.FitToPagesTall = false; WS.PageSetup.RightMargin = ExlApp.InchesToPoints(0.2); WS.PageSetup.LeftMargin = ExlApp.InchesToPoints(0.2); WS.PageSetup.TopMargin = ExlApp.InchesToPoints(0); WS.PageSetup.BottomMargin = ExlApp.CentimetersToPoints(0.2);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)