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 10:51 Go to next message
Eclipse UserFriend
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 11:03 Go to previous messageGo to next message
Konstantin Scheglov is currently offline Konstantin ScheglovFriend
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.
Re: Get table data from SWT app to EXCEL [message #466791 is a reply to message #466747] Tue, 17 January 2006 19:06 Go to previous message
Haris Peco is currently offline Haris PecoFriend
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: Mon Dec 22 09:24:11 GMT 2014

Powered by FUDForum. Page generated in 0.02471 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software