Using Aspose.Cells

[Kris Sercu]

Hi,

we currently have an OE10 application running that generates Excel documents on the server side. Some of those excel files contain a lot of data and thus take up a lot of resources. The result is that users are starting to complain about the performance of our system.

My company now is changing policy about using Excel on the server side, just to avoid performance problems... They are plannng to switch to Aspose.Cells (www.aspose.com) to generate the excel documents. It should be a lot faster and take up a lot less server time.
Aspose.Cells is a DLL that we would have to call from our program instead of the Excel object.
The Aspose website only explains how to use the DLL in a .NET or Java environment. Since I know nothing about those 2 I have a few questions:

• does anyone have experience with Aspose.Cells with OE10 or Progress?
• If yes: would you like to explain how to use the DLL in a program? How to instantiate?
• If no: could you explain me in general how to use DLL's in an OE10 program? It's my first encounter with using a DLL from one of my programs. So: knowing how to instantiate and use the DLL would be very useful

Thanks in advance!

Cheers,
Kris

 

[joey.jeremiah]

OpenXML !!

 

[Kris Sercu]

Thanks for the detailed reply :lol:

Anyway, my company's policy is to get rid of MS Office completely on the server side, so "OpenXML!!" isn't a valid answer, I guess.
MS Office takes too much resources away from the server...
We could easily make CSV's, but we have to have formatting, borders, etc..., because it's nicer to the eye and we have to mail the documents to customers...

Now back to the original questions pls

Or is there another alternative?

Kris