diff --git a/ClosedXML/ClosedXML/ClosedXML/ClosedXML.csproj b/ClosedXML/ClosedXML/ClosedXML/ClosedXML.csproj index d7b2854..991d71c 100644 --- a/ClosedXML/ClosedXML/ClosedXML/ClosedXML.csproj +++ b/ClosedXML/ClosedXML/ClosedXML/ClosedXML.csproj @@ -24,6 +24,7 @@ false bin\Debug\ DEBUG;TRACE + NET4 prompt 4 @@ -139,7 +140,6 @@ - diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs index 1319098..ff5808f 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs @@ -9,8 +9,11 @@ using System.Reflection; using System.Text; using System.Text.RegularExpressions; +#if NET4 + using System.ComponentModel.DataAnnotations; +#endif - internal partial class XLCell : IXLCell, IXLStylized + internal class XLCell : IXLCell, IXLStylized { public Boolean StyleChanged { get; set; } public static readonly DateTime BaseDate = new DateTime(1899, 12, 30); @@ -2040,5 +2043,18 @@ { return Worksheet.Row(Address.RowNumber); } + + private String GetFieldName(Object[] customAttributes) + { +#if NET4 + var displayAttributes = customAttributes.Where(a => a is DisplayAttribute).Select(a => (a as DisplayAttribute).Name); + if (displayAttributes.Any()) + return displayAttributes.Single(); + else + return null; +#else + return null; +#endif + } } } \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell_DotNetSpecific.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell_DotNetSpecific.cs deleted file mode 100644 index 82c0468..0000000 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell_DotNetSpecific.cs +++ /dev/null @@ -1,19 +0,0 @@ -using System; -using System.ComponentModel.DataAnnotations; -using System.Linq; - -namespace ClosedXML.Excel -{ - internal partial class XLCell - { - private String GetFieldName(Object[] customAttributes) - { - var displayAttributes = customAttributes.Where(a => a is DisplayAttribute).Select(a => (a as DisplayAttribute).Name); - if (displayAttributes.Any()) - return displayAttributes.Single(); - else - return null; - } - - } -} diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCells.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCells.cs index fafc66e..2651162 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCells.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCells.cs @@ -57,9 +57,11 @@ range.FirstAddress.ColumnNumber, range.LastAddress.RowNumber, range.LastAddress.ColumnNumber) - .Where(c => !c.IsEmpty(_includeFormats) || (_includeFormats && c.HasComment)); - if (_predicate != null) - cellRange = cellRange.Where(c=>_predicate(c)); + .Where(c => + !c.IsEmpty(_includeFormats) + || (_includeFormats && c.HasComment) + || (_predicate != null && _predicate(c)) + ); foreach(var cell in cellRange) { @@ -121,10 +123,11 @@ var cellRange = cellsInRanges.SelectMany( cir => cir.Value.Select(a => cir.Key.Internals.CellsCollection.GetCell(a)).Where( - cell => cell != null && (!cell.IsEmpty(_includeFormats) || (_includeFormats && cell.HasComment)))); - - if (_predicate != null) - cellRange = cellRange.Where(c => _predicate(c)); + cell => cell != null && ( + !cell.IsEmpty(_includeFormats) + || (_includeFormats && cell.HasComment) + || (_predicate != null && _predicate(cell)) + ))); foreach (var cell in cellRange) { diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs index eca622d..310a8f5 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs @@ -294,7 +294,13 @@ LoadFont(runProperties, rt); } - var shape = xdoc.Root.Element("xml").Elements().First(e => (string)e.Attribute("type") == "#_x0000_t202"); + var xml = xdoc.Root.Element("xml"); + XElement shape; + if (xml != null) + shape = xml.Elements().First(e => (string)e.Attribute("type") == "#_x0000_t202"); + else + shape = xdoc.Root.Elements().First(e => (string)e.Attribute("type") == "#_x0000_t202"); + LoadShapeProperties(xlComment, shape); var clientData = shape.Elements().First(e => e.Name.LocalName == "ClientData"); @@ -362,7 +368,7 @@ } } - var stroke = shape.Elements().First(e=>e.Name.LocalName == "stroke"); + var stroke = shape.Elements().FirstOrDefault(e=>e.Name.LocalName == "stroke"); if (stroke != null) { var opacity = stroke.Attribute("opacity"); @@ -462,7 +468,7 @@ private void LoadClientData(IXLDrawing drawing, XElement clientData) { - var anchor = clientData.Elements().First(e=>e.Name.LocalName == "Anchor"); + var anchor = clientData.Elements().FirstOrDefault(e=>e.Name.LocalName == "Anchor"); if (anchor != null) LoadClientDataAnchor(drawing, anchor); LoadDrawingPositioning(drawing, clientData); @@ -471,8 +477,8 @@ private void LoadDrawingProtection(IXLDrawing drawing, XElement clientData) { - var lockedElement = clientData.Elements().First(e => e.Name.LocalName == "Locked"); - var lockTextElement = clientData.Elements().First(e => e.Name.LocalName == "LockText"); + var lockedElement = clientData.Elements().FirstOrDefault(e => e.Name.LocalName == "Locked"); + var lockTextElement = clientData.Elements().FirstOrDefault(e => e.Name.LocalName == "LockText"); Boolean locked = lockedElement != null && lockedElement.Value.ToLower() == "true"; Boolean lockText = lockTextElement != null && lockTextElement.Value.ToLower() == "true"; drawing.Style.Protection.Locked = locked; @@ -482,8 +488,8 @@ private static void LoadDrawingPositioning(IXLDrawing drawing, XElement clientData) { - var moveWithCellsElement = clientData.Elements().First(e => e.Name.LocalName == "MoveWithCells"); - var sizeWithCellsElement = clientData.Elements().First(e => e.Name.LocalName == "SizeWithCells"); + var moveWithCellsElement = clientData.Elements().FirstOrDefault(e => e.Name.LocalName == "MoveWithCells"); + var sizeWithCellsElement = clientData.Elements().FirstOrDefault(e => e.Name.LocalName == "SizeWithCells"); Boolean moveWithCells = moveWithCellsElement != null && moveWithCellsElement.Value.ToLower() == "true"; Boolean sizeWithCells = sizeWithCellsElement != null && sizeWithCellsElement.Value.ToLower() == "true"; if (moveWithCells && !sizeWithCells) diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Comments/AddingComments.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Comments/AddingComments.cs index 200e91f..bce0c0e 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Comments/AddingComments.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Comments/AddingComments.cs @@ -13,6 +13,27 @@ public void Create(string filePath) { var wb = new XLWorkbook(); + AddMiscComments(wb); + AddVisibilityComments(wb); + AddStyleAlignment(wb); + wb.SaveAs(filePath); + } + + private void AddStyleAlignment(XLWorkbook wb) + { + var ws = wb.Worksheets.Add("Style Alignment"); + + // Automagically adjust the size of the comment to fit the contents + ws.Cell("A1").Comment.Style.Alignment.SetAutomaticSize(); + ws.Cell("A1").Comment.AddText("Things are pretty tight around here"); + + + // Set all comments to visible + ws.CellsUsed(c => c.HasComment).ForEach(c => c.Comment.SetVisible()); + } + + private static void AddMiscComments(XLWorkbook wb) + { var ws = wb.Worksheets.Add("Comments"); ws.Cell("A1").SetValue("Hidden").Comment.AddText("Hidden"); @@ -75,9 +96,33 @@ .Protection.SetLockText(false) .Web.SetAlternateText("This won't be released to the web"); + + ws.CellsUsed(c => !c.Address.ToStringRelative().Equals("A1") && c.HasComment).ForEach(c => c.Comment.SetVisible()); + } + + private static void AddVisibilityComments(XLWorkbook wb) + { + var ws = wb.Worksheets.Add("Visibility"); + + // By default comments are hidden + ws.Cell("A1").SetValue("I have a comment").Comment.AddText("Hidden"); - ws.CellsUsed(true, c => !c.Address.ToStringRelative().Equals("A1") && c.HasComment).ForEach(c => c.Comment.SetVisible()); - wb.SaveAs(filePath); + // Set the comment as visible + ws.Cell("A2").Comment.SetVisible().AddText("Visible"); + + // The ZOrder on previous comments were 1 and 2 respectively + // here we're explicit about the ZOrder + ws.Cell("A3").Comment.SetZOrder(5).SetVisible().AddText("On Top"); + + // We want this comment to appear underneath the one for A3 + // so we set the ZOrder to something lower + ws.Cell("A4").Comment.SetZOrder(4).SetVisible().AddText("Underneath"); + ws.Cell("A4").Comment.Style.Alignment.SetVertical(XLDrawingVerticalAlignment.Bottom); + + // Alternatively you could set all comments to visible with the following line: + // ws.CellsUsed(c => c.HasComment).ForEach(c => c.Comment.SetVisible()); + + ws.Columns().AdjustToContents(); } } } diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs index e80d76f..b94fea7 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs @@ -11,76 +11,77 @@ { public static void CreateAllFiles() { - new HelloWorld().Create(@"C:\Excel Files\Created\HelloWorld.xlsx"); - new BasicTable().Create(@"C:\Excel Files\Created\BasicTable.xlsx"); + //new HelloWorld().Create(@"C:\Excel Files\Created\HelloWorld.xlsx"); + //new BasicTable().Create(@"C:\Excel Files\Created\BasicTable.xlsx"); - new StyleExamples().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"); - new InsertRows().Create(@"C:\Excel Files\Created\InsertRows.xlsx"); - 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(@"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"); - new DeletingRanges().Create(@"C:\Excel Files\Created\DeletingRanges.xlsx"); - new Margins().Create(@"C:\Excel Files\Created\Margins.xlsx"); - new Page().Create(@"C:\Excel Files\Created\Page.xlsx"); - new HeaderFooters().Create(@"C:\Excel Files\Created\HeaderFooters.xlsx"); - new Sheets().Create(@"C:\Excel Files\Created\Sheets.xlsx"); - new SheetTab().Create(@"C:\Excel Files\Created\SheetTab.xlsx"); - new MultipleRanges().Create(@"C:\Excel Files\Created\MultipleRanges.xlsx"); - new StyleWorksheet().Create(@"C:\Excel Files\Created\StyleWorksheet.xlsx"); - new StyleRowsColumns().Create(@"C:\Excel Files\Created\StyleRowsColumns.xlsx"); - new InsertingDeletingRows().Create(@"C:\Excel Files\Created\InsertingDeletingRows.xlsx"); - 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(@"C:\Excel Files\Created\LambdaExpressions.xlsx"); - new DefaultStyles().Create(@"C:\Excel Files\Created\DefaultStyles.xlsx"); - 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"); - new Outline().Create(@"C:\Excel Files\Created\Outline.xlsx"); - 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(@"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 StyleExamples().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"); + //new InsertRows().Create(@"C:\Excel Files\Created\InsertRows.xlsx"); + //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(@"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"); + //new DeletingRanges().Create(@"C:\Excel Files\Created\DeletingRanges.xlsx"); + //new Margins().Create(@"C:\Excel Files\Created\Margins.xlsx"); + //new Page().Create(@"C:\Excel Files\Created\Page.xlsx"); + //new HeaderFooters().Create(@"C:\Excel Files\Created\HeaderFooters.xlsx"); + //new Sheets().Create(@"C:\Excel Files\Created\Sheets.xlsx"); + //new SheetTab().Create(@"C:\Excel Files\Created\SheetTab.xlsx"); + //new MultipleRanges().Create(@"C:\Excel Files\Created\MultipleRanges.xlsx"); + //new StyleWorksheet().Create(@"C:\Excel Files\Created\StyleWorksheet.xlsx"); + //new StyleRowsColumns().Create(@"C:\Excel Files\Created\StyleRowsColumns.xlsx"); + //new InsertingDeletingRows().Create(@"C:\Excel Files\Created\InsertingDeletingRows.xlsx"); + //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(@"C:\Excel Files\Created\LambdaExpressions.xlsx"); + //new DefaultStyles().Create(@"C:\Excel Files\Created\DefaultStyles.xlsx"); + //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"); + //new Outline().Create(@"C:\Excel Files\Created\Outline.xlsx"); + //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(@"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(@"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"); - new DataValidation().Create(@"C:\Excel Files\Created\DataValidation.xlsx"); - new HideSheets().Create(@"C:\Excel Files\Created\HideSheets.xlsx"); - new SheetProtection().Create(@"C:\Excel Files\Created\SheetProtection.xlsx"); - new AutoFilter().Create(@"C:\Excel Files\Created\AutoFilter.xlsx"); - new Sorting().Create(@"C:\Excel Files\Created\Sorting.xlsx"); - new SortExample().Create(@"C:\Excel Files\Created\SortExample.xlsx"); - new AddingDataSet().Create(@"C:\Excel Files\Created\AddingDataSet.xlsx"); - new AddingDataTableAsWorksheet().Create(@"C:\Excel Files\Created\AddingDataTableAsWorksheet.xlsx"); - new TabColors().Create(@"C:\Excel Files\Created\TabColors.xlsx"); - new ShiftingFormulas().Create(@"C:\Excel Files\Created\ShiftingFormulas.xlsx"); - new CopyingRowsAndColumns().Create(@"C:\Excel Files\Created\CopyingRowsAndColumns.xlsx"); - new UsingRichText().Create(@"C:\Excel Files\Created\UsingRichText.xlsx"); - new UsingPhonetics().Create(@"C:\Excel Files\Created\UsingPhonetics.xlsx"); - new WalkingRanges().Create(@"C:\Excel Files\Created\CellMoves.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(@"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"); + //new DataValidation().Create(@"C:\Excel Files\Created\DataValidation.xlsx"); + //new HideSheets().Create(@"C:\Excel Files\Created\HideSheets.xlsx"); + //new SheetProtection().Create(@"C:\Excel Files\Created\SheetProtection.xlsx"); + //new AutoFilter().Create(@"C:\Excel Files\Created\AutoFilter.xlsx"); + //new Sorting().Create(@"C:\Excel Files\Created\Sorting.xlsx"); + //new SortExample().Create(@"C:\Excel Files\Created\SortExample.xlsx"); + //new AddingDataSet().Create(@"C:\Excel Files\Created\AddingDataSet.xlsx"); + //new AddingDataTableAsWorksheet().Create(@"C:\Excel Files\Created\AddingDataTableAsWorksheet.xlsx"); + //new TabColors().Create(@"C:\Excel Files\Created\TabColors.xlsx"); + //new ShiftingFormulas().Create(@"C:\Excel Files\Created\ShiftingFormulas.xlsx"); + //new CopyingRowsAndColumns().Create(@"C:\Excel Files\Created\CopyingRowsAndColumns.xlsx"); + //new UsingRichText().Create(@"C:\Excel Files\Created\UsingRichText.xlsx"); + //new UsingPhonetics().Create(@"C:\Excel Files\Created\UsingPhonetics.xlsx"); + //new WalkingRanges().Create(@"C:\Excel Files\Created\CellMoves.xlsx"); + new AddingComments().Create(@"C:\Excel Files\Created\AddingComments.xlsx"); } } } diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Program.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Program.cs index 982cd31..16edb3c 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Program.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Program.cs @@ -7,8 +7,6 @@ { CreateFiles.CreateAllFiles(); LoadFiles.LoadAllFiles(); - - ModifyFiles.Run(); } } } \ No newline at end of file diff --git a/ClosedXML/ClosedXML/ClosedXML_Net3.5/ClosedXML_Net3.5.csproj b/ClosedXML/ClosedXML/ClosedXML_Net3.5/ClosedXML_Net3.5.csproj index 8f68671..94930e5 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Net3.5/ClosedXML_Net3.5.csproj +++ b/ClosedXML/ClosedXML/ClosedXML_Net3.5/ClosedXML_Net3.5.csproj @@ -715,7 +715,6 @@ PathHelper.cs - diff --git a/ClosedXML/ClosedXML/ClosedXML_Net3.5/Excel/Cells/XLCell_DotNetSpecific.cs b/ClosedXML/ClosedXML/ClosedXML_Net3.5/Excel/Cells/XLCell_DotNetSpecific.cs deleted file mode 100644 index 76ec6eb..0000000 --- a/ClosedXML/ClosedXML/ClosedXML_Net3.5/Excel/Cells/XLCell_DotNetSpecific.cs +++ /dev/null @@ -1,13 +0,0 @@ -using System; - - -namespace ClosedXML.Excel -{ - internal partial class XLCell - { - private String GetFieldName(Object[] customAttributes) - { - return null; - } - } -} diff --git a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs index 4d74ee3..c206af6 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs @@ -12,9 +12,10 @@ { static void Main(string[] args) { - //Use this space to play with ClosedXML + var wb = new XLWorkbook(); + var ws = wb.Worksheets.Add("Sheet1"); - + wb.SaveAs(@"Sandbox.xlsx"); } } }