B4J Question How to Setting Column Width in XLUtils

virpalacios

Active Member
Licensed User
Longtime User
Hi All , Greetings, This is my first question of 2026 , :D , This is posible to set column width when creating excel sheets with XLUtils?

Thanks in Advance for your comments,

Best Regards 😄👍
 
Solution
B4X:
    Sub Process_Globals   

        Private XL As XLUtils

    End Sub
    
    
    XL.Initialize
    Dim Workbook As XLWorkbookWriter = XL.CreateWriterBlank
    Dim sheet1 As XLSheetWriter = Workbook.CreateSheetWriterByName(sheetName)   
    sheet1.PoiSheet.SetColumnWidth(1, 20*256)

bdunkleysmith

Active Member
Licensed User
Longtime User
B4X:
    Sub Process_Globals   

        Private XL As XLUtils

    End Sub
    
    
    XL.Initialize
    Dim Workbook As XLWorkbookWriter = XL.CreateWriterBlank
    Dim sheet1 As XLSheetWriter = Workbook.CreateSheetWriterByName(sheetName)   
    sheet1.PoiSheet.SetColumnWidth(1, 20*256)
 
Upvote 1
Solution
Top