Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
php export problem
I have a spreadsheet in Excel 2010 into which I enter data each day. The
sheet is set up to use CONCATENATE to wrap the data with html tags and uses CONCATENATE again to bring them all together. I then right click the final CONCATENATE cell, copy the results and then paste them into the rest of the html on my raw web page. This works without any issues. However, I now need to include some PHP in the middle of all this and this is producing some odd results that I cannot remove. The copied output has a " added at the start and the same added at the end and, within the code, every " is doubled so that something like <p class="subtitle" becomes <p class=""subtitle"". The PHP is held in one cell with ALT-Enter used to put each statement on a separate line within the cell. The actual PHP looks like: <?php $json_string = file_get_contents('http://website_address.json'); $parsed_json = json_decode($json_string); $weathernow = $parsed_json-{'current_observation'}-{'weather'}; // $time = $parsed_json-{'current_observation'}-{'observation_time'}; $icon = $parsed_json-{'current_observation'}-{'icon_url'}; $text1 = "The current weather here is<span class=lowercase $weathernow</span <img class=middle src="; $text2 = ""; echo $text1,$icon,$text2; ? Could anyone offer a way to stop the addition of the " characters and their duplication and why would the addition of the PHP code add the unwanted instances of the " character? -- F www.vulcantothesky.org - keep the last remaining Vulcan flying |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
php export problem | Excel Discussion (Misc queries) | |||
Odd Export as PDF problem - Killing me. | Excel Programming | |||
Export txt file problem | Excel Programming | |||
Export data problem | Excel Programming | |||
Another problem with export to TXT | Excel Programming |