Creacion y manejo de Hojas de calculo Excel

Hi Pedro,

quite a large scenario... 🙂 There are more choices: it depends on how much "quick and dirty" you wanna go.

1) The simpler way:
- creation: you could dump to a CSV file and have that CSV file loaded into Excel.
- read or update: despite being deprecated, afaik DDE is still working today either in Uniface and in Excel.
Filedump instruction and DDE calls are your friends here...follow the links...

2) The programmer way:  you can easily import ALL Excel signatures into Uniface and use Excel as server to do whatever you want! Development environment command line switches are your friends here, expecially /sti...follow the link...

3) The "I do not know which Office system will be in use at customer site" way:
you can built an intermediate Uniface layer able to deal with a spreadsheet generated from an office automation package available on the market; it should be probably built based on option #2. Well...this is obviously the more complex choice...not enough time to describe it here!

Hope it helps!

Regards,
Gianni

Muchas gracias Gianni, el punto 1 evidentemente es el más sencillo pero de menos control. 

El punto 2 da un poco de miedo porque en cualquier momento deja de funcionar.

El punto 3 es el que he utilizado y el problema que tengo es que el archivo .xls debe existir y necesito crearlo al momento. El ejemplo que está en la página supone el archivo creado.

Alguna ayuda de como crearlo?

Saludos

Hi Pedro,

the quickest way is to start from an empty Excel file, previously saved on disk, using it as a template. Something like:
- filecopy myEmptyExcelFile.xlsx toBeUsedNow.xlsx
- then open file toBeUsedNow.xlsx and fill cells/row

Regards,
Gianni

Good Idea, Thanks