Advanced Features

The JS-SDK provides advanced features to directly manipulate files. Below is the call process of advanced features:
1. Wait for a file to be loaded
await demo.ready() // You can call an advanced API only after the demo is ready. The demo object is the object after the JS-SDK is instantiated.
2. Get the file object
// Text
const wordApp = demo.WordApplication()
// Spreadsheet
const excelApp = demo.ExcelApplication()
// Presentation
const pptApp = demo.PPTApplication()
// PDF
const pdfApp = demo.PDFApplication()
﻿
// Automatic recognition
const app = demo.Application
3. Use advanced features
Below is the sample code of using advanced features on text, spreadsheet, presentation, and PDF files. For the specific formats supported for each file type, see Specifications and Limits.
Text file
Get the total number of pages
  /*
  * @param: WdInformation: {
  *      wdNumberOfPagesInDocument: 4
  *  }
  * @return: {PagesCount: number, End: boolean}
  */
  const app = demo.WordApplication()
  const {Enum} = app
  let totalPages = await app.ActiveDocument.Range.Information(Enum.WdInformation.wdNumberOfPagesInDocument)
  if (totalPages.End) {
    // Getting the total number of pages is an async operation. The obtained number of pages is accurate only after `totalPages.End` becomes `true`.
    console.log("All pages are loaded. There are ", totalPages.PagesCount, " pages in total.")
  }
Get the current page
  /*
  * @param: WdInformation: {
  *      wdActiveEndPageNumber: 3
  *  }
  * @return: number
  */
  const app = demo.WordApplication()
  const {Enum} = app
  let currentPage = await app.ActiveDocument.Selection.Information(Enum.WdInformation.wdActiveEndPageNumber)
Go to the specified page
  /*
  * @param: { What?: WdGoToItem, Which?: WdGoToDirection.wdGoToAbsolute, Count?: number, Name?: string}
  * WdGoToItem: {
  *      wdGoToPage: 1,
  *  }
  *  WdGoToDirection: {
  *      wdGoToAbsolute: 1
  *  }
  * @return: number Return the target page number
  */
  const app = demo.WordApplication()
  const {Enum} = app
  const page = await app.ActiveDocument.Selection.GoTo(Enum.WdGoToItem.wdGoToPage, Enum.WdGoToDirection.wdGoToAbsolute, 10)
  // Or
  const page = await app.ActiveDocument.Selection.GoTo({
    What: Enum.WdGoToItem.wdGoToPage,
    Which: Enum.WdGoToDirection.wdGoToAbsolute,
    Count: 10
  })
Set whether to show comments
  /*
  * @param: bool
  * Valid values: `true` (yes); `false` (no).
  */
﻿
  // Hide comments.
  demo.WordApplication().ActiveDocument.ActiveWindow.View.ShowComments = false
Set whether to show the table of contents
  /*
  * @param: bool
  * Valid values: `true` (yes); `false` (no).
  */
﻿
  // Hide the table of contents.
  demo.WordApplication().ActiveDocument.ActiveWindow.DocumentMap = false
Zoom the view
  /*
  * @return: number
  */
  await demo.WordApplication().ActiveDocument.ActiveWindow.View.Zoom.Percentage  // Read the view zoom level.
﻿
  /*
  * @param : 50 <= number <= 300 (The zoom level is between 50% and 300%.)
  */
  demo.WordApplication().ActiveDocument.ActiveWindow.View.Zoom.Percentage = 100  // Set the view zoom level.
Spreadsheet file
Get the names of all sheets
const app = demo.ExcelApplication()
const Names = []
// For(start, end, step, handle)
await app.For(1, app.Sheets.Count, 1, async (Index) => {
    Names.push(await app.Sheets.Item(Index).Name)
})
console.log(Names)
Get the name of the current sheet
const app = demo.ExcelApplication()
const name = await app.ActiveSheet.Name
Switch to the specified sheet
const app = demo.ExcelApplication()
const sheetIndex = 1 // Sheet number, which starts from 1.
app.Sheets.Item(sheetIndex).Activate() // Switch the sheet.
Zoom the view
  /*
  * @return: number
  */
  await demo.ExcelApplication().ActiveWorkbook.ActiveSheetView.Zoom	// Read the view zoom level.
  /*
  * @param : 10 <= number <= 500 (The zoom level is between 10% and 500%.)
  */
  demo.ExcelApplication().ActiveWorkbook.ActiveSheetView.Zoom = 100	// Set the view zoom level.
Presentation file
Get the total number of pages
  /*
  * @return: number
  */
  let totalPages = await demo.PPTApplication().ActivePresentation.Slides.Count
Get the current page
  /*
  * @return: number
  */
  let totalPages = await demo.PPTApplication().ActivePresentation.SlideShowWindow.View.Slide.SlideIndex
Go to the specified page
  /*
  * @param: number
  */
  await demo.PPTApplication().ActivePresentation.SlideShowWindow.View.GotoSlide(3)	// Go to page 3.
Start a slide show
await demo.PPTApplication().ActivePresentation.SlideShowSettings.Run()
Exit the slide show
await demo.PPTApplication().ActivePresentation.SlideShowWindow.View.Exit()
Play the next animation
  await demo.PPTApplication().ActivePresentation.SlideShowWindow.View.GotoNextClick()
Play the previous animation
  await demo.PPTApplication().ActivePresentation.SlideShowWindow.View.GotoPreClick()
Get the play status
  /*
  * @return: string ('preview' | 'play')
  */
  let currentState = await demo.PPTApplication().ActivePresentation.SlideShowWindow.View.State
Zoom the view
  /*
  * @return: number
  */
  await demo.PPTApplication().ActivePresentation.View.Zoom	// Read the view zoom level.
  /*
  * @param : 1 <= number <= 400 (The zoom level is between 1% and 400%.)
  */
  demo.PPTApplication().ActivePresentation.View.Zoom = 100	// Set the view zoom level (non-play mode).
PDF file
Get the total number of pages
  /*
  * @return: number
  */
  let totalPages = await demo.PDFApplication().ActivePDF.PagesCount
Get the current page
  /*
  * @return: number
  */
  let totalPages = await demo.PDFApplication().ActivePDF.CurrentPage
Go to the specified page
  /*
  * @param : { PageNum: number }
  */
  let PageNum = 10
  await demo.PDFApplication().ActivePDF.JumpToPage({PageNum})
Set the page rendering mode
  /*
  * 1: Single-page mode
  * 0: Multi-page mode
  */
﻿
  demo.PDFApplication().ActivePDF.PageMode = 1	  // Set the single-page mode.
Set whether to show the table of contents
  /*
  * true: Show the table of contents
  * false: Hide the table of contents
  */
  demo.PDFApplication().ActivePDF.DocumentMap = true	// Show the table of contents.
Zoom the view
  /*
  * @return: number
  */
  await demo.PDFApplication().ActivePDF.Zoom  // Read the view zoom level.
  /*
  * @param : 1 <= number <= 400 (The zoom level is between 1% and 400%.)
  */
  demo.PDFApplication().ActivePDF.Zoom = 100  // Set the view zoom level.
Listen on events
You can use the on method of the instance to listen on events.
demo.on('Event name', function(data) {
    // do something...
})
Event
Description
fileOpen
The file was opened successfully or failed to be opened.
error
An error occurred, and an error code was returned.
fileStatus
The file was saved, and a status value was returned. Valid values: 0 (the file had no updates); 1 (the version was saved successfully); 2 (the file was empty and couldn't be saved); 3 (the space was full); 4 (the file was being saved); 5 (the file failed to be saved); 6 (the file updates were being saved; this status will be triggered when the file content is modified); 7 (the change to the file content was saved successfully).

Was this page helpful?

You can also Contact Sales or Submit a Ticket for help.

Yes

Event	Description
fileOpen	The file was opened successfully or failed to be opened.
error	An error occurred, and an error code was returned.
fileStatus	The file was saved, and a `status` value was returned. Valid values: `0` (the file had no updates); `1` (the version was saved successfully); `2` (the file was empty and couldn't be saved); `3` (the space was full); `4` (the file was being saved); `5` (the file failed to be saved); `6` (the file updates were being saved; this status will be triggered when the file content is modified); `7` (the change to the file content was saved successfully).

tencent cloud

New User Offers

Next-Generation CDN：EdgeOne

Elasticsearch Service Special Offers

Free Tier

Tencent Cloud Startup Program

Special Offers

Lighthouse Special Offers

Cloud Object Storage Special Offers

Featured Products

New Products

Education

Tencent Cloud Online Education Solutions

Gaming

Gaming Solution

Game Media Solutions

Financial Services

Financial Services Solution

Audio & Video

Audio/Video Solution

LVB Recording Solution

Interactive Classroom Solution

Interactive Live Streaming Solution

Audio Chat Social Networking Solution

Real Estate

Tencent Cloud LinkBase(Weiling)

E-commerce

E-commerce retail solutions

Compute

Cloud Virtual Machine

Auto Scaling

Batch Compute

CVM Dedicated Host

Database

TencentDB for MySQL

TencentDB for Redis®

TencentDB for CTSDB

TDSQL for MySQL

Data Transfer Service

TencentDB for MongoDB

TencentDB for PostgreSQL

TencentDB for SQL Server

TencentDB for TcaplusDB

Video Service

Cloud Streaming Services

Video on Demand

Media Processing Service

Cloud Application Rendering

Cloud Contact Center

Game Multimedia Engine

Chat

Real-time Communication

Tencent Effect SDK

AI and Machine Learning

Image Creation Large Model

Face Fusion

eKYC

Optical Character Recognition

Video Creation Large Model

Industry Applications

Tencent HealthCare Omics Platform

Container and Middleware

TDMQ for CKafka

Serverless Cloud Function

Tencent Kubernetes Engine

Tencent Kubernetes Engine for Serverless

Networking

Cloud Load Balancer

Virtual Private Cloud

Direct Connect

Cloud Connect Network

NAT Gateway

VPN Connection

Bandwidth Package

Anycast Internet Acceleration

Elastic Network Interface

Flow Logs

Global Application Acceleration Platform

Security

Captcha