B4J Question [SOLVED] XLUtils / JPOI5 Create excel sheet if it does not exist.

[RAFA BRAVO]

Is there a way to know if a sheet exists in an excel workbook? And if it doesn't exist, create it. thanks.

 

[EnriqueGonzalez]

hi!
yes you can use this line:

wb is a XlWorkbookWriter class

wb.PoiWorkbook.GetSheetNames

this will return the names of all the sheets within the workbook

 

[RAFA BRAVO]

thanks, it works perfect