.net and Excel

T

tmaster

New Member
heya ,
im new to progress, i made some examples to learn the language
and how we work with it .

im currently facing an issue of excel and .net (on linux server) .
i understand that thru mfg/pro u can run a com-handle object
to create an excel or just use a csv file ,and in .net theres no problem using csv files .

tho to create xls files in .net u need to embed it in an html file using
either VBscript or javascript, and thus u over come the com-handle issue
and u can create xls files.

im wondering if theres any option to create xls files without an html ?
using an object just like a com-handle .

thanks in advance .
 
What I generally do in preference to using com objects to generate Excel files is to generate them in xml. Then just give them the .xls extension and Bob's your uncle. By doing it this way you can generate the files on both Windows and Unix/Linux without any problems - you will of course still need a version of Excel that can read these files to open them.

You can create your own sample Excel files by just creating a simple sheet in Excel and saving it to xml. That will show you the structure and the required elements. It's very well possible to create your own standard function/library/procedure that can do all this stuff for you so you do not have to keep re-inventing the wheel and can just call that from within your programs. Oh, one word of warning, due to all the tags that come with xml your files will be bigger than a standard xls file, so very large spreadsheets will result in very large files as well...

Hope this helps,

Paul
 
You must log in or register to reply here.
Back
Top