Excel CustomFilter 이벤트는 자동 필터가 아닌 사용자가 정의한 기준을 필터로 적용합니다.



1. 먼저 Properties 세팅을 해서 찾을 조건에 대하여 설정을 합니다. (Event Properties)


  • Event Name : 이벤트 이름


  • Excel ID : 엑셀 ID 값


  • Sheet Name (ex: Sheet1) : 표를 생성할 시트명
  • Filter Type : AutoFilter/Table
    • AutoFilter : 해당 Sheet에 있는 filter
    • Tabel Name: 테이블 이름 설정


  • Filter Column Offset : 설정 적용할 컬럼. ex)컬럼 A는 0
  • Filter1 Operator : 찾을 조건

None/Less Than/Equal/Less Than or Equal/Greater Than/Not Equal/Greater Than Or Equal/

Begins With/Not Begin With/Ends With/Not Ends With/

Contains/Not Contains/

Date is Before/Date is Before Or Equal/Is After/Date Is After Or Equal/

Top Items/Top Percent/Bottom Items/Bottom Percent/AboveAverage/BelowAverage/

Tomorrow/Today/Yesterday/

NextWeek/ThisWeek/LastWeek/

NextMonth/ThisMonth/LastMonth/

NextQuarter/ThisQuarter/LastQuarter/

NextYear/ThisYear/LastYear/YearToDate/

Q1/Q2/Q3/Q4/

M1/M2/M3/M4/M5/M6/M7/M8/M9/M10/M11/M12

  • Filter1 Value : 적용할 데이터
  • Filter Combination : 병합 필터. And/Or
  • Filter2 Operator : 찾을 조건

None/Less Than/Equal/Less Than or Equal/Greater Than/Not Equal/Greater Than Or Equal/

Begins With/Not Begin With/Ends With/Not Ends With/

Contains/Not Contains/

Date is Before/Date is Before Or Equal/Is After/Date Is After Or Equal/

Top Items/Top Percent/Bottom Items/Bottom  Percent/AboveAverage/BelowAverage/

Tomorrow/Today/Yesterday/

NextWeek/ThisWeek/LastWeek/

NextMonth/ThisMonth/LastMonth

/NextQuarter/ThisQuarter/LastQuarter

/NextYear/ThisYear/LastYear/YearToDate

/Q1/Q2/Q3/Q4/

M1/M2/M3/M4/M5/M6/M7/M8/M9/M10/M11/M12

  • Filter2 Value : 적용할 데이터





2. Pre Run Script를 통하여 변수 대입 및 동적인 처리가 가능합니다.





[참고사항]

- 엑셀 ID는 Alias로써 여러 엑셀 파일을 열때도 Alias 명으로 설정하시면 됩니다.


Created with the Personal Edition of HelpNDoc: Easily create PDF Help documents