C# Excel单元格合并及图片插入

///合并"A1","B1"

Range range = worksheet.get_Range("A1","B1");

range.MergeCells = true;

///插入图片C:\\CA\\ceshi1(测试).bmp

float PicLeft, PicTop, PicWidth, PicHeight;PicLeft = Convert.ToSingle(range.Left);PicTop = Convert.ToSingle(range.Top);PicWidth = Convert.ToSingle(range.Width);//PicWidth = 50;PicHeight = Convert.ToSingle(range.Height);workSheet.Shapes.AddPicture("C:\\CA\\ceshi1(测试).bmp", MsoTriState.msoFalse,MsoTriState.msoTrue, PicLeft, PicTop, PicWidth, PicHeight);