fillering_auto

[Sam1000won]

{"version":"0.3.0","body":"function main(workbook: ExcelScript.Workbook) {\n // 활성 워크시트를 받으세요.\n let selectedSheet = workbook.getActiveWorksheet();\n\n // C1 셀에서 시작합니다.\n let startCell = selectedSheet.getRange("C1:E1");\n\n // 사용된 범위를 가져오고 마지막 셀을 찾습니다.\n let usedRange = selectedSheet.getUsedRange();\n let lastCell = usedRange.getLastCell();\n\n // C1 셀에서 마지막 데이터가 있는 셀까지의 범위를 지정합니다.\n let range = selectedSheet.getRangeByIndexes(\n startCell.getRowIndex(),\n startCell.getColumnIndex(),\n lastCell.getRowIndex() - startCell.getRowIndex() + 1,\n lastCell.getColumnIndex() - startCell.getColumnIndex() + 1\n );\n\n // 지정된 범위에 필터를 적용합니다.\n selectedSheet.getAutoFilter().apply(range.getAddress());\n}\n","description":"","noCodeMetadata":null,"parameterInfo":"{"version":1,"originalParameterOrder":[],"parameterSchema":{"type":"object","default":{},"x-ms-visibility":"internal"},"returnSchema":{"type":"object","properties":{}},"signature":{"comment":"","parameters":[{"name":"workbook","comment":""}]}}","apiInfo":"{"variant":"synchronous","variantVersion":2}"}