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