Пример #1
0
        private void GestionDuGraphe(Document document, List <int> valeursDuGraphe)
        {
            foreach (InlineShape inlineShape in document.InlineShapes)
            {
                if (inlineShape.HasChart == MsoTriState.msoTrue)
                {
                    Microsoft.Office.Interop.Word.Chart graphique = inlineShape.Chart;

                    Workbook  wb = graphique.ChartData.Workbook;
                    Worksheet ws = wb.Worksheets["Feuil1"];

                    ws.Range["B2"].Value = valeursDuGraphe[0];
                    ws.Range["B2"].Value = valeursDuGraphe[1];
                    ws.Range["C3"].Value = valeursDuGraphe[2];
                    ws.Range["D4"].Value = valeursDuGraphe[3];
                    graphique.Refresh();
                    graphique = null;

                    // Pour fermer proprement Excel
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(ws);
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(wb);

                    ws = null;
                    wb = null;
                }
            }
        }