예제 #1
0
        public Image copyChart()
        {
            // ChartObjects chartObjects = sheet.ChartObjects();
            //xlWorkbook.Charts.Select("Retenção_PDS");
            //System.Windows.Forms.IDataObject data = System.Windows.Forms.Clipboard.GetDataObject();
            //xlWorkbook.ActiveChart.CopyPicture(XlPictureAppearance.xlScreen, XlCopyPictureFormat.xlBitmap);
            //
            ChartObjects charts = (ChartObjects)sheet.ChartObjects(Type.Missing);

            charts.Select("Retenção_PDS");
            ChartObject chart = charts.Item(1);

            System.Windows.Forms.IDataObject data = System.Windows.Forms.Clipboard.GetDataObject();
            chart.Chart.CopyPicture(XlPictureAppearance.xlScreen, XlCopyPictureFormat.xlBitmap);
            Image t = (Image)data.GetData(System.Windows.Forms.DataFormats.Bitmap, true);

            return(t);
        }