Clearing Excel Cells

Post Reply
User avatar
Jeff Barnes
Posts: 933
Joined: Sun Oct 09, 2005 1:05 pm
Location: Ontario, Canada
Contact:

Clearing Excel Cells

Post by Jeff Barnes »

Hi Everybody,

Does anyone know the command to select a range of cells and completely clear that range.

I need to be able to remove the data in the cells and any formatting including the lines around the cell and any shading.
Thanks,
Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)
User avatar
nageswaragunupudi
Posts: 10721
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 8 times
Contact:

Post by nageswaragunupudi »

oSheet:Range( <spec> ):Select()
oExcel:Selection:ClearContents()
oExcel:Selection:ClearFormats()
Regards

G. N. Rao.
Hyderabad, India
User avatar
Jeff Barnes
Posts: 933
Joined: Sun Oct 09, 2005 1:05 pm
Location: Ontario, Canada
Contact:

Post by Jeff Barnes »

Thanks Nageswaragunupudi.

Exactly what I needed.
Thanks,
Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)
Post Reply