samona Posted July 31, 2008 Share Posted July 31, 2008 Hi, Is there a way to export dynamic HTML output from php into an excel file? Any ideas how? Quote Link to comment https://forums.phpfreaks.com/topic/117591-export-php-html-output-into-excel/ Share on other sites More sharing options...
cooldude832 Posted July 31, 2008 Share Posted July 31, 2008 cntrl +c , cntrl +v Quote Link to comment https://forums.phpfreaks.com/topic/117591-export-php-html-output-into-excel/#findComment-604838 Share on other sites More sharing options...
discomatt Posted July 31, 2008 Share Posted July 31, 2008 That one is VERY tricky, considering there's a very large number of ways the html and the excel file could be formatted. Quote Link to comment https://forums.phpfreaks.com/topic/117591-export-php-html-output-into-excel/#findComment-604850 Share on other sites More sharing options...
samona Posted July 31, 2008 Author Share Posted July 31, 2008 I have a php script that outputs tables in html. I want to be able to export that data into excel. I'm not sure what steps to take. I then want to email that excel file. I want this done automatically using a script. Not manually lol Quote Link to comment https://forums.phpfreaks.com/topic/117591-export-php-html-output-into-excel/#findComment-604885 Share on other sites More sharing options...
discomatt Posted July 31, 2008 Share Posted July 31, 2008 The easiest way is to generate a CSV file from the data directly. There's plenty of information on creating a CSV file from PHP data on the web. CSV files can be read by Excel. Quote Link to comment https://forums.phpfreaks.com/topic/117591-export-php-html-output-into-excel/#findComment-604891 Share on other sites More sharing options...
samona Posted July 31, 2008 Author Share Posted July 31, 2008 Just so I know i'm understanding it currently 1. Output the php as a csv file 2. import the csv file into an excel file 3. email the excel file Would that work, or do I have to do any special steps to output the html as csv file? Quote Link to comment https://forums.phpfreaks.com/topic/117591-export-php-html-output-into-excel/#findComment-604894 Share on other sites More sharing options...
discomatt Posted July 31, 2008 Share Posted July 31, 2008 Just email the CSV file. Most systems will open it with Excel if it's installed. Quote Link to comment https://forums.phpfreaks.com/topic/117591-export-php-html-output-into-excel/#findComment-604896 Share on other sites More sharing options...
samona Posted July 31, 2008 Author Share Posted July 31, 2008 The thing is I want to email it to a cell phone. when its emailed as excel file it shows up really nicely. Quote Link to comment https://forums.phpfreaks.com/topic/117591-export-php-html-output-into-excel/#findComment-604901 Share on other sites More sharing options...
samona Posted August 1, 2008 Author Share Posted August 1, 2008 anyone can help? Quote Link to comment https://forums.phpfreaks.com/topic/117591-export-php-html-output-into-excel/#findComment-605472 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.