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));
}
