public void ResizeColumns() { #region radspreadprocessing-working-with-rows-and-columns-resizing_2 Workbook workbook = new Workbook(); Worksheet worksheet = workbook.Worksheets.Add(); ColumnSelection columnSelection = worksheet.Columns[5, 7]; double columnWidth = columnSelection.GetWidth().Value.Value; columnSelection.SetWidth(new ColumnWidth(columnWidth + 50, true)); #endregion }
protected Workbook createWorkbook() { Workbook workbook = new Workbook(); workbook.Sheets.Add(SheetType.Worksheet); Worksheet worksheet = workbook.ActiveWorksheet; worksheet.Name = "OTE RT"; List <TaskB> tasks = new List <TaskB>(); try { string recFilter = gridMain.MasterTableView.FilterExpression; GridSortExpressionCollection gridSortExxpressions = gridMain.MasterTableView.SortExpressions; TasksController cont = new TasksController(); int tasksCount = cont.CountAllTasks(recFilter); tasks = cont.GetAllTasks(0, tasksCount, recFilter, gridSortExxpressions); } catch (Exception) { } prepareDocument(worksheet); int currentRow = 1; CellBorder border = new CellBorder(CellBorderStyle.Thin, tcBlack); CellBorders borders = new CellBorders(border, border, border, border, null, null, null, null); double fontSize = 12; foreach (TaskB curTask in tasks) { worksheet.Cells[currentRow, 0].SetValue(curTask.ID.ToString()); worksheet.Cells[currentRow, 0].SetFontSize(fontSize); worksheet.Cells[currentRow, 0].SetBorders(borders); worksheet.Cells[currentRow, 1].SetValue(curTask.RegNo); worksheet.Cells[currentRow, 1].SetFormat(new CellValueFormat("@")); worksheet.Cells[currentRow, 1].SetFontSize(fontSize); worksheet.Cells[currentRow, 1].SetBorders(borders); worksheet.Cells[currentRow, 2].SetValue(curTask.OrderDate); worksheet.Cells[currentRow, 2].SetFormat(new CellValueFormat(dateFormat)); worksheet.Cells[currentRow, 2].SetFontSize(fontSize); worksheet.Cells[currentRow, 2].SetBorders(borders); worksheet.Cells[currentRow, 3].SetValue(curTask.Customer.NameGR); worksheet.Cells[currentRow, 3].SetFontSize(fontSize); worksheet.Cells[currentRow, 3].SetBorders(borders); worksheet.Cells[currentRow, 4].SetValue(curTask.Job.Name); worksheet.Cells[currentRow, 4].SetFontSize(fontSize); worksheet.Cells[currentRow, 4].SetBorders(borders); string distance = curTask.Distance.Position1 + " - " + curTask.Distance.Position2 + " (" + curTask.Distance.KM.ToString() + ")"; worksheet.Cells[currentRow, 5].SetValue(distance); worksheet.Cells[currentRow, 5].SetFontSize(fontSize); worksheet.Cells[currentRow, 5].SetBorders(borders); worksheet.Cells[currentRow, 6].SetValue(curTask.DateTimeStartOrder.GetValueOrDefault()); worksheet.Cells[currentRow, 6].SetFormat(new CellValueFormat(dateFormat)); worksheet.Cells[currentRow, 6].SetFontSize(fontSize); worksheet.Cells[currentRow, 6].SetBorders(borders); worksheet.Cells[currentRow, 7].SetValue(curTask.DateTimeEndOrder.GetValueOrDefault()); worksheet.Cells[currentRow, 7].SetFormat(new CellValueFormat(dateFormat)); worksheet.Cells[currentRow, 7].SetFontSize(fontSize); worksheet.Cells[currentRow, 7].SetBorders(borders); worksheet.Cells[currentRow, 8].SetValue(curTask.DateTimeDurationOrder); worksheet.Cells[currentRow, 8].SetFontSize(fontSize); worksheet.Cells[currentRow, 8].SetBorders(borders); worksheet.Cells[currentRow, 9].SetValue(double.Parse(curTask.AddedCharges.GetValueOrDefault().ToString())); worksheet.Cells[currentRow, 9].SetFormat(new CellValueFormat(currencyFormat)); worksheet.Cells[currentRow, 9].SetFontSize(fontSize); worksheet.Cells[currentRow, 9].SetBorders(borders); worksheet.Cells[currentRow, 10].SetValue(double.Parse(curTask.CostCalculated.GetValueOrDefault().ToString())); worksheet.Cells[currentRow, 10].SetFormat(new CellValueFormat(currencyFormat)); worksheet.Cells[currentRow, 10].SetFontSize(fontSize); worksheet.Cells[currentRow, 10].SetBorders(borders); if (curTask.DateTimeStartActual.GetValueOrDefault().Year > 2000) { worksheet.Cells[currentRow, 11].SetValue(curTask.DateTimeStartActual.GetValueOrDefault()); } else { worksheet.Cells[currentRow, 11].SetValue(""); } worksheet.Cells[currentRow, 11].SetFormat(new CellValueFormat(dateFormat)); worksheet.Cells[currentRow, 11].SetFontSize(fontSize); worksheet.Cells[currentRow, 11].SetBorders(borders); if (curTask.DateTimeEndActual.GetValueOrDefault().Year > 2000) { worksheet.Cells[currentRow, 12].SetValue(curTask.DateTimeEndActual.GetValueOrDefault()); } else { worksheet.Cells[currentRow, 12].SetValue(""); } worksheet.Cells[currentRow, 12].SetFormat(new CellValueFormat(dateFormat)); worksheet.Cells[currentRow, 12].SetFontSize(fontSize); worksheet.Cells[currentRow, 12].SetBorders(borders); if (curTask.IsCanceled == true) { worksheet.Cells[currentRow, 13].SetValue(0); } else { worksheet.Cells[currentRow, 13].SetValue(curTask.DateTimeDurationActual.GetValueOrDefault()); } worksheet.Cells[currentRow, 13].SetFontSize(fontSize); worksheet.Cells[currentRow, 13].SetBorders(borders); if (curTask.PaymentDateOrder.GetValueOrDefault().Year > 2000) { worksheet.Cells[currentRow, 14].SetValue(curTask.PaymentDateOrder.GetValueOrDefault()); } else { worksheet.Cells[currentRow, 14].SetValue(""); } worksheet.Cells[currentRow, 14].SetFormat(new CellValueFormat(dateFormat)); worksheet.Cells[currentRow, 14].SetFontSize(fontSize); worksheet.Cells[currentRow, 14].SetBorders(borders); worksheet.Cells[currentRow, 15].SetValue(double.Parse(curTask.CostActual.GetValueOrDefault().ToString())); worksheet.Cells[currentRow, 15].SetFormat(new CellValueFormat(currencyFormat)); worksheet.Cells[currentRow, 15].SetFontSize(fontSize); worksheet.Cells[currentRow, 15].SetBorders(borders); if (curTask.PaymentDateCalculated.GetValueOrDefault().Year > 2000) { worksheet.Cells[currentRow, 16].SetValue(curTask.PaymentDateCalculated.GetValueOrDefault()); } else { worksheet.Cells[currentRow, 16].SetValue(""); } worksheet.Cells[currentRow, 16].SetFormat(new CellValueFormat(dateFormat)); worksheet.Cells[currentRow, 16].SetFontSize(fontSize); worksheet.Cells[currentRow, 16].SetBorders(borders); //if (curTask.PaymentDateActual.GetValueOrDefault().Year > 2000) { // worksheet.Cells[currentRow, 17].SetValue(curTask.PaymentDateActual.GetValueOrDefault()); //} else { // worksheet.Cells[currentRow, 17].SetValue(""); //} //worksheet.Cells[currentRow,17].SetFormat(new CellValueFormat(dateFormat)); //worksheet.Cells[currentRow,17].SetFontSize(fontSize); //worksheet.Cells[currentRow,17].SetBorders(borders); string isCanc = "ΟΧΙ"; if (curTask.IsCanceled == true) { isCanc = "ΝΑΙ"; } worksheet.Cells[currentRow, 17].SetValue(isCanc); worksheet.Cells[currentRow, 17].SetFontSize(fontSize); worksheet.Cells[currentRow, 17].SetBorders(borders); worksheet.Cells[currentRow, 18].SetValue(curTask.Comments); worksheet.Cells[currentRow, 18].SetIsWrapped(true); worksheet.Cells[currentRow, 18].SetFontSize(fontSize); worksheet.Cells[currentRow, 18].SetBorders(borders); worksheet.Cells[currentRow, 19].SetValue(curTask.InvoceComments); worksheet.Cells[currentRow, 19].SetIsWrapped(true); worksheet.Cells[currentRow, 19].SetFontSize(fontSize); worksheet.Cells[currentRow, 19].SetBorders(borders); worksheet.Cells[currentRow, 20].SetValue(curTask.EnteredByUser); worksheet.Cells[currentRow, 20].SetFontSize(fontSize); worksheet.Cells[currentRow, 20].SetBorders(borders); worksheet.Cells[currentRow, 21].SetValue(curTask.DateStamp); worksheet.Cells[currentRow, 21].SetFormat(new CellValueFormat(dateFormat)); worksheet.Cells[currentRow, 21].SetFontSize(fontSize); worksheet.Cells[currentRow, 21].SetBorders(borders); currentRow++; } for (int i = 0; i < worksheet.Columns.Count; i++) { worksheet.Columns[i].AutoFitWidth(); } for (int i = 0; i < worksheet.Columns.Count; i++) { if (i == 18 || i == 19) { worksheet.Columns[i].SetWidth(new ColumnWidth(300, true)); } ColumnSelection columnSelection = worksheet.Columns[i]; ColumnWidth columnWidth = columnSelection.GetWidth().Value; double curColWidth = columnWidth.Value + 10; if (curColWidth > 2000) { curColWidth = 2000; } columnSelection.SetWidth(new ColumnWidth(curColWidth, columnWidth.IsCustom)); } ColumnSelection columnSelection4 = worksheet.Columns[4]; ColumnWidth columnWidth4 = columnSelection4.GetWidth().Value; double curColWidth4 = columnWidth4.Value + 10; if (curColWidth4 > 2000) { curColWidth4 = 2000; } columnSelection4.SetWidth(new ColumnWidth(curColWidth4, columnWidth4.IsCustom)); return(workbook); }
protected Workbook createWorkbook() { Workbook workbook = new Workbook(); workbook.Sheets.Add(SheetType.Worksheet); Worksheet worksheet = workbook.ActiveWorksheet; worksheet.Name = "KET " + forDate.ToString("dd-MM-yyyy"); List <TaskForH> tasks = getTasksForHelpers(forDate); prepareDocument(worksheet); int currentRow = 1; CellBorder border = new CellBorder(CellBorderStyle.Thin, tcBlack); CellBorders borders = new CellBorders(border, border, border, border, null, null, null, null); double fontSize = 12; foreach (TaskForH curTask in tasks) { worksheet.Cells[currentRow, 0].SetValue(curTask.Count.ToString()); worksheet.Cells[currentRow, 0].SetFontSize(fontSize); worksheet.Cells[currentRow, 0].SetBorders(borders); worksheet.Cells[currentRow, 1].SetValue(curTask.Customer); worksheet.Cells[currentRow, 1].SetFormat(new CellValueFormat("@")); worksheet.Cells[currentRow, 1].SetFontSize(fontSize); worksheet.Cells[currentRow, 1].SetBorders(borders); worksheet.Cells[currentRow, 2].SetValue(curTask.FromPlace); worksheet.Cells[currentRow, 2].SetFormat(new CellValueFormat("@")); worksheet.Cells[currentRow, 2].SetFontSize(fontSize); worksheet.Cells[currentRow, 2].SetBorders(borders); worksheet.Cells[currentRow, 3].SetValue(curTask.FromTime + " - " + curTask.ToTime); worksheet.Cells[currentRow, 3].SetFontSize(fontSize); worksheet.Cells[currentRow, 3].SetBorders(borders); worksheet.Cells[currentRow, 4].SetValue(curTask.Comments); worksheet.Cells[currentRow, 4].SetIsWrapped(true); worksheet.Cells[currentRow, 4].SetFontSize(fontSize); worksheet.Cells[currentRow, 4].SetBorders(borders); currentRow++; } for (int i = 0; i < worksheet.Columns.Count; i++) { worksheet.Columns[i].AutoFitWidth(); } for (int i = 0; i < worksheet.Columns.Count; i++) { if (i == 4) { worksheet.Columns[i].SetWidth(new ColumnWidth(500, true)); } ColumnSelection columnSelection = worksheet.Columns[i]; ColumnWidth columnWidth = columnSelection.GetWidth().Value; double curColWidth = columnWidth.Value + 10; if (curColWidth > 2000) { curColWidth = 2000; } columnSelection.SetWidth(new ColumnWidth(curColWidth, columnWidth.IsCustom)); } ColumnSelection columnSelection4 = worksheet.Columns[4]; ColumnWidth columnWidth4 = columnSelection4.GetWidth().Value; double curColWidth4 = columnWidth4.Value + 10; if (curColWidth4 > 2000) { curColWidth4 = 2000; } columnSelection4.SetWidth(new ColumnWidth(curColWidth4, columnWidth4.IsCustom)); return(workbook); }