Spire.xls将图片放入Excel单元格

//创建Workbook对象

  Workbook workbook = new Workbook();

  //获取第一张工作表

  Worksheet sheet = workbook.Worksheets[0];

  //指定列宽、行高

  sheet.Columns[0].ColumnWidth = 50;

  sheet.Rows[0].RowHeight = 160;



  //加载图片，添加到指定单元格

  ExcelPicture picture = sheet.Pictures.Add(1,1, "tp.png");

  //指定图片宽度和高度

  picture.Width = 300;

  picture.Height = 180;



  //通过LeftColumnOffset和TopRowOffset属性值设置图片在单元格中的横向、纵向对齐

  picture.LeftColumnOffset = 75;

  picture.TopRowOffset = 20;



  //保存文档

  workbook.SaveToFile("result.xlsx", FileFormat.Version2013);

  System.Diagnostics.Process.Start("result.xlsx");