| using Microsoft.VisualStudio.TestTools.UnitTesting; |
| using OfficeOpenXml; |
| using System; |
| using System.Collections.Generic; |
| using System.IO; |
| using System.Linq; |
| using System.Text; |
| |
| namespace EPPlusTest |
| { |
| [TestClass] |
| public class DTS_FailingTests |
| { |
| |
| [TestMethod] |
| public void DeleteWorksheetWithReferencedImage() |
| { |
| var ms = new MemoryStream(); |
| using (var pck = new ExcelPackage()) |
| { |
| var ws = pck.Workbook.Worksheets.Add("original"); |
| ws.Drawings.AddPicture("Pic1", Properties.Resources.Test1); |
| pck.Workbook.Worksheets.Copy("original", "copy"); |
| pck.SaveAs(ms); |
| } |
| ms.Position = 0; |
| |
| using (var pck = new ExcelPackage(ms)) |
| { |
| var ws = pck.Workbook.Worksheets["original"]; |
| pck.Workbook.Worksheets.Delete(ws); |
| pck.Save(); |
| } |
| } |
| |
| [TestMethod] |
| public void CopyAndDeleteWorksheetWithImage() |
| { |
| using (var pck = new ExcelPackage(new MemoryStream())) |
| { |
| var ws = pck.Workbook.Worksheets.Add("original"); |
| ws.Drawings.AddPicture("Pic1", Properties.Resources.Test1); |
| pck.Workbook.Worksheets.Copy("original", "copy"); |
| pck.Workbook.Worksheets.Delete(ws); |
| pck.Save(); |
| } |
| } |
| } |
| } |