You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
63 lines
2.2 KiB
C#
63 lines
2.2 KiB
C#
namespace com.azkoss.excellite
|
|
{
|
|
using System;
|
|
|
|
///<summary>
|
|
///Indexing modes used by <see cref="com.azkoss.excellite.CellRange">CellRange</see>.
|
|
///</summary>
|
|
///<example> Following code creates horizontal, vertical and rectangular cell ranges and demonstrates how
|
|
///indexing works different in different context. <see cref="com.azkoss.excellite.CellRange.SetBorders(com.azkoss.excellite.MultipleBorders,System.Drawing.Color,com.azkoss.excellite.LineStyle)">SetBorders</see>
|
|
///method is used to mark outside borders of the rectangular range.
|
|
///<code lang="Visual Basic">
|
|
///Dim cr As CellRange = excelFile.Worksheets(0).Rows(1).Cells
|
|
///
|
|
///cr(0).Value = cr.IndexingMode
|
|
///cr(3).Value = "D2"
|
|
///cr("B").Value = "B2"
|
|
///
|
|
///cr = excelFile.Worksheets(0).Columns(4).Cells
|
|
///
|
|
///cr(0).Value = cr.IndexingMode
|
|
///cr(2).Value = "E3"
|
|
///cr("5").Value = "E5"
|
|
///
|
|
///cr = excelFile.Worksheets(0).Cells.GetSubrange("F2", "J8")
|
|
///cr.SetBorders(MultipleBorders.Outside, Color.Navy, LineStyle.Dashed)
|
|
///
|
|
///cr("I7").Value = cr.IndexingMode
|
|
///cr(0, 0).Value = "F2"
|
|
///cr("G3").Value = "G3"
|
|
///cr(5).Value = "F3" <font color="Green">' Cell range width is 5 (F G H I J).</font>
|
|
///</code>
|
|
///<code lang="C#">
|
|
///CellRange cr = excelFile.Worksheets[0].Rows[1].Cells;
|
|
///
|
|
///cr[0].Value = cr.IndexingMode;
|
|
///cr[3].Value = "D2";
|
|
///cr["B"].Value = "B2";
|
|
///
|
|
///cr = excelFile.Worksheets[0].Columns[4].Cells;
|
|
///
|
|
///cr[0].Value = cr.IndexingMode;
|
|
///cr[2].Value = "E3";
|
|
///cr["5"].Value = "E5";
|
|
///
|
|
///cr = excelFile.Worksheets[0].Cells.GetSubrange("F2", "J8");
|
|
///cr.SetBorders(MultipleBorders.Outside, Color.Navy, LineStyle.Dashed);
|
|
///
|
|
///cr["I7"].Value = cr.IndexingMode;
|
|
///cr[0,0].Value = "F2";
|
|
///cr["G3"].Value = "G3";
|
|
///cr[5].Value = "F3"; <font color="Green">// Cell range width is 5 (F G H I J).</font>
|
|
///</code>
|
|
///</example>
|
|
///<seealso cref="com.azkoss.excellite.CellRange.IndexingMode" />
|
|
public enum RangeIndexingMode
|
|
{
|
|
Rectangular,
|
|
Horizontal,
|
|
Vertical
|
|
}
|
|
}
|
|
|