Export to excel - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

ebosysindia · 05-11-2009, 03:52 AM

I have data in ms-access database.I want to export it to Excel on click of a button which is in front end developed in core java.
I am working on frames NOT applet.

I developed a macro in access to export data to excel.
But i dont know how to run this macro on click of a button in core java application.
Is it possible to run ms-access macro on click of a button in core java application?

If not possible kindly suggest some other way.

Kindly do me a favour in this regard.

Thanks in advance.

Grantdr · 07-02-2009, 06:33 PM

I need to export a Table information in a Excel spreadsheet to XML format. I need this to be displayed in an HTML page. I know the later part. But May I know how to export Excel to XML?

stevepeterson · 07-19-2009, 08:45 AM

You can use JXL API.

Java Excel API is a java API enabling developers to read, write, and modify Excel spreadsheets dynamically. Any operating system which can run a Java virtual machine can both process and deliver Excel spreadsheets. One nice thing about JExcelApi is that it has no dependencies on any third party libraries.

Ross Geller · 08-15-2009, 04:39 PM

I am a newbie website programmer so i am researching resources that i can use to help me learning more. I pick up some ideas from your post. Thanks