B4J Question Poi causes error in compiled version Packager 11

oldeast

Active Member
Licensed User
Longtime User
debug.bat file attached
Error occurs when excel file for export is selected..
Required Poi packager properties have been included in the Packager 11 set up
thank you
Excel File selection:
Case "Export"
           
                Dim fc As FileChooser                 ' Use filechooser from jFX library
                Dim fileSelected As String            ' File selected. If selected full path is returned else ""
                Dim n,p As String
                Dim response As Int
                fc.Initialize
                fc.InitialDirectory = GetSystemProperty("user.home", "c:\")      ' Set starting folder
                fc.Title = "Select a File to receive the data..."
                fc.SetExtensionFilter("Excel files..",Array As String("*.xls","*.xlsx"))
                response=fx.Msgbox2(Null,"Please select a BLANK Excel file ...","Export","OK", "Cancel", "", fx.MSGBOX_INFORMATION)
                If response=-3 Then
                    Toast.ToastShow("Export was cancelled.")
                    Return
                End If

                fileSelected = fc.ShowOpen(MediaForm) ' Show the dialog and select
                If fileSelected="" Then Exit
                'Return fileSelected
                Dim fileO As JavaObject
               
                fileO.InitializeNewInstance("java.io.File", Array As Object(fileSelected))

                n = fileO.RunMethod("getName",Null)
                p = fileO.RunMethod("getPath", Null)
                p = p.Replace(n, "")
                Hdrlist.Initialize
                Poi.InitializeExisting(p,n,"")
 

Attachments

  • debug.txt
    6.7 KB · Views: 176

oldeast

Active Member
Licensed User
Longtime User
I have failed to find my error...so I would appreciate a clue as to what I have not done correctly.

Thank you
 
Upvote 0

oldeast

Active Member
Licensed User
Longtime User
My settings
B4X:
#Region Project Attributes
    #CommandLineArgs:
    #MergeLibraries: True
    #PackagerProperty: AdditionalModuleInfoString = opens schemaorg_apache_xmlbeans.system.sD023D6490046BA0250A839A9AD24C443;
    #PackagerProperty: IncludedModules = jdk.charsets
    #PackagerProperty: IconFile = ...Objects\HDB.ico
    #PackagerProperty: ExeName = HDB
#End Region

Sub Process_Globals
    Private InputJar As String = "C:\Users\oldea\Downloads\SourceCode\B4J\HDB-6.0\Objects\HDB.jar" 'change as needed
    Private NetFrameworkCSC As String = "%WINDIR%\Microsoft.NET\Framework64\v4.0.30319\csc.exe" 'windows only
    Private IconFile As String
    Private ExcludedModules As List
    ExcludedModules = Array("javafx.web") 'comment this line if using WebView
    Private IncludedModules As List = Array("jdk.charsets")
    Private AdditionalModuleInfoString As String '= "exports net.sf.jasperreports.engine.fill;"
    Private VMArgs As String
    'non configurable variables:
 
Upvote 0
Top