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 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 Bug47668()
{
XSSFWorkbook workbook = XSSFTestDataSamples.OpenSampleWorkbook("47668.xlsx");
IList allPictures = workbook.GetAllPictures();
Assert.AreEqual(1, allPictures.Count);
PackagePartName imagePartName = PackagingUriHelper
.CreatePartName("/xl/media/image1.jpeg");
PackagePart imagePart = workbook.Package.GetPart(imagePartName);
Assert.IsNotNull(imagePart);
foreach (XSSFPictureData pictureData in allPictures)
{
PackagePart picturePart = pictureData.GetPackagePart();
Assert.AreSame(imagePart, picturePart);
}
XSSFSheet sheet0 = (XSSFSheet)workbook.GetSheetAt(0);
XSSFDrawing Drawing0 = (XSSFDrawing)sheet0.CreateDrawingPatriarch();
XSSFPictureData pictureData0 = (XSSFPictureData)Drawing0.GetRelations()[0];
byte[] data0 = pictureData0.Data;
CRC32 crc0 = new CRC32();
crc0.Update(data0);
XSSFSheet sheet1 = workbook.GetSheetAt(1) as XSSFSheet;
XSSFDrawing Drawing1 = sheet1.CreateDrawingPatriarch() as XSSFDrawing;
XSSFPictureData pictureData1 = (XSSFPictureData)Drawing1.GetRelations()[0];
byte[] data1 = pictureData1.Data;
CRC32 crc1 = new CRC32();
crc1.Update(data1);
Assert.AreEqual(crc0.Value, crc1.Value);
workbook.Close();
}
