When opening an Excel workbook programatically using the Excel object model, there are various options that you can specify. For example, this is a command in our current code that I’m in the process of replacing:
oWkBook = oXLApp.Workbooks.Open(FileName, Password:=Trim(mPassword), ReadOnly:=True, UpdateLinks:=False, Converter:=True, IgnoreReadOnlyRecommended:=True)
Using Aspose.Cells, how can I specify these options (particularly the UpdateLinks:=False one)? I can see from the documentation that there is an enumerator for this (WorkbookSettings.UpdateLinksType) but I can’t see how to use it for this purpose.
I currently have this:
Dim loadOptions As New LoadOptions
If mPassword.Length > 0 Then
loadOptions.Password = mPassword
End If
Dim spreadSheet As Workbook = New Workbook(fileOriginalName, loadOptions)
Thanks…