diff --git a/ClosedXML/ClosedXML/ClosedXML/..svnbridge/.svnbridge b/ClosedXML/ClosedXML/ClosedXML/..svnbridge/.svnbridge index ee46f87..0fdd4dd 100644 --- a/ClosedXML/ClosedXML/ClosedXML/..svnbridge/.svnbridge +++ b/ClosedXML/ClosedXML/ClosedXML/..svnbridge/.svnbridge @@ -3,4 +3,8 @@ svn:ignorebin obj *.ReSharper +svn:ignorebin +obj +*.ReSharper +ClosedXML.csproj.user \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs index c6861ba..946495c 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs @@ -156,12 +156,9 @@ { return null; } - else - { - var firstRow = cellsUsed.Min(c => c.Address.RowNumber); - var firstColumn = cellsUsed.Min(c => c.Address.ColumnNumber); - return Worksheet.Cell(firstRow, firstColumn); - } + var firstRow = cellsUsed.Min(c => c.Address.RowNumber); + var firstColumn = cellsUsed.Min(c => c.Address.ColumnNumber); + return Worksheet.Cell(firstRow, firstColumn); } IXLCell IXLRangeBase.LastCellUsed() diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/BasicTable.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/BasicTable.cs index bfe9799..c084772 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/BasicTable.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/BasicTable.cs @@ -4,9 +4,9 @@ namespace ClosedXML_Examples { - public class BasicTable + public class BasicTable : IXLExample { - public void Create(String filePath) + public void Create(string filePath) { // Creating a new workbook var wb = new XLWorkbook(); diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/ClosedXML_Examples.csproj b/ClosedXML/ClosedXML/ClosedXML_Examples/ClosedXML_Examples.csproj index 7d0da0d..225874c 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/ClosedXML_Examples.csproj +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/ClosedXML_Examples.csproj @@ -123,6 +123,7 @@ + @@ -144,6 +145,7 @@ + @@ -171,9 +173,9 @@ - + - + diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCells.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCells.cs index 43418ff..3254600 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCells.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCells.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples { - public class ColumnCells + public class ColumnCells : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCollections.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCollections.cs index d3d6192..a97b777 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCollections.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCollections.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Columns { - public class ColumnCollection + public class ColumnCollection : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnSettings.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnSettings.cs index 49a50b3..e051640 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnSettings.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnSettings.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Columns { - public class ColumnSettings + public class ColumnSettings : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/DeletingColumns.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/DeletingColumns.cs index bc14681..405a9bf 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/DeletingColumns.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/DeletingColumns.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples { - public class DeletingColumns + public class DeletingColumns : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/InsertColumns.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/InsertColumns.cs index 02d5e4c..e5f5579 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/InsertColumns.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/InsertColumns.cs @@ -5,7 +5,7 @@ namespace ClosedXML_Examples.Columns { - public class InsertColumns + public class InsertColumns : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs index 5adac1e..639e3df 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs @@ -13,9 +13,10 @@ { new HelloWorld().Create(@"C:\Excel Files\Created\HelloWorld.xlsx"); new BasicTable().Create(@"C:\Excel Files\Created\BasicTable.xlsx"); + new StyleExamples().Create(); - new ChangingBasicTable().Create(); - new ShiftingRanges().Create(); + new ChangingBasicTable().Create(@"C:\Excel Files\Created\BasicTable_Modified.xlsx"); + new ShiftingRanges().Create(@"C:\Excel Files\Created\ShiftingRanges.xlsx"); new ColumnSettings().Create(@"C:\Excel Files\Created\ColumnSettings.xlsx"); new RowSettings().Create(@"C:\Excel Files\Created\RowSettings.xlsx"); new MergeCells().Create(@"C:\Excel Files\Created\MergedCells.xlsx"); @@ -23,7 +24,7 @@ new InsertColumns().Create(@"C:\Excel Files\Created\InsertColumns.xlsx"); new ColumnCollection().Create(@"C:\Excel Files\Created\ColumnCollection.xlsx"); new DataTypes().Create(@"C:\Excel Files\Created\DataTypes.xlsx"); - new MultipleSheets().Create(); + new MultipleSheets().Create(@"C:\Excel Files\Created\MultipleSheets.xlsx"); new RowCollection().Create(@"C:\Excel Files\Created\RowCollection.xlsx"); new DefiningRanges().Create(@"C:\Excel Files\Created\DefiningRanges.xlsx"); new ClearingRanges().Create(@"C:\Excel Files\Created\ClearingRanges.xlsx"); @@ -40,11 +41,11 @@ new InsertingDeletingColumns().Create(@"C:\Excel Files\Created\InsertingDeletingColumns.xlsx"); new DeletingColumns().Create(@"C:\Excel Files\Created\DeletingColumns.xlsx"); new CellValues().Create(@"C:\Excel Files\Created\CellValues.xlsx"); - new LambdaExpressions().Create(); + new LambdaExpressions().Create(@"C:\Excel Files\Created\LambdaExpressions.xlsx"); new DefaultStyles().Create(@"C:\Excel Files\Created\DefaultStyles.xlsx"); - new TransposeRanges().Create(); - new TransposeRangesPlus().Create(); - new MergeMoves().Create(); + new TransposeRanges().Create(@"C:\Excel Files\Created\TransposeRanges.xlsx"); + new TransposeRangesPlus().Create(@"C:\Excel Files\Created\TransposeRangesPlus.xlsx"); + new MergeMoves().Create(@"C:\Excel Files\Created\MergedMoves.xlsx"); new WorkbookProperties().Create(@"C:\Excel Files\Created\WorkbookProperties.xlsx"); new AdjustToContents().Create(@"C:\Excel Files\Created\AdjustToContents.xlsx"); new HideUnhide().Create(@"C:\Excel Files\Created\HideUnhide.xlsx"); @@ -52,16 +53,17 @@ new Formulas().Create(@"C:\Excel Files\Created\Formulas.xlsx"); new Collections().Create(@"C:\Excel Files\Created\Collections.xlsx"); new NamedRanges().Create(@"C:\Excel Files\Created\NamedRanges.xlsx"); - new CopyingRanges().Create(); + new CopyingRanges().Create(@"C:\Excel Files\Created\CopyingRanges.xlsx"); new BlankCells().Create(@"C:\Excel Files\Created\BlankCells.xlsx"); new TwoPages().Create(@"C:\Excel Files\Created\TwoPages.xlsx"); new UsingColors().Create(@"C:\Excel Files\Created\UsingColors.xlsx"); + new ColumnCells().Create(@"C:\Excel Files\Created\ColumnCells.xlsx"); new RowCells().Create(@"C:\Excel Files\Created\RowCells.xlsx"); new FreezePanes().Create(@"C:\Excel Files\Created\FreezePanes.xlsx"); new UsingTables().Create(@"C:\Excel Files\Created\UsingTables.xlsx"); new ShowCase().Create(@"C:\Excel Files\Created\ShowCase.xlsx"); - new CopyingWorksheets().Create(); + new CopyingWorksheets().Create(@"C:\Excel Files\Created\CopyingWorksheets.xlsx"); new InsertingTables().Create(@"C:\Excel Files\Created\InsertingTables.xlsx"); new InsertingData().Create(@"C:\Excel Files\Created\InsertingData.xlsx"); new Hyperlinks().Create(@"C:\Excel Files\Created\Hyperlinks.xlsx"); diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/DeleteRows.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/DeleteRows.cs new file mode 100644 index 0000000..25b7152 --- /dev/null +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/DeleteRows.cs @@ -0,0 +1,86 @@ +using System; +using System.Linq; +using ClosedXML.Excel; + + +namespace ClosedXML_Examples.Delete +{ + public class DeleteRows : IXLExample + { + #region Variables + + // Public + + // Private + + + #endregion + + #region Properties + + // Public + + // Private + + // Override + + + #endregion + + #region Events + + // Public + + // Private + + // Override + + + #endregion + + #region Methods + + // Public + public void Create(String filePath) + { + #region Create case + { + var workbook = new XLWorkbook(); + var ws = workbook.Worksheets.Add("Delete red rows"); + + // Put a value in a few cells + foreach (var r in Enumerable.Range(1, 5)) + foreach (var c in Enumerable.Range(1, 5)) + ws.Cell(r, c).Value = string.Format("R{0}C{1}", r, c); + + + var blueRow = ws.Rows(1, 2); + var redRow = ws.Row(5); + + blueRow.Style.Fill.BackgroundColor = XLColor.Blue; + + redRow.Style.Fill.BackgroundColor = XLColor.Red; + workbook.SaveAs(filePath); + } + #endregion + + #region Remove rows + { + var workbook = new XLWorkbook(filePath); + var ws = workbook.Worksheets.Worksheet("Delete red rows"); + + ws.Rows(1, 2).Delete(); + workbook.Save(); + } + #endregion + + } + + // Private + + // Override + + + #endregion + } +} diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/RemoveRows.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/RemoveRows.cs deleted file mode 100644 index 40ecbbe..0000000 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/RemoveRows.cs +++ /dev/null @@ -1,86 +0,0 @@ -using System; -using System.Linq; -using ClosedXML.Excel; - - -namespace ClosedXML_Examples.Delete -{ - public class DeleteRows - { - #region Variables - - // Public - - // Private - - - #endregion - - #region Properties - - // Public - - // Private - - // Override - - - #endregion - - #region Events - - // Public - - // Private - - // Override - - - #endregion - - #region Methods - - // Public - public void Create(String filePath) - { - #region Create case - { - var workbook = new XLWorkbook(); - var ws = workbook.Worksheets.Add("Delete red rows"); - - // Put a value in a few cells - foreach (var r in Enumerable.Range(1, 5)) - foreach (var c in Enumerable.Range(1, 5)) - ws.Cell(r, c).Value = string.Format("R{0}C{1}", r, c); - - - var blueRow = ws.Rows(1, 2); - var redRow = ws.Row(5); - - blueRow.Style.Fill.BackgroundColor = XLColor.Blue; - - redRow.Style.Fill.BackgroundColor = XLColor.Red; - workbook.SaveAs(filePath); - } - #endregion - - #region Remove rows - { - var workbook = new XLWorkbook(filePath); - var ws = workbook.Worksheets.Worksheet("Delete red rows"); - - ws.Rows(1, 2).Delete(); - workbook.Save(); - } - #endregion - - } - - // Private - - // Override - - - #endregion - } -} diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/ExampleHelper.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/ExampleHelper.cs new file mode 100644 index 0000000..102d450 --- /dev/null +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/ExampleHelper.cs @@ -0,0 +1,12 @@ +using System.IO; + +namespace ClosedXML_Examples +{ + public static class ExampleHelper + { + public static string GetTempFilePath() + { + return Path.GetTempFileName(); + } + } +} \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/IXLExample.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/IXLExample.cs new file mode 100644 index 0000000..ad4384f --- /dev/null +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/IXLExample.cs @@ -0,0 +1,7 @@ +namespace ClosedXML_Examples +{ + public interface IXLExample + { + void Create(string filePath); + } +} \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/ChangingBasicTable.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/ChangingBasicTable.cs index 24693a7..5419cbe 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/ChangingBasicTable.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/ChangingBasicTable.cs @@ -1,34 +1,47 @@ -using ClosedXML.Excel; +using System.IO; +using ClosedXML.Excel; namespace ClosedXML_Examples { - public class ChangingBasicTable + public class ChangingBasicTable : IXLExample { - public void Create() + public void Create(string filePath) { - var workbook = new XLWorkbook(@"C:\Excel Files\Created\BasicTable.xlsx"); - var ws = workbook.Worksheet(1); - - // Change the background color of the headers - var rngHeaders = ws.Range("B3:F3"); - rngHeaders.Style.Fill.BackgroundColor = XLColor.LightSalmon; - - // Change the date formats - var rngDates = ws.Range("E4:E6"); - rngDates.Style.DateFormat.Format = "MM/dd/yyyy"; - - // Change the income values to text - var rngNumbers = ws.Range("F4:F6"); - foreach (var cell in rngNumbers.Cells()) + string tempFile = ExampleHelper.GetTempFilePath(); + try { - cell.DataType = XLCellValues.Text; - cell.Value += " Dollars"; + new BasicTable().Create(tempFile); + var workbook = new XLWorkbook(tempFile); + var ws = workbook.Worksheet(1); + + // Change the background color of the headers + var rngHeaders = ws.Range("B3:F3"); + rngHeaders.Style.Fill.BackgroundColor = XLColor.LightSalmon; + + // Change the date formats + var rngDates = ws.Range("E4:E6"); + rngDates.Style.DateFormat.Format = "MM/dd/yyyy"; + + // Change the income values to text + var rngNumbers = ws.Range("F4:F6"); + foreach (var cell in rngNumbers.Cells()) + { + cell.DataType = XLCellValues.Text; + cell.Value += " Dollars"; + } + + ws.Columns().AdjustToContents(); + + workbook.SaveAs(filePath); } - - ws.Columns().AdjustToContents(); - - workbook.SaveAs(@"C:\Excel Files\Created\BasicTable_Modified.xlsx"); + finally + { + if (File.Exists(tempFile)) + { + File.Delete(tempFile); + } + } } } } \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataSet.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataSet.cs index 46e57e7..16cb968 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataSet.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataSet.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class AddingDataSet + public class AddingDataSet : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataTableAsWorksheet.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataTableAsWorksheet.cs index 1e9f946..2fe1510 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataTableAsWorksheet.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataTableAsWorksheet.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class AddingDataTableAsWorksheet + public class AddingDataTableAsWorksheet : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AdjustToContents.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AdjustToContents.cs index b102bb0..c35304d 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AdjustToContents.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AdjustToContents.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class AdjustToContents + public class AdjustToContents : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AutoFilter.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AutoFilter.cs index 25c77d4..acf82dd 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AutoFilter.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AutoFilter.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class AutoFilter + public class AutoFilter : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/BlankCells.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/BlankCells.cs index 1bb0ad9..232950e 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/BlankCells.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/BlankCells.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class BlankCells + public class BlankCells : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CellValues.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CellValues.cs index a90d208..6919bcf 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CellValues.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CellValues.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class CellValues + public class CellValues : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Collections.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Collections.cs index ee1456f..b7bd51c 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Collections.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Collections.cs @@ -6,7 +6,7 @@ namespace ClosedXML_Examples.Misc { - public class Collections + public class Collections : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CopyingWorksheets.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CopyingWorksheets.cs index 93c5ad7..1790094 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CopyingWorksheets.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CopyingWorksheets.cs @@ -1,65 +1,45 @@ -using ClosedXML.Excel; - +using System.IO; +using ClosedXML.Excel; +using ClosedXML_Examples.Ranges; namespace ClosedXML_Examples.Misc { - public class CopyingWorksheets + public class CopyingWorksheets : IXLExample { - #region Variables - - // Public - - // Private - - - #endregion - - #region Properties - - // Public - - // Private - - // Override - - - #endregion - - #region Events - - // Public - - // Private - - // Override - - - #endregion - - #region Methods - - // Public - public void Create() + public void Create(string filePath) { - var wb = new XLWorkbook(@"C:\Excel Files\Created\UsingTables.xlsx"); - var wsSource = wb.Worksheet(1); - // Copy the worksheet to a new sheet in this workbook - wsSource.CopyTo("Copy"); + string tempFile1 = ExampleHelper.GetTempFilePath(); + string tempFile2 = ExampleHelper.GetTempFilePath(); + try + { + new UsingTables().Create(tempFile1); + var wb = new XLWorkbook(tempFile1); - // We're going to open another workbook to show that you can - // copy a sheet from one workbook to another: - var wbSource = new XLWorkbook(@"C:\Excel Files\Created\BasicTable.xlsx"); - wbSource.Worksheet(1).CopyTo(wb, "Copy From Other"); + var wsSource = wb.Worksheet(1); + // Copy the worksheet to a new sheet in this workbook + wsSource.CopyTo("Copy"); + + // We're going to open another workbook to show that you can + // copy a sheet from one workbook to another: + new BasicTable().Create(tempFile2); + var wbSource = new XLWorkbook(tempFile2); + wbSource.Worksheet(1).CopyTo(wb, "Copy From Other"); - // Save the workbook with the 2 copies - wb.SaveAs(@"C:\Excel Files\Created\CopyingWorksheets.xlsx"); + // Save the workbook with the 2 copies + wb.SaveAs(filePath); + } + finally + { + if (File.Exists(tempFile1)) + { + File.Delete(tempFile1); + } + if (File.Exists(tempFile2)) + { + File.Delete(tempFile2); + } + } } - // Private - - // Override - - - #endregion } } diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataTypes.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataTypes.cs index f626c8c..265b4b9 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataTypes.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataTypes.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class DataTypes + public class DataTypes : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataValidation.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataValidation.cs index d098981..04449e4 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataValidation.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataValidation.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class DataValidation + public class DataValidation : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Formulas.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Formulas.cs index 84a0845..8707e4c 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Formulas.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Formulas.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class Formulas + public class Formulas : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/FreezePanes.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/FreezePanes.cs index 5e84577..913738f 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/FreezePanes.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/FreezePanes.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class FreezePanes + public class FreezePanes : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideSheets.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideSheets.cs index aadfa35..8d0b6fd 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideSheets.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideSheets.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class HideSheets + public class HideSheets : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideUnhide.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideUnhide.cs index 0f25028..82fe795 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideUnhide.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideUnhide.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class HideUnhide + public class HideUnhide : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Hyperlinks.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Hyperlinks.cs index 18379e2..50eb9c7 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Hyperlinks.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Hyperlinks.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class Hyperlinks + public class Hyperlinks : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingData.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingData.cs index 812a42f..67f922b 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingData.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingData.cs @@ -6,7 +6,7 @@ namespace ClosedXML_Examples.Misc { - public class InsertingData + public class InsertingData : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingTables.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingTables.cs index f738263..3be4627 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingTables.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingTables.cs @@ -8,7 +8,7 @@ namespace ClosedXML_Examples.Misc { - public class InsertingTables + public class InsertingTables : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/LambdaExpressions.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/LambdaExpressions.cs index a8c00aa..44ac1e5 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/LambdaExpressions.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/LambdaExpressions.cs @@ -1,35 +1,49 @@ -using System.Linq; +using System.IO; +using System.Linq; using ClosedXML; using ClosedXML.Excel; namespace ClosedXML_Examples { - public class LambdaExpressions + public class LambdaExpressions : IXLExample { - public void Create() + public void Create(string filePath) { - var workbook = new XLWorkbook(@"C:\Excel Files\Created\BasicTable.xlsx"); - var ws = workbook.Worksheet(1); - // Define a range with the data - var firstDataCell = ws.Cell("B4"); - var lastDataCell = ws.LastCellUsed(); - var rngData = ws.Range(firstDataCell.Address, lastDataCell.Address); + string tempFile = ExampleHelper.GetTempFilePath(); + try + { + new BasicTable().Create(tempFile); + var workbook = new XLWorkbook(tempFile); + var ws = workbook.Worksheet(1); - // Delete all rows where Outcast = false (the 3rd column) - rngData.Rows() // From all rows - .Where(r => !r.Cell(3).GetBoolean()) // where the 3rd cell of each row is false - .ForEach(r => r.Delete()); // delete the row and shift the cells up (the default for rows in a range) + // Define a range with the data + var firstDataCell = ws.Cell("B4"); + var lastDataCell = ws.LastCellUsed(); + var rngData = ws.Range(firstDataCell.Address, lastDataCell.Address); - // Put a light gray background to all text cells - rngData.Cells() // From all cells - .Where(c => c.DataType == XLCellValues.Text) // where the data type is Text - .ForEach(c => c.Style.Fill.BackgroundColor = XLColor.LightGray); // Fill with a light gray + // Delete all rows where Outcast = false (the 3rd column) + rngData.Rows() // From all rows + .Where(r => !r.Cell(3).GetBoolean()) // where the 3rd cell of each row is false + .ForEach(r => r.Delete()); // delete the row and shift the cells up (the default for rows in a range) - // Put a thick border to the bottom of the table (we may have deleted the bottom cells with the border) - rngData.LastRow().Style.Border.BottomBorder = XLBorderStyleValues.Thick; + // Put a light gray background to all text cells + rngData.Cells() // From all cells + .Where(c => c.DataType == XLCellValues.Text) // where the data type is Text + .ForEach(c => c.Style.Fill.BackgroundColor = XLColor.LightGray); // Fill with a light gray - workbook.SaveAs(@"C:\Excel Files\Created\LambdaExpressions.xlsx"); + // Put a thick border to the bottom of the table (we may have deleted the bottom cells with the border) + rngData.LastRow().Style.Border.BottomBorder = XLBorderStyleValues.Thick; + + workbook.SaveAs(filePath); + } + finally + { + if (File.Exists(tempFile)) + { + File.Delete(tempFile); + } + } } } } \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeCells.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeCells.cs index 87cb974..ed9456f 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeCells.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeCells.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class MergeCells + public class MergeCells : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeMoves.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeMoves.cs index 45f5402..d8b341e 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeMoves.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeMoves.cs @@ -1,88 +1,53 @@ -using ClosedXML.Excel; +using System.IO; +using ClosedXML.Excel; namespace ClosedXML_Examples.Misc { - public class MergeMoves + public class MergeMoves : IXLExample { - #region Variables - // Public - - // Private - - - #endregion - - #region Properties - - // Public - - // Private - - // Override - - - #endregion - - #region Constructors - - // Public - - - // Private - - - #endregion - - #region Events - - // Public - - // Private - - // Override - - - #endregion - - #region Methods - - // Public - public void Create() + public void Create(string filePath) { - var workbook = new XLWorkbook(@"C:\Excel Files\Created\MergedCells.xlsx"); - var ws = workbook.Worksheet(1); + string tempFile = ExampleHelper.GetTempFilePath(); + try + { + new MergeCells().Create(tempFile); + var workbook = new XLWorkbook(tempFile); - ws.Range("B1:F1").InsertRowsBelow(1); - ws.Range("A3:A9").InsertColumnsAfter(1); - ws.Row(1).Delete(); - ws.Column(1).Delete(); + var ws = workbook.Worksheet(1); - ws.Range("E8:E9").InsertColumnsAfter(1); - ws.Range("F2:F8").Merge(); - ws.Range("E3:E4").InsertColumnsAfter(1); - ws.Range("F2:F8").Merge(); - ws.Range("E1:E2").InsertColumnsAfter(1); - ws.Range("G2:G8").Merge(); - ws.Range("E1:E2").Delete(XLShiftDeletedCells.ShiftCellsLeft); + ws.Range("B1:F1").InsertRowsBelow(1); + ws.Range("A3:A9").InsertColumnsAfter(1); + ws.Row(1).Delete(); + ws.Column(1).Delete(); - ws.Range("D3:E3").InsertRowsBelow(1); - ws.Range("A1:B1").InsertRowsBelow(1); - ws.Range("B3:D3").Merge(); - ws.Range("A1:B1").Delete(XLShiftDeletedCells.ShiftCellsUp); + ws.Range("E8:E9").InsertColumnsAfter(1); + ws.Range("F2:F8").Merge(); + ws.Range("E3:E4").InsertColumnsAfter(1); + ws.Range("F2:F8").Merge(); + ws.Range("E1:E2").InsertColumnsAfter(1); + ws.Range("G2:G8").Merge(); + ws.Range("E1:E2").Delete(XLShiftDeletedCells.ShiftCellsLeft); - ws.Range("B8:D8").Merge(); - ws.Range("D8:D9").Clear(); + ws.Range("D3:E3").InsertRowsBelow(1); + ws.Range("A1:B1").InsertRowsBelow(1); + ws.Range("B3:D3").Merge(); + ws.Range("A1:B1").Delete(XLShiftDeletedCells.ShiftCellsUp); - workbook.SaveAs(@"C:\Excel Files\Created\MergedMoves.xlsx"); + ws.Range("B8:D8").Merge(); + ws.Range("D8:D9").Clear(); + + workbook.SaveAs(filePath); + } + finally + { + if (File.Exists(tempFile)) + { + File.Delete(tempFile); + } + } } - // Private - - // Override - - - #endregion } } diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MultipleSheets.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MultipleSheets.cs index 6bf2151..630c139 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MultipleSheets.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MultipleSheets.cs @@ -4,43 +4,10 @@ namespace ClosedXML_Examples.Misc { - public class MultipleSheets + public class MultipleSheets : IXLExample { - #region Variables - - // Public - - // Private - - - #endregion - - #region Properties - - // Public - - // Private - - // Override - - - #endregion - - #region Events - - // Public - - // Private - - // Override - - - #endregion - - #region Methods - - // Public - public void Create() + + public void Create(string filePath) { var wb = new XLWorkbook(); foreach (var wsNum in Enumerable.Range(1, 5)) @@ -57,14 +24,7 @@ // Swap sheets in positions 1 and 2 wb.Worksheet(2).Position = 1; - wb.SaveAs(@"C:\Excel Files\Created\OrganizingSheets.xlsx"); + wb.SaveAs(filePath); } - - // Private - - // Override - - - #endregion } } diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Outline.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Outline.cs index d5b5432..0d7dd21 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Outline.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Outline.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class Outline + public class Outline : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/SheetProtection.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/SheetProtection.cs index 1b226cd..9ff9e3e 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/SheetProtection.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/SheetProtection.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class SheetProtection + public class SheetProtection : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShiftingFormulas.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShiftingFormulas.cs index 1a8bc80..f54aeb3 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShiftingFormulas.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShiftingFormulas.cs @@ -5,7 +5,7 @@ namespace ClosedXML_Examples.Misc { - public class ShiftingFormulas + public class ShiftingFormulas : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShowCase.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShowCase.cs index 8281a6e..c8edc32 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShowCase.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShowCase.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples { - public class ShowCase + public class ShowCase : IXLExample { public void Create(String filePath) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/TabColors.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/TabColors.cs index 09a2451..19f1664 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/TabColors.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/TabColors.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class TabColors + public class TabColors : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/WorkbookProperties.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/WorkbookProperties.cs index 35b9e18..60bb8c8 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/WorkbookProperties.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/WorkbookProperties.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class WorkbookProperties + public class WorkbookProperties : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/HeaderFooters.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/HeaderFooters.cs index b8111c5..ed8646e 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/HeaderFooters.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/HeaderFooters.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.PageSetup { - public class HeaderFooters + public class HeaderFooters : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Margins.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Margins.cs index 926ee82..e343126 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Margins.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Margins.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.PageSetup { - public class Margins + public class Margins : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Page.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Page.cs index 3ae9870..e4d745e 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Page.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Page.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.PageSetup { - public class Page + public class Page : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/SheetTab.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/SheetTab.cs index 84cc971..1048dec 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/SheetTab.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/SheetTab.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.PageSetup { - public class SheetTab + public class SheetTab : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Sheets.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Sheets.cs index ec4f7b9..a7b2584 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Sheets.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Sheets.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.PageSetup { - public class Sheets + public class Sheets : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/TwoPages.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/TwoPages.cs index 39ac3ec..33cf47d 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/TwoPages.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/TwoPages.cs @@ -5,7 +5,7 @@ namespace ClosedXML_Examples.PageSetup { - public class TwoPages + public class TwoPages : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ClearingRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ClearingRanges.cs index 2aefef4..4f9c9c1 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ClearingRanges.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ClearingRanges.cs @@ -5,7 +5,7 @@ namespace ClosedXML_Examples.Ranges { - public class ClearingRanges + public class ClearingRanges : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/CopyingRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/CopyingRanges.cs index 4ceadb5..8569d7c 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/CopyingRanges.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/CopyingRanges.cs @@ -1,24 +1,37 @@ -using ClosedXML.Excel; +using System.IO; +using ClosedXML.Excel; namespace ClosedXML_Examples { - public class CopyingRanges + public class CopyingRanges : IXLExample { - public void Create() + public void Create(string filePath) { - var workbook = new XLWorkbook(@"C:\Excel Files\Created\BasicTable.xlsx"); - var ws = workbook.Worksheet(1); + string tempFile = ExampleHelper.GetTempFilePath(); + try + { + new BasicTable().Create(tempFile); + var workbook = new XLWorkbook(tempFile); + var ws = workbook.Worksheet(1); - // Define a range with the data - var firstTableCell = ws.FirstCellUsed(); - var lastTableCell = ws.LastCellUsed(); - var rngData = ws.Range(firstTableCell.Address, lastTableCell.Address); + // Define a range with the data + var firstTableCell = ws.FirstCellUsed(); + var lastTableCell = ws.LastCellUsed(); + var rngData = ws.Range(firstTableCell.Address, lastTableCell.Address); - // Copy the table to another worksheet - var wsCopy = workbook.Worksheets.Add("Contacts Copy"); - wsCopy.Cell(1,1).Value = rngData; + // Copy the table to another worksheet + var wsCopy = workbook.Worksheets.Add("Contacts Copy"); + wsCopy.Cell(1, 1).Value = rngData; - workbook.SaveAs(@"C:\Excel Files\Created\CopyingRanges.xlsx"); + workbook.SaveAs(filePath); + } + finally + { + if (File.Exists(tempFile)) + { + File.Delete(tempFile); + } + } } } } \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DefiningRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DefiningRanges.cs index 28b8761..ba51969 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DefiningRanges.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DefiningRanges.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Ranges { - public class DefiningRanges + public class DefiningRanges : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DeletingRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DeletingRanges.cs index 10e743a..fa10274 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DeletingRanges.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DeletingRanges.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Ranges { - public class DeletingRanges + public class DeletingRanges : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingColumns.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingColumns.cs index d10959d..1e23002 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingColumns.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingColumns.cs @@ -3,7 +3,7 @@ namespace ClosedXML_Examples { - public class InsertingDeletingColumns + public class InsertingDeletingColumns : IXLExample { public void Create(String filePath) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingRows.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingRows.cs index 467f083..4c5a4db 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingRows.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingRows.cs @@ -3,7 +3,7 @@ namespace ClosedXML_Examples { - public class InsertingDeletingRows + public class InsertingDeletingRows : IXLExample { public void Create(String filePath) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/MultipleRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/MultipleRanges.cs index 516c2ee..d49becf 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/MultipleRanges.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/MultipleRanges.cs @@ -3,7 +3,7 @@ namespace ClosedXML_Examples { - public class MultipleRanges + public class MultipleRanges : IXLExample { public void Create(String filePath) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/NamedRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/NamedRanges.cs index 2c401bb..6959ba7 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/NamedRanges.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/NamedRanges.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class NamedRanges + public class NamedRanges : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ShiftingRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ShiftingRanges.cs index 4e7ab7d..58fa3be 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ShiftingRanges.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ShiftingRanges.cs @@ -1,27 +1,40 @@ -using ClosedXML.Excel; +using System.IO; +using ClosedXML.Excel; namespace ClosedXML_Examples { - public class ShiftingRanges + public class ShiftingRanges : IXLExample { - public void Create() + public void Create(string filePath) { - var workbook = new XLWorkbook(@"C:\Excel Files\Created\BasicTable.xlsx"); - var ws = workbook.Worksheet(1); + string tempFile = ExampleHelper.GetTempFilePath(); + try + { + new BasicTable().Create(tempFile); + var workbook = new XLWorkbook(tempFile); + var ws = workbook.Worksheet(1); - // Get a range object - var rngHeaders = ws.Range("B3:F3"); + // Get a range object + var rngHeaders = ws.Range("B3:F3"); - // Insert some rows/columns before the range - ws.Row(1).InsertRowsAbove(2); - ws.Column(1).InsertColumnsBefore(2); + // Insert some rows/columns before the range + ws.Row(1).InsertRowsAbove(2); + ws.Column(1).InsertColumnsBefore(2); - // Change the background color of the headers - rngHeaders.Style.Fill.BackgroundColor = XLColor.LightSalmon; + // Change the background color of the headers + rngHeaders.Style.Fill.BackgroundColor = XLColor.LightSalmon; - ws.Columns().AdjustToContents(); - - workbook.SaveAs(@"C:\Excel Files\Created\ShiftingRanges.xlsx"); + ws.Columns().AdjustToContents(); + + workbook.SaveAs(filePath); + } + finally + { + if (File.Exists(tempFile)) + { + File.Delete(tempFile); + } + } } } } diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/SortExample.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/SortExample.cs index 69393cf..1f2ecea 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/SortExample.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/SortExample.cs @@ -5,7 +5,7 @@ namespace ClosedXML_Examples.Misc { - public class SortExample + public class SortExample : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/Sorting.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/Sorting.cs index 8c1c5f8..2f1c1b0 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/Sorting.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/Sorting.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Misc { - public class Sorting + public class Sorting : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRanges.cs index a16a332..d1d3a08 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRanges.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRanges.cs @@ -1,22 +1,37 @@ -using ClosedXML.Excel; +using System.IO; +using ClosedXML.Excel; namespace ClosedXML_Examples { - public class TransposeRanges + public class TransposeRanges:IXLExample { - public void Create() + public void Create(string filePath) { - var workbook = new XLWorkbook(@"C:\Excel Files\Created\BasicTable.xlsx"); - var ws = workbook.Worksheet(1); + string tempFile = ExampleHelper.GetTempFilePath(); + try + { + new BasicTable().Create(tempFile); + var workbook = new XLWorkbook(tempFile); - var rngTable = ws.Range("B2:F6"); + var ws = workbook.Worksheet(1); - rngTable.Transpose(XLTransposeOptions.MoveCells); + var rngTable = ws.Range("B2:F6"); - ws.Columns().AdjustToContents(); + rngTable.Transpose(XLTransposeOptions.MoveCells); - workbook.SaveAs(@"C:\Excel Files\Created\TransposeRanges.xlsx"); + ws.Columns().AdjustToContents(); + + workbook.SaveAs(filePath); + } + finally + { + if (File.Exists(tempFile)) + { + File.Delete(tempFile); + } + } + } } } \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRangesPlus.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRangesPlus.cs index b9978c7..13aaf7e 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRangesPlus.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRangesPlus.cs @@ -1,33 +1,46 @@ -using ClosedXML.Excel; - +using System.IO; +using ClosedXML.Excel; namespace ClosedXML_Examples { - public class TransposeRangesPlus + public class TransposeRangesPlus : IXLExample { - public void Create() + public void Create(string filePath) { - var workbook = new XLWorkbook(@"C:\Excel Files\Created\BasicTable.xlsx"); - var ws = workbook.Worksheet(1); + string tempFile = ExampleHelper.GetTempFilePath(); + try + { + new BasicTable().Create(tempFile); + var workbook = new XLWorkbook(tempFile); - var rngTable = ws.Range("B2:F6"); + var ws = workbook.Worksheet(1); - rngTable.Row(rngTable.RowCount() - 1).Delete(XLShiftDeletedCells.ShiftCellsUp); + var rngTable = ws.Range("B2:F6"); - // Place some markers - var cellNextRow = ws.Cell(rngTable.RangeAddress.LastAddress.RowNumber + 1, rngTable.RangeAddress.LastAddress.ColumnNumber); - cellNextRow.Value = "Next Row"; - var cellNextColumn = ws.Cell(rngTable.RangeAddress.LastAddress.RowNumber, rngTable.RangeAddress.LastAddress.ColumnNumber + 1); - cellNextColumn.Value = "Next Column"; + rngTable.Row(rngTable.RowCount() - 1).Delete(XLShiftDeletedCells.ShiftCellsUp); - rngTable.Transpose(XLTransposeOptions.MoveCells); - rngTable.Transpose(XLTransposeOptions.MoveCells); - rngTable.Transpose(XLTransposeOptions.ReplaceCells); - rngTable.Transpose(XLTransposeOptions.ReplaceCells); + // Place some markers + var cellNextRow = ws.Cell(rngTable.RangeAddress.LastAddress.RowNumber + 1, rngTable.RangeAddress.LastAddress.ColumnNumber); + cellNextRow.Value = "Next Row"; + var cellNextColumn = ws.Cell(rngTable.RangeAddress.LastAddress.RowNumber, rngTable.RangeAddress.LastAddress.ColumnNumber + 1); + cellNextColumn.Value = "Next Column"; - ws.Columns().AdjustToContents(); + rngTable.Transpose(XLTransposeOptions.MoveCells); + rngTable.Transpose(XLTransposeOptions.MoveCells); + rngTable.Transpose(XLTransposeOptions.ReplaceCells); + rngTable.Transpose(XLTransposeOptions.ReplaceCells); - workbook.SaveAs(@"C:\Excel Files\Created\TransposeRangesPlus.xlsx"); + ws.Columns().AdjustToContents(); + + workbook.SaveAs(filePath); + } + finally + { + if (File.Exists(tempFile)) + { + File.Delete(tempFile); + } + } } } } \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/UsingTables.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/UsingTables.cs index 104761f..72d6c84 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/UsingTables.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/UsingTables.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Ranges { - public class UsingTables + public class UsingTables : IXLExample { #region Methods diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/InsertRows.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/InsertRows.cs index 2da6924..8b46171 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/InsertRows.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/InsertRows.cs @@ -5,7 +5,7 @@ namespace ClosedXML_Examples.Rows { - public class InsertRows + public class InsertRows : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCells.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCells.cs index c5e9529..369ae43 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCells.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCells.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples { - public class RowCells + public class RowCells : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCollection.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCollection.cs new file mode 100644 index 0000000..b4b8817 --- /dev/null +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCollection.cs @@ -0,0 +1,96 @@ +using System; +using ClosedXML.Excel; + + +namespace ClosedXML_Examples.Rows +{ + public class RowCollection : IXLExample + { + #region Variables + + // Public + + // Private + + + #endregion + + #region Properties + + // Public + + // Private + + // Override + + + #endregion + + + #region Events + + // Public + + // Private + + // Override + + + #endregion + + #region Methods + + // Public + public void Create(String filePath) + { + var workbook = new XLWorkbook(); + var ws = workbook.Worksheets.Add("Rows of a Range"); + + // All rows in a range + ws.Range("A1:B2").Rows().Style.Fill.BackgroundColor = XLColor.DimGray; + + var bigRange = ws.Range("B4:C17"); + + // Contiguous rows by number + bigRange.Rows(1, 2).Style.Fill.BackgroundColor = XLColor.Red; + + // Contiguous rows by number + bigRange.Rows("4:5").Style.Fill.BackgroundColor = XLColor.Blue; + + // Spread rows by number + bigRange.Rows("7:8,10:11").Style.Fill.BackgroundColor = XLColor.Orange; + + // Using a single number + bigRange.Rows("13").Style.Fill.BackgroundColor = XLColor.Cyan; + + // Adjust the height + ws.Rows().Height = 15; + + var ws2 = workbook.Worksheets.Add("Rows of a Worksheet"); + + // Contiguous rows by number + ws2.Rows(1, 2).Style.Fill.BackgroundColor = XLColor.Red; + + // Contiguous rows by number + ws2.Rows("4:5").Style.Fill.BackgroundColor = XLColor.Blue; + + // Spread rows by number + ws2.Rows("7:8,10:11").Style.Fill.BackgroundColor = XLColor.Orange; + + // Using a single number + ws2.Rows("13").Style.Fill.BackgroundColor = XLColor.Cyan; + + // Adjust the height + ws2.Rows("1:13").Height = 15; + + workbook.SaveAs(filePath); + } + + // Private + + // Override + + + #endregion + } +} diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCollections.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCollections.cs deleted file mode 100644 index 3fb13a1..0000000 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCollections.cs +++ /dev/null @@ -1,96 +0,0 @@ -using System; -using ClosedXML.Excel; - - -namespace ClosedXML_Examples.Rows -{ - public class RowCollection - { - #region Variables - - // Public - - // Private - - - #endregion - - #region Properties - - // Public - - // Private - - // Override - - - #endregion - - - #region Events - - // Public - - // Private - - // Override - - - #endregion - - #region Methods - - // Public - public void Create(String filePath) - { - var workbook = new XLWorkbook(); - var ws = workbook.Worksheets.Add("Rows of a Range"); - - // All rows in a range - ws.Range("A1:B2").Rows().Style.Fill.BackgroundColor = XLColor.DimGray; - - var bigRange = ws.Range("B4:C17"); - - // Contiguous rows by number - bigRange.Rows(1, 2).Style.Fill.BackgroundColor = XLColor.Red; - - // Contiguous rows by number - bigRange.Rows("4:5").Style.Fill.BackgroundColor = XLColor.Blue; - - // Spread rows by number - bigRange.Rows("7:8,10:11").Style.Fill.BackgroundColor = XLColor.Orange; - - // Using a single number - bigRange.Rows("13").Style.Fill.BackgroundColor = XLColor.Cyan; - - // Adjust the height - ws.Rows().Height = 15; - - var ws2 = workbook.Worksheets.Add("Rows of a Worksheet"); - - // Contiguous rows by number - ws2.Rows(1, 2).Style.Fill.BackgroundColor = XLColor.Red; - - // Contiguous rows by number - ws2.Rows("4:5").Style.Fill.BackgroundColor = XLColor.Blue; - - // Spread rows by number - ws2.Rows("7:8,10:11").Style.Fill.BackgroundColor = XLColor.Orange; - - // Using a single number - ws2.Rows("13").Style.Fill.BackgroundColor = XLColor.Cyan; - - // Adjust the height - ws2.Rows("1:13").Height = 15; - - workbook.SaveAs(filePath); - } - - // Private - - // Override - - - #endregion - } -} diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowSettings.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowSettings.cs index bcdc3a8..54798a2 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowSettings.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowSettings.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Rows { - public class RowSettings + public class RowSettings : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/DefaultStyles.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/DefaultStyles.cs index a2c4a6c..8c49955 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/DefaultStyles.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/DefaultStyles.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Styles { - public class DefaultStyles + public class DefaultStyles : IXLExample { public void Create(String filePath) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleAlignment.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleAlignment.cs index 3da077e..8ff3bcf 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleAlignment.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleAlignment.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Styles { - public class StyleAlignment + public class StyleAlignment : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleBorder.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleBorder.cs index 5ba43c1..d151b27 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleBorder.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleBorder.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Styles { - public class StyleBorder + public class StyleBorder : IXLExample { public void Create(String filePath) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFill.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFill.cs index 684cbf3..f9edee2 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFill.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFill.cs @@ -6,7 +6,7 @@ { - public class StyleFill + public class StyleFill : IXLExample { public void Create(String filePath) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFont.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFont.cs index 33160d2..43c86a3 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFont.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFont.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Styles { - public class StyleFont + public class StyleFont : IXLExample { public void Create(String filePath) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleNumberFormat.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleNumberFormat.cs index 7360879..0972de5 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleNumberFormat.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleNumberFormat.cs @@ -3,7 +3,7 @@ namespace ClosedXML_Examples.Styles { - public class StyleNumberFormat + public class StyleNumberFormat : IXLExample { #region Variables diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleRowsColumns.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleRowsColumns.cs index 9eddc22..4681ac9 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleRowsColumns.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleRowsColumns.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Styles { - public class StyleRowsColumns + public class StyleRowsColumns : IXLExample { public void Create(String filePath) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleWorksheet.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleWorksheet.cs index 5092633..5669aaf 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleWorksheet.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleWorksheet.cs @@ -4,7 +4,7 @@ namespace ClosedXML_Examples.Styles { - public class StyleWorksheet + public class StyleWorksheet : IXLExample { public void Create(String filePath) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/UsingColors.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/UsingColors.cs index aa5b604..b736cff 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/UsingColors.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/UsingColors.cs @@ -5,7 +5,7 @@ namespace ClosedXML_Examples.Styles { - public class UsingColors + public class UsingColors : IXLExample { public void Create(String filePath) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/..svnbridge/.svnbridge b/ClosedXML/ClosedXML/ClosedXML_Tests/..svnbridge/.svnbridge index bdf168c..fe3fcbf 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/..svnbridge/.svnbridge +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/..svnbridge/.svnbridge @@ -1,3 +1,6 @@ svn:ignorebin obj - \ No newline at end of file +svn:ignorebin +obj +ClosedXML_Tests.csproj.user +bugtraq:numbertrue \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Cells/..svnbridge/.svnbridge b/ClosedXML/ClosedXML/ClosedXML_Tests/Cells/..svnbridge/.svnbridge deleted file mode 100644 index 06883fa..0000000 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Cells/..svnbridge/.svnbridge +++ /dev/null @@ -1,3 +0,0 @@ -bugtraq:numbertruesvn:ignorebin -obj - \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Cells/XLCellTests.cs b/ClosedXML/ClosedXML/ClosedXML_Tests/Cells/XLCellTests.cs deleted file mode 100644 index edd6c55..0000000 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/Cells/XLCellTests.cs +++ /dev/null @@ -1,35 +0,0 @@ -using System; -using System.Text; -using System.Collections.Generic; -using System.Linq; -using ClosedXML; -using ClosedXML.Excel; -using Microsoft.VisualStudio.TestTools.UnitTesting; - -namespace ClosedXML_Tests.Excel -{ - /// - /// Summary description for UnitTest1 - /// - [TestClass] - public class XLCellTests - { - - - [TestMethod] - public void TestConvertColumnLetterToNumberAnd() - { - CheckColumnNumber(1); - CheckColumnNumber(27); - CheckColumnNumber(28); - CheckColumnNumber(52); - CheckColumnNumber(53); - CheckColumnNumber(1000); - } - private static void CheckColumnNumber(int column) - { - Assert.AreEqual(column, ExcelHelper.GetColumnNumberFromLetter(ExcelHelper.GetColumnLetterFromNumber(column))); - } - - } -} diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj b/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj index 30bcbbb..bd2b5b1 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj +++ b/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj @@ -59,8 +59,18 @@ - + + + + + + + + + + + @@ -70,6 +80,13 @@ {BD5E6BFE-E837-4A35-BCA9-39667D873A20} ClosedXML + + {03A518D0-1CB7-488E-861C-C4E782B27A46} + ClosedXML_Examples + + + +