Set Hidden Formula - VB.NET
Spreadsheet SDK sample in VB.NET demonstrating ‘Set Hidden Formula’
Program.vb
Imports System.Diagnostics
Imports System.IO
Imports Bytescout.Spreadsheet
Class Program
Friend Shared Sub Main(args As String())
' Open spreadsheet from file
Dim document As New Spreadsheet()
document.LoadFromFile("example.xls")
' Get first worksheet
Dim worksheet As Worksheet = document.Workbook.Worksheets(0)
' Hide formula in B9 cell
worksheet.Cell("B9").HiddenFormula = True
' Protect the worksheet with password
worksheet.Protect("password")
' Delete output file if exists
If File.Exists("changed.xls") Then
File.Delete("changed.xls")
End If
' Save document
document.SaveAs("changed.xls")
' Close spreadsheet
document.Close()
' Open generated XLS document in default program
Process.Start("changed.xls")
End Sub
End Class