output to Excel File - xls
- Thread starter nate100
- Start date
If the Excel document is going to get bigger then a few lines, then I would first make a csv file like you always do and then convert that to Excel and format it the way you like. You can do this by using somthing like:
h-ws is the comhandle to the active worksheet....
This way of making Excel will proof to be much an dmuch faster then writing each cell in Excel directly.
Casper.
Code:
IF lp_savexls THEN h-ws:saveAs(REPLACE(cp_file,'csv','xls'),-4143,,,,,,). /* -4143 = xlWorkbookNormal */
NO-RETURN-VALUE h-xl:VISIBLE = NO.This way of making Excel will proof to be much an dmuch faster then writing each cell in Excel directly.
Casper.
GregTomkins
Active Member
Can you create COM handles from a P4GL character client? I was assuming he was looking for one of those utilities (which are a dime a dozen in the Java/C# world) that let you create .XLS's without having access to the Excel runtime.
I missed the character part of Progress 
We use xml to generate Excel on Appserver: http://msdn.microsoft.com/en-us/library/aa338205.aspx
Casper.
We use xml to generate Excel on Appserver: http://msdn.microsoft.com/en-us/library/aa338205.aspx
Casper.
If all you are outputting is csv format files then simply name the output as xls.
ie.
OUTPUT TO "[dir]\yourfile.xls".
your looping here.
OUTPUT CLOSE.
other than that, or for more complicated Excel files you need to create a com handle and talk to Excel directly. I can provide an example if you wish.
Paul
ie.
OUTPUT TO "[dir]\yourfile.xls".
your looping here.
OUTPUT CLOSE.
other than that, or for more complicated Excel files you need to create a com handle and talk to Excel directly. I can provide an example if you wish.
Paul
The Excel com object would need to exist on the client machine. so if it is unix then i guess not.
If this is GUI, then you already know the basis (Outputting to CSV).
Output a stream to WhatEverFileName.xls
Let Windows do the hard work for you.
You are only interested in thde data extracted from the database.
Give that data to Windows and let that sort out the formatting.
Its that simple.
Output a stream to WhatEverFileName.xls
Let Windows do the hard work for you.
You are only interested in thde data extracted from the database.
Give that data to Windows and let that sort out the formatting.
Its that simple.
I forgot to mention that it is also posible to use plain (well plain ) XML:
http://www.microsoft.com/downloads/...52-3547-420a-a412-00a2662442d9&displaylang=en
Here you find the xsd's for most office 2003 products. Fairly easy to work with.
casper.
) XML:http://www.microsoft.com/downloads/...52-3547-420a-a412-00a2662442d9&displaylang=en
Here you find the xsd's for most office 2003 products. Fairly easy to work with.
casper.