PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → [WD19] How can I delete a row in a Excel file
[WD19] How can I delete a row in a Excel file
Iniciado por guest, 30,sep. 2015 11:47 - 3 respuestas
Publicado el 30,septiembre 2015 - 11:47
Hi,

I build a excel sheet with windev. After all I need to delete some rows at special conditions.
But I can´t find xlsRowdelete or something.

Any ideas ?
Publicado el 30,septiembre 2015 - 15:31
Hi Michael,

As far as I know it is not possible. Neither with xls functions nor the spreadsheet control.
I'm clearing each cell one by one...

Kind Regards,

Joris
Publicado el 30,septiembre 2015 - 17:00
Hello Michael,

2 ideas:

1. Create a new spreadsheet, and copy everything from the old one to the new one in a loop EXCEPT for the line to delete

2. Use OLE automation

Best regards
Publicado el 30,septiembre 2015 - 21:50
Hi Fabrice and Joris,

I choosed the way to overjump some rows in the creation process in conjunction of different conditions. It´s more effort but it works.