1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98:
| public void exportXLS(List<signFlow> container) { string colLast = "L"; int rowCurrent = 1; object n = System.Reflection.Missing.Value;
Excel.Application excapp = new Excel.Application(); var workbook = excapp.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet); var sheet = (Excel.Worksheet)workbook.Sheets[1]; foreach (signFlow flow in container) { int colCurrent = 1;
sheet.Cells[rowCurrent, colCurrent] = flow.getName; colCurrent++; sheet.Cells[rowCurrent, colCurrent] = flow.getDek; colCurrent++; sheet.Cells[rowCurrent, colCurrent] = flow.getLok; colCurrent++; sheet.Cells[rowCurrent, colCurrent] = flow.getRef; colCurrent++; sheet.Cells[rowCurrent, colCurrent] = flow.getRW; colCurrent++; sheet.Cells[rowCurrent, colCurrent] = flow.getSign; colCurrent++; sheet.Cells[rowCurrent, colCurrent] = flow.getSNA; colCurrent++; sheet.Cells[rowCurrent, colCurrent] = flow.getLength; colCurrent++; if (flow.getFunction.Count >= 1) { foreach (string[] function in flow.getFunction) { sheet.Cells[rowCurrent, colCurrent] = value; colCurrent++; sheet.Cells[rowCurrent, colCurrent] = fct; colCurrent++; sheet.Cells[rowCurrent, colCurrent] = incr; colCurrent++; if (flow.getFunction.Count > 1) rowCurrent++; colCurrent -= 3; } } rowCurrent++; }
sheet.get_Range("A1", colLast + rowCurrent).Font.Name = "Arial Narrow"; sheet.get_Range("A1", colLast + rowCurrent).Font.Size = 8; sheet.get_Range("A1", colLast + "1").Font.Bold = true; sheet.get_Range("M1", "U1").Orientation = Excel.XlOrientation.xlUpward; sheet.get_Range("A1", colLast + "1").HorizontalAlignment = Excel.XlHAlign.xlHAlignLeft; sheet.get_Range("A1", "A1").ColumnWidth = 20; sheet.get_Range("B1", "B1").ColumnWidth = 20; sheet.get_Range("C1", "C1").ColumnWidth = 13; sheet.get_Range("D1", "D1").ColumnWidth = 12; sheet.get_Range("E1", "E1").ColumnWidth = 20; sheet.get_Range("F1", "F1").ColumnWidth = 20; sheet.get_Range("G1", "G1").ColumnWidth = 8; sheet.get_Range("H1", "H1").ColumnWidth = 8; sheet.get_Range("I1", "I1").ColumnWidth = 14; sheet.get_Range("J1", "J1").ColumnWidth = 6; sheet.get_Range("K1", "K1").ColumnWidth = 15; sheet.get_Range("L1", "L1").ColumnWidth = 30; sheet.get_Range("A1", colLast + rowCurrent).Cells.WrapText = true; sheet.get_Range("A1", colLast + rowCurrent).AutoFilter(1, Type.Missing, Excel.XlAutoFilterOperator.xlAnd, Type.Missing, true); Excel.Range firstRow = sheet.get_Range("B2", "B2"); firstRow.Activate(); firstRow.Select(); firstRow.Application.ActiveWindow.FreezePanes = true;
workbook.SaveAs("D:\\Markus_Ehinger\\C#-Versuche\\Files einlesen\\klasse_zu_xls\\ConsoleApplication1\\Exports\\export.xls", n, n, n, n, n, Excel.XlSaveAsAccessMode.xlNoChange, n, n, n, n, n); workbook.Close(false, n, n);
sheet = null; workbook = null; } } |