Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Standard Widget Toolkit (SWT) » Get table data from SWT app to EXCEL
Get table data from SWT app to EXCEL [message #466745] Tue, 17 January 2006 05:51 Go to next message
Eclipse User
Originally posted by: tyler.scott.gmx.com

Hi all,

I wrote an application in SWT that displays a big amound of data within a
table. Now I want that this table data can be used in Microsoft Excel for
further analysis. In the current version of the tool you can export the SWT
table in an CSV file and then open this file in Excel. This is a little bit
circuitous and I want to estabilish a direct connection between SWT and
Excel via OLE or something. So I push a Button in the SWT app, Excel opens
and the data appears in a new spreadsheet. This would be perfect!

Does anybody know how this could be done?

thx in advance,
volker
Re: Get table data from SWT app to EXCEL [message #466747 is a reply to message #466745] Tue, 17 January 2006 06:03 Go to previous messageGo to next message
Konstantin Scheglov is currently offline Konstantin Scheglov
Messages: 554
Registered: July 2009
Senior Member
Tyler Scott wrote:

> I wrote an application in SWT that displays a big amound of data within a
> table. Now I want that this table data can be used in Microsoft Excel for
> further analysis. In the current version of the tool you can export the SWT
> table in an CSV file and then open this file in Excel. This is a little bit
> circuitous and I want to estabilish a direct connection between SWT and
> Excel via OLE or something. So I push a Button in the SWT app, Excel opens
> and the data appears in a new spreadsheet. This would be perfect!
>
> Does anybody know how this could be done?

Use POI.

--
SY, Konstantin.
Advanced Eclipse SWT Designer (http://www.swt-designer.com)


Konstantin Scheglov,
Google, Inc.
Re: Get table data from SWT app to EXCEL [message #466791 is a reply to message #466747] Tue, 17 January 2006 14:06 Go to previous message
Haris Peco is currently offline Haris Peco
Messages: 1072
Registered: July 2009
Senior Member
Konstantin Scheglov wrote:

> Tyler Scott wrote:
>
>> I wrote an application in SWT that displays a big amound of data within a
>> table. Now I want that this table data can be used in Microsoft Excel for
>> further analysis. In the current version of the tool you can export the
>> SWT table in an CSV file and then open this file in Excel. This is a
>> little bit circuitous and I want to estabilish a direct connection
>> between SWT and Excel via OLE or something. So I push a Button in the SWT
>> app, Excel opens and the data appears in a new spreadsheet. This would be
>> perfect!
>>
>> Does anybody know how this could be done?
>
> Use POI.
>
you can open external Excel with Program or internal with Ole (or
wit OfficeBean in OpenOffice - this wokr on linux, too)
for making excel output you can use POI (like Konstantin's advice) or
jexcelapi - jasperreport use both
Previous Topic:Java SWT Minimized-Shell RAM Usage
Next Topic:How to set gradient color from left-top to right-bottom??
Goto Forum:
  


Current Time: Sun Apr 20 18:00:36 EDT 2014

Powered by FUDForum. Page generated in 0.01494 seconds