从Excel工作表中清除数据 [英] clearing data from excel sheet

问题描述

我有一个应用程序，用户通过该应用程序在每个特定时间间隔后以表格形式输入其任务，并将输入的数据插入到excel工作表中.该表格具有指向excel工作表的报告的链接，其中存储了所有数据.当我按下链接时，输入的数据会成倍增加.无论如何，它存在以便我可以在将数据插入程序中之前清除excel工作表.我已经尝试了SQL查询，例如delete和将每列更新为null.但是没有工作.请帮助...
提前Thnx.

Hi,
I have an application by which a user enters his task in the form aft every specific time interval and the data entered is inserted into the excel sheet.The form has a link to the report of excel sheet where all the data is stored.so each time I m pressing the link,the data entered is getting multiplied.Is there anyway so that I can clear the excel sheet before I insert the data in my program.I have tried the sql queries like delete and updating each column to null.But none worked.plz help...
Thnx in advance.

推荐答案

可以使用Clear方法:

Can you use Clear method: http://msdn.microsoft.com/en-us/library/aa223824(v=office.11).aspx[^]

这篇关于从Excel工作表中清除数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！