Skip to Content

Getting issue while Downloading excel with leading zero from GUI_download in DBF format

Feb 20 at 07:47 AM


avatar image

Hi Folks,

I have to download an excel from GUI_DOWNLOAD with leading zero ,So I have use DBF format but the issue is all the japanese character is now coming as # . I have use code page 8000, this is working fine in ASC format but in that case leading zero is not coming. If anybody work on this type of requirement kindly help.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jelena Perfiljeva
Feb 20 at 05:03 PM

"Leading zero not coming" - do you just not see the leading zero when you open the file in Excel? When there are only numeric characters in a cell Excel automatically converts it into a number format and drops the leading zeroes. This is a known effect and questions about it have been answered many times. Use Google.

Otherwise provide more details on what the issue is exactly and what have you done so far to troubleshoot this.

10 |10000 characters needed characters left characters exceeded
Veselina Peykova
Feb 20 at 06:39 PM

I have no experience with dbf containing Japanese characters, but several years ago I had to deal with dbf with Armenian texts.

Do not use Excel to view these, on top of somewhat misleading numbers representation, the display and texts can be messed up too - even when the file is correct!

If memory serves, for most of the time I used LibreOffice to view the generated files, because there was an option to select the desired code page when you open the file.

Another set of tools that I used before installing LibreOffice was a combination of Notepad++ and a small utility (via command prompt) that displayed information for header and field descriptor sections.

Edit: the reason why I mentioned these tools is to hint that before jumping to a conclusion that there is a problem with your code you could verify the file correctness with alternative software.

10 |10000 characters needed characters left characters exceeded