/// <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;
}