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! 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. 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". Link to comment https://forums.phpfreaks.com/topic/234556-export-value-to-excel/#findComment-1205585 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.