onlyican Posted September 15, 2006 Share Posted September 15, 2006 Hey guysI have a challenge in front of meI am creating a script, which allows the user to add sales of products, add stock to DB bla bla blaBut what they want is a way to export the results into a (sorry in advanced) Micro N Soft Excel Spreadhseet (I did say sorry)Any suggestions on writing Excel Spreadhseets in PHP Link to comment https://forums.phpfreaks.com/topic/20931-export-to-excel/ Share on other sites More sharing options...
Barand Posted September 15, 2006 Share Posted September 15, 2006 Easiest way is to create a CSV file which Excel will open just by double-clicking on the file icon. Link to comment https://forums.phpfreaks.com/topic/20931-export-to-excel/#findComment-92722 Share on other sites More sharing options...
gijew Posted September 15, 2006 Share Posted September 15, 2006 frwrite() and save as .csv file. If you need a header just store in a variable and prepend to the loop of your results. It's just a few lines of code. Link to comment https://forums.phpfreaks.com/topic/20931-export-to-excel/#findComment-92731 Share on other sites More sharing options...
onlyican Posted September 15, 2006 Author Share Posted September 15, 2006 Can u add Cell Formatting into Comma Seperated Value Sheets? Link to comment https://forums.phpfreaks.com/topic/20931-export-to-excel/#findComment-92734 Share on other sites More sharing options...
AndyB Posted September 15, 2006 Share Posted September 15, 2006 No Link to comment https://forums.phpfreaks.com/topic/20931-export-to-excel/#findComment-92739 Share on other sites More sharing options...
Barand Posted September 15, 2006 Share Posted September 15, 2006 For that you need COM.Try googling "php com excel" Link to comment https://forums.phpfreaks.com/topic/20931-export-to-excel/#findComment-92741 Share on other sites More sharing options...
onlyican Posted September 16, 2006 Author Share Posted September 16, 2006 Thankx I will look into COMS(And I didn't think I could add cell formatting in CVS, thats why I called it comma Seperated values) Link to comment https://forums.phpfreaks.com/topic/20931-export-to-excel/#findComment-92901 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.