diff --git a/ClosedXML/ClosedXML/..svnbridge/.svnbridge b/ClosedXML/ClosedXML/..svnbridge/.svnbridge index 42e94b8..5204a60 100644 --- a/ClosedXML/ClosedXML/..svnbridge/.svnbridge +++ b/ClosedXML/ClosedXML/..svnbridge/.svnbridge @@ -2,4 +2,8 @@ bugtraq:numbertruesvn:ignore*.suo TestResults *.user - \ No newline at end of file +svn:ignore*.suo +TestResults +*.user +ClosedXML.6.0.ReSharper +bugtraq:numbertrue \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs index db40014..32e46a4 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs @@ -356,7 +356,7 @@ workbook.Sheets = new Sheets(); var worksheets = WorksheetsInternal; - workbook.Sheets.Elements().Where(s => worksheets.Deleted.Contains(s.Id)).ForEach(s => s.Remove()); + workbook.Sheets.Elements().Where(s => worksheets.Deleted.Contains(s.Id)).ToList().ForEach(s => s.Remove()); foreach (Sheet sheet in workbook.Sheets.Elements()) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/ClosedXML_Examples.csproj b/ClosedXML/ClosedXML/ClosedXML_Examples/ClosedXML_Examples.csproj index 225874c..89e925f 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/ClosedXML_Examples.csproj +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/ClosedXML_Examples.csproj @@ -123,6 +123,7 @@ + diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/DeleteFewWorksheets.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/DeleteFewWorksheets.cs new file mode 100644 index 0000000..f585a17 --- /dev/null +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/DeleteFewWorksheets.cs @@ -0,0 +1,41 @@ +using System.IO; +using ClosedXML.Excel; + +namespace ClosedXML_Examples.Delete +{ + public class DeleteFewWorksheets:IXLExample + { + public void Create(string filePath) + { + string tempFile = ExampleHelper.GetTempFilePath(); + try + { + //Note: Prepare + { + var workbook = new XLWorkbook(); + workbook.Worksheets.Add("1"); + workbook.Worksheets.Add("2"); + workbook.Worksheets.Add("3"); + workbook.Worksheets.Add("4"); + workbook.SaveAs(tempFile); + } + + //Note: Delate few worksheet + { + var workbook = new XLWorkbook(tempFile); + workbook.Worksheets.Delete("1"); + workbook.Worksheets.Delete("2"); + workbook.SaveAs(filePath); + } + } + finally + { + if (File.Exists(tempFile)) + { + File.Delete(tempFile); + } + } + + } + } +} \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj b/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj index eefeed8..16fb664 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj @@ -156,6 +156,9 @@ + + +