[SOLVED] Export to excel

[nehaa]

:(
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.
:)

[OrangeDog]

No, it's not possible. You'll have to re-write it in Java. Creating a csv file is the simplest, and will be readable in excel.

[nehaa]

how csv files can be created in core java application taking data from ms-access database???

however
Now I have thought to test Jexcel api for creating excel sheets.
I'm facing the following problem :-

Project1.java:4211: reference to Font is ambiguous, both class jxl.write.Font in jxl.write and class java.awt.Font in java.awt match


Project1.java:2472: reference to Label is ambiguous, both class jxl.write.Label in jxl.write and class
java.awt.Label in java.awt match

how to solve it????

thanks for ur consideration
waiting for reply

[OrangeDog]

I mention csv as it's a very simple format - commas separate columns, newlines separate rows.

You've imported multiple classes with the same name. Either only import the classes you need, or if you need them both you have to use the full name (i.e. jxl.write.Font).

[nehaa]

I have no problem using csv files.

But I am unable to understand how data from ms-accesss can be brought to csv file and then converting this csv file to excel.
And all this is to be done using core java.

If you please help me out.

thanks again
waiting for your reply

[OrangeDog]

Use a JDBC driver to connect to the database. Excel will read csv with no problems. If you want to create an .xls or .xlsx you'll need to use an excel java library like that JExcel you found.

[nehaa]

I am using Jexcel API
I have created workbook,worksheet........
But i am unable to set value of cells as Strings.
I searched for it but only came to know about Number class in JExcel which sets number as cell value.

But in my database I have many tables having columns of Strings , date etc.

How to put them in excel Worksheet using Jexcel???

If you please help me out.

Thanks a lot

[OrangeDog]

Cell (JExcel 1.3 Documentation)

[nehaa]

:)My problem is solved

Thanks a lot for your great help.:)

[nehaa]

I tried a lot but couldnot find way to close thread.
:confused:

Thanks

[OrangeDog]

Use Thread Tool at the top of the thread