tinfanide Posted November 15, 2011 Share Posted November 15, 2011 I've built up the connection to SQL database with the help of PHP and AJAX.My case is thatWhen users input some info,PHP transfers the data to the SQL database But I want the SQL data to be converted to xls (I think it has to convert the data first to CSV and convert CSV to XLS for Excel)I guess if there is something to do with ASP.NET or VB to do with the Microsoft taskI want the process to be autoWhile users are inputing data,the server takes it and auto saves as XLS into the localhost machineand the other users can view the data in XLS on the local machine. Is it a must to use Microsoft languages such as ASP or VB?Can't do with PHP or SQL? Link to comment Share on other sites More sharing options...
justsomeguy Posted November 15, 2011 Share Posted November 15, 2011 I use this library to generate Excel documents: http://phpexcel.codeplex.com/ Since you posted this in the ASP forum, if you want to use ASP you should also be able to find components to help with that. http://www.google.com/search?client=opera&rls=en&q=asp+excel&sourceid=opera&ie=utf-8&oe=utf-8&channel=suggest Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.