Currently I'm using the Jakarta POI project to write data in Excel file
format. Is there something equivalent available in .NET as we're thinking
of converting to J#?
Or, can I use third-party jar files in J#?
Thanks.

Jeff

"Jeff Goble" <jeffgoble (AT) prunethis (DOT) earthlink.net> a écrit dans le message de
news: efe6uXRnEHA.3172 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
There are some third party libraries that read and write Excel files without
going through Excel automation (so you can deploy your app on PCs that don't
have Excel). Take a look at http://www.syncfusion.com/Products/excelrw.aspx
for example.

Bruno.

"Jeff Goble" <jeffgoble (AT) prunethis (DOT) earthlink.net> wrote

Hi Jeff,

To generate Excel and Word in .NET or Java you can use SoftArtisans OfficeWriter:

http://officewriter.softartisans.com

-Chris

Hi Jeff,

Very timely post. I have just today grabbed all of the POI stuff and am
trying to port it to J#. I've run across an issue, perhaps we can help each
other out. I'm more comfortable with C++ and VB.net, and deciced to use J#
just to minimize porting hassles, but its not my strength.

First, to the others in this topic, Automation is not desirable when you
want a general purpose utility that may run in the background. Automation is
explicitly described as dangerous outside of desktop interactive situations.
Unfortunatley you have to get down and dirty and write OLE 2.0 container
files. I had hoped that there would be .NET OLE 2.0 calls but could not find
them.

The POI stuff seems, so far, to be marvelous to work with.

I actually got the POI file system code ported to J# in about 2 hours. I was
impressed, never having written a J# program before.

After porting I called their test routine, which read in and wrote out the
file, and it worked! Excel read the output file with no errors. The only
change i had to make was to convert calls to Java.Arrays functions not
supported by J#, which was a snap.

Next I moved on to HSSF, which implements the Excel file format (within the
POI)

I'm running into problems with the java.Stack type. The POI code uses the
Stack type and then wants to access those variables as a list (ie. calling
'get', not 'pop'), and Visual Studio is complaing about this. It doesn't
like the java.Stack data type.

I'd be happy to send you the J# project as i have it now if you have J#
expertise and would be willing to share the results.

John Mott
VP Software Development
CRE Technologies
johnmott (AT) comcast (DOT) net


"Jeff Goble" <jeffgoble (AT) prunethis (DOT) earthlink.net> wrote

This describes the issues involving server side automation.

http://support.microsoft.com/default...b;en-us;257757

John


"Lars-Inge Tønnessen [VJ# MVP]" <http://emailme.larsinge.com> wrote in
message news:%23yQkxCwoEHA.2864 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Microsoft doesn't suggest automating Excel from multithreaded apps, for
performance and stability reasons from what I've read in the past

there shouldn't be some licensing problem, unless maybe if you make a
web-based Excel front-end that just uses Excel under the hood

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
George Birbilis <birbilis (AT) kagi (DOT) com> [Microsoft MVP J#]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ QuickTime VCL and ActiveX controls (for PowerPoint/VB/Delphi etc.)
+ Plugs VCL and ActiveX controls (InterProcess/Internet communication)
+ TransFormations, VB6 forms to ASP.net WebForms convertion
http://www.kagi.com/birbilis
+ Robotics
http://www.mech.upatras.gr/~robgroup
.................................................. .......................

grab the "Supplemental UI library" for J# from MS J# site. It should have
Collections support equivalent to Sun Java1.2 (apart from the Swing stuff it
has in there)


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
George Birbilis <birbilis (AT) kagi (DOT) com> [Microsoft MVP J#]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ QuickTime VCL and ActiveX controls (for PowerPoint/VB/Delphi etc.)
+ Plugs VCL and ActiveX controls (InterProcess/Internet communication)
+ TransFormations, VB6 forms to ASP.net WebForms convertion
http://www.kagi.com/birbilis
+ Robotics
http://www.mech.upatras.gr/~robgroup
.................................................. .......................

I read JLCA (Java Language Convertion Assistant [Java->C#]) just added RMI
support, so wonder why J# hasn't yet (maybe they're planning it)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
George Birbilis <birbilis (AT) kagi (DOT) com> [Microsoft MVP J#]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ QuickTime VCL and ActiveX controls (for PowerPoint/VB/Delphi etc.)
+ Plugs VCL and ActiveX controls (InterProcess/Internet communication)
+ TransFormations, VB6 forms to ASP.net WebForms convertion
http://www.kagi.com/birbilis
+ Robotics
http://www.mech.upatras.gr/~robgroup
.................................................. .......................

Jeff Goble wrote:

-
eusdar
-----------------------------------------------------------------------
Posted via http://www.codecomments.co
-----------------------------------------------------------------------