Either way, the clipboard APIs will not work on a non-STA thread.
Romys's suggestion is a handy shortcut, but GetImage() is still going to do the same thing that your code is already doing, so if your code doesn't work as written, there is no reason to think that GetImage() will.Īre you developing a VSTO application? The fact that you are getting a suggests that either you are not or that you are trying to execute this code on a background thread. This code should work as written (and I've verified that it works in VSTO 2008 / Office 2007). How can I get range that includs Objects in Excel. ) does not contain Objects like Shapes, Graphs. How can I save bitmap from clipboard that is copied from Excel?Ģ. Clipboard.GetDataObject always returns null.
How can I resolve the problems below? Or any other suggestions?ġ. If (iData.GetDataPresent(DataFormats.Bitmap))īitmap bmp = (Bitmap)iData.GetData(DataFormats.Bitmap) If (null != iData) // ?iData is always null IDataObject iData = Clipboard.GetDataObject() // ? ORange.Copy() // copy the range to the Clipboard. ORange = sheetExcel.get_Range("A1", br) // Select using cells Using Excel = īr = (.XlCellType.xlCellTypeLastCell, )
0 kommentar(er)
