topic-11749

Posts: 933

Joined: Sun Oct 09, 2005 01:05 PM

Clearing Excel Cells
Posted: Fri Jun 27, 2008 05:51 PM

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)

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Clearing Excel Cells
Posted: Sat Jun 28, 2008 07:15 AM

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

Regards

G. N. Rao.

Hyderabad, India

Posts: 933

Joined: Sun Oct 09, 2005 01:05 PM

Clearing Excel Cells
Posted: Mon Jun 30, 2008 01:20 AM

Thanks Nageswaragunupudi.

Exactly what I needed.

Thanks,

Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)

FiveTech Support Forums