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 Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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? Quote Link to comment Share on other sites More sharing options...
AndyB Posted September 15, 2006 Share Posted September 15, 2006 No Quote Link to comment 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" Quote Link to comment 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) Quote Link to comment 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.