Page History

...

{description}
{excerpt}Sets or returns the ratio between the workbook's tab bar and the horizontal scroll bar.

...

{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}

{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.