private void SetCellValue(object value, CellExportedEventArgs e, WorksheetCell cell, IMeasure measured) { if (e.Field.Name == "Item.ManageRequestStatus" || e.Field.Name == "Item.Request.ManageRequestStatus") { cell.Value = Expl_User_Journal_ManagePU_Request_List.StatusToString(Convert.ToInt16(value)); return; } ExportHelper.SetCellValue(cell, value, measured, e.Field.Tag, e.Field.Name); }
protected void ugrdEEP_CellExported(object sender, CellExportedEventArgs e) { int iRdex = e.CurrentRowIndex; int iCdex = e.CurrentColumnIndex; if (iRdex > 6) { if (iCdex % 3 == 2 && e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value != null) { if (e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value.ToString() != "-") { string str = e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value.ToString(); char[] sep = { '<', '>' }; Array a = str.Split(sep); e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value = a.GetValue(2); } } } }
void FormatExportValue(CellExportedEventArgs e, IMeasure measured) { if (e.Record.Cells.Count <= e.Field.Index) { return; } var value = e.Record.Cells[e.Field.Index].Value; if (value is string) { FilteringString(e, value as string); return; } var cell = e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex]; SetCellValue(value, e, cell, measured); }
/// <summary> /// Отфильтровываем недо символы /// </summary> /// <param name="e"></param> /// <param name="value"></param> void FilteringString(CellExportedEventArgs e, string value) { if (e == null || e.Field == null) { return; } switch (e.Field.Name) { case "StringData": value = FileAdapter.RemoveBadChar(value, 1024, " "); break; default: return; } var cell = e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex]; cell.Value = value; }
protected void ugrdEEP_CellExported(object sender, CellExportedEventArgs e) { int iRdex = e.CurrentRowIndex; int iCdex = e.CurrentColumnIndex; string strEname = string.Empty; if (iRdex > 4) { if (iCdex > 6) { strEname = ugridKpiTargetList.Rows[iRdex - 5].Cells.FromKey("THRESHOLD_ENAME").Text; string[] strEnameA = strEname.Split('*'); string strEname1 = strEnameA.GetValue(iCdex - 7).ToString().Split('^').GetValue(0).ToString(); string strEname2 = strEnameA.GetValue(iCdex - 7).ToString().Split('^').GetValue(1).ToString(); string str = e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value.ToString(); char[] sep = { '<', '>' }; Array a = str.Split(sep); e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value = a.GetValue(0).ToString().Replace(" ", " [") + (strEname1.Length > 4 ? strEname1.Substring(0, 4) : strEname1) + "] \n" + a.GetValue(4).ToString().Replace(" ", " [") + (strEname2.Length > 4 ? strEname2.Substring(0, 4) : strEname2) + "] "; e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].CellFormat.WrapText = ExcelDefaultableBoolean.True; } } }
protected void ugrdEEP_CellExported(object sender, CellExportedEventArgs e) { }
protected void UltraWebGridExcelExporter_CellExported(object sender, CellExportedEventArgs e) { int iRdex = e.CurrentRowIndex; int iCdex = e.CurrentColumnIndex; if (iRdex != 0) { if ((((iCdex == 0) || (iCdex == 4)) || ((iCdex == 8) || (iCdex == 11))) && (e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value != null)) { e.CurrentWorksheet.Columns[iCdex].Width = 0x1964; } e.CurrentWorksheet.Rows[iRdex].Height = 350; } else if (iRdex != 0) { e.CurrentWorksheet.Rows[iRdex].Height = 350; } }
protected void UltraWebGridExcelExporter_CellExported(object sender, CellExportedEventArgs e) { int iRdex = e.CurrentRowIndex; int iCdex = e.CurrentColumnIndex; if (iRdex != 0) { if ((e.GridColumn.Key.ToLower() == "otdate") && (e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value != null)) { e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value = string.Format("{0:" + "yyyy/MM/dd" + "}", Convert.ToDateTime(e.CurrentWorksheet.Rows[iRdex].Cells[iCdex].Value)); } e.CurrentWorksheet.Rows[iRdex].Height = 350; } }
void OnCellExported(object sender, CellExportedEventArgs e) { var value = e.Value; if (value == null) { return; } var exporter = sender as ProryvDataPresenterExcelExporter; var measured = exporter != null ? exporter.Measured : null; if (value is string) { FormatExportValue(e, measured); return; } WorksheetRow row = null; try { row = e.CurrentWorksheet.Rows[e.CurrentRowIndex]; } catch { } if (row == null) { return; } WorksheetCell cell = null; try { cell = row.Cells[e.CurrentColumnIndex]; } catch {} if (cell == null) { return; } //var value = e.Value; System.Windows.Style cellStyle = e.Field.Settings.EditorStyle; if (cellStyle != null) { var cSetter = cellStyle.Setters.FirstOrDefault(s => s is Setter && (s as Setter).Property.Name.Equals(TextEditorBase.ValueToDisplayTextConverterProperty.Name)) as Setter; if (cSetter != null) { var c = cSetter.Value as IValueConverter; if (c != null) { cell.Value = c.Convert(value, null, null, null); return; } //e.FormatSettings.FontColor = (fgSetter.Value as SolidColorBrush).Color; //e.FormatSettings.FillPatternForegroundColor = (bgSetter.Value as SolidColorBrush).Color; } } //var measured = e.Record.DataPresenter.FindParent<IMeasure>(); SetCellValue(value, e, cell, measured); }