excel file damaged after adding images and saving

[rick-yang1987]

NPOI Version

2.6.2

File Type

• XLSX

Upload the Excel File

项目资金预算(原文件).xlsx

Reproduce Steps

1、open file
2、add image
3、save

Issue Description

[tonyqus]

Can you share the code of how you add the image?

[rick-yang1987]

static Boolean InsertImage(XSSFWorkbook workbook, ISheet sheet, byte[] imageData, int row, int column, int endRows, int endCols) { try { XSSFCellStyle style = (XSSFCellStyle)workbook.CreateCellStyle(); style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center; style.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center; XSSFDrawing patriarch = (XSSFDrawing)sheet.CreateDrawingPatriarch(); XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, column, row, endCols + 1, endRows + 1); anchor.AnchorType = AnchorType.MoveAndResize; int pictureIndex = workbook.AddPicture(imageData, PictureType.BMP); XSSFPicture picture = (XSSFPicture)patriarch.CreatePicture(anchor, pictureIndex); picture.LineStyle = LineStyle.None; } catch(System.Exception ex) { return false; } return true; }