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? 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 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. 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 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. 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? 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. 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. 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? 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
Archived
This topic is now archived and is closed to further replies.