public static Byte[] ToExcel(F0Model.FilteredData data)
{
MemoryStream ms;
UInt32 zoomScale = 100;
String fontName = "Arial";
Double fontSize = 10;
using (Spreadsheet spreadsheet = new Spreadsheet(1)) // один лист
{
spreadsheet.SetSheetName(1, "Отчёт МДВ 1");
spreadsheet.SetZoomScale(zoomScale);
spreadsheet.SetFont(0, fontName, fontSize); // default font
spreadsheet.SetFont(1, fontName, fontSize); // data font
UInt32 dxfId = spreadsheet.AppendDifferentialFormat("font-weight: bold;");
XlWorksheet[] wss = spreadsheet.Wss;
GenerateColumns(wss[0], Md.Table1Columns);
GenrateSheetData0(wss[0], data);
//GenerateMergeCells(wss[0]);
///GenerateConditionalFormatting(wss[0], dxfId, t);
///GenerateBackgroundColor(wss[0], t);
GeneratePageSetup(wss[0]);
ms = spreadsheet.CreateDocument();
}
return(ms.ToArray());
}
