|
| [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. |
| |
| |
| | | |
|
| | | | |
| | |
|