: : : : I am designing a pricing system that occasional requires users to export filtered data into a spreadsheet and make comparisons in there. Users can then alter that data and 'suck' it back into the system.
: : : : I use Eclipse based on a Linux OS. Does anyone know how i can do that?
: : : :
: : : I dont know how this could be under linux on windows system you could youse a dde connection to controll the excel sheet.
: : :
: : : But this would be a commercial product to make a dde connection.....
: : :
: : : look if it is a similar technic under linux.......
: : :
: : : or export the data into a file under a specf. folder and let the spreedsheet read the data with a macro through a button click !!
: : :
: : : i googled and fond this site
http://www.javaworld.com/javaworld/javaqa/2001-06/04-qa-0629-excel.html
: : to be very helpful but i want to run this on a Linux platform and not the windows one illustrated above. those using windows can try the above code, its very helpful. As for linux, anyone with something helpful?
: : :
: :
: :
: Perhaps OpenOffice is an idea. As far as I know it is mostly compatible with MS Office and able to run on several OSes.
:
Do yo0u know how i can do that using OpenOffice? I have it on my machine and was toying with the idea. Ms Excel got the nod coz a lot of the big guys here use that and the rule of thumb is to make them happy

How can i use OpenOffice Calc and Java?