write "=COUNT(..)" from Progress to Excel?
Fri, 2010-10-15 14:12 — Vasile S
| Project: | Browse-to-Excel |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
Hello.
I'm trying to output something to Excel and make some calculations.
Some (basic math) functions works.. some not.
See attached sample procedure - errors I get are listed in there.
I'm using OpenEdge 10.0B02 and there's Excel 2007 installed.
With Progress COM Object Viewer I can open EXCEL.EXE and XL5EN32.OLB
Thank you in advance,
Vasile S.
| Attachment | Size |
|---|---|
| outp-to-excel.p | 1.63 KB |
- Login to post comments
Comments
#1
You just need to change the ; to , and it works fine.
change:
=COUNTIF(A2:A11;6)
to:
=COUNTIF(A2:A11,6)
note: it's always a good idea to open up Excel to verify your formulas.
-Rob W
#2
Thank you Rob.. I didn't see that coming.. :(
I've copied the formula (have to say that there were no errors!) from Excel into the procedure! And also I have write the formula from Progress without the leading "=" and add it (the "=") afterwards, in the xls created by my procedure - again Excel did not find anything wrong.
And by this I've learned that the regional settings of the Windows affect the way the formulas have to be written in Excel.I forget to mention that Windows and the Office installation uses the (continental) european regional settings..... In this case, functions must use the ";" instead of "," between parameters!
So.. it looks like the the Excel automation engine is checking syntax in the "american way", although the rgional settings says it otherwise... :D
I'm looking forward to go back on Monday and check this.. I'll let you know if it works - but I don't see why not.
Thanks again!
Vasile S.
#3
yep.. that was the problem.
Comma have to be used between functions parameters, although it will be displayed as ";" when regional settings set "," as decimal separator....
Thanks Rob!
V.
PS: how do I set the status of this issue to "closed"?!