krishna.p Posted April 22, 2009 Share Posted April 22, 2009 Hi All, Iam new to php. In my php application i would like to create/update excel worksheets using php code. here i need to fetch the data from mysql database and then i have to insert into excel sheet on daily basis. The next day same procedure happens and this time i have to update the data into second worksheet of same excel sheet. Would appreciate if you guys can tell me on 1)how to create new tabs in excel worksheet and then 2)how to insert images into excel worksheet using phpcode and then 3)how to perform functions like sum,subtraction operations on the data using php code.. Thanks in advance. Thanks, krishna.p Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted April 22, 2009 Share Posted April 22, 2009 can it be done? as far as I understand it you can only use vbscript in MS office apps. Maybe have a look at COM Quote Link to comment Share on other sites More sharing options...
krishna.p Posted April 22, 2009 Author Share Posted April 22, 2009 Thanks for the reply.. till now iam able to send data to excel sheet. ie.. in my application if user clicks on EXCEL BUTTON, user will get the open, save,cancel dialog box. If he opens it, user will find the data. but in my case here, i would like to save data in sheets wise...perform some sum/substract operations on it..... is it not possible using php? Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted April 22, 2009 Share Posted April 22, 2009 yes but that dialogue is simply for downloading a generic spreadsheet clicking on your excel button I imagine is simply a link to an xls file - thats got nothing to do with php interacting with the spread sheet. Quote Link to comment Share on other sites More sharing options...
Mchl Posted April 22, 2009 Share Posted April 22, 2009 Check PHPExcel Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted April 22, 2009 Share Posted April 22, 2009 i'll bookmark that one! Quote Link to comment Share on other sites More sharing options...
nankoweap Posted April 22, 2009 Share Posted April 22, 2009 php excel looks promising. what i've done in the past is create a simple multi-worksheet spreadsheet, save it as XML, examine the XML to determine each element's XML representation and build a file using that data. it was relatively easy to decipher, but them the spreadsheets i needed to create were relatively simple in both data and formatting. i'd certainly opt for something like php excel, if it suited my needs. jason Quote Link to comment Share on other sites More sharing options...
markjoe Posted April 22, 2009 Share Posted April 22, 2009 I've done Excel sheets with COM before, it works, but is very slow. I ended up replacing that with using a Pear library, much faster, and supports tons of features. http://pear.php.net/package/Spreadsheet_Excel_Writer 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.