本帖最后由 Richard.Ma 于 2021-4-6 16:40 编辑
我看了一下你的spreadjs代码,其中的src() ,实际上保存的是此图片的base64编码而非路径
因此,在GC中添加同样的图片,只需要获取此base64字符串,转换为MemoryStream后插入表格即可
- //转换
- public MemoryStream ConvertBase64ToStream(string base64String)
- {
- byte[] imageBytes = Convert.FromBase64String(base64String);
- MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length);
- ms.Write(imageBytes, 0, imageBytes.Length);
- return ms;
- }
- void addImage(string base64str) {
- Workbook workbook = new Workbook();
- var worksheet = workbook.Worksheets[0];
- Image img = ConvertBase64ToImage(base64str);
- int df = img.Width;
- MemoryStream ms = ConvertBase64ToStream(base64str);
- worksheet.Shapes.AddPicture(ms, ImageType.PNG, 100, 100, 200, 200);
- workbook.Save(@"D:\Projects\0331.xlsx");
- }
复制代码
|