代码摘要如下:
Object o = Type.Missing;
Microsoft.Office.Interop.Excel.Application objExcelApp = new Microsoft.Office.Interop.Excel.Application();
objExcelApp.DisplayAlerts = false;
objExcelApp.Visible = false;
Workbook objWorkbook = objExcelApp.Workbooks.Open("E:\\Book1.xls", o, o, o, o, o, o, o, o, o, o, o, o, o, o);
Worksheet objWorksheet = (Worksheet)objWorkbook.ActiveSheet;
Shapes objShapes = objWorksheet.Shapes;
int shapesCount = objShapes.Count;
PictureBox objPictureBox = new PictureBox();
Range objRange;
for (int i = 1; i < shapesCount; i++)
{
objShapes.Item(i).CopyPicture(Appearance.Button, XlCopyPictureFormat.xlBitmap);
IDataObject objIDO = (IDataObject)Clipboard.GetDataObject();
if (objIDO.GetDataPresent(DataFormats.Bitmap))
{
objPictureBox.Image = (Bitmap)objIDO.GetData(DataFormats.Bitmap);
objPictureBox.Image.Save("E:\\" + i+ ".jpg");
}
else
{
objPictureBox.Image = null;
}
}
objExcelApp.Quit();
objExcelApp = null;