Free Trial
Web API version
Licensing
Request A Quote
HAVE QUESTIONS OR NEED HELP? SUBMIT THE SUPPORT REQUEST FORM or write email to SUPPORT@BYTESCOUT.COM
Freeze Rows And Columns | VB.NET
Module1.vb:
VB
'******************************************************************************************* ' ' Download Free Evaluation Version From: https://bytescout.com/download/web-installer ' ' Also available as Web API! Free Trial Sign Up: https://secure.bytescout.com/users/sign_up // ' Copyright © 2017-2018 ByteScout Inc. All rights reserved. ' http://www.bytescout.com ' '******************************************************************************************* Imports System Imports Bytescout.Spreadsheet Module Module1 Sub Main() Dim spreadsheet As Spreadsheet = New Spreadsheet() Console.WriteLine("Read excel file...") spreadsheet.LoadFromFile(".\Input.xls") Console.WriteLine("Read first spreadsheet...") Dim worksheet As Worksheet = spreadsheet.Worksheets(0) Console.WriteLine("Freeze rows...") worksheet.ViewOptions.SplitRow = 1 worksheet.ViewOptions.PanesFrozen = True Console.WriteLine("Freeze columns...") worksheet = spreadsheet.Worksheets(1) worksheet.ViewOptions.SplitColumn = 1 worksheet.ViewOptions.PanesFrozen = True Console.WriteLine("Save excel file...") spreadsheet.SaveAs("Output.xls") ' Cleanup spreadsheet.Dispose() Console.WriteLine() Console.WriteLine("Press any key to continue...") Console.ReadLine() End Sub End Module