diff --git a/ClosedXML/ClosedXML/ClosedXML.sln b/ClosedXML/ClosedXML/ClosedXML.sln index 6f03ef0..cfa7fa3 100644 --- a/ClosedXML/ClosedXML/ClosedXML.sln +++ b/ClosedXML/ClosedXML/ClosedXML.sln @@ -135,9 +135,6 @@ GlobalSection(SolutionProperties) = preSolution HideSolutionNode = FALSE EndGlobalSection - GlobalSection(Performance) = preSolution - HasPerformanceSessions = true - EndGlobalSection GlobalSection(TestCaseManagementSettings) = postSolution CategoryFile = ClosedXML.vsmdi EndGlobalSection diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCellsCollection.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCellsCollection.cs index 2d4d867..2990966 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCellsCollection.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCellsCollection.cs @@ -1,11 +1,13 @@ using System; using System.Collections.Generic; +using System.Linq; namespace ClosedXML.Excel { internal class XLCellsCollection { - private readonly Dictionary _cellsDictionary = new Dictionary(); + + private readonly Dictionary> rowsCollection = new Dictionary>(); public Dictionary ColumnsUsed = new Dictionary(); public HashSet Deleted = new HashSet(); @@ -34,7 +36,13 @@ IncrementUsage(RowsUsed, row); IncrementUsage(ColumnsUsed, column); - _cellsDictionary.Add(new XLSheetPoint(row, column), cell); + Dictionary columnsCollection; + if (!rowsCollection.TryGetValue(row, out columnsCollection)) + { + columnsCollection = new Dictionary(); + rowsCollection.Add(row, columnsCollection); + } + columnsCollection.Add(column, cell); if (row > MaxRowUsed) MaxRowUsed = row; if (column > MaxColumnUsed) MaxColumnUsed = column; var sp = new XLSheetPoint(row, column); @@ -67,7 +75,7 @@ RowsUsed.Clear(); ColumnsUsed.Clear(); - _cellsDictionary.Clear(); + rowsCollection.Clear(); MaxRowUsed = 0; MaxColumnUsed = 0; } @@ -84,24 +92,31 @@ DecrementUsage(ColumnsUsed, row); var sp = new XLSheetPoint(row, column); Deleted.Add(sp); - _cellsDictionary.Remove(sp); - //_cells[row, column] = null; + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(row, out columnsCollection)) + { + columnsCollection.Remove(column); + } } internal IEnumerable GetCells(Int32 rowStart, Int32 columnStart, - Int32 rowEnd, Int32 columnEnd, + Int32 rowEnd, Int32 columnEnd, Func predicate = null) { int finalRow = rowEnd > MaxRowUsed ? MaxRowUsed : rowEnd; int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd; for (int ro = rowStart; ro <= finalRow; ro++) { - for (int co = columnStart; co <= finalColumn; co++) + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(ro, out columnsCollection)) { - XLCell cell; - if (_cellsDictionary.TryGetValue(new XLSheetPoint(ro, co), out cell) - && (predicate == null || predicate(cell))) - yield return cell; + for (int co = columnStart; co <= finalColumn; co++) + { + XLCell cell; + if (columnsCollection.TryGetValue(co, out cell) + && (predicate == null || predicate(cell))) + yield return cell; + } } } } @@ -115,15 +130,20 @@ int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd; for (int ro = rowStart; ro <= finalRow; ro++) { - for (int co = columnStart; co <= finalColumn; co++) + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(ro, out columnsCollection)) { - XLCell cell; - if (_cellsDictionary.TryGetValue(new XLSheetPoint(ro, co), out cell) + for (int co = columnStart; co <= finalColumn; co++) + { + XLCell cell; + if (columnsCollection.TryGetValue(co, out cell) && !cell.IsEmpty(includeFormats) && (predicate == null || predicate(cell))) - yield return cell; + yield return cell; + } } } + } public XLSheetPoint FirstPointUsed(Int32 rowStart, Int32 columnStart, @@ -133,7 +153,7 @@ int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd; var firstRow = FirstRowUsed(rowStart, columnStart, finalRow, finalColumn, includeFormats, predicate); - if (firstRow == 0) return new XLSheetPoint(0,0); + if (firstRow == 0) return new XLSheetPoint(0, 0); var firstColumn = FirstColumnUsed(rowStart, columnStart, finalRow, finalColumn, includeFormats, predicate); if (firstColumn == 0) return new XLSheetPoint(0, 0); @@ -156,22 +176,27 @@ return new XLSheetPoint(firstRow, firstColumn); } - public int FirstRowUsed(int rowStart, int columnStart, int rowEnd, int columnEnd, Boolean includeFormats, + public int FirstRowUsed(int rowStart, int columnStart, int rowEnd, int columnEnd, Boolean includeFormats, Func predicate = null) { int finalRow = rowEnd > MaxRowUsed ? MaxRowUsed : rowEnd; int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd; for (int ro = rowStart; ro <= finalRow; ro++) { - for (int co = columnStart; co <= finalColumn; co++) + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(ro, out columnsCollection)) { - XLCell cell; - if (_cellsDictionary.TryGetValue(new XLSheetPoint(ro, co), out cell) + for (int co = columnStart; co <= finalColumn; co++) + { + XLCell cell; + if (columnsCollection.TryGetValue(co, out cell) && !cell.IsEmpty(includeFormats) && (predicate == null || predicate(cell))) - return ro; + return ro; + } } } + return 0; } @@ -179,17 +204,22 @@ { int finalRow = rowEnd > MaxRowUsed ? MaxRowUsed : rowEnd; int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd; - for (int co = columnStart; co <= finalColumn; co++) + for (int ro = rowStart; ro <= finalRow; ro++) { - for (int ro = rowStart; ro <= finalRow; ro++) + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(ro, out columnsCollection)) { - XLCell cell; - if (_cellsDictionary.TryGetValue(new XLSheetPoint(ro, co), out cell) + for (int co = columnStart; co <= finalColumn; co++) + { + XLCell cell; + if (columnsCollection.TryGetValue(co, out cell) && !cell.IsEmpty(includeFormats) && (predicate == null || predicate(cell))) - return co; + return co; + } } } + return 0; } @@ -198,16 +228,19 @@ { int finalRow = rowEnd > MaxRowUsed ? MaxRowUsed : rowEnd; int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd; - for (int ro = finalRow; ro >= rowStart; ro--) { - for (int co = finalColumn; co >= columnStart; co--) + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(ro, out columnsCollection)) { - XLCell cell; - if (_cellsDictionary.TryGetValue(new XLSheetPoint(ro, co), out cell) - && !cell.IsEmpty(includeFormats) + for (int co = finalColumn; co >= columnStart; co--) + { + XLCell cell; + if (columnsCollection.TryGetValue(co, out cell) + && !cell.IsEmpty(includeFormats) && (predicate == null || predicate(cell))) - return ro; + return ro; + } } } return 0; @@ -215,20 +248,25 @@ public int LastColumnUsed(int rowStart, int columnStart, int rowEnd, int columnEnd, Boolean includeFormats, Func predicate = null) { + int maxCo = 0; int finalRow = rowEnd > MaxRowUsed ? MaxRowUsed : rowEnd; int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd; - for (int co = finalColumn; co >= columnStart; co--) + for (int ro = finalRow; ro >= rowStart; ro--) { - for (int ro = finalRow; ro >= rowStart; ro--) + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(ro, out columnsCollection)) { - XLCell cell; - if (_cellsDictionary.TryGetValue(new XLSheetPoint(ro, co), out cell) - && !cell.IsEmpty(includeFormats) + for (int co = finalColumn; co >= columnStart && co > maxCo; co--) + { + XLCell cell; + if (columnsCollection.TryGetValue(co, out cell) + && !cell.IsEmpty(includeFormats) && (predicate == null || predicate(cell))) - return co; + maxCo = co; + } } } - return 0; + return maxCo; } public void RemoveAll(Int32 rowStart, Int32 columnStart, @@ -238,11 +276,14 @@ int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd; for (int ro = rowStart; ro <= finalRow; ro++) { - for (int co = columnStart; co <= finalColumn; co++) + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(ro, out columnsCollection)) { - var sp = new XLSheetPoint(ro, co); - if (_cellsDictionary.ContainsKey(sp)) - Remove(sp); + for (int co = columnStart; co <= finalColumn; co++) + { + if (columnsCollection.ContainsKey(co)) + Remove(ro, co); + } } } } @@ -252,14 +293,16 @@ { int finalRow = rowEnd > MaxRowUsed ? MaxRowUsed : rowEnd; int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd; - for (int ro = rowStart; ro <= finalRow; ro++) { - for (int co = columnStart; co <= finalColumn; co++) + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(ro, out columnsCollection)) { - var sp = new XLSheetPoint(ro, co); - if (_cellsDictionary.ContainsKey(sp)) - yield return sp; + for (int co = columnStart; co <= finalColumn; co++) + { + if (columnsCollection.ContainsKey(co)) + yield return new XLSheetPoint(ro, co); + } } } } @@ -268,15 +311,18 @@ { if (row > MaxRowUsed || column > MaxColumnUsed) return null; - var sp = new XLSheetPoint(row, column); - XLCell cell; - return _cellsDictionary.TryGetValue(sp, out cell) ? cell : null; + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(row, out columnsCollection)) + { + XLCell cell; + return columnsCollection.TryGetValue(column, out cell) ? cell : null; + } + return null; } - public XLCell GetCell(XLSheetPoint sheetPoint) + public XLCell GetCell(XLSheetPoint sp) { - XLCell cell; - return _cellsDictionary.TryGetValue(sheetPoint, out cell) ? cell : null; + return GetCell(sp.Row, sp.Column); } internal void SwapRanges(XLSheetRange sheetRange1, XLSheetRange sheetRange2, XLWorksheet worksheet) @@ -297,10 +343,10 @@ //if (cell1 != null) //{ - cell1.Address = new XLAddress(cell1.Worksheet, sp2.Row, sp2.Column, false, false); - Remove(sp1); - //if (cell2 != null) - Add(sp1, cell2); + cell1.Address = new XLAddress(cell1.Worksheet, sp2.Row, sp2.Column, false, false); + Remove(sp1); + //if (cell2 != null) + Add(sp1, cell2); //} //if (cell2 == null) continue; @@ -308,7 +354,7 @@ cell2.Address = new XLAddress(cell2.Worksheet, sp1.Row, sp1.Column, false, false); Remove(sp2); //if (cell1 != null) - Add(sp2, cell1); + Add(sp2, cell1); } } } @@ -322,27 +368,37 @@ { for (int ro = 1; ro <= MaxRowUsed; ro++) { - for (int co = 1; co <= MaxColumnUsed; co++) + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(ro, out columnsCollection)) { - XLCell cell; - if (_cellsDictionary.TryGetValue(new XLSheetPoint(ro, co), out cell) && predicate(cell)) - yield return cell; + for (int co = 1; co <= MaxColumnUsed; co++) + { + XLCell cell; + if (columnsCollection.TryGetValue(co, out cell) + && (predicate == null || predicate(cell))) + yield return cell; + } } } + } public Boolean Contains(Int32 row, Int32 column) { - return _cellsDictionary.ContainsKey(new XLSheetPoint(row, column)); + Dictionary columnsCollection; + return rowsCollection.TryGetValue(row, out columnsCollection) && columnsCollection.ContainsKey(column); } public Int32 MinRowInColumn(Int32 column) { for (int row = 1; row <= MaxRowUsed; row++) { - XLCell cell; - if (_cellsDictionary.TryGetValue(new XLSheetPoint(row, column), out cell)) - return row; + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(row, out columnsCollection)) + { + if (columnsCollection.ContainsKey(column)) + return row; + } } return 0; @@ -352,9 +408,12 @@ { for (int row = MaxRowUsed; row >= 1; row--) { - XLCell cell; - if (_cellsDictionary.TryGetValue(new XLSheetPoint(row, column), out cell)) - return row; + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(row, out columnsCollection)) + { + if (columnsCollection.ContainsKey(column)) + return row; + } } return 0; @@ -362,11 +421,11 @@ public Int32 MinColumnInRow(Int32 row) { - for (int column = 1; column <= MaxColumnUsed; column++) + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(row, out columnsCollection)) { - XLCell cell; - if (_cellsDictionary.TryGetValue(new XLSheetPoint(row, column), out cell)) - return column; + if (columnsCollection.Count > 0) + return columnsCollection.Keys.Min(); } return 0; @@ -374,11 +433,11 @@ public Int32 MaxColumnInRow(Int32 row) { - for (int column = MaxColumnUsed; column >= 1; column--) + Dictionary columnsCollection; + if (rowsCollection.TryGetValue(row, out columnsCollection)) { - XLCell cell; - if (_cellsDictionary.TryGetValue(new XLSheetPoint(row, column), out cell)) - return column; + if (columnsCollection.Count > 0) + return columnsCollection.Keys.Max(); } return 0; diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPageSetup.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPageSetup.cs index b688db5..463c0ee 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPageSetup.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPageSetup.cs @@ -158,7 +158,7 @@ /// Gets or sets the page number that will begin the printout. /// For example, the first page of your printout could be numbered page 5. /// - UInt32 FirstPageNumber { get; set; } + Int64 FirstPageNumber { get; set; } /// /// Gets or sets a value indicating whether the worksheet will be centered on the page horizontally. /// @@ -288,7 +288,7 @@ IXLPageSetup SetScale(Int32 value); IXLPageSetup SetHorizontalDpi(Int32 value); IXLPageSetup SetVerticalDpi(Int32 value); - IXLPageSetup SetFirstPageNumber(UInt32 value); + IXLPageSetup SetFirstPageNumber(Int64 value); IXLPageSetup SetCenterHorizontally(); IXLPageSetup SetCenterHorizontally(Boolean value); IXLPageSetup SetCenterVertically(); IXLPageSetup SetCenterVertically(Boolean value); IXLPageSetup SetPaperSize(XLPaperSize value); diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLPageSetup.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLPageSetup.cs index 10273a9..5eaa80a 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLPageSetup.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLPageSetup.cs @@ -106,7 +106,7 @@ public XLPaperSize PaperSize { get; set; } public Int32 HorizontalDpi { get; set; } public Int32 VerticalDpi { get; set; } - public UInt32 FirstPageNumber { get; set; } + public Int64 FirstPageNumber { get; set; } public Boolean CenterHorizontally { get; set; } public Boolean CenterVertically { get; set; } public XLPrintErrorValues PrintErrorValue { get; set; } @@ -217,7 +217,7 @@ public IXLPageSetup SetScale(Int32 value) { Scale = value; return this; } public IXLPageSetup SetHorizontalDpi(Int32 value) { HorizontalDpi = value; return this; } public IXLPageSetup SetVerticalDpi(Int32 value) { VerticalDpi = value; return this; } - public IXLPageSetup SetFirstPageNumber(UInt32 value) { FirstPageNumber = value; return this; } + public IXLPageSetup SetFirstPageNumber(Int64 value) { FirstPageNumber = value; return this; } public IXLPageSetup SetCenterHorizontally() { CenterHorizontally = true; return this; } public IXLPageSetup SetCenterHorizontally(Boolean value) { CenterHorizontally = value; return this; } public IXLPageSetup SetCenterVertically() { CenterVertically = true; return this; } public IXLPageSetup SetCenterVertically(Boolean value) { CenterVertically = value; return this; } public IXLPageSetup SetPaperSize(XLPaperSize value) { PaperSize = value; return this; } diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs index 9cfc896..24cd221 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs @@ -4,6 +4,7 @@ using ClosedXML_Examples.Ranges; using ClosedXML_Examples.Rows; using ClosedXML_Examples.Styles; +using System.IO; namespace ClosedXML_Examples { @@ -11,77 +12,79 @@ { public static void CreateAllFiles() { - new HelloWorld().Create(@"D:\Excel Files\Created\HelloWorld.xlsx"); - new BasicTable().Create(@"D:\Excel Files\Created\BasicTable.xlsx"); + var path = @"C:\ClosedXML_Tests\Created"; + + new HelloWorld().Create(path + @"\HelloWorld.xlsx"); + new BasicTable().Create(path + @"\BasicTable.xlsx"); new StyleExamples().Create(); - new ChangingBasicTable().Create(@"D:\Excel Files\Created\BasicTable_Modified.xlsx"); - new ShiftingRanges().Create(@"D:\Excel Files\Created\ShiftingRanges.xlsx"); - new ColumnSettings().Create(@"D:\Excel Files\Created\ColumnSettings.xlsx"); - new RowSettings().Create(@"D:\Excel Files\Created\RowSettings.xlsx"); - new MergeCells().Create(@"D:\Excel Files\Created\MergedCells.xlsx"); - new InsertRows().Create(@"D:\Excel Files\Created\InsertRows.xlsx"); - new InsertColumns().Create(@"D:\Excel Files\Created\InsertColumns.xlsx"); - new ColumnCollection().Create(@"D:\Excel Files\Created\ColumnCollection.xlsx"); - new DataTypes().Create(@"D:\Excel Files\Created\DataTypes.xlsx"); - new MultipleSheets().Create(@"D:\Excel Files\Created\MultipleSheets.xlsx"); - new RowCollection().Create(@"D:\Excel Files\Created\RowCollection.xlsx"); - new DefiningRanges().Create(@"D:\Excel Files\Created\DefiningRanges.xlsx"); - new ClearingRanges().Create(@"D:\Excel Files\Created\ClearingRanges.xlsx"); - new DeletingRanges().Create(@"D:\Excel Files\Created\DeletingRanges.xlsx"); - new Margins().Create(@"D:\Excel Files\Created\Margins.xlsx"); - new Page().Create(@"D:\Excel Files\Created\Page.xlsx"); - new HeaderFooters().Create(@"D:\Excel Files\Created\HeaderFooters.xlsx"); - new Sheets().Create(@"D:\Excel Files\Created\Sheets.xlsx"); - new SheetTab().Create(@"D:\Excel Files\Created\SheetTab.xlsx"); - new MultipleRanges().Create(@"D:\Excel Files\Created\MultipleRanges.xlsx"); - new StyleWorksheet().Create(@"D:\Excel Files\Created\StyleWorksheet.xlsx"); - new StyleRowsColumns().Create(@"D:\Excel Files\Created\StyleRowsColumns.xlsx"); - new InsertingDeletingRows().Create(@"D:\Excel Files\Created\InsertingDeletingRows.xlsx"); - new InsertingDeletingColumns().Create(@"D:\Excel Files\Created\InsertingDeletingColumns.xlsx"); - new DeletingColumns().Create(@"D:\Excel Files\Created\DeletingColumns.xlsx"); - new CellValues().Create(@"D:\Excel Files\Created\CellValues.xlsx"); - new LambdaExpressions().Create(@"D:\Excel Files\Created\LambdaExpressions.xlsx"); - new DefaultStyles().Create(@"D:\Excel Files\Created\DefaultStyles.xlsx"); - new TransposeRanges().Create(@"D:\Excel Files\Created\TransposeRanges.xlsx"); - new TransposeRangesPlus().Create(@"D:\Excel Files\Created\TransposeRangesPlus.xlsx"); - new MergeMoves().Create(@"D:\Excel Files\Created\MergedMoves.xlsx"); - new WorkbookProperties().Create(@"D:\Excel Files\Created\WorkbookProperties.xlsx"); - new AdjustToContents().Create(@"D:\Excel Files\Created\AdjustToContents.xlsx"); - new HideUnhide().Create(@"D:\Excel Files\Created\HideUnhide.xlsx"); - new Outline().Create(@"D:\Excel Files\Created\Outline.xlsx"); - new Formulas().Create(@"D:\Excel Files\Created\Formulas.xlsx"); - new Collections().Create(@"D:\Excel Files\Created\Collections.xlsx"); - new NamedRanges().Create(@"D:\Excel Files\Created\NamedRanges.xlsx"); - new CopyingRanges().Create(@"D:\Excel Files\Created\CopyingRanges.xlsx"); - new BlankCells().Create(@"D:\Excel Files\Created\BlankCells.xlsx"); - new TwoPages().Create(@"D:\Excel Files\Created\TwoPages.xlsx"); - new UsingColors().Create(@"D:\Excel Files\Created\UsingColors.xlsx"); + new ChangingBasicTable().Create(path + @"\BasicTable_Modified.xlsx"); + new ShiftingRanges().Create(path + @"\ShiftingRanges.xlsx"); + new ColumnSettings().Create(path + @"\ColumnSettings.xlsx"); + new RowSettings().Create(path + @"\RowSettings.xlsx"); + new MergeCells().Create(path + @"\MergedCells.xlsx"); + new InsertRows().Create(path + @"\InsertRows.xlsx"); + new InsertColumns().Create(path + @"\InsertColumns.xlsx"); + new ColumnCollection().Create(path + @"\ColumnCollection.xlsx"); + new DataTypes().Create(path + @"\DataTypes.xlsx"); + new MultipleSheets().Create(path + @"\MultipleSheets.xlsx"); + new RowCollection().Create(path + @"\RowCollection.xlsx"); + new DefiningRanges().Create(path + @"\DefiningRanges.xlsx"); + new ClearingRanges().Create(path + @"\ClearingRanges.xlsx"); + new DeletingRanges().Create(path + @"\DeletingRanges.xlsx"); + new Margins().Create(path + @"\Margins.xlsx"); + new Page().Create(path + @"\Page.xlsx"); + new HeaderFooters().Create(path + @"\HeaderFooters.xlsx"); + new Sheets().Create(path + @"\Sheets.xlsx"); + new SheetTab().Create(path + @"\SheetTab.xlsx"); + new MultipleRanges().Create(path + @"\MultipleRanges.xlsx"); + new StyleWorksheet().Create(path + @"\StyleWorksheet.xlsx"); + new StyleRowsColumns().Create(path + @"\StyleRowsColumns.xlsx"); + new InsertingDeletingRows().Create(path + @"\InsertingDeletingRows.xlsx"); + new InsertingDeletingColumns().Create(path + @"\InsertingDeletingColumns.xlsx"); + new DeletingColumns().Create(path + @"\DeletingColumns.xlsx"); + new CellValues().Create(path + @"\CellValues.xlsx"); + new LambdaExpressions().Create(path + @"\LambdaExpressions.xlsx"); + new DefaultStyles().Create(path + @"\DefaultStyles.xlsx"); + new TransposeRanges().Create(path + @"\TransposeRanges.xlsx"); + new TransposeRangesPlus().Create(path + @"\TransposeRangesPlus.xlsx"); + new MergeMoves().Create(path + @"\MergedMoves.xlsx"); + new WorkbookProperties().Create(path + @"\WorkbookProperties.xlsx"); + new AdjustToContents().Create(path + @"\AdjustToContents.xlsx"); + new HideUnhide().Create(path + @"\HideUnhide.xlsx"); + new Outline().Create(path + @"\Outline.xlsx"); + new Formulas().Create(path + @"\Formulas.xlsx"); + new Collections().Create(path + @"\Collections.xlsx"); + new NamedRanges().Create(path + @"\NamedRanges.xlsx"); + new CopyingRanges().Create(path + @"\CopyingRanges.xlsx"); + new BlankCells().Create(path + @"\BlankCells.xlsx"); + new TwoPages().Create(path + @"\TwoPages.xlsx"); + new UsingColors().Create(path + @"\UsingColors.xlsx"); - new ColumnCells().Create(@"D:\Excel Files\Created\ColumnCells.xlsx"); - new RowCells().Create(@"D:\Excel Files\Created\RowCells.xlsx"); - new FreezePanes().Create(@"D:\Excel Files\Created\FreezePanes.xlsx"); - new UsingTables().Create(@"D:\Excel Files\Created\UsingTables.xlsx"); - new ShowCase().Create(@"D:\Excel Files\Created\ShowCase.xlsx"); - new CopyingWorksheets().Create(@"D:\Excel Files\Created\CopyingWorksheets.xlsx"); - new InsertingTables().Create(@"D:\Excel Files\Created\InsertingTables.xlsx"); - new InsertingData().Create(@"D:\Excel Files\Created\InsertingData.xlsx"); - new Hyperlinks().Create(@"D:\Excel Files\Created\Hyperlinks.xlsx"); - new DataValidation().Create(@"D:\Excel Files\Created\DataValidation.xlsx"); - new HideSheets().Create(@"D:\Excel Files\Created\HideSheets.xlsx"); - new SheetProtection().Create(@"D:\Excel Files\Created\SheetProtection.xlsx"); - new AutoFilter().Create(@"D:\Excel Files\Created\AutoFilter.xlsx"); - new Sorting().Create(@"D:\Excel Files\Created\Sorting.xlsx"); - new SortExample().Create(@"D:\Excel Files\Created\SortExample.xlsx"); - new AddingDataSet().Create(@"D:\Excel Files\Created\AddingDataSet.xlsx"); - new AddingDataTableAsWorksheet().Create(@"D:\Excel Files\Created\AddingDataTableAsWorksheet.xlsx"); - new TabColors().Create(@"D:\Excel Files\Created\TabColors.xlsx"); - new ShiftingFormulas().Create(@"D:\Excel Files\Created\ShiftingFormulas.xlsx"); - new CopyingRowsAndColumns().Create(@"D:\Excel Files\Created\CopyingRowsAndColumns.xlsx"); - new UsingRichText().Create(@"D:\Excel Files\Created\UsingRichText.xlsx"); - new UsingPhonetics().Create(@"D:\Excel Files\Created\UsingPhonetics.xlsx"); - new WalkingRanges().Create(@"D:\Excel Files\Created\CellMoves.xlsx"); - new AddingComments().Create(@"D:\Excel Files\Created\AddingComments.xlsx"); + new ColumnCells().Create(path + @"\ColumnCells.xlsx"); + new RowCells().Create(path + @"\RowCells.xlsx"); + new FreezePanes().Create(path + @"\FreezePanes.xlsx"); + new UsingTables().Create(path + @"\UsingTables.xlsx"); + new ShowCase().Create(path + @"\ShowCase.xlsx"); + new CopyingWorksheets().Create(path + @"\CopyingWorksheets.xlsx"); + new InsertingTables().Create(path + @"\InsertingTables.xlsx"); + new InsertingData().Create(path + @"\InsertingData.xlsx"); + new Hyperlinks().Create(path + @"\Hyperlinks.xlsx"); + new DataValidation().Create(path + @"\DataValidation.xlsx"); + new HideSheets().Create(path + @"\HideSheets.xlsx"); + new SheetProtection().Create(path + @"\SheetProtection.xlsx"); + new AutoFilter().Create(path + @"\AutoFilter.xlsx"); + new Sorting().Create(path + @"\Sorting.xlsx"); + new SortExample().Create(path + @"\SortExample.xlsx"); + new AddingDataSet().Create(path + @"\AddingDataSet.xlsx"); + new AddingDataTableAsWorksheet().Create(path + @"\AddingDataTableAsWorksheet.xlsx"); + new TabColors().Create(path + @"\TabColors.xlsx"); + new ShiftingFormulas().Create(path + @"\ShiftingFormulas.xlsx"); + new CopyingRowsAndColumns().Create(path + @"\CopyingRowsAndColumns.xlsx"); + new UsingRichText().Create(path + @"\UsingRichText.xlsx"); + new UsingPhonetics().Create(path + @"\UsingPhonetics.xlsx"); + new WalkingRanges().Create(path + @"\CellMoves.xlsx"); + new AddingComments().Create(path + @"\AddingComments.xlsx"); } } } diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/LoadFiles.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/LoadFiles.cs index d8db0e0..cc1b1d6 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/LoadFiles.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/LoadFiles.cs @@ -8,8 +8,8 @@ { public static void LoadAllFiles() { - var forLoadingFolder = @"D:\Excel Files\Created"; - var forSavingFolder = @"D:\Excel Files\Modified"; + var forLoadingFolder = @"C:\ClosedXML_Tests\Created"; + var forSavingFolder = @"C:\ClosedXML_Tests\Modified"; foreach (var file in Directory.GetFiles(forLoadingFolder)) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/ModifyFiles.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/ModifyFiles.cs index 5bf3245..9e2cc47 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/ModifyFiles.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/ModifyFiles.cs @@ -6,7 +6,7 @@ { public static void Run() { - new DeleteRows().Create(@"D:\Excel Files\Modified\DeleteRows.xlsx"); + new DeleteRows().Create(@"C:\ClosedXML_Tests\Modified\DeleteRows.xlsx"); } } } diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/StyleExamples.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/StyleExamples.cs index afd1b40..74717e5 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/StyleExamples.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/StyleExamples.cs @@ -54,11 +54,12 @@ // Public public void Create() { - new StyleFont().Create(@"D:\Excel Files\Created\styleFont.xlsx"); - new StyleFill().Create(@"D:\Excel Files\Created\styleFill.xlsx"); - new StyleBorder().Create(@"D:\Excel Files\Created\styleBorder.xlsx"); - new StyleAlignment().Create(@"D:\Excel Files\Created\styleAlignment.xlsx"); - new StyleNumberFormat().Create(@"D:\Excel Files\Created\styleNumberFormat.xlsx"); + var path = @"C:\ClosedXML_Tests\Created"; + new StyleFont().Create(path + @"\styleFont.xlsx"); + new StyleFill().Create(path + @"\styleFill.xlsx"); + new StyleBorder().Create(path + @"\styleBorder.xlsx"); + new StyleAlignment().Create(path + @"\styleAlignment.xlsx"); + new StyleNumberFormat().Create(path + @"\styleNumberFormat.xlsx"); } // Private diff --git a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs index 669da7f..7a96b36 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs @@ -15,14 +15,13 @@ static void Main(string[] args) { - XLWorkbook wb = new XLWorkbook(); - IXLWorksheet ws = wb.Worksheets.Add("test"); - DateTime mydt = new DateTime(2014, 5, 22, 23, 32, 15, 164); - ws.Cell(1, 1).Value = mydt; - var d = ws.FirstCell().GetDateTime(); + XLWorkbook wb = new XLWorkbook(@"c:\temp\test.xlsx"); + var start = DateTime.Now; wb.SaveAs(@"c:\temp\saved.xlsx"); + var end = DateTime.Now; + Console.WriteLine((end - start).TotalSeconds); Console.WriteLine("Done"); - //Console.ReadKey(); + Console.ReadKey(); } } diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Excel/Columns/ColumnTests.cs b/ClosedXML/ClosedXML/ClosedXML_Tests/Excel/Columns/ColumnTests.cs index c4d1747..0a98c4f 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Excel/Columns/ColumnTests.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Excel/Columns/ColumnTests.cs @@ -225,5 +225,16 @@ ws.Columns(1, 2).Group(); ws.Columns(1, 2).Ungroup(true); } + + [Test] + public void LastColumnUsed() + { + IXLWorksheet ws = new XLWorkbook().AddWorksheet("Sheet1"); + ws.Cell("A1").Value = "A1"; + ws.Cell("B1").Value = "B1"; + ws.Cell("A2").Value = "A2"; + var lastCoUsed = ws.LastColumnUsed().ColumnNumber(); + Assert.AreEqual(2, lastCoUsed); + } } } \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataSet.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataSet.xlsx index 0f0db82..e7b93cd 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataSet.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataSet.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataTableAsWorksheet.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataTableAsWorksheet.xlsx index 453655e..691b172 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataTableAsWorksheet.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AddingDataTableAsWorksheet.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AdjustToContents.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AdjustToContents.xlsx index 35eca35..5c77bdc 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AdjustToContents.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AdjustToContents.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AutoFilter.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AutoFilter.xlsx index ee1c104..5217d6a 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AutoFilter.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/AutoFilter.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/BasicTable.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/BasicTable.xlsx index 15a003e..562c2ff 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/BasicTable.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/BasicTable.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/BlankCells.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/BlankCells.xlsx index c715c26..8819d8e 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/BlankCells.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/BlankCells.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CellValues.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CellValues.xlsx index 851090c..3eee826 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CellValues.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CellValues.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Collections.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Collections.xlsx index 7f90817..048210a 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Collections.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Collections.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingRowsAndColumns.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingRowsAndColumns.xlsx index 0cbf803..96dd664 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingRowsAndColumns.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingRowsAndColumns.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx index 4a79910..1784e6a 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/DataTypes.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/DataTypes.xlsx index 463a6eb..711d9a4 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/DataTypes.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/DataTypes.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/DataValidation.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/DataValidation.xlsx index f9a8e97..0de8171 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/DataValidation.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/DataValidation.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx index b81155d..0190cb8 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/FreezePanes.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/FreezePanes.xlsx index eb1f346..d66619f 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/FreezePanes.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/FreezePanes.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/HideSheets.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/HideSheets.xlsx index 4f274ed..0801cba 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/HideSheets.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/HideSheets.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/HideUnhide.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/HideUnhide.xlsx index 4e3e17c..a7bc970 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/HideUnhide.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/HideUnhide.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Hyperlinks.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Hyperlinks.xlsx index 887cbe6..417ba65 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Hyperlinks.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Hyperlinks.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/InsertingData.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/InsertingData.xlsx index 24a8ad0..acdc35a 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/InsertingData.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/InsertingData.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/InsertingTables.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/InsertingTables.xlsx index 098bb99..459a752 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/InsertingTables.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/InsertingTables.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/LambdaExpressions.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/LambdaExpressions.xlsx index 374afba..46071a6 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/LambdaExpressions.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/LambdaExpressions.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/MergeCells.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/MergeCells.xlsx index ded3bb2..2fcd0d7 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/MergeCells.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/MergeCells.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/MergeMoves.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/MergeMoves.xlsx index dc1da1d..39522aa 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/MergeMoves.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/MergeMoves.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Outline.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Outline.xlsx index a2de35c..9d7ce64 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Outline.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/Outline.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/SheetProtection.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/SheetProtection.xlsx index 68052bc..d7a9ab1 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/SheetProtection.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/SheetProtection.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/ShiftingFormulas.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/ShiftingFormulas.xlsx index dd7c5f6..464cd6b 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/ShiftingFormulas.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/ShiftingFormulas.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/ShowCase.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/ShowCase.xlsx index ec06d3f..6cf390c 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/ShowCase.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/ShowCase.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/TabColors.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/TabColors.xlsx index 874728c..cff262c 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/TabColors.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/TabColors.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/WorkbookProperties.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/WorkbookProperties.xlsx index 1bb1c4b..5b32f01 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/WorkbookProperties.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Misc/WorkbookProperties.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx index 40515d8..b141dd0 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx Binary files differ diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/Sorting.xlsx b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/Sorting.xlsx index f2a62e6..dee13b1 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/Sorting.xlsx +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Resource/Examples/Ranges/Sorting.xlsx Binary files differ