Excel Office Scripts: Use Filter on Table and get Visible Range as Objects

Поделиться
HTML-код
  • Опубликовано: 15 сен 2024
  • For source code and input files, checkout this link:
    github.com/sum...

Комментарии • 3

  • @_Areknames_
    @_Areknames_ 2 года назад

    Great, very clear explaination and method! I have a minor question : at 3:22 you comment multiple lines at once after selecting them , how can this be achieved? thank you

    • @johnlarimer2399
      @johnlarimer2399 10 месяцев назад

      If I understand correctly, the shortcuts in the editor are based on VS Code; code.visualstudio.com/shortcuts/keyboard-shortcuts-windows.pdf

  • @akashnanndi4501
    @akashnanndi4501 2 года назад

    Hello, how do I filter pivot table by color using office scripts. I need to copy rows with specific color from pivot table