/// <summary> /// Formatiere das Dokument /// </summary> /// <param name="sheets"></param> private void GenerateWorksheetAbhackeListe(WorksheetCollection sheets) { Worksheet sheet = sheets.Add(this._SheetName + " vom " + DateTime.Now.ToLongDateString()); this._Sheet = sheet; sheet.Table.StyleID = "ta1"; WorksheetColumn column0 = sheet.Table.Columns.Add(58); WorksheetColumn column1 = sheet.Table.Columns.Add(60); WorksheetColumn column2 = sheet.Table.Columns.Add(48); WorksheetColumn column3 = sheet.Table.Columns.Add(); column3.Width = 120; WorksheetColumn column44 = sheet.Table.Columns.Add(); column44.Width = 80; WorksheetColumn column4 = sheet.Table.Columns.Add(); column4.Width = 64; WorksheetColumn column7 = sheet.Table.Columns.Add(); column7.Width = 20; WorksheetColumn column8 = sheet.Table.Columns.Add(); column8.Width = 20; WorksheetColumn column9 = sheet.Table.Columns.Add(); column9.Width = 20; WorksheetColumn column10 = sheet.Table.Columns.Add(); column10.Width = 20; WorksheetColumn column11 = sheet.Table.Columns.Add(); column11.Width = 20; WorksheetColumn column12 = sheet.Table.Columns.Add(); column12.Width = 20; WorksheetColumn column13 = sheet.Table.Columns.Add(); column13.Width = 170; // Generierung Daten Zellen WorksheetRow Row0 = sheet.Table.Rows.Add(); Row0.Height = 18; Row0.AutoFitHeight = true; WorksheetCell cell; cell = Row0.Cells.Add(); cell.StyleID = "ce1"; cell.Data.Type = DataType.String; cell.Data.Text = "Ausweis Nummer"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.StyleID = "ce1"; cell.Data.Type = DataType.String; cell.Data.Text = "Personen Haushalt"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.StyleID = "ce1"; cell.Data.Type = DataType.String; cell.Data.Text = "Gruppe"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.StyleID = "ce1"; cell.Data.Type = DataType.String; cell.Data.Text = "Name"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.StyleID = "ce1"; cell.Data.Type = DataType.String; cell.Data.Text = "Ort"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.StyleID = "ce6"; cell.Data.Type = DataType.String; cell.Data.Text = "Ausweis gültig bis"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.StyleID = "ce8"; cell.Data.Type = DataType.String; cell.Data.Text = "Wochen"; cell.MergeAcross = 5; cell = Row0.Cells.Add(); cell.StyleID = "ce9"; cell.Data.Type = DataType.String; cell.Data.Text = "Bemerkungen"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.Index = 1024; // ----------------------------------------------- WorksheetRow Row1 = sheet.Table.Rows.Add(); Row1.Height = 12; Row1.AutoFitHeight = false; // Hole Kalenderwochen, für die nächsten 6 Wochen aus Klasse: CalendarWeekDays, und // schreibe diese in das DataSheet for (int rows = 1; rows <= 6; rows++) { Row1.Cells.Add(); } CalendarWeekDays cal = new CalendarWeekDays(); List <int> weekList = new List <int>(); weekList = cal.NumberOfWeek(DateTime.Now); for (int week = 0; week <= 5; week++) { Row1.Cells.Add(weekList[week].ToString(), DataType.Number, "ce10"); } cell.Index = 1016; // ----------------------------------------------- // Optionen // ----------------------------------------------- sheet.Options.ProtectObjects = false; sheet.Options.ProtectScenarios = false; }
/// <summary> /// Formatiere das Dokument /// </summary> /// <param name="sheets"></param> private void GenerateWorksheetAbhackeListe(WorksheetCollection sheets) { Worksheet sheet = sheets.Add(this._SheetName + " vom " + DateTime.Now.ToLongDateString()); this._Sheet = sheet; sheet.Table.StyleID = "ta1"; WorksheetColumn column0 = sheet.Table.Columns.Add(58); WorksheetColumn column1 = sheet.Table.Columns.Add(60); WorksheetColumn column2 = sheet.Table.Columns.Add(48); WorksheetColumn column3 = sheet.Table.Columns.Add(); column3.Width = 120; WorksheetColumn column44 = sheet.Table.Columns.Add(); column44.Width = 80; WorksheetColumn column4 = sheet.Table.Columns.Add(); column4.Width = 64; WorksheetColumn column7 = sheet.Table.Columns.Add(); column7.Width = 20; WorksheetColumn column8 = sheet.Table.Columns.Add(); column8.Width = 20; WorksheetColumn column9 = sheet.Table.Columns.Add(); column9.Width = 20; WorksheetColumn column10 = sheet.Table.Columns.Add(); column10.Width = 20; WorksheetColumn column11 = sheet.Table.Columns.Add(); column11.Width = 20; WorksheetColumn column12 = sheet.Table.Columns.Add(); column12.Width = 20; WorksheetColumn column13 = sheet.Table.Columns.Add(); column13.Width = 170; // Generierung Daten Zellen WorksheetRow Row0 = sheet.Table.Rows.Add(); Row0.Height = 18; Row0.AutoFitHeight = true; WorksheetCell cell; cell = Row0.Cells.Add(); cell.StyleID = "ce1"; cell.Data.Type = DataType.String; cell.Data.Text = "Ausweis Nummer"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.StyleID = "ce1"; cell.Data.Type = DataType.String; cell.Data.Text = "Personen Haushalt"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.StyleID = "ce1"; cell.Data.Type = DataType.String; cell.Data.Text = "Gruppe"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.StyleID = "ce1"; cell.Data.Type = DataType.String; cell.Data.Text = "Name"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.StyleID = "ce1"; cell.Data.Type = DataType.String; cell.Data.Text = "Ort"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.StyleID = "ce6"; cell.Data.Type = DataType.String; cell.Data.Text = "Ausweis gültig bis"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.StyleID = "ce8"; cell.Data.Type = DataType.String; cell.Data.Text = "Wochen"; cell.MergeAcross = 5; cell = Row0.Cells.Add(); cell.StyleID = "ce9"; cell.Data.Type = DataType.String; cell.Data.Text = "Bemerkungen"; cell.MergeDown = 1; cell = Row0.Cells.Add(); cell.Index = 1024; // ----------------------------------------------- WorksheetRow Row1 = sheet.Table.Rows.Add(); Row1.Height = 12; Row1.AutoFitHeight = false; // Hole Kalenderwochen, für die nächsten 6 Wochen aus Klasse: CalendarWeekDays, und // schreibe diese in das DataSheet for (int rows = 1; rows <= 6; rows++) { Row1.Cells.Add(); } CalendarWeekDays cal = new CalendarWeekDays(); List<int> weekList = new List<int>(); weekList = cal.NumberOfWeek(DateTime.Now); for (int week = 0; week <= 5; week++) { Row1.Cells.Add(weekList[week].ToString(), DataType.Number, "ce10"); } cell.Index = 1016; // ----------------------------------------------- // Optionen // ----------------------------------------------- sheet.Options.ProtectObjects = false; sheet.Options.ProtectScenarios = false; }