Page History

{description}
{excerpt}Sets or returns the ratio between the workbook's tab bar and the horizontal scroll bar.
{excerpt}
{signature:C#}
 public double TabRatio{ get; set; }
{signature}{signature:vb.net}
Public Property TabRatio() As Double
{signature}
{remarks}
For example, if [TabRatio|Workbook.TabRatio] is set to 50, the tab bar will take up 50\% of the width of the workbook window, while the horizontal scroll bar will take up the other half.The value of {{TabRatio}} should be between 0 and 100. If the value is less than 0, ExcelWriter will set {{TabRatio}}  to 0.  If the value is greater than 100, ExcelWriter will set {{TabRatio}}  to 100.
{remarks}
{example}{code:csharp|title=C#}

          //--- Get the ratio between the workbook's tab bar and the horizontal scroll bar
          double ratio = wb.TabRatio;

          //--- Set the ratio between the workbook's tab bar and the horizontal scroll bar
          wb.TabRatio = 20;
        {code}
{code:vb.net|title=vb.net}

          '--- Get the ratio between the workbook's tab bar and the horizontal scroll bar
          Dim ratio As Double = wb.TabRatio

          '--- Set the ratio between the workbook's tab bar and the horizontal scroll bar
          wb.TabRatio = 20
        {code}

{example}