C# (CSharp) XLClearOptions示例

示例#1

        public void CanClearMergedRanges(XLClearOptions options, int expectedCount)
        {
            using (var wb = new XLWorkbook())
            {
                var ws = wb.AddWorksheet("Test");

                ws.Range("A1:C3").Merge();
                ws.Range("A4:B6").Merge();
                ws.Range("D1:F3").Merge();
                ws.Range("E4:F6").Merge();

                ws.Range("C1:D6").Clear(options);

                Assert.AreEqual(expectedCount, ws.MergedRanges.Count);
            }
        }

示例#2

文件： XLRangeColumn.cs 项目： zhoushlu/ClosedXML

 public new IXLRangeColumn Clear(XLClearOptions clearOptions = XLClearOptions.All)
 {
     base.Clear(clearOptions);
     return(this);
 }

示例#3

文件： XLTables.cs 项目： sreenandini/test_buildscripts

 public IXLTables Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats)
 {
     _tables.Values.ForEach(t => t.Clear(clearOptions));
     return this;
 }

示例#4

 public IXLTables Clear(XLClearOptions clearOptions = XLClearOptions.All)
 {
     _tables.Values.ForEach(t => t.Clear(clearOptions));
     return(this);
 }

示例#5

 public IXLRangeColumns Clear(XLClearOptions clearOptions = XLClearOptions.All)
 {
     _ranges.ForEach(c => c.Clear(clearOptions));
     return(this);
 }

示例#6

文件： XLColumns.cs 项目： sreenandini/test_buildscripts

 public IXLColumns Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats)
 {
     _columns.ForEach(c=>c.Clear(clearOptions));
     return this;
 }

示例#7

文件： XLRow.cs 项目： sreenandini/test_buildscripts

 public new IXLRow Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats)
 {
     base.Clear(clearOptions);
     return this;
 }

示例#8

 public IXLTableRows Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats)
 {
     _ranges.ForEach(r => r.Clear(clearOptions));
     return(this);
 }

示例#9

文件： XLTableRows.cs 项目： ThiagoMSArrais/ClosedXML-1

 public IXLTableRows Clear(XLClearOptions clearOptions = XLClearOptions.All)
 {
     _ranges.ForEach(r => r.Clear(clearOptions));
     return(this);
 }

示例#10

文件： XLRangeRows.cs 项目： zhihuaqiu/ClosedXML

 public IXLRangeRows Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats)
 {
     _ranges.ForEach(c => c.Clear(clearOptions));
     return this;
 }

示例#11

文件： XLRangeRows.cs 项目： sreenandini/test_buildscripts

 public IXLRangeRows Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats)
 {
     _ranges.ForEach(c => c.Clear(clearOptions));
     return this;
 }

示例#12

文件： XLRangeColumns.cs 项目： zxcvas/ClosedXML

 public IXLRangeColumns Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats)
 {
     _ranges.ForEach(c => c.Clear(clearOptions));
     return(this);
 }

示例#13

文件： XLCells.cs 项目： vinhdang/ClosedXML

 public IXLCells Clear(XLClearOptions clearOptions = XLClearOptions.All)
 {
     this.ForEach <XLCell>(c => c.Clear(clearOptions));
     return(this);
 }

示例#14

 public static XLCellsUsedOptions ToCellsUsedOptions(this XLClearOptions options)
 {
     return((XLCellsUsedOptions)options);
 }

示例#15

文件： XLCells.cs 项目： zxcvas/ClosedXML

 public IXLCells Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats)
 {
     this.ForEach <XLCell>(c => c.Clear(clearOptions));
     return(this);
 }

示例#16

文件： XLRangeRow.cs 项目： zhihuaqiu/ClosedXML

 public new IXLRangeRow Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats)
 {
     base.Clear(clearOptions);
     return(this);
 }

示例#17

文件： XLTables.cs 项目： zxcvas/ClosedXML

 public IXLTables Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats)
 {
     _tables.Values.ForEach(t => t.Clear(clearOptions));
     return(this);
 }

示例#18

 public IXLRows Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats)
 {
     _rows.ForEach(c => c.Clear(clearOptions));
     return(this);
 }

示例#19

 public new IXLRow Clear(XLClearOptions clearOptions = XLClearOptions.All)
 {
     base.Clear(clearOptions);
     return(this);
 }

示例#20

 public IXLRows Clear(XLClearOptions clearOptions = XLClearOptions.All)
 {
     _rows.ForEach(c => c.Clear(clearOptions));
     return(this);
 }

示例#21

文件： XLTableRows.cs 项目： sreenandini/test_buildscripts

 public IXLTableRows Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats)
 {
     _ranges.ForEach(r => r.Clear(clearOptions));
     return this;
 }