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 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 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?
:

: : : 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?
: :
:
:

ok i read the articel but as i saw you can only read the spreedsheet with the odbc driver ?!

You wanted to write (export) to the spreedsheet.....

Further i think under linux as i know also the odbc driver can be used so google for the table calculation software which you have and hope there are odbc driver support for this product then you could use the same methode like in the article...

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

: : : : 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?

: : : : : 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?
:
Look at this pdf file under Chapter 3

http://wi.wu-wien.ac.at/rgf/diplomarbeiten/BakkStuff/2006/200607_Prem/20060724_ooRexxSnippetsOOoWriter_2.1_odt.pdf

there is a description of openoffice interface uno ??

it says it can be talked over this interface with openoffice from any language check it out i hope it works......