B4J Question Problem with Initialization of PoiWorkbook

[Zvi]

Hi, I'm trying to use PoiWorkbook but when the program gets to the line "wb.InitializeExisting(File.DirApp,"","B4J Excel.xlsx",False)" I get the following error:
"java.io.FileNotFoundException: C:\Users\zviba\OneDrive\Desktop\B4JEXC~1\Objects (Access is denied)"

The excel file is not password-protected.

I would really appreciate some help

'Non-UI application (console / server application)
#Region Project Attributes
    #CommandLineArgs:
    #MergeLibraries: True
#End Region

Sub Process_Globals
    Private xl As XLUtils
End Sub

Sub AppStart (Args() As String)
    CreateWorkBook2
    StartMessageLoop 'non-ui app
End Sub

Sub CreateWorkBook2 As ResumableSub
    Dim wb As PoiWorkbook
    If File.Exists(File.DirApp,"B4J Excel.xlsx") Then
        wb.InitializeExisting(File.DirApp,"","B4J Excel.xlsx",False)
    End If
    StopMessageLoop 'non-ui
End Sub

 

[walt61]

The workbook doesn't seem to be the problem; your Objects folder is. It is emptied/created when compiling. As it sits in OneDrive, OneDrive is probably syncing the folder, hence the 'access denied' error. Pause syncing or move the project outside OneDrive, that should do the trick.

 

[Zvi]

Hi walt61, thank you for your suggestion.
I paused OneDrive and tried running the code again... same problem.
To be certain, I transferred the code (incl. all directories) to a folder that is not covered by OneDrive. Same problem ?‍

 

[walt61]

Hi @Zvi , damn, I hate it when I'm wrong That said: I think I see the problem now. Have a look at InitializeExisting: you swapped the filename and password values! It should be:

wb.InitializeExisting(File.DirApp,"B4J Excel.xlsx","",False)

 

[Zvi]

Genius! Thanks. That solved the problem ?