엑셀 비밀번호 sheetjs password - ChoDragon9/posts GitHub Wiki

구현 코드: https://the-next-web-research-lab.github.io/fe-dev/code-snippets/OpenSources/sheetjs.html

문제

• SheetJs 오픈 소스 버전은 엑셀 파일의 패스워드 암호화 기능을 미제공
  • https://github.com/SheetJS/sheetjs/issues/791

해결 방법

• ECMA-376 표준 암호화를 구현한 officecrypto-tool을 활용
  • https://github.com/zurmokeeper/officecrypto-tool/tree/main
• ECMA-376 암호화 키 생성 알고리즘
  • 문서: https://learn.microsoft.com/en-us/openspecs/office_file_formats/ms-offcrypto/84f1cce1-1e82-4e05-bc8e-91456ad44823
  • 구현: https://github.com/zurmokeeper/officecrypto-tool/blob/main/src/crypto/ecma376_standard.js#L7
• 스트림 데이터
  • 문서
    • EncryptedPackage: https://learn.microsoft.com/en-us/openspecs/office_file_formats/ms-offcrypto/b60c8b35-2db2-4409-8710-59d88a793f83
    • EncryptionInfo: https://learn.microsoft.com/en-us/openspecs/office_file_formats/ms-offcrypto/2895eba1-acb1-4624-9bde-2cdad3fea015
  • 구현: https://github.com/zurmokeeper/officecrypto-tool/blob/main/src/crypto/ecma376_standard.js#L198