如何删除没有标题从Excel工作表删除的行? [英] How to delete rows without headings getting deleted from excel sheet ?

问题描述

我想每次将新数据插入excel工作表时都删除行.我尝试使用sql查询从[Sheet1 $]中删除".但是gt IASM.plz帮助中不支持删除的错误；

I want to delete rows each time my new data gets inserted into the excel sheet.i tried using sql query ''delete from [Sheet1$]''.but gt an error that deleteing not supported in IASM.plz help;

推荐答案

''.但是gt IASM.plz帮助中不支持删除的错误；

''.but gt an error that deleteing not supported in IASM.plz help;

对，你是什么用于访问电子表格中的数据，自动化还是其他?

首先要做的是搜索google，因为excel无论如何都不使用sql样式或形式的查询.以下是几个链接供您查看:

http://support.microsoft.com/kb/302084 [ http://csharp.net-informations.com/excel/csharp-excel-tutorial.htm [^ ]

第二个链接是关于与excel有关的任何事情的一项非常有用的研究，当我需要一点信息时，我将其用作主要的分页信息，几乎所有您需要的与c#excel有关的内容都将在这里.

丹

right, what are you using to access the data in the spreadsheet, automation or something else?

The first thing to do is search google because excel does not use sql style queries in anyway shape or form. Here are a couple of links for you to have a look at:

http://support.microsoft.com/kb/302084[^]

http://csharp.net-informations.com/excel/csharp-excel-tutorial.htm[^]

The second link is an extremely useful research in regards to anything to do with excel, I use it as my primary go to pag whenever I need a bit of info pretty much everything you will ever need in regards to c# excel will be on here.

Dan

这篇关于如何删除没有标题从Excel工作表删除的行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！