PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WEBDEV 2024 → how to delete column in  Xls file
how to delete column in Xls file
Débuté par Veer, 31 aoû. 2018 14:56 - 5 réponses
Membre enregistré
13 messages
Popularité : +1 (1 vote)
Posté le 31 août 2018 - 14:56
Please tell how to delete column in xls (excel) file
Membre enregistré
498 messages
Popularité : +8 (8 votes)
Posté le 31 août 2018 - 19:50
Hi Veer

Sorry but I think Windev only can crete xls and add info I don't think He can delete colums

--
Best Regards
Jose
Membre enregistré
13 messages
Popularité : +1 (1 vote)
Posté le 01 septembre 2018 - 08:30
Thanks.Hi i need to create xls from looper with selected columns. how to create in webdev by programming
Membre enregistré
498 messages
Popularité : +8 (8 votes)
Posté le 01 septembre 2018 - 15:30
Hi Veer

Hey! I never knew that you can create a xls file from a looper only with table but!

https://help.windev.com/en-US/…

there you have it! this could work with a browsing looper or a memory looper so try it out!
Everything set on the looper should it be on your xls file with no problem just follow everything that link says
Good luck!

--
Best Regards
Jose
Membre enregistré
13 messages
Popularité : +1 (1 vote)
Posté le 02 septembre 2018 - 12:02
Thanks
Posté le 03 septembre 2018 - 15:20
Hi

you can do the following:
- record a macro in excel when you delete the column in question
- study the macro code and do the same thing using OLE automation

Of course, this means that excel needs to be available on the machine

Best regards

4--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

Free Video Courses, free WXShowroom.com, open source WXReplication, open
source WXEDM.

More information on http://www.fabriceharari.com


On 8/31/2018 6:56 AM, Veer wrote:
> Please tell how to delete column in xls (excel) file