Okay, I know how to export information from MySQL to an excel sheet. However, Some data is going to have html formatting. I'm having a problem with excel not translating HTML in its own cells. And whenever there is a comma, then excel will move to the next cell. For example: (Dr. Johnson M.D., B.S.E) The comma will send B.S.E. to the next cell. I'm using a contribution from www.oscommerce.com . Here's the code I am using to export: [!--coloro:#009900--][span style=\"color:#009900\"][!--/coloro--]<?php if (!$HTTP_GET_VARS['submit']) { ?> <?php echo "Export and Save Customer Data onto your Local Machine"; echo '<form action="'. $phpself.'">'; echo '<input type="submit" value="Export" name="submit"></form>'; ?> <?php } else { $contents="HR Category,Posting,Statement\n"; $user_query = mysql_query('select f.faqdesk_id , c.categories_id , f.faqdesk_question , c.categories_name , f.faqdesk_answer_short from faqdesk_description as f join faqdesk_to_categories as f2c on f.faqdesk_id = f2c.faqdesk_id join faqdesk_categories_description as c on f2c.categories_id = c.categories_id'); while($row = mysql_fetch_array($user_query)) { $contents.=$row[categories_name].","; $contents.=$row[faqdesk_question].","; $contents.=$row[faqdesk_answer_short]."\n"; } Header("Content-Disposition: attachment; filename=export.csv"); print $contents; }[!--colorc--][/span][!--/colorc--] And this works just fine - only if there is simple data. But if there is formatting or html involved (like: <b>customer name</b>) then I get the whole thing exported to the cell. Is there a way to make excel read html correctly. Or maybe a different way to code it so the html doesn't get exported? Any ideas?
