Madnhain Posted April 24, 2011 Share Posted April 24, 2011 Is it possible to export a single value from a mysql DB into a pre-existing excel spread sheet? I know how to create a spread sheet from php and mysql, but not a single value into a pre-existing excel document cell. here's basically what I'm doing: Creating a financial expense tracking report in php, user will input each expense, it will keep a running tally of the available funds in user's bank account. The user has an excel spread sheet that requires the current value of available funds and updates a budget forecast according. SO, I need to somehow get the available balance of the bank account (generated by user input) into the pre-existing excel spreadsheet. Any thoughts? I'm totally at a loss. Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/234556-export-value-to-excel/ Share on other sites More sharing options...
firedealer Posted April 24, 2011 Share Posted April 24, 2011 I'm not expert with XML, but XPATH address to a specific cell is possible? I'm just give an idea, so you can investigate this deeper. Quote Link to comment https://forums.phpfreaks.com/topic/234556-export-value-to-excel/#findComment-1205442 Share on other sites More sharing options...
Madnhain Posted April 24, 2011 Author Share Posted April 24, 2011 Thanks, I'll look into that. I'm not familiar with XPATH and quite novice at XML, just from a quick look into this, it seems there isn't really a "quick fix". Quote Link to comment https://forums.phpfreaks.com/topic/234556-export-value-to-excel/#findComment-1205585 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.