public void TestRead() { XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("WithDrawing.xlsx"); IList pictures = wb.GetAllPictures(); //wb.GetAllPictures() should return the same instance across multiple calls Assert.AreSame(pictures, wb.GetAllPictures()); Assert.AreEqual(5, pictures.Count); String[] ext = { "jpeg", "emf", "png", "emf", "wmf" }; String[] mimetype = { "image/jpeg", "image/x-emf", "image/png", "image/x-emf", "image/x-wmf" }; for (int i = 0; i < pictures.Count; i++) { Assert.AreEqual(ext[i], ((XSSFPictureData)pictures[i]).SuggestFileExtension()); Assert.AreEqual(mimetype[i], ((XSSFPictureData)pictures[i]).MimeType); } int num = pictures.Count; byte[] pictureData = { 0xA, 0xB, 0XC, 0xD, 0xE, 0xF }; int idx = wb.AddPicture(pictureData, PictureType.JPEG); Assert.AreEqual(num + 1, pictures.Count); //idx is 0-based index in the #pictures array Assert.AreEqual(pictures.Count - 1, idx); XSSFPictureData pict = (XSSFPictureData)pictures[idx]; Assert.AreEqual("jpeg", pict.SuggestFileExtension()); Assert.IsTrue(Arrays.Equals(pictureData, pict.Data)); }
public void Test53568() { XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("53568.xlsx"); List <XSSFPictureData> pictures = wb.GetAllPictures() as List <XSSFPictureData>; Assert.IsNotNull(pictures); Assert.AreEqual(4, pictures.Count); XSSFSheet sheet1 = wb.GetSheetAt(0) as XSSFSheet; List <XSSFShape> shapes1 = (sheet1.CreateDrawingPatriarch() as XSSFDrawing).GetShapes(); Assert.IsNotNull(shapes1); Assert.AreEqual(5, shapes1.Count); for (int i = 0; i < wb.NumberOfSheets; i++) { XSSFSheet sheet = wb.GetSheetAt(i) as XSSFSheet; XSSFDrawing Drawing = sheet.CreateDrawingPatriarch() as XSSFDrawing; foreach (XSSFShape shape in Drawing.GetShapes()) { if (shape is XSSFPicture) { XSSFPicture pic = (XSSFPicture)shape; XSSFPictureData picData = pic.PictureData as XSSFPictureData; Assert.IsNotNull(picData); } } } }
//public XSSFChart CreateChart(IClientAnchor anchor) //{ // return CreateChart((XSSFClientAnchor)anchor); //} /** * Add the indexed picture to this Drawing relations * * @param pictureIndex the index of the picture in the workbook collection of pictures, * {@link Npoi.Core.xssf.usermodel.XSSFWorkbook#getAllPictures()} . */ internal PackageRelationship AddPictureReference(int pictureIndex) { XSSFWorkbook wb = (XSSFWorkbook)GetParent().GetParent(); XSSFPictureData data = (XSSFPictureData)wb.GetAllPictures()[pictureIndex]; PackagePartName ppName = data.GetPackagePart().PartName; PackageRelationship rel = GetPackagePart().AddRelationship(ppName, TargetMode.Internal, XSSFRelation.IMAGES.Relation); AddRelation(rel.Id, new XSSFPictureData(data.GetPackagePart(), rel)); return(rel); }
/** * Return the dimension of the embedded image in pixel * * @return image dimension in pixels */ public Size GetImageDimension() { XSSFPictureData picData = PictureData as XSSFPictureData; return(GetImageDimension(picData.GetPackagePart(), picData.PictureType)); }