Groups > microsoft.public.excel.programming > #110783

Re: delete data in an execl from c++

From	GS <gs@v.invalid>
Newsgroups	microsoft.public.excel.programming
Subject	Re: delete data in an execl from c++
Date	2018-11-25 14:05 -0500
Organization	A noiseless patient Spider
Message-ID	<pterpj$qen$1@dont-email.me> (permalink)
References	<320f896b-130d-4b30-8f1c-d0c78bfc9377@googlegroups.com>

Show all headers | View raw

> how can i delete data in an excel from c++ ? 
> i've tried excel_file_name.clean() but it's not working.
> thanks in advance .

Either of methods Clear OR ClearContents

Ref a Range on a specific sheet...
  appXL.ActiveWorkbook.Sheets(#).Range("A1:D11").Clear
  appXL.ActiveWorkbook.Sheets(#).Range("A1:D11").ClearContents

OR Ref a sheet...
  appXL.ActiveWorkbook.Sheets(#).Cells.Clear
  appXL.ActiveWorkbook.Sheets(#).Cells.ClearContents

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

delete data in an execl  from c++ eyahammi1994@gmail.com - 2018-11-24 12:06 -0800
  Re: delete data in an execl  from c++ GS <gs@v.invalid> - 2018-11-25 14:05 -0500

csiph-web