//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; //Set worksheet tab color. worksheet.TabColor = Color.Green; //Set worksheet default row height. worksheet.StandardHeight = 20; //Set worksheet default column width. worksheet.StandardWidth = 50; //Split worksheet to panes. worksheet.SplitPanes(worksheet.Range["B3"].Row, worksheet.Range["B3"].Column); IWorksheet worksheet1 = workbook.Worksheets.Add(); //Hide worksheet. worksheet1.Visible = Visibility.Hidden;
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) 'Set worksheet tab color. worksheet.TabColor = Color.Green 'Set worksheet default row height. worksheet.StandardHeight = 20 'Set worksheet default column width. worksheet.StandardWidth = 50 'Split worksheet to panes. worksheet.SplitPanes(worksheet.Range!B3.Row, worksheet.Range!B3.Column) Dim worksheet1 As IWorksheet = workbook.Worksheets.Add() 'Hide worksheet. worksheet1.Visible = Visibility.Hidden ' save to an excel file workbook.Save("ConfigWorksheet.xlsx")