Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

former_member486356
Participant

‎02-20-2018 7:47 AM

0 Kudos

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.

2 REPLIES 2

Jelena
Active Contributor

‎02-20-2018 5:03 PM

0 Kudos

"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.

VeselinaPeykova
Active Contributor

‎02-20-2018 6:39 PM

0 Kudos

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.