2. PHPRunner General questions
  3. Export Results
This topic is locked

Export Results

 		10/14/2009 13:38:53
PHPRunner General questions
W
 wengen author

Hello,
I searched the forums, but did not see an answer to this:
One of the fields that we want to export to excel is a url. Is there a way to modify export.php so that urls appear as hyperlinks in the exported .xls? We would like to show the hyperlink as "Click Here" in the excel fields.
Thanks,
wengen
J
 		Jane 10/15/2009

Wengen,
just set up this field as Hyperlink on the "View as" settings dialog on the Visual Editor tab.
W
 		wengen author 10/15/2009

Jane,
We have it set on the List Page "View As" Tab to "Hyperlink" ---> "Display Link in new Window" ----> "Display word".
It shows up correctly on the List Page, but when we export the results to Excel, the spreadsheet cells display it as a text url, not as a hyperlink like My link
Thanks
wengen
Sergey Kornilov admin 10/15/2009

It looks like you'll need to modify generated ..._export.php file. PHPRunner by default exports raw data only, not formatting or hyperlinks.
W
 		wengen author 10/15/2009

Thanks Sergey!
wengen