B4J Question Help with jPOI : Error Object should first be initialized

incendio

Well-Known Member
Licensed User
Longtime User
Hello guys,

I have a problem with jPOI, here are my codes :
B4X: 
Sub btnStart_Action
    wb.InitializeExisting(File.DirApp,"RcpMonthly.xlsx","")
    ws = wb.GetSheet(0)
    Private row As PoiRow
    Private Cell As PoiCell
   
    row = ws.GetRow(7)
    row.IsInitialized

    Cell = row.GetCell(1)
    Cell.IsInitialized

    Cell.ValueString =  "Java"
    wb.Save(File.DirApp,"test.xlsx")
    fx.Msgbox(MainForm,"OK","Info")
End Sub

It raised an error :
Error occurred on line: 38 (Main)
java.lang.RuntimeException: Object should first be initialized (PoiRow).

Line 38 point to Cell = row.GetCell(1).
Where am I missing here?

Thanks in advance.
 
Sort by date Sort by votes

incendio

Well-Known Member
Licensed User
Longtime User
You mean ws.CreateRow.

I am modifying existing excel sheet, do not want to create new row.
 
Last edited:
Upvote 0

incendio

Well-Known Member
Licensed User
Longtime User
How to modifying existing excel cell? Create New row will lose existing cell format.
 
Upvote 0

incendio

Well-Known Member
Licensed User
Longtime User
Found the reason.

My first codes for modifying cell will work only on an non empty cell.

For an empty cell, no other choice, must use CreateRow, cause there is no initialized method for cell.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
B4J Question java.lang.RuntimeException: Object should first be initialized (HttpSession).
Replies
7
Views
2K
Erel
  • Question
B4J Question java.lang.RuntimeException: Object should first be initialized (HttpSession).
Replies
3
Views
1K
birnesoft
D
  • Locked
  • Question
B4J Question APOI formula
Replies
5
Views
1K
Erel
C
  • Question
B4J Question B4XPages / Error java.lang.RuntimeException: Object should first be initialized (B4XView) when try to update a value
Replies
7
Views
2K
christianjeannot
C
  • Question
B4J Question B4Xtable sql.exception error SOLVED
Replies
5
Views
973
ilan
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…