private void Exportar() { try { List <String> Titulos = new List <String>(); Titulos.Add("Reporte"); Int32 _fila = 2; Infrastructure.WinForms.Controls.ExcelAportes _xls = new Infrastructure.WinForms.Controls.ExcelAportes(1, Titulos, ""); Object[] _cabeceras = new Object[1]; DataTable _dt = _xls.RadGridViewToDataTable(grdItems, ref _cabeceras, grdItems.FilterDescriptors.Count > 0); /*****************************************/ if (_dt.Columns["Print"] != null) { _dt.Columns.Remove("Print"); } _cabeceras = new Object[_dt.Columns.Count]; for (int i = 0; i < _dt.Columns.Count; i++) { _cabeceras[i] = _dt.Columns[i].Caption; } /*******************************************/ if (_dt.Rows.Count > 0) { DateTime thisDay = DateTime.Today; List <String> _listTituloFiltro = new List <String>(); _listTituloFiltro.Add("GENERADO : " + thisDay.ToString("D")); _xls.InsertarTitulos(Presenter.Title, 1, ref _fila, 1, _listTituloFiltro, _cabeceras.Length); _xls.addDataArray(1, _cabeceras, 1, _fila + 2, true, true); _xls.addDataList(1, _dt, 1, _fila + 3, true, true); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido un error al exportar.", ex); } }
private void Exportar() { try { List <String> Titulos = new List <String>(); Titulos.Add("Reporte"); Int32 _fila = 2; Infrastructure.WinForms.Controls.ExcelAportes _xls = new Infrastructure.WinForms.Controls.ExcelAportes(1, Titulos, ""); Object[] _cabeceras = new Object[1]; DataTable _dt = _xls.RadGridViewToDataTable(grdItems, ref _cabeceras, grdItems.FilterDescriptors.Count > 0); if (_dt.Rows.Count > 0) { List <String> _listTituloFiltro = new List <String>(); _listTituloFiltro.Add(""); _xls.InsertarTitulos(Presenter.Title, 1, ref _fila, 1, _listTituloFiltro, _cabeceras.Length); _xls.addDataArray(1, _cabeceras, 1, _fila + 2, true, true); _xls.addDataList(1, _dt, 1, _fila + 3, true, true); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido un error al exportar.", ex); } }