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);