Page History

Description

Excerpt
Sets or returns the ratio between the workbook's tab bar and the horizontal scroll bar.

Signature

	C#
	C#

 public double TabRatio{ get; set; }

Signature

	vb.net
	vb.net

Public Property TabRatio() As Double

Remarks
For example, if 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.

Example

Code Block

	csharp
	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 Block

	vb.net
	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

Space Shortcuts

Page tree

Versions Compared

Old Version 7

New Version Current

Key