public void exec(System.Data.DataTable dt)
{
System.IO.File.Copy(template, copie, true);
SpreadsheetDocument myWorkbook = SpreadsheetDocument.Open(copie, true);
WorkbookPart workbookPart = myWorkbook.WorkbookPart;
WorksheetPart wsPart = XcelWin.getWorksheetPartByName(myWorkbook, "Feuil1");
//DocumentFormat.OpenXml.Spreadsheet.Columns columns = new Columns();
//for(int i=0;i<size.Length;i++)
//{
// DocumentFormat.OpenXml.Spreadsheet.Column c = new Column();
// c.CustomWidth = true;
// c.Min = (uint) i+1;
// c.Max = (uint) i+1;
// c.Width = size[i];
// columns.Append(c);
//}
//DocumentFormat.OpenXml.Spreadsheet.Columns cc = new Columns();
//cc.Append(new DocumentFormat.OpenXml.Spreadsheet.Column() { Min = 1, Max = 3, CustomWidth = true, Width = 5 });
////wsPart.Worksheet.Append(cc);
//Worksheet ws = wsPart.Worksheet;
//ws.Append(cc);
DrawingsPart drawingsPart1 = wsPart.AddNewPart <DrawingsPart>("rId1");
XcelWin.GenerateDrawingsPart1Content(drawingsPart1);
ChartPart chartPart1 = drawingsPart1.AddNewPart <ChartPart>("rId1");
XcelWin.GenerateChartPart1Content(chartPart1);
Drawing drawing1 = new Drawing()
{
Id = "rId1"
};
wsPart.Worksheet.Append(drawing1);
workbookPart.Workbook.Save();
myWorkbook.Close();
}
