protected void rg1_ExcelMLExportRowCreated(object sender, GridExportExcelMLRowCreatedArgs e)
{
if (e.RowType == GridExportExcelMLRowType.DataRow)
{
if (!isConfigured)
{
//Set Worksheet name
// e.Worksheet.Name = "Hoja";
//Set Column widths
foreach (ColumnElement column in e.Worksheet.Table.Columns)
{
if (e.Worksheet.Table.Columns.IndexOf(column) == 7)
{
column.Attributes["ss:Width"] = "180"; //set width 180 a columna Nombre
}
else
{
column.Attributes["ss:Width"] = "80"; //set width 80 al resto de columnas
}
}
//Set Page options
PageSetupElement pageSetup = e.Worksheet.WorksheetOptions.PageSetup;
pageSetup.PageLayoutElement.IsCenteredVertical = true;
pageSetup.PageLayoutElement.IsCenteredHorizontal = true;
pageSetup.PageMarginsElement.Left = 0.5;
pageSetup.PageMarginsElement.Top = 0.5;
pageSetup.PageMarginsElement.Right = 0.5;
pageSetup.PageMarginsElement.Bottom = 0.5;
pageSetup.PageLayoutElement.PageOrientation = PageOrientationType.Landscape;
//Freeze panes
e.Worksheet.WorksheetOptions.AllowFreezePanes = true;
e.Worksheet.WorksheetOptions.LeftColumnRightPaneNumber = 1;
e.Worksheet.WorksheetOptions.TopRowBottomPaneNumber = 1;
e.Worksheet.WorksheetOptions.SplitHorizontalOffset = 1;
e.Worksheet.WorksheetOptions.SplitVerticalOffest = 1;
isConfigured = true;
}
}
}
protected void OnGridInvoiceExcelMLExportRowCreated(object source, GridExportExcelMLRowCreatedArgs e)
{
if (e.RowType == GridExportExcelMLRowType.DataRow)
{
//if (e.Row.Cells[0] != null && ((string)e.Row.Cells[0].Data.DataItem).Contains("U"))
//{
// e.Row.Cells[0].StyleValue = "MyCustomStyle";
//}
//else
//{
//}
}
else if (e.RowType == GridExportExcelMLRowType.HeaderRow)
{
if (e.Row.Cells[0] != null)
{
e.Row.Cells[0].StyleValue = "MyCustomStyle";
}
}
}
