autofilter_开发者

C# Excel Automation: Retrieving rows after AutoFilter() with SpecialCells() does not seem to work properly

First time poster here :). I\'m having the following trouble automating Excel 2010 from a WinForms C# application. My test table looks the following way:[详细]

2023-04-12 18:19 分类：问答

How to make hidden rows not editable/copiable in VBA?

The macro hides rows. After the rows are hidden, users can copy, edit and delete blocks of cells/rows. When users select the range that contains hidden cells, hidden cells, unfortunately, got selected[详细]

2023-04-12 14:36 分类：问答

How to remove blank rows when using Excel VBA Autofilter

I have written a macro that searches through workbook and applies an autofilter to any listobjects which have a column named \"Code\". However, when I apply the filter, it does not filter out the blan[详细]

2023-04-12 09:49 分类：问答

Combine multiple exclusion (<>) criteria in AutoFilter

I have worked around my issue by using this dirty hack: \' Filter managerial functions ActiveSheet.Range(\"$A$1:$BW$2211\").AutoFilter Field:=36, Criteria1:=\"<>Head*\", _[详细]

2023-04-10 16:23 分类：问答

Speed up Excel Autofilter

I have a workbook that I made which generates a density map of I/O signals in an industrial plant.The whole workbook is driven by the lead sheet which the user inputs the signal type and where it is l[详细]

2023-04-07 19:53 分类：问答

Excel crashes when renewing auto-filters oncellchange

I use the following code to refresh an autofilter in Excel upon a cell change. Private Sub Worksheet_Change(ByVal Target As Range)[详细]

2023-03-23 22:53 分类：问答

Excel VBA Filtering Issue

Awesome Stackoverflow users, I am having difficulty with something that seems simple enough to not cause this much trouble. I am trying to filter a given sheet based on a criteria. Here is the code:[详细]

2023-02-02 20:59 分类：问答

Is there any Java-Excel library that supports AutoFilter in Excel?

Last开发者_如何学JAVA time I checked, Apache POI did not support this feature. If you know any solution that does, either free or commercial, please suggest.Apache POI does support AutoFilter, though[详细]

2023-01-15 12:33 分类：问答

How to make the Excel broken autofilter indicator go away?

Excel 2003 Working with a large sheet which is typically autofiltered. However when autofilter is tu开发者_运维问答rned off the indicators are still all there, they just don\'t work.[详细]

2022-12-12 12:28 分类：问答

Excel Autofilter in VB.NET

In my application I\'m exporting an Excel file by getting the layout of a HTML page. So, in my codebehind, I\'m modifying the HTML layout and inserting itens on it like if it was a webpage. Doing it t[详细]

2022-12-11 04:21 分类：问答