Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IDataBar Interface : DataBarDirection Property

DataBarDirection Property

Gets or sets the direction of the data bar.
Syntax
'Declaration
 
Property DataBarDirection As DataBarDirection
'Usage
 
Dim instance As IDataBar
Dim value As DataBarDirection
 
instance.DataBarDirection = value
 
value = instance.DataBarDirection
DataBarDirection DataBarDirection {get; set;}
Example
The position of the DataBar will be DataBarDirection.context by default. This can be changed to DataBarDirection.leftToRight or DataBarDirection.rightToLeft. In our example we set the direction of the DataBar to DataBarDirection.rightToLeft.
using Syncfusion.XlsIO;
            
class Example
{
    static void Main()
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create a worksheet.        
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;            
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet worksheet = workbook.Worksheets[0];
            
            //Load data to Apply Conditional Formatting.
            worksheet["A1"].Text = "DataBar";
            worksheet["A2"].Number = 10;
            worksheet["A3"].Number = 20;
            worksheet["A4"].Number = 30;
            worksheet["A5"].Number = 40;
            worksheet["A6"].Number = 50;
            worksheet["A7"].Number = 60;
            worksheet["A8"].Number = 70;
            worksheet["A9"].Number = 80;
            worksheet["A10"].Number = 90;
            worksheet["A11"].Number = 100;
            
            //Create instance of IConditonalFormat and IConditionalFormats.
            IConditionalFormats formats = worksheet["A2:A11"].ConditionalFormats;
            IConditionalFormat format = formats.AddCondition();
            
            //Set FormatType as DataBar.
            format.FormatType = ExcelCFType.DataBar;
            IDataBar dataBar = format.DataBar;
            
            //Set Bar Direction
            dataBar.DataBarDirection = DataBarDirection.rightToLeft;
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also