Sign in to follow this  
boboS

Excel file manipulation

Recommended Posts

Whats the easyest way to change the content of an .xls file programatically.

I have a site with a MySQL database, users will fill some date and after that I need to change or create a new xls file automatically with the given data. Some xls files contains dropboxes that need to be selected and some formulas.

Thank you.

Share this post


Link to post
Share on other sites
[quote name='boboS' timestamp='1313769946' post='4851254']
Whats the easyest way to change the content of an .xls file programatically.

I have a site with a MySQL database, users will fill some date and after that I need to change or create a new xls file automatically with the given data. Some xls files contains dropboxes that need to be selected and some formulas.

Thank you.


[/quote]



You are looking for Excel Automation. I made some software that automatically generates Excel graphics and calculates specific things. Here is a link that will get you started:

http://www.c-sharpcorner.com/uploadfile/thiagu304/excelautomation01052007080910am/excelautomation.aspx

Here is a link to the Excel Developer Center. This will show you how to use any version of Excel. Probably the better link to follow once you get started.

http://msdn.microsoft.com/en-us/office/aa905411

Share this post


Link to post
Share on other sites
[quote name='boboS' timestamp='1313769946' post='4851254']
Whats the easyest way to change the content of an .xls file programatically.

I have a site with a MySQL database, users will fill some date and after that I need to change or create a new xls file automatically with the given data. Some xls files contains dropboxes that need to be selected and some formulas.

Thank you.


[/quote]

You could possibly use VBA language or if You have possiblity to use Visual Studio 2008 or newer
there is built-in feature of writing applications for MS Office.

Share this post


Link to post
Share on other sites
I'd suggest finding a library that will do it for you. A quick search found http://code.google.com/p/excellibrary/ and http://www.libxl.com/ for example. That way you won't need Excel installed on your web server.

Share this post


Link to post
Share on other sites
While I am not saying not to use a library, Excel can connect to a database on a remote host easily enough. So you wouldn't need to install Excel on your web server.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this