セル範囲のフィルタリング

列のデータ全体にフィルタを適用しないで、特定の範囲のみをフィルタ対象とするには、範囲フィルタを使用できます。

ワークシートに範囲フィルタを適用するには、フィルタ対象の範囲を指定し、フィルタした範囲を取得するにはIRangeインタフェースのAutoFilterメソッドを使用する必要があります。

	コードのコピー
// 範囲フィルタリング。 GcSpreadSheet.Workbook.Worksheets[1].Range("B2").Value = "Banana"; GcSpreadSheet.Workbook.Worksheets[1].Range("B3").Value = "Banana"; GcSpreadSheet.Workbook.Worksheets[1].Range("B4").Value = "Apple"; GcSpreadSheet.Workbook.Worksheets[1].Range("B5").Value = "Orange"; GcSpreadSheet.Workbook.Worksheets[1].Range("B6").Value = "Banana"; GcSpreadSheet.Workbook.Worksheets[1].Range("B7").Value = "Orange"; GcSpreadSheet.Workbook.Worksheets[1].Range("B8").Value = "Apple"; GcSpreadSheet.Workbook.Worksheets[1].Range("B9").Value = "Banana"; GcSpreadSheet.Workbook.Worksheets[1].Range("C2").Value = "Banana"; GcSpreadSheet.Workbook.Worksheets[1].Range("C3").Value = "Orange"; GcSpreadSheet.Workbook.Worksheets[1].Range("C4").Value = "Apple"; GcSpreadSheet.Workbook.Worksheets[1].Range("C5").Value = "Banana"; GcSpreadSheet.Workbook.Worksheets[1].Range("C6").Value = "Orange"; GcSpreadSheet.Workbook.Worksheets[1].Range("C7").Value = "Orange"; GcSpreadSheet.Workbook.Worksheets[1].Range("C8").Value = "Apple"; GcSpreadSheet.Workbook.Worksheets[1].Range("C9").Value = "Banana"; GcSpreadSheet.Workbook.Worksheets[1].Range("D2").Value = "Apple"; GcSpreadSheet.Workbook.Worksheets[1].Range("D3").Value = "Banana"; GcSpreadSheet.Workbook.Worksheets[1].Range("D4").Value = "Orange"; GcSpreadSheet.Workbook.Worksheets[1].Range("D5").Value = "Apple"; GcSpreadSheet.Workbook.Worksheets[1].Range("D6").Value = "Banana"; GcSpreadSheet.Workbook.Worksheets[1].Range("D7").Value = "Orange"; GcSpreadSheet.Workbook.Worksheets[1].Range("D8").Value = "Apple"; GcSpreadSheet.Workbook.Worksheets[1].Range("D9").Value = "Banana"; GcSpreadSheet.Workbook.Worksheets[1].Name = " RangeFiltering"; // 次のコードは、列C（1はフィルターの左列Bから2番目の列）を「Banana」でフィルタします。 GcSpreadSheet.Workbook.Worksheets[1].Range("B1:D10").AutoFilter(1, "Banana");

コードのコピー

// 範囲フィルタリング。
GcSpreadSheet.Workbook.Worksheets[1].Range("B2").Value = "Banana";
GcSpreadSheet.Workbook.Worksheets[1].Range("B3").Value = "Banana";
GcSpreadSheet.Workbook.Worksheets[1].Range("B4").Value = "Apple";
GcSpreadSheet.Workbook.Worksheets[1].Range("B5").Value = "Orange";
GcSpreadSheet.Workbook.Worksheets[1].Range("B6").Value = "Banana";
GcSpreadSheet.Workbook.Worksheets[1].Range("B7").Value = "Orange";
GcSpreadSheet.Workbook.Worksheets[1].Range("B8").Value = "Apple";
GcSpreadSheet.Workbook.Worksheets[1].Range("B9").Value = "Banana";
GcSpreadSheet.Workbook.Worksheets[1].Range("C2").Value = "Banana";
GcSpreadSheet.Workbook.Worksheets[1].Range("C3").Value = "Orange";
GcSpreadSheet.Workbook.Worksheets[1].Range("C4").Value = "Apple";
GcSpreadSheet.Workbook.Worksheets[1].Range("C5").Value = "Banana";
GcSpreadSheet.Workbook.Worksheets[1].Range("C6").Value = "Orange";
GcSpreadSheet.Workbook.Worksheets[1].Range("C7").Value = "Orange";
GcSpreadSheet.Workbook.Worksheets[1].Range("C8").Value = "Apple";
GcSpreadSheet.Workbook.Worksheets[1].Range("C9").Value = "Banana";
GcSpreadSheet.Workbook.Worksheets[1].Range("D2").Value = "Apple";
GcSpreadSheet.Workbook.Worksheets[1].Range("D3").Value = "Banana";
GcSpreadSheet.Workbook.Worksheets[1].Range("D4").Value = "Orange";
GcSpreadSheet.Workbook.Worksheets[1].Range("D5").Value = "Apple";
GcSpreadSheet.Workbook.Worksheets[1].Range("D6").Value = "Banana";
GcSpreadSheet.Workbook.Worksheets[1].Range("D7").Value = "Orange";
GcSpreadSheet.Workbook.Worksheets[1].Range("D8").Value = "Apple";
GcSpreadSheet.Workbook.Worksheets[1].Range("D9").Value = "Banana";
GcSpreadSheet.Workbook.Worksheets[1].Name = " RangeFiltering";

// 次のコードは、列C（1はフィルターの左列Bから2番目の列）を「Banana」でフィルタします。
GcSpreadSheet.Workbook.Worksheets[1].Range("B1:D10").AutoFilter(1, "Banana");

	コードのコピー
'範囲フィルタリング。 GcSpreadSheet.Workbook.Worksheets(1).Range("B2").Value = "Banana" GcSpreadSheet.Workbook.Worksheets(1).Range("B3").Value = "Banana" GcSpreadSheet.Workbook.Worksheets(1).Range("B4").Value = "Apple" GcSpreadSheet.Workbook.Worksheets(1).Range("B5").Value = "Orange" GcSpreadSheet.Workbook.Worksheets(1).Range("B6").Value = "Banana" GcSpreadSheet.Workbook.Worksheets(1).Range("B7").Value = "Orange" GcSpreadSheet.Workbook.Worksheets(1).Range("B8").Value = "Apple" GcSpreadSheet.Workbook.Worksheets(1).Range("B9").Value = "Banana" GcSpreadSheet.Workbook.Worksheets(1).Range("C2").Value = "Banana" GcSpreadSheet.Workbook.Worksheets(1).Range("C3").Value = "Orange" GcSpreadSheet.Workbook.Worksheets(1).Range("C4").Value = "Apple" GcSpreadSheet.Workbook.Worksheets(1).Range("C5").Value = "Banana" GcSpreadSheet.Workbook.Worksheets(1).Range("C6").Value = "Orange" GcSpreadSheet.Workbook.Worksheets(1).Range("C7").Value = "Orange" GcSpreadSheet.Workbook.Worksheets(1).Range("C8").Value = "Apple" GcSpreadSheet.Workbook.Worksheets(1).Range("C9").Value = "Banana" GcSpreadSheet.Workbook.Worksheets(1).Range("D2").Value = "Apple" GcSpreadSheet.Workbook.Worksheets(1).Range("D3").Value = "Banana" GcSpreadSheet.Workbook.Worksheets(1).Range("D4").Value = "Orange" GcSpreadSheet.Workbook.Worksheets(1).Range("D5").Value = "Apple" GcSpreadSheet.Workbook.Worksheets(1).Range("D6").Value = "Banana" GcSpreadSheet.Workbook.Worksheets(1).Range("D7").Value = "Orange" GcSpreadSheet.Workbook.Worksheets(1).Range("D8").Value = "Apple" GcSpreadSheet.Workbook.Worksheets(1).Range("D9").Value = "Banana" GcSpreadSheet.Workbook.Worksheets(1).Name = " RangeFiltering" '次のコードは、列C（1はフィルターの左列Bから2番目の列）を「Banana」でフィルタします。 GcSpreadSheet.Workbook.Worksheets(1).Range("B1:D10").AutoFilter(1, "Banana");

コードのコピー

'範囲フィルタリング。
 GcSpreadSheet.Workbook.Worksheets(1).Range("B2").Value = "Banana"
 GcSpreadSheet.Workbook.Worksheets(1).Range("B3").Value = "Banana"
 GcSpreadSheet.Workbook.Worksheets(1).Range("B4").Value = "Apple"
 GcSpreadSheet.Workbook.Worksheets(1).Range("B5").Value = "Orange"
 GcSpreadSheet.Workbook.Worksheets(1).Range("B6").Value = "Banana"
 GcSpreadSheet.Workbook.Worksheets(1).Range("B7").Value = "Orange"
 GcSpreadSheet.Workbook.Worksheets(1).Range("B8").Value = "Apple"
 GcSpreadSheet.Workbook.Worksheets(1).Range("B9").Value = "Banana"
 GcSpreadSheet.Workbook.Worksheets(1).Range("C2").Value = "Banana"
 GcSpreadSheet.Workbook.Worksheets(1).Range("C3").Value = "Orange"
 GcSpreadSheet.Workbook.Worksheets(1).Range("C4").Value = "Apple"
 GcSpreadSheet.Workbook.Worksheets(1).Range("C5").Value = "Banana"
 GcSpreadSheet.Workbook.Worksheets(1).Range("C6").Value = "Orange"
 GcSpreadSheet.Workbook.Worksheets(1).Range("C7").Value = "Orange"
 GcSpreadSheet.Workbook.Worksheets(1).Range("C8").Value = "Apple"
 GcSpreadSheet.Workbook.Worksheets(1).Range("C9").Value = "Banana"
 GcSpreadSheet.Workbook.Worksheets(1).Range("D2").Value = "Apple"
 GcSpreadSheet.Workbook.Worksheets(1).Range("D3").Value = "Banana"
 GcSpreadSheet.Workbook.Worksheets(1).Range("D4").Value = "Orange"
 GcSpreadSheet.Workbook.Worksheets(1).Range("D5").Value = "Apple"
 GcSpreadSheet.Workbook.Worksheets(1).Range("D6").Value = "Banana"
 GcSpreadSheet.Workbook.Worksheets(1).Range("D7").Value = "Orange"
 GcSpreadSheet.Workbook.Worksheets(1).Range("D8").Value = "Apple"
 GcSpreadSheet.Workbook.Worksheets(1).Range("D9").Value = "Banana"
 GcSpreadSheet.Workbook.Worksheets(1).Name = " RangeFiltering"

'次のコードは、列C（1はフィルターの左列Bから2番目の列）を「Banana」でフィルタします。
GcSpreadSheet.Workbook.Worksheets(1).Range("B1:D10").AutoFilter(1, "Banana");