excel

fellows, I am writing a program with OpenEdge Progress 11.7, which is to validate an excel file provided by internal users. One of the things that I need to validate is the number of digits that the decimal numbers have on the spreadsheet. On the excel, the decimal numbers are displayed with 4...

Has anyone used Excel's RemoveDuplicates method in Progress 4GL? Could you tell me what the syntax is? Example in VBA ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes

Estimados: Teníamos implementada la función diseñada por Jan Sutjahjo que publicó hace 14 años en el 2008 (archivo tt2xls.i) para un excel con más de 100 mil lineas y la función tardaba alrededor de 5 horas en crear el Excel. Logramos reducir la construcción del Excel a 7 minutos a partir de...

Hi - I've recorded a macro to change the left margin in an Excel spreadsheet. ActiveSheet.Pagesetup.LeftMargin = Application.InchesToPoints(0.25). Does anyone know the syntax when doing this via Progress, version 9.1c? I've substituted ":" for the ".", but it doesn't like 'LeftMargin" or...

I want to open 3 sheets in an excel file using progress 4gl and export data into it. Currently i am generating 3 csv files which i have to mail to users. I want to generate the data in the 3 csv in a single csv or excel file with 3 sheets. Can some 1 help me out with this??

Hi, i have a problem with OpenOffice...i would like to format a cell in text-format "@". I found this Code on OEHive, but it doesn't work (http://www.oehive.org/files/calcUtils.i.txt): DEF VAR mpLocale AS COM-HANDLE NO-UNDO. /* Get the current cell */ chCell =...

The DocxFactory project is a free tool for generating .DOCX and .XLSX files using Progress OpenEdge 4GL/ABL. Features at a glance - Simple to use - To create a .DOCX or .XLSX file, design a template (regular .DOCX or .XLSX file) and merge your data with the template using 4GL/ABL. No technical...