Eclipse Community Forums: Standard Widget Toolkit (SWT) » Get table data from SWT app to EXCEL

Help

Home

Home » Eclipse Projects » Standard Widget Toolkit (SWT) » Get table data from SWT app to EXCEL

Show: Today's Messages :: Show Polls :: Message Navigator

Get table data from SWT app to EXCEL [message #466745]

Tue, 17 January 2006 10:51

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

Report message to a moderator

Re: Get table data from SWT app to EXCEL [message #466747 is a reply to message #466745]

Tue, 17 January 2006 11:03

Konstantin Scheglov

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

Report message to a moderator

Re: Get table data from SWT app to EXCEL [message #466791 is a reply to message #466747]

Tue, 17 January 2006 19:06

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

Report message to a moderator

Previous Topic:	Java SWT Minimized-Shell RAM Usage
Next Topic:	How to set gradient color from left-top to right-bottom??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 13:14:30 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter