Exporting MySQL data to excel (HTML tags)
-
I am exporting data from MySQL to excel using php. One field is having embeding code for video(with HTML tags) for eg. embedding code of youtube.com all fields data is exporting to excel perfectly but this video field is coming blank. for eg. try to export embed code of this page from mysql to excel [] blank is coming in excel When I am importing from excel to mysql its working fine. Plzzz Help. Thanks in Advance
-
I am exporting data from MySQL to excel using php. One field is having embeding code for video(with HTML tags) for eg. embedding code of youtube.com all fields data is exporting to excel perfectly but this video field is coming blank. for eg. try to export embed code of this page from mysql to excel [] blank is coming in excel When I am importing from excel to mysql its working fine. Plzzz Help. Thanks in Advance
Without seeing your code, it's a bit hard to tell. Have you tried to read the field and output it to the browser, to ensure that it is being read correctly? Also, will your method of output to excel handle the intended data? Can you manually put data into this field(or should I say- the representation of it in your php code) and have it transfered to excel?
