1/**//// <summary> 2 /// 1.Clear CircleReference 3 /// 2.Set Page to Fit Wide 4 /// 3.Set Column Text fit 5 /// </summary> 6 /// <param name="app"></param> 7 /// <param name="ws"></param> 8 private void WorkSheetPageSet(Microsoft.Office.Interop.Excel.Application app, Worksheet ws) 9 { 10 ClearCircleReference(ws); 11 12 SetPagetoFitWide(ws); 13 14 SetColumnFit(ws); 15 } 16 17 /**//// <summary> 18 /// Set Column Text fit 19 /// </summary> 20 /// <param name="sheet"></param> 21 private static void SetColumnFit(Worksheet sheet) 22 { 23 char column = 'B'; 24 for (int i = 0; i < 25; i++) 25 { 26 27 Range range = sheet.get_Range(String.Format("{0}1", column.ToString()), 28 String.Format("{0}1", column.ToString())); 29 if (range != null) 30 { 31 range.EntireColumn.AutoFit(); 32 } 33 column++; 34 } 35 } 36 37 /**//// <summary> 38 /// Clear CircleReference 39 /// </summary> 40 /// <param name="sheet">Worksheet object</param> 41 private void ClearCircleReference(Worksheet sheet) 42 { 43 Range range = sheet.CircularReference; 44 while (range != null) 45 { 46 range.Clear(); 47 range = sheet.CircularReference; 48 } 49 } 50 51 /**//// <summary> 52 /// Set Page to Fit Wide 53 /// </summary> 54 /// <param name="ws">Worksheet object</param> 55 private static void SetPagetoFitWide(Worksheet ws) 56 { 57 ws.PageSetup.Zoom = false; 58 ws.PageSetup.FitToPagesWide = 1; 59 ws.PageSetup.FitToPagesTall = false; 60 } |