B4J Question [XLutils] how set cell format to Text ??

behnam_tr

Active Member
Licensed User
Longtime User
in XLutils
how set cell format to Text ??

i want to write and read phone number like this : 0914****** , 0933***** , ......

after save when i want to edit phone number in excel file it changed to 914*****,933*****

After editing, I can not add the number '0' to the first of the phone number

i want to set cell format to TEXT

thanks
 

Attachments

  • b4x_xlutils.png
    b4x_xlutils.png
    24.6 KB · Views: 132

behnam_tr

Active Member
Licensed User
Longtime User
Solved

B4X:
Dim tellstyle As XLStyle = Workbook.CreateStyle.DataFormat("TEXT").HorizontalAlignment("LEFT")
 
Last edited:
Upvote 0
Top