2. PHPRunner General questions
  3. [SOLVED]  Export to Excel Format (Number Stored as Text)
This topic is locked
[SOLVED]

 Export to Excel Format (Number Stored as Text)

 		10/3/2019 12:45:17 PM
PHPRunner General questions
F
 facun_baur author

Hi Guys,

I appreciate if anyone could help me with this problem.
When EXPORTING to EXCEL, a varchar TYPE field which contains 18 digit number is change to scientific notation. I want to get the number stored as text in Excel format.
Example:

Data in Table : 197904292010011006

Excel result : 1,97904E+..

Desire result : '197904292010011006 OR 197904292010011006
I'm using PHPRunner Enterprise Edition 10.3 and database Mysql.
Thank you in advance.

Facun
S
 		sthefaine 10/3/2019

Facun,
The way I was able to accomplish this was to create an alias field in the query portion of phprunner and concatenated this symbol before the # ' so # would be '197904292010011006

Excel interprets this as text. Then I would go to the fields settings in phprunner and uncheck the list etc for this item accept for export. Uncheck your # field on export and replace it with this one.
Hope this helps.
Steve
F
 		facun_baur author 10/6/2019

Hi Steve,
Thanks for answering and your solution is working well.
Have a good day.
jadachDevClub member 10/6/2019



Facun,
The way I was able to accomplish this was to create an alias field in the query portion of phprunner and concatenated this symbol before the # ' so # would be '197904292010011006

Excel interprets this as text. Then I would go to the fields settings in phprunner and uncheck the list etc for this item accept for export. Uncheck your # field on export and replace it with this one.
Hope this helps.
Steve


Clever. Thanks for sharing