JavaScript Excel 동시 편집 기능

  # 프로젝트 폴더 생성 

mkdir spread-collaboration
cd spread-collaboration

 # Node.js 프로젝트 초기화 

npm init -y

 # 필수 패키지 설치 

npm install @mescius/spread-sheets \
     @mescius/spread-sheets-collaboration \
     @mescius/spread-sheets-collaboration-client \
     @mescius/js-collaboration \
     @mescius/js-collaboration-client \
     express 

  import 
express from 
 'express' 
;
 import 
{ Server } from 
 '@mescius/js-collaboration' 
;
 import 
* as 
OT from 
 '@mescius/js-collaboration-ot' 
;

 const 
app = express();
 const 
httpServer = http.createServer(app);
 const 
server = new 
Server({ httpServer });

 // OT 문서 서비스 초기화 

 const 
documentServices = new 
OT.DocumentServices();
server.useFeature(OT.documentFeature(documentServices));

httpServer.listen( 8080 
); 

  import 
* as 
GC from 
 '@mescius/spread-sheets' 
;
 import 
{ Client } from 
 '@mescius/js-collaboration-client' 
;
 import 
* as 
OT from 
 '@mescius/js-collaboration-ot-client' 
;
 import 
{ bind } from 
 '@mescius/spread-sheets-collaboration-client' 
;

 // SpreadJS 워크북 생성 

 const 
workbook = new 
GC.Spread.Sheets.Workbook( 'ss' 
);

 // 서버 연결 및 룸 참여 

 const 
conn = new 
Client().connect( 'room1' 
);
 const 
doc = new 
OT.SharedDoc(conn);
 await 
doc.fetch();

 // 문서가 없으면 생성 

 if 
(!doc.type) {
  await 
doc.create(workbook.collaboration.toSnapshot());
}

 // 워크북과 문서 바인딩 

bind(workbook, doc); 

  # 클라이언트 빌드 

npm run build

 # 서버 시작 

npm run start

 # 브라우저에서 접속 

 http://localhost:8080