virpalacios Active Member Licensed User Longtime User Jan 29, 2026 #1 Hi All , Greetings, This is my first question of 2026 , , This is posible to set column width when creating excel sheets with XLUtils? Thanks in Advance for your comments, Best Regards
Hi All , Greetings, This is my first question of 2026 , , This is posible to set column width when creating excel sheets with XLUtils? Thanks in Advance for your comments, Best Regards
Solution bdunkleysmith Jan 29, 2026 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)
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 Jan 29, 2026 #2 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
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)
virpalacios Active Member Licensed User Longtime User Jan 29, 2026 #3 Thanks I Lot, for You Quick Answer, Best Regards Upvote 0