public ActionResult ExportarDetallesCuenta(Guid id, DateTime?desde, DateTime?hasta)
{
var conv = System.ComponentModel.TypeDescriptor.GetConverter(new TipoMovimiento());
string nombre = DataContext.Usuarios.Single(u => u.IdUsuario == id).Nombre;
var detalles = ListaDetalles(id, desde, hasta).ToArray().Select(m => new
{
Fecha = m.FechaMovimiento,
//Fecha = m.FechaAlta,
Tipo = conv.ConvertToString((m.Transaccion == null ? TipoMovimiento.Pago :
//Tipo = conv.ConvertToString((m.TipoTransaccion == null ? TipoMovimiento.Pago :
(m.MontoDebe ?? 0.0) > (m.MontoHaber ?? 0.0) ? TipoMovimiento.ReservaAnulada :
TipoMovimiento.Reserva)),
Moneda = m.Moneda.Descripcion,
Monto = Decimal.Round((decimal)(m.MontoHaber - m.MontoDebe), 2),
MontoPesos = Decimal.Round((decimal)((m.MontoHaber - m.MontoDebe) * m.Cotizacion), 2),
Cliente = m.Transaccion != null ? m.Transaccion.Usuario.Nombre + " " + m.Transaccion.Usuario.Apellido : null
//Cliente = m.TipoTransaccion != null ? m.Usuario.Nombre + " " + m.Usuario.Apellido : null
}).ToArray();
var tabla = detalles.DataTableDeEnumerable();
var data = MsExcel.ExportToExcel(tabla);
return(new FileContentResult(data, "application/vnd.ms-excel")
{
FileDownloadName = String.Format("DetallesCuenta-{0}.xls", nombre)
});
}
private static void TestExcelUseSimple()
{
MsExcel.GetInstance().Open(@"E:\Temp\ToDelete\FirstWorbook.xlsx");
Workbook w = MsExcel.GetInstance().GetOpenWorkbookByName(@"FirstWorbook.xlsx");
if (w != null)
{
Console.WriteLine(w.WorksheetExists("newWorksheet6"));
}
Worksheet ws = w.GetWorksheetByName("newWorksheet6");
ws.SetCellValue(10, 20, "toto");
MsExcel.GetInstance()
.SetDisplayAlerts(false); // TODO: to refactor added to allow delete worksheet when Excel not visible
w.Save();
w.Close();
}
private static void TestAddList()
{
MsExcel.GetInstance().Open(@"E:\Temp\ToDelete\FirstWorbook.xlsx");
Workbook w = MsExcel.GetInstance().GetOpenWorkbookByName(@"FirstWorbook.xlsx");
w.AddWorksheet("TestWs");
List <List <string> > lls = new List <List <string> >();
for (int i = 0; i < 10; i++)
{
var ls = new List <string>();
for (int j = 0; j < 20; j++)
{
ls.Add((i + j).ToString());
}
lls.Add(ls);
}
Worksheet ws = w.GetWorksheetByName("TestWs");
ws.SetTable(lls, 5, 3);
w.Save();
w.Close();
}
static void Main(string[] args)
{
MsExcel ms = MsExcel.GetInstance();
}
private static void TestExcelUse()
{
MsExcel.GetInstance().Open(@"E:\Temp\ToDelete\FirstWorbook.xlsx");
List <Workbook> lw = MsExcel.GetInstance().GetOpenWorkbooks();
MsExcel.GetInstance()
.SetDisplayAlerts(false); // TODO: to refactor added to allow delete worksheet when Excel not visible
foreach (var w in lw)
{
Console.WriteLine(w.Name + " " + w.FullName);
if (!string.Equals(w.Name, "FirstWorbook.xlsx"))
{
continue;
}
w.AddWorksheet("newWorksheet6", true);
var l = w.WorksheetList;
foreach (var ws in l)
{
Console.WriteLine(" " + ws.Name);
Console.WriteLine(" Rows = " + ws.RowsCount);
Console.WriteLine(" Columns = " + ws.RowsCount);
for (int r = 1; r <= 5; r++)
{
for (int c = 1; c <= 4; c++)
{
Console.WriteLine(" " + ws.GetCellValue(r, c));
}
}
ws.SetCellValue(10, 10, "Test2and Test3");
ws.SetCellFontStyle(10, 10, "bold", 2, 5);
ws.SetCellValue(10, 1, "Test23 and Test24");
ws.SetCellFontStyle(10, 1, "bold");
ws.SetCellColor(10, 1, System.Drawing.Color.Red, 2, 4);
ws.SetCellValue(9, 2, "Test23 and \n Test24");
//List<List<string>> lls = ws.GetTable(1, 1, 4, 2);
w.Save();
List <List <string> > lls = ws.GetTableType(1, 1, 5, 2);
foreach (var row in lls)
{
foreach (var col in row)
{
Console.Write(col + " | ");
}
Console.WriteLine();
}
List <List <dynamic> > lld = ws.GetTableDynamic(1, 1, 5, 2);
foreach (var row in lld)
{
foreach (var col in row)
{
dynamic d = col;
if (d == null)
{
Console.Write("null" + " | ");
}
else
{
Console.Write(d.GetType() + " | ");
}
}
Console.WriteLine();
}
}
w.Close();
}
}
