如何导出图片到Excel

登录

问题描述：如何向Spread 中添加图片，并且导出到Excel 中。
问题解答：通过ImageCellType 添加图片到单元格后，使用SaveExcel保存为Excel即可。
关键代码：

private void AddImageToCell()
{
FarPoint.Win.Spread.CellType.ImageCellType icelltype = new FarPoint.Win.Spread.CellType.ImageCellType();
icelltype.Style = FarPoint.Win.RenderStyle.Stretch;
icelltype.TransparencyColor = Color.Black;
icelltype.TransparencyTolerance = 100;
fpSpread1.Sheets[0].Rows[0].CellType = icelltype;
System.Drawing.Image image = (System.Drawing.Image)Properties.Resources.ResourceManager.GetObject("Tulips");
System.IO.MemoryStream stream = new System.IO.MemoryStream();
byte[] bytes;
string str;
image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
stream.Seek(0, System.IO.SeekOrigin.Begin);
bytes = stream.GetBuffer();
str = System.Convert.ToBase64String(bytes);
fpSpread1.Sheets[0].Cells[0, 0].Value = image;
fpSpread1.Sheets[0].Cells[0, 0].Text = "test";
fpSpread1.Sheets[0].Protect = false;
this.fpSpread1.SaveExcel("test.xls");
}

复制代码

效果截图：

示例下载：点击下载

		自动登录	找回密码
密码			立即注册

[WinForms] 如何导出图片到Excel