问题描述:如何向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");
- }
复制代码
效果截图:
示例下载:点击下载 |