Find the answer to your Linux question:
Results 1 to 2 of 2
Hi all, I'm wrote php program which reads data from database and writes in excel sheel. When i tried to write a number like 000234 , in excel sheet it ...
  1. 10-29-2007 #1
    Lakshmipathi
    Lakshmipathi is offline
    Linux Guru Lakshmipathi's Avatar
    Join Date
    Sep 2006
    Location
    3rd rock from sun - Often seen near moon
    Posts
    1,568

    Smile php+Spreadsheet writer -->Zero are truncated

    Hi all,
    I'm wrote php program which reads data from database and writes in excel sheel.
    When i tried to write a number like 000234 ,
    in excel sheet it comes like 234 ...zero are truncated
    How to write without truncating zeroes??
    - Lakshmipathi.G
    -------------------
    FOSS India Award winning ext3fs Undelete tool and tutorials www.giis.co.in
    First they criticize you,Then they laugh at you,Then they fight with you,Then you win. - M.K.Gandhi
    -------------------
    Reply With Quote Reply With Quote
  2. 10-31-2007 #2
    Lakshmipathi
    Lakshmipathi is offline
    Linux Guru Lakshmipathi's Avatar
    Join Date
    Sep 2006
    Location
    3rd rock from sun - Often seen near moon
    Posts
    1,568
    oops ...no one out there...
    anyway here is the solution i found.
    use writeString() instead of write()
    HTH
    - Lakshmipathi.G
    -------------------
    FOSS India Award winning ext3fs Undelete tool and tutorials www.giis.co.in
    First they criticize you,Then they laugh at you,Then they fight with you,Then you win. - M.K.Gandhi
    -------------------
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

...