Syncfusion Document Processing

https://github.com/syncfusion-content/document-processing-docs
Admin
Syncfusion Document Processing is a comprehensive collection of libraries and SDKs that enable...
Tokens:5,427,601
Snippets:42,896
Trust Score:6.4
Update:2 months ago
Show doc for...
Tokens:
Raw
### NuGet CLI Installation Examples

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/NuGet-Packages.md

Practical examples for installing specific packages or using a package.config file on Windows, Mac, and Linux.

```bash
#install specific package for Windows 
nuget.exe install “Syncfusion.DocIO.Net.Core"

#install all package which mention in package.config path for Windows 
nuget.exe install “C:\Users\SyncfusionApplication\package.config”

#install specific package for Mac and Linux 
mono nuget.exe install “Syncfusion.DocIO.Net.Core"

#install all package which mention in package.config path for Mac and Linux 
mono nuget.exe install “C:\Users\SyncfusionApplication\package.config”
```

--------------------------------

### Manual Project Installation and Execution

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/angular/setup-with-syncfusion-cli.md

Navigate to the project directory, install dependencies, and start the development server if automatic setup was skipped.

```bash
cd my-pdf-viewer-app
npm install
npm start
```

--------------------------------

### Example Runtime Output

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Data-Extraction/NET/ocr-processor/Amazon-Linux-EC2-Setup-Guide.md

Example output showing installed .NET runtime paths.

```text
Microsoft.AspNetCore.App 8.0.x [/usr/lib64/dotnet/shared/Microsoft.AspNetCore.App]
Microsoft.NETCore.App 8.0.x [/usr/lib64/dotnet/shared/Microsoft.NETCore.App]
```

--------------------------------

### Interactive CLI Output Example

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/angular/setup-with-syncfusion-cli.md

A representation of the prompts and selections made during the interactive setup process.

```text
✓ Project name? ... my-pdf-viewer-app
✓ Choose Framework: » Angular 
✓ Choose Build Tool: » Webpack 
✓ Choose Language: » TypeScript 
✓ Choose Template: » PDF Viewer 
✓ Choose Theme: » Material3 
✓ Choose Style Format: » CSS 
✓ Would you like to integrate the Syncfusion MCP Server? ... no 
✓ Would you like to install Component Skills? ... no 
✓ Install dependencies and start app now? ... yes
```

--------------------------------

### Run the React project

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Spreadsheet/React/getting-started.md

Commands to navigate to the project directory, install dependencies, and start the development server.

```bash
cd my-app
npm install
npm run dev
```

--------------------------------

### Project Configuration Prompts

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Word/Word-Processor/angular/getting-started.md

Example prompts encountered during the Angular project setup process.

```text
? Which stylesheet system would you like to use?
❯ CSS             [ https://developer.mozilla.org/docs/Web/CSS                     ]
  Tailwind CSS    [ https://tailwindcss.com                                        ]
  Sass (SCSS)     [ https://sass-lang.com/documentation/syntax#scss                ]
  Sass (Indented) [ https://sass-lang.com/documentation/syntax#the-indented-syntax ]
  Less            [ http://lesscss.org                                             ]
```

```text
? Do you want to enable Server-Side Rendering (SSR) and Static Site Generation (SSG/Prerendering)? (y/N) N
```

```text
? Which AI tools do you want to configure with Angular best practices? https://angular.dev/ai/develop-with-ai
❯ None
  Agents.md      [ https://agents.md/                                               ]
  Claude         [ https://docs.anthropic.com/en/docs/claude-code/memory            ]
  Cursor         [ https://docs.cursor.com/en/context/rules                         ]
  Gemini         [ https://ai.google.dev/gemini-api/docs                            ]
  GitHub Copilot [ https://code.visualstudio.com/docs/copilot/copilot-customization ]
  JetBrains AI   [ https://www.jetbrains.com/help/junie/customize-guidelines.html   ]
```

--------------------------------

### Remix Project Setup Prompts

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Spreadsheet/React/environment-integration/remix.md

Example of the interactive prompts encountered during the Remix project creation process.

```text
   dir   Where should we create your new project?
         ./my-react-router-app

      ◼  Using default template See https://github.com/remix-run/react-router-templates for more
      ✔  Template copied

   git   Initialize a new git repository?
         No

  deps   Install dependencies with npm?
         Yes
```

--------------------------------

### Configure MCP Server for Code Studio

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Word/Word-Processor/asp-net-core/mcp.md

Create a .codestudio/mcp.json file in your workspace and click Start to install the server.

```json
// Create a `.codestudio/mcp.json` file in your workspace:

{
  "servers": {
    "sf-aspnetcore-mcp": {
      "type": "stdio",
      "command": "dnx",
      "args": ["Syncfusion.AspNetCore.MCP", "--yes"],
      "env": {
        "Syncfusion_API_Key_Path": "YOUR_API_KEY_FILE_PATH"
        // or
        // "Syncfusion_API_Key": "YOUR_API_KEY"
      }
    }
  }
}

// After creating the file, click Start in the inline action to install the server.
```

--------------------------------

### Install .NET SDK

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Data-Extraction/NET/ocr-processor/Amazon-Linux-EC2-Setup-Guide.md

Install the .NET 8.0 SDK using yum.

```bash
sudo yum install -y dotnet-sdk-8.0
```

--------------------------------

### Install and Verify Git

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PowerPoint/Conversions/PowerPoint-To-Image/NET/Convert-PowerPoint-to-Image-in-AWS-Linux-EC2.md

Installs Git and verifies the installation version.

```bash
sudo yum install git -y
```

```bash
git --version
```

--------------------------------

### Install project dependencies

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/vue/getting-started-application.md

Commands to navigate to the project directory and install dependencies.

```bash
cd my-project
npm install
```

```bash
cd my-project
yarn install
```

--------------------------------

### Install .NET SDK

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PowerPoint/Conversions/PowerPoint-To-Image/NET/Convert-PowerPoint-to-Image-in-AWS-Linux-EC2.md

Installs the .NET 8.0 SDK on the EC2 instance.

```bash
sudo yum install dotnet-sdk-8.0
```

--------------------------------

### Select project options

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/react/depoyment-integration/nextjs-getting-started.md

Example of the configuration prompts for project features like TypeScript, ESLint, and the App Router.

```bash
√ What is your project named? ... ej2-next-js-pdfviewer
√ Would you like to use TypeScript? ... No / `Yes`
√ Would you like to use ESLint? ... No / `Yes`
√ Would you like to use Tailwind CSS? ... `No` / Yes
√ Would you like to use `src/` directory? ... No / `Yes`
√ Would you like to use App Router? (recommended) ... No / `Yes`
√ Would you like to customize the default import alias? ... `No`/ Yes
Creating a new Next.js app in D:\ej2-next-js-pdfviewer.
```

--------------------------------

### Install Local .NET Tool

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/mcp-server/documentsdk.md

Commands to install the Syncfusion Document SDK MCP server as a local .NET tool.

```bash
dotnet tool install Syncfusion.DocumentSdk.MCP
```

--------------------------------

### Select project configurations

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Spreadsheet/React/environment-integration/nextjs-getting-started.md

Example of the command line prompts for selecting project features.

```bash
√ What is your project named? ... ej2-next-js-spreadsheet
√ Would you like to use TypeScript? ... No / `Yes`
√ Would you like to use ESLint? ... No / `Yes`
√ Would you like to use Tailwind CSS? ... `No` / Yes
√ Would you like to use `src/` directory? ... No / `Yes`
√ Would you like to use App Router? (recommended) ... No / `Yes`
√ Would you like to customize the default import alias? ... `No`/ Yes
Creating a new Next.js app in D:\ej2-next-js-spreadsheet.
```

--------------------------------

### Apply Configuration and Verify

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/javascript-es5/server-deployment/how-to-deploy-docker-image-in-azure-kubernetes-service.md

Deploy the configuration file and list all resources to retrieve the external IP.

```console
kubectl create -f ./pdfviewer-server.yaml
kubectl get all
```

--------------------------------

### Initialize project folder

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Library/javascript/Create-PDF-document-typescript.md

Create a new directory and initialize a package.json file.

```bash
mkdir pdf-typescript-app
cd pdf-typescript-app
npm init -y
```

--------------------------------

### Perform Whole-Word Search

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/asp-net-mvc/text-search.md

Examples of performing a whole-word search in both standalone and server-backed PDF Viewer setups.

```cshtml
<button type="button" onclick="searchText()">Search Text</button>
<div style="width:100%;height:600px">
    @Html.EJS().PdfViewer("pdfviewer").EnableTextSearch(true).DocumentPath("https://cdn.syncfusion.com/content/pdf/hive-succinctly.pdf").Render()
</div>

<script>
    function searchText() {
        var pdfViewer = document.getElementById('pdfviewer').ej2_instances[0];
        pdfViewer.textSearch.searchText('pdf', false, true);
    }
</script>
```

```cshtml
<button type="button" onclick="searchText()">Search Text</button>
<div style="width:100%;height:600px">
    @Html.EJS().PdfViewer("pdfviewer").ServiceUrl(VirtualPathUtility.ToAbsolute("~/api/PdfViewer/")).EnableTextSearch(true).DocumentPath("https://cdn.syncfusion.com/content/pdf/hive-succinctly.pdf").Render()
</div>

<script>
    function searchText() {
        var pdfViewer = document.getElementById('pdfviewer').ej2_instances[0];
        pdfViewer.textSearch.searchText('pdf', false, true);
    }
</script>
```

--------------------------------

### Select configuration options

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Word/Word-Processor/react/nextjs-getting-started.md

Example of the prompt output for selecting project configuration defaults.

```text
? Would you like to use the recommended Next.js defaults?
>   Yes, use recommended defaults - TypeScript, ESLint, Tailwind CSS, App Router
    No, reuse previous settings
    No, customize settings
```

--------------------------------

### Perform Case-Sensitive Search

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/asp-net-mvc/text-search.md

Examples of performing a case-sensitive search in both standalone and server-backed PDF Viewer setups.

```cshtml
<button type="button" onclick="searchText()">Search Text</button>
<div style="width:100%;height:600px">
    @Html.EJS().PdfViewer("pdfviewer").EnableTextSearch(true).DocumentPath("https://cdn.syncfusion.com/content/pdf/hive-succinctly.pdf").Render()
</div>

<script>
    function searchText() {
        var pdfViewer = document.getElementById('pdfviewer').ej2_instances[0];
        pdfViewer.textSearch.searchText('PDF', true);
    }
</script>
```

```cshtml
<button type="button" onclick="searchText()">Search Text</button>
<div style="width:100%;height:600px">
    @Html.EJS().PdfViewer("pdfviewer").ServiceUrl(VirtualPathUtility.ToAbsolute("~/api/PdfViewer/")).EnableTextSearch(true).DocumentPath("https://cdn.syncfusion.com/content/pdf/hive-succinctly.pdf").Render()
</div>

<script>
    function searchText() {
        var pdfViewer = document.getElementById('pdfviewer').ej2_instances[0];
        pdfViewer.textSearch.searchText('PDF', true);
    }
</script>
```

--------------------------------

### Run the project

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Spreadsheet/Vue/vue-3-getting-started.md

Commands to navigate to the project directory and start the development server.

```bash
cd my-project
npm install
npm run dev
```

--------------------------------

### Run Application

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Spreadsheet/React/environment-integration/create-react-app.md

Commands to start the development server.

```bash
npm start
```

```bash
yarn start
```

--------------------------------

### Configure Data Validation in Spreadsheet

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Spreadsheet/Javascript-ES6/data-validation.md

Example demonstrating the setup of a Spreadsheet component with data validation enabled.

```ts
{% include code-snippet/spreadsheet/javascript-es6/data-validation-cs2/index.ts %}
```

```html
{% include code-snippet/spreadsheet/javascript-es6/data-validation-cs2/index.html %}
```

--------------------------------

### Complete Excel Creation Example

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Excel-Library/NET/create-excel-file-csharp-vbnet.md

A full implementation example showing the creation of an Excel file from initialization to saving.

```csharp
using Syncfusion.XlsIO;
namespace ExcelCreation
{
  class Program
  {
    static void Main(string[] args)
    {
      //New instance of ExcelEngine is created equivalent to launching Excel with no workbooks open
      //Instantiate the spreadsheet creation engine
      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Instantiate the Excel application object
        IApplication application = excelEngine.Excel;

        //Assigns default application version
        application.DefaultVersion = ExcelVersion.Xlsx;

        //A new workbook is created equivalent to creating a new workbook in Excel
        //Create a workbook with 1 worksheet
        IWorkbook workbook = application.Workbooks.Create(1);

        //Access a worksheet from workbook
        IWorksheet worksheet = workbook.Worksheets[0];

        //Adding text data
        worksheet.Range["A1"].Text = "Month";
        worksheet.Range["B1"].Text = "Sales";
        worksheet.Range["A6"].Text = "Total";

        //Adding DateTime data
        worksheet.Range["A2"].DateTime = new DateTime(2015, 1, 10);
        worksheet.Range["A3"].DateTime = new DateTime(2015, 2, 10);
        worksheet.Range["A4"].DateTime = new DateTime(2015, 3, 10);

        //Applying number format for date value cells A2 to A4
        worksheet.Range["A2:A4"].NumberFormat = "mmmm, yyyy";

        //Auto-size the first column to fit the content
        worksheet.AutofitColumn(1);

        //Adding numeric data
        worksheet.Range["B2"].Number = 68878;
        worksheet.Range["B3"].Number = 71550;
        worksheet.Range["B4"].Number = 72808;

        //Adding formula
        worksheet.Range["B6"].Formula = "SUM(B2:B4)";

        //Inserting image
        FileStream imageStream = new FileStream("image.jpg", FileMode.Open, FileAccess.Read);
        worksheet.Pictures.AddPicture(10, 2, imageStream);

        //Saving the workbook to disk in XLSX format
        workbook.SaveAs("Sample.xlsx");
      }
    }
  }
}
```

--------------------------------

### Run the Angular project

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Spreadsheet/Angular/getting-started.md

Commands to navigate to the project directory, install dependencies, and start the development server.

```bash
cd syncfusion-angular-app
npm install
ng serve
```

--------------------------------

### Build, Publish, and Run Application

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PowerPoint/Conversions/PowerPoint-To-Image/NET/Convert-PowerPoint-to-Image-in-AWS-Linux-EC2.md

Builds the application, navigates to the publish directory, and executes the application.

```bash
dotnet publish -c Release
```

```bash
cd bin/Release/net8.0/publish
```

```bash
dotnet your-application.dll --urls http://0.0.0.0:5000
```

--------------------------------

### Clone the quickstart repository

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Spreadsheet/Javascript-ES6/getting-started.md

Use Git to clone the Essential JS 2 quickstart project from GitHub.

```bash
git clone https://github.com/SyncfusionExamples/ej2-quickstart-webpack ej2-quickstart
```

--------------------------------

### Run Syncfusion Vue Project

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Word/Word-Processor/vue/getting-started-vue-3.md

Commands to navigate to the project directory, install dependencies, and start the development server.

```bash
cd syncfusion-vue-app
npm install
npm run dev
```

--------------------------------

### Get Selection Offsets in Vue

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Word/Word-Processor/vue/how-to/move-selection-to-specific-position.md

Retrieves the start and end hierarchical indices of the current selection using the selectionChange event.

```html
<template>
  <div id="app">
    <ejs-documenteditorcontainer ref="container" :serviceUrl="serviceUrl" height="590px" id="container"
      :enableToolbar="true" v-on:selectionChange="selectionChanged.bind(this)"></ejs-documenteditorcontainer>
  </div>
</template>
<script setup>
import { DocumentEditorContainerComponent as EjsDocumenteditorcontainer, Toolbar } from '@syncfusion/ej2-vue-documenteditor';
import { provide, ref } from 'vue';

const container = ref(null);
const serviceUrl = 'https://document.syncfusion.com/web-services/docx-editor/api/documenteditor/';

//Inject require modules.
provide('DocumentEditorContainer', [Toolbar]);

const selectionChanged = function () {
  //Get the start index of current selection
  let startOffset = container.value.ej2Instances.documentEditor.selection.startOffset;
  //Get the end index of current selection
  let endOffset = container.value.ej2Instances.documentEditor.selection.endOffset;
}
</script>
```

```html
<template>
  <div id="app">
    <ejs-documenteditorcontainer ref="container" :serviceUrl="serviceUrl" height="590px" id="container"
      :enableToolbar="true" v-on:selectionChange="selectionChanged.bind(this)"></ejs-documenteditorcontainer>
  </div>
</template>
<script>
import { DocumentEditorContainerComponent, Toolbar } from '@syncfusion/ej2-vue-documenteditor';

export default {
  components: {
    'ejs-documenteditorcontainer': DocumentEditorContainerComponent
  },
  data() {
    return {
      serviceUrl:
        'https://document.syncfusion.com/web-services/docx-editor/api/documenteditor/',
    };
  },
  provide: {
    //Inject require modules.
    DocumentEditorContainer: [Toolbar]
  },
  methods: {
    selectionChanged: function () {
      //Get the start index of current selection
      let startOffset =
        this.$refs.container.ej2Instances.documentEditor.selection.startOffset;
      //Get the end index of current selection
      let endOffset = this.$refs.container.ej2Instances.documentEditor.selection.endOffset;
    }
  }
};
</script>
```

--------------------------------

### Implement Stamp Annotation in Options API

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/vue/annotation/stamp-annotation.md

A complete example showing the Options API setup with a server-backed PDF Viewer component.

```html
<template>
  <div id="app">
    <button id="set">Stamp</button>
    <ejs-pdfviewer id="pdfViewer" ref="pdfviewer" :serviceUrl="serviceUrl" :documentPath="documentPath"
      :documentLoad="documentLoad">
    </ejs-pdfviewer>
  </div>
</template>

<script>

import {
  PdfViewerComponent, Toolbar, Magnification, Navigation, LinkAnnotation,
  BookmarkView, Annotation, ThumbnailView, Print, TextSelection,
  TextSearch, FormFields, FormDesigner, PageOrganizer, SignStampItem
} from '@syncfusion/ej2-vue-pdfviewer';

export default {
  name: "App",
  components: {
    "ejs-pdfviewer": PdfViewerComponent
  },
  data() {
    return {
      serviceUrl: "https://document.syncfusion.com/web-services/pdf-viewer/api/pdfviewer",
      documentPath: "https://cdn.syncfusion.com/content/pdf/pdf-succinctly.pdf",
    };
  },
  provide: {
    PdfViewer: [Toolbar, Magnification, Navigation, LinkAnnotation, BookmarkView, ThumbnailView,
      Print, TextSelection, TextSearch, Annotation, FormFields, FormDesigner, PageOrganizer]
  },
  methods: {
    documentLoad() {
      const viewer = this.$refs.pdfviewer.ej2Instances;
      document.getElementById('set').addEventListener('click', () => {
        viewer.annotation.setAnnotationMode('Stamp', null, SignStampItem.Witness);
      });
    }
  }
}
</script>
```

--------------------------------

### Initialize a Node.js project

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Library/javascript/Create-PDF-document-node-js.md

Create a new directory and initialize a new Node.js project using npm.

```bash
mkdir pdf-node-app
cd pdf-node-app
npm init -y
```

--------------------------------

### Get Selected Text Indices in C#

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/xamarin/Select-And-Copy-Text.md

Extract the start and end indices of the selected text using the TextSelectionCompleted event arguments.

```c#
private void PdfViewerControl_TextSelectionCompleted(object sender, TextSelectionCompletedEventArgs args) 
{
	//Starting index of the selected text on the page. 
	int startIndex = args.SelectedTextStartIndex; 
	//Ending index of the selected text on the page.
	int endIndex= args.SelectedTextEndIndex; 
}
```

--------------------------------

### Run the Remix development server

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/react/depoyment-integration/remix.md

Starts the local development server to preview the application.

```bash
npm run dev
# open the URL printed by the dev server (usually http://localhost:3000)
```

--------------------------------

### Configure Culture-Specific Spreadsheet

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Spreadsheet/React/formula-and-calculation/culture-specific-formula-separators.md

Examples demonstrating the setup of the Spreadsheet component with German culture, including locale configuration and data source definitions.

```jsx
{% include code-snippet/spreadsheet/react/formula-cs3/app/App.jsx %}
```

```tsx
{% include code-snippet/spreadsheet/react/formula-cs3/app/App.tsx %}
```

```json
{% include code-snippet/spreadsheet/react/formula-cs3/app/locale.json %}
```

```jsx
{% include code-snippet/spreadsheet/react/formula-cs3/app/datasource.jsx %}
```

```tsx
{% include code-snippet/spreadsheet/react/formula-cs3/app/datasource.tsx %}
```

--------------------------------

### Get Page Count in Vue Document Editor

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Word/Word-Processor/vue/how-to/insert-page-number-and-navigate-to-page.md

Examples demonstrating how to access the pageCount property using both Composition and Options API patterns.

```html
<template>
  <div id="app">
    <ejs-documenteditorcontainer ref="container" :serviceUrl="serviceUrl" height="590px" id="container"
      :enableToolbar="true" v-on:created="onCreated.bind(this)"></ejs-documenteditorcontainer>
  </div>
</template>
<script setup>
import { DocumentEditorContainerComponent as EjsDocumenteditorcontainer, Toolbar } from '@syncfusion/ej2-vue-documenteditor';
import { provide, ref } from 'vue';

const container = ref(null);
const serviceUrl = 'https://document.syncfusion.com/web-services/docx-editor/api/documenteditor/';

//Inject require modules.
provide('DocumentEditorContainer', [Toolbar])

const onCreated = function () {
  // To insert text in cursor position
  container.value.ej2Instances.documentEditor.editor.insertText('Document editor');
  // To get the total number of pages
  let pageCount = container.value.ej2Instances.documentEditor.pageCount;
}
</script>
```

```html
<template>
  <div id="app">
    <ejs-documenteditorcontainer ref="container" :serviceUrl="serviceUrl" height="590px" id="container"
      :enableToolbar="true" v-on:created="onCreated.bind(this)"></ejs-documenteditorcontainer>
  </div>
</template>
<script>
import { DocumentEditorContainerComponent, Toolbar } from '@syncfusion/ej2-vue-documenteditor';

export default {
  components: {
    'ejs-documenteditorcontainer': DocumentEditorContainerComponent
  },
  data() {
    return {
      serviceUrl:
        'https://document.syncfusion.com/web-services/docx-editor/api/documenteditor/',
    };
  },
  provide: {
    //Inject require modules.
    DocumentEditorContainer: [Toolbar]
  },
  methods: {
    onCreated: function () {
      // To insert text in cursor position
      this.$refs.container.ej2Instances.documentEditor.editor.insertText('Document editor');
      // To get the total number of pages
      let pageCount = this.$refs.container.ej2Instances.documentEditor.pageCount;
    }
  }
};
</script>
```

--------------------------------

### Navigate to sample directory

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PowerPoint/Conversions/PowerPoint-To-Image/NET/Convert-PowerPoint-to-Image-in-Google-App-Engine.md

Use this command to navigate to the specific sample directory you wish to run.

```CLI
cd Convert-PPTX-to-image
```

--------------------------------

### Get and paste selected content as SFDT

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Word/Word-Processor/javascript-es5/how-to/get-the-selected-content.md

This example initializes the Document Editor, selects content, extracts it as SFDT, and pastes it back into the document.

```js
import { DocumentEditorContainer, Toolbar } from '@syncfusion/ej2-documenteditor';

DocumentEditorContainer.Inject(Toolbar);

let container: DocumentEditorContainer = new DocumentEditorContainer({ enableToolbar: true, height: '590px' });

container.serviceUrl = 'https://document.syncfusion.com/web-services/docx-editor/api/documenteditor/';

container.appendTo('#container');

// To insert text in cursor position
container.documentEditor.editor.insertText('Document editor');
// To select all the content in document
container.documentEditor.selection.selectAll();
// Insert bookmark to selected content
container.documentEditor.editor.insertBookmark('Bookmark1');
//Select the bookmark
container.documentEditor.selection.selectBookmark('Bookmark1');
// To get the selected content as sfdt
let selectedContent: string = container.documentEditor.selection.sfdt;
// Insert the sfdt content in cursor position using paste API
container.documentEditor.editor.paste(selectedContent);
```

--------------------------------

### Configure project name

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/react/depoyment-integration/nextjs-getting-started.md

Example of the project naming prompt during the initialization process.

```bash
√ What is your project named? » ej2-next-js-pdfviewer
```

--------------------------------

### Programmatically Edit Shape Annotations in Vue

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/vue/annotation/shape-annotation.md

This example shows the template and script setup for modifying various shape annotations using the Options API.

```vue
<template>
  <div id="app">
    <button v-on:click="editLineAnnotation">Edit Line Annotation programatically</button>
    <button v-on:click="editArrowAnnotation">Edit Arrow Annotation programatically</button>
    <button v-on:click="editRectangleAnnotation">Edit Rectangle Annotation programatically</button>
    <button v-on:click="editCircleAnnotation">Edit Circle Annotation programatically</button>
    <button v-on:click="editPolygonAnnotation">Edit Polygon Annotation programatically</button>
    <ejs-pdfviewer id="pdfViewer" ref="pdfviewer" :documentPath="documentPath" :resourceUrl="resourceUrl">
    </ejs-pdfviewer>
  </div>
</template>

<script>
import {
  PdfViewerComponent, Toolbar, Magnification, Navigation, LinkAnnotation,
  BookmarkView, Annotation, ThumbnailView, Print, TextSelection,
  TextSearch, FormFields, FormDesigner, PageOrganizer
} from '@syncfusion/ej2-vue-pdfviewer';

export default {
  name: "App",
  components: {
    "ejs-pdfviewer": PdfViewerComponent
  },
  data() {
    return {
      documentPath: "https://cdn.syncfusion.com/content/pdf/pdf-succinctly.pdf",
      resourceUrl: 'https://cdn.syncfusion.com/ej2/31.2.2/dist/ej2-pdfviewer-lib',
    };
  },
  provide: {
    PdfViewer: [Toolbar, Magnification, Navigation, LinkAnnotation, BookmarkView, Annotation,
      ThumbnailView, Print, TextSelection, TextSearch, FormFields, FormDesigner, PageOrganizer]
  },
  methods: {
    editLineAnnotation: function () {
      const pdfviewer = this.$refs.pdfviewer.ej2Instances;
      for (let i = 0; i < pdfviewer.annotationCollection.length; i++) {
        if (pdfviewer.annotationCollection[i].subject === "Line") {
          pdfviewer.annotationCollection[i].strokeColor = "#0000FF";
          pdfviewer.annotationCollection[i].thickness = 2;
          pdfviewer.annotationCollection[i].annotationSelectorSettings.resizerShape = "Circle"
          pdfviewer.annotation.editAnnotation(pdfviewer.annotationCollection[i]);
        }
      }
    },
    editArrowAnnotation: function () {
      const pdfviewer = this.$refs.pdfviewer.ej2Instances;
      for (let i = 0; i < pdfviewer.annotationCollection.length; i++) {
        if (pdfviewer.annotationCollection[i].subject === "Arrow") {
          pdfviewer.annotationCollection[i].strokeColor = "#0000FF";
          pdfviewer.annotationCollection[i].thickness = 2;
          pdfviewer.annotationCollection[i].fillColor = "#FFFF00";
          pdfviewer.annotationCollection[i].annotationSelectorSettings.resizerShape = "Circle"
          pdfviewer.annotation.editAnnotation(pdfviewer.annotationCollection[i]);
        }
      }
    },
    editRectangleAnnotation: function () {
      const pdfviewer = this.$refs.pdfviewer.ej2Instances;
      for (let i = 0; i < pdfviewer.annotationCollection.length; i++) {
        if (pdfviewer.annotationCollection[i].subject === "Rectangle") {
          pdfviewer.annotationCollection[i].strokeColor = "#0000FF";
          pdfviewer.annotationCollection[i].thickness = 2;
          pdfviewer.annotationCollection[i].fillColor = "#FFFF00";
          pdfviewer.annotationCollection[i].annotationSelectorSettings.resizerShape = "Circle"
          pdfviewer.annotation.editAnnotation(pdfviewer.annotationCollection[i]);
        }
      }
    },
    editCircleAnnotation: function () {
      const pdfviewer = this.$refs.pdfviewer.ej2Instances;
      for (let i = 0; i < pdfviewer.annotationCollection.length; i++) {
        if (pdfviewer.annotationCollection[i].subject === "Circle") {
          pdfviewer.annotationCollection[i].strokeColor = "#0000FF";
          pdfviewer.annotationCollection[i].thickness = 2;
          pdfviewer.annotationCollection[i].fillColor = "#FFFF00";
          pdfviewer.annotationCollection[i].annotationSelectorSettings.resizerShape = "Circle"
          pdfviewer.annotation.editAnnotation(pdfviewer.annotationCollection[i]);
        }
      }
    },
    editPolygonAnnotation: function () {
      const pdfviewer = this.$refs.pdfviewer.ej2Instances;
      for (let i = 0; i < pdfviewer.annotationCollection.length; i++) {
        if (pdfviewer.annotationCollection[i].subject === "Polygon") {
          pdfviewer.annotationCollection[i].strokeColor = "#0000FF";
          pdfviewer.annotationCollection[i].thickness = 2;
          pdfviewer.annotationCollection[i].fillColor = "#FFFF00";
          pdfviewer.annotationCollection[i].annotationSelectorSettings.resizerShape = "Circle"
          pdfviewer.annotation.editAnnotation(pdfviewer.annotationCollection[i]);
        }
      }
    }
  }
}
</script>
```

--------------------------------

### Initialize ExcelEngine and Application

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Excel-Library/NET/create-excel-file-csharp-vbnet.md

Create an instance of the ExcelEngine to launch the spreadsheet creation environment.

```csharp
//New instance of ExcelEngine is created equivalent to launching Microsoft Excel with no workbooks open
//Instantiate the spreadsheet creation engine
ExcelEngine excelEngine = new ExcelEngine();

//Instantiate the Excel application object
IApplication application = excelEngine.Excel;
```

```vbnet
'New instance of ExcelEngine is created equivalent to launching Microsoft Excel with no workbooks open
'Instantiate the spreadsheet creation engine
Dim excelEngine As ExcelEngine = New ExcelEngine

'Instantiate the Excel application object
Dim application As IApplication = excelEngine.Excel
```

--------------------------------

### Handle signaturePropertiesChange event in PDF Viewer

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/javascript-es6/annotations/annotation-event.md

The signaturePropertiesChange event is triggered when signature properties are modified. The example demonstrates the setup and event handler implementation.

```html
<!DOCTYPE html>
<html lang="en">

<head>
    <title>EJ2 PDF Viewer</title>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <meta name="description" content="TypeScript PDF Viewer Control" />
    <meta name="author" content="Syncfusion" />
    <link href="index.css" rel="stylesheet" />
    <link href="https://cdn.syncfusion.com/ej2/31.1.23/material.css" rel="stylesheet" />

    <script src="https://cdnjs.cloudflare.com/ajax/libs/systemjs/0.19.38/system.js"></script>
    <script src="systemjs.config.js"></script>
<script src="https://cdn.syncfusion.com/ej2/syncfusion-helper.js" type ="text/javascript"></script>
</head>
<body>
    <div id='loader'>Loading....</div>
    <div id='container'>
        <div id='PdfViewer' style="height:500px;width:100%;"></div>
    </div>
</body>
</html>
```

```typescript
import { PdfViewer, Toolbar, Magnification, Navigation, LinkAnnotation,ThumbnailView, BookmarkView,
    TextSelection, Annotation, FormDesigner, FormFields, FormFieldAddArgs, PageOrganizer } from '@syncfusion/ej2-pdfviewer';

PdfViewer.Inject( Toolbar,Magnification, Navigation, LinkAnnotation,ThumbnailView,
             BookmarkView, TextSelection, Annotation, FormDesigner, FormFields, PageOrganizer );

let viewer: PdfViewer = new PdfViewer({
    documentPath: 'https://cdn.syncfusion.com/content/pdf/pdf-succinctly.pdf',
    resourceUrl: 'https://cdn.syncfusion.com/ej2/31.1.23/dist/ej2-pdfviewer-lib',
    signaturePropertiesChange: function (args: any) {
        console.log('Signature properties changed on page ' + args.pageIndex);
    }
});
viewer.appendTo('#pdfViewer');
```

--------------------------------

### Load Office files in Blazor SfPdfViewer

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/blazor/faqs/how-to-load-office-files.md

This example shows the setup of an SfUploader to handle file selection and an SfPdfViewer2 component to display the converted document.

```cshtml
@page "/"
@using Syncfusion.Blazor.SfPdfViewer;
@using Syncfusion.Blazor.Buttons;
@using Syncfusion.Pdf;
@using Syncfusion.Pdf.Graphics;
@using Syncfusion.Pdf.Interactive;
@using Syncfusion.Pdf.Parsing;
@using Syncfusion.Pdf.Security;
@using Syncfusion.Blazor.Inputs;
@using Syncfusion.DocIO;
@using WFormatType = Syncfusion.DocIO.FormatType;
@using Syncfusion.Presentation;
@using Syncfusion.PresentationRenderer;
@using Syncfusion.XlsIO;
@using Syncfusion.XlsIORenderer;
@using Syncfusion.DocIORenderer;
@using System.IO;

<SfUploader AllowedExtensions=".doc, .docx, .rtf, .docm, .dotm, .dotx, .dot, .xls, .xlsx, .pptx, .pptm, .potx, .potm .jpeg, .png, .bmp">
    <UploaderEvents OnUploadStart="OnSuccess"></UploaderEvents>
    <UploaderAsyncSettings SaveUrl="https://aspnetmvc.syncfusion.com/services/api/uploadbox/Save"
        RemoveUrl="https://aspnetmvc.syncfusion.com/services/api/uploadbox/Remove"></UploaderAsyncSettings>
</SfUploader>
<SfPdfViewer2 @ref="viewerInstance" 
              Height="100%" 
              Width="100%" 
              ToolbarSettings="@ToolbarSettings">
</SfPdfViewer2>

@code {
    private SfPdfViewer2 viewerInstance;

    private PdfViewerToolbarSettings ToolbarSettings = new PdfViewerToolbarSettings()
        {
            ToolbarItems = new List<ToolbarItem>()
            {
                ToolbarItem.PageNavigationTool,
                ToolbarItem.MagnificationTool,
                ToolbarItem.CommentTool,
                ToolbarItem.SelectionTool,
                ToolbarItem.PanTool,
                ToolbarItem.UndoRedoTool,
                ToolbarItem.CommentTool,
                ToolbarItem.AnnotationEditTool,
                ToolbarItem.SearchOption,
                ToolbarItem.PrintOption,
                ToolbarItem.DownloadOption,
                ToolbarItem.SubmitForm,
            }
        };
```

--------------------------------

### Navigate to sample directory

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Conversions/Excel-to-PDF/NET/convert-excel-to-pdf-in-google-app-engine.md

Use this command to change the current directory to the sample project folder.

```c#
cd Convert-Excel-to-PDF
```

--------------------------------

### Navigate to project directory

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Conversions/Excel-to-Image/NET/convert-excel-to-image-in-google-app-engine.md

Change the current directory to the project folder containing the sample application.

```CLI
cd Convert-Excel-to-Image
```

--------------------------------

### Blazor Project Setup Commands

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Data-Extraction/NET/ocr-processor/blazor.md

CLI commands for creating a new Blazor Server project, navigating to the directory, and installing the required OCR NuGet package.

```bash
dotnet new blazorserver -n CreatePdfBlazorServerApp
```

```bash
cd CreatePdfBlazorServerApp
```

```bash
dotnet add package Syncfusion.PDF.OCR.Net.Core
```

--------------------------------

### Run the React project

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Word/Word-Processor/react/getting-started.md

Commands to navigate to the project directory and start the development server.

```bash
cd syncfusion-react-app
npm install
npm run dev
```

--------------------------------

### Implement Search Functionality in Xamarin.Android

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/xamarin-android/Search-For-Text-Instance.md

This example shows the setup of the search bar, event handling for text input, and the implementation of search and clear search operations.

```csharp
namespace GettingStartedDroid
{
    [Activity(Label = "GettingStartedDroid", MainLauncher = true, Icon = "@drawable/icon")]
    public class MainActivity : Activity
    {
        SfPdfViewer pdfViewer;
        EditText pageNumberEntry;
        TextView pageCountText;
        ImageButton pageDownButton;
        ImageButton pageUpButton;
        LinearLayout mainView;
        GridLayout toolBarGrid;
        GridLayout searchBarGrid;
        EditText searchView;
        ImageButton searchButton;
        ImageButton backButton;
        ImageButton clearSearchButton;
        string searchText = string.Empty;

        protected override void OnCreate(Bundle bundle)
        {
            base.OnCreate(bundle);
            SetContentView(Resource.Layout.Main);

            //Access the controls in the design.
            pdfViewer = FindViewById<SfPdfViewer>(Resource.Id.pdfviewercontrol);
            pageNumberEntry = FindViewById<EditText>(Resource.Id.pagenumberentry);
            pageCountText = FindViewById<TextView>(Resource.Id.pagecounttext);
            pageDownButton = FindViewById<ImageButton>(Resource.Id.pagedownbutton);
            pageUpButton = FindViewById<ImageButton>(Resource.Id.pageupbutton);
            mainView = FindViewById<LinearLayout>(Resource.Id.parentview);
            toolBarGrid = FindViewById<GridLayout>(Resource.Id.toolbarGrid);
            searchBarGrid = FindViewById<GridLayout>(Resource.Id.searchGrid);
            searchButton = FindViewById<ImageButton>(Resource.Id.searchButton);
            searchView = FindViewById<EditText>(Resource.Id.search);
            backButton = FindViewById<ImageButton>(Resource.Id.backButton);
            clearSearchButton = FindViewById<ImageButton>(Resource.Id.clearSearchResult);

            //Wire up events.
            pageNumberEntry.KeyPress += PageNumberEntry_KeyPress;
            pageDownButton.Click += PageDownButton_Click;
            pageUpButton.Click += PageUpButton_Click;
            pdfViewer.DocumentLoaded += PdfViewer_DocumentLoaded;
            searchButton.Click += SearchButton_Click;
            backButton.Click += BackButton_Click;
            clearSearchButton.Click += ClearSearchButton_Click;

            searchView.SetHintTextColor(Android.Graphics.Color.Rgb(189, 189, 189));
            searchView.Hint = "Search text";
            searchView.FocusableInTouchMode = true;
            searchView.TextSize = 18;
            searchView.SetTextColor(Android.Graphics.Color.Rgb(103, 103, 103));
            searchView.TextAlignment = TextAlignment.Center;
            searchView.KeyPress += SearchView_KeyPress;
            searchView.TextChanged += SearchView_TextChanged;

            searchBarGrid.Visibility = ViewStates.Invisible;

            //Access the document in the resource as stream and load it in the PDF viewer.
            Stream PdfStream = Assets.Open("GIS Succinctly.pdf");
            pdfViewer.LoadDocument(PdfStream);
        }

        private void SearchView_TextChanged(object sender, Android.Text.TextChangedEventArgs e)
        {
            if (searchView.Text != string.Empty)
            {
                clearSearchButton.Visibility = ViewStates.Visible;
            }
            else
            {
                clearSearchButton.Visibility = ViewStates.Invisible;
            }
        }

        private void SearchView_KeyPress(object sender, View.KeyEventArgs e)
        {
            var editText = sender as EditText;
            if (e.KeyCode == Keycode.Enter)
            {
                if (!string.IsNullOrWhiteSpace(editText.Text) && !string.IsNullOrEmpty(editText.Text))
                {
                    searchText = editText.Text;
                    pdfViewer.SearchText(searchText);
                }
                InputMethodManager inputMethodManager = (InputMethodManager)mainView.Context.GetSystemService(Context.InputMethodService);
                inputMethodManager.HideSoftInputFromWindow(mainView.WindowToken, HideSoftInputFlags.None);
            }
        }

        private void ClearSearchButton_Click(object sender, System.EventArgs e)
        {
            pdfViewer.CancelSearch();
            searchView.Text = "";
            clearSearchButton.Visibility = ViewStates.Invisible;
            InputMethodManager inputMethodManager = (InputMethodManager)mainView.Context.GetSystemService(Context.InputMethodService);
            inputMethodManager.ShowSoftInput(searchView, ShowFlags.Implicit);
        }
```

--------------------------------

### Trigger PDF Download Programmatically

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/react/download.md

Use the download() method on the PDF Viewer instance to initiate a download. These examples demonstrate the implementation for both standalone and server-backed setups.

```javascript
import * as ReactDOM from 'react-dom';
import * as React from 'react';
import './index.css';
import { PdfViewerComponent, Toolbar, Magnification, Navigation, LinkAnnotation, BookmarkView,
         ThumbnailView, Print, TextSelection, Annotation, TextSearch, Inject } from '@syncfusion/ej2-react-pdfviewer';
let pdfviewer;

function App() {
  function downloadClicked() {
    var viewer = document.getElementById('container').ej2_instances[0];
    viewer.download();
  }
  return (<div>
    <div className='control-section'>
     {/* Render the PDF Viewer */}
     <button onClick={downloadClicked}>Download</button>
      <PdfViewerComponent
        ref={(scope) => { pdfviewer = scope; }}
        id="container"
        documentPath="https://cdn.syncfusion.com/content/pdf/pdf-succinctly.pdf"
        resourceUrl="https://cdn.syncfusion.com/ej2/31.2.2/dist/ej2-pdfviewer-lib"
                style={{ 'height': '640px' }}>
              <Inject services={[ Toolbar, Magnification, Navigation, LinkAnnotation, Annotation,
                                  BookmarkView, ThumbnailView, Print, TextSelection, TextSearch]} />
      </PdfViewerComponent>
    </div>
  </div>
  );
}
const root = ReactDOM.createRoot(document.getElementById('sample'));
root.render(<App />);
```

```javascript
import * as ReactDOM from 'react-dom';
import * as React from 'react';
import './index.css';
import { PdfViewerComponent, Toolbar, Magnification, Navigation, LinkAnnotation, BookmarkView,
         ThumbnailView, Print, TextSelection, Annotation, TextSearch, Inject } from '@syncfusion/ej2-react-pdfviewer';
let pdfviewer;

function App() {
  function downloadClicked() {
    var viewer = document.getElementById('container').ej2_instances[0];
    viewer.download();
  }
  return (<div>
    <div className='control-section'>
     {/* Render the PDF Viewer */}
     <button onClick={downloadClicked}>Download</button>
      <PdfViewerComponent
        ref={(scope) => { pdfviewer = scope; }}
        id="container"
        documentPath="https://cdn.syncfusion.com/content/pdf/pdf-succinctly.pdf"
        serviceUrl="https://document.syncfusion.com/web-services/pdf-viewer/api/pdfviewer"
        style={{ 'height': '640px' }}>
              <Inject services={[ Toolbar, Magnification, Navigation, LinkAnnotation, Annotation,
                                  BookmarkView, ThumbnailView, Print, TextSelection, TextSearch]} />
      </PdfViewerComponent>
    </div>
  </div>
  );
}
const root = ReactDOM.createRoot(document.getElementById('sample'));
root.render(<App />);
```

--------------------------------

### Navigate to the sample directory

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Excel-Library/NET/Loading-and-Saving/loading-and-saving-excel-files-in-google-app-engine.md

Change the current working directory to the specific sample folder.

```bash
cd LoadingandSaving
```

--------------------------------

### Get Visible Worksheet Names in .NET

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Excel-Library/NET/faqs/how-to-get-the-list-of-worksheet-names-in-an-Excel-workbook.md

These examples demonstrate how to iterate through a workbook's worksheets and check the visibility property to print only visible sheet names.

```c#
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Xlsx;
    IWorkbook workbook = application.Workbooks.Open(Path.GetFullPath(@"Data/Input.xlsx"));

    //Get the worksheets collection
    WorksheetsCollection worksheets = workbook.Worksheets as WorksheetsCollection;

    //Print visible worksheet names
    foreach (IWorksheet worksheet in worksheets)
    {
        if (worksheet.Visibility == WorksheetVisibility.Visible)
            Console.WriteLine(worksheet.Name);
    }
}
```

```c#
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Xlsx;

    IWorkbook workbook = application.Workbooks.Open("Input.xlsx");

    //Get the worksheets collection
    WorksheetsCollection worksheets = workbook.Worksheets as WorksheetsCollection;

    //Print visible worksheet names
    foreach (IWorksheet worksheet in worksheets)
    {
        if (worksheet.Visibility == WorksheetVisibility.Visible)
    	    Console.WriteLine(worksheet.Name);
    }
}
```

```vb.net
Using excelEngine As ExcelEngine = New ExcelEngine()
    Dim application As IApplication = excelEngine.Excel
    application.DefaultVersion = ExcelVersion.Xlsx
    Dim inputStream As New FileStream("Input.xlsx", FileMode.Open, FileAccess.Read)
    Dim workbook As IWorkbook = application.Workbooks.Open(inputStream)

    'Get the worksheets collection
    Dim worksheets As WorksheetsCollection = TryCast(workbook.Worksheets, WorksheetsCollection)

    'Print visible worksheet names
    For Each worksheet As IWorksheet In worksheets
        If worksheet.Visibility = WorksheetVisibility.Visible Then
            Console.WriteLine(worksheet.Name)
        End If
    Next
End Using
```

--------------------------------

### Configure Highlight Annotation Mode

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/angular/annotation/text-markup-annotation.md

Use the annotationModule.setAnnotationMode method to toggle between highlight mode and none. These examples show the implementation for client-side and server-backed PDF Viewer setups.

```typescript
import { Component, OnInit } from '@angular/core';
import { LinkAnnotationService, BookmarkViewService,
         MagnificationService, ThumbnailViewService, ToolbarService,
         NavigationService, TextSearchService, TextSelectionService,
         PrintService, FormDesignerService, FormFieldsService,
         AnnotationService, PageOrganizerService } from '@syncfusion/ej2-angular-pdfviewer';

@Component({
  selector: 'app-root',
  // specifies the template string for the PDF Viewer component
  template: `<div class="content-wrapper">
  <button (click)="addAnnotation()">Highlight Text</button>
  <button (click)="setNone()">None</button>
  <ejs-pdfviewer
    id="pdfViewer"
    [documentPath]='document'
    [resourceUrl]='resource'
    style="height:640px;display:block">
  </ejs-pdfviewer>
</div>`,
  providers: [ LinkAnnotationService, BookmarkViewService, MagnificationService,
               ThumbnailViewService, ToolbarService, NavigationService,
               TextSearchService, TextSelectionService, PrintService,
               AnnotationService, FormDesignerService, FormFieldsService, PageOrganizerService]
})
export class AppComponent implements OnInit {
    public document = 'https://cdn.syncfusion.com/content/pdf/pdf-succinctly.pdf';
    public resource: string = "https://cdn.syncfusion.com/ej2/25.1.35/dist/ej2-pdfviewer-lib";
    ngOnInit(): void {
    }
    addAnnotation() {
      var pdfviewer = (<any>document.getElementById('pdfViewer')).ej2_instances[0];
      pdfviewer.annotationModule.setAnnotationMode('Highlight');
    }
    setNone() {
      var pdfviewer = (<any>document.getElementById("pdfViewer")).ej2_instances[0];
      pdfviewer.annotationModule.setAnnotationMode("None");
    }
}
```

```typescript
import { Component, OnInit } from '@angular/core';
import { LinkAnnotationService, BookmarkViewService,
         MagnificationService, ThumbnailViewService, ToolbarService,
         NavigationService, TextSearchService, TextSelectionService,
         PrintService, FormDesignerService, FormFieldsService,
         AnnotationService, PageOrganizerService } from '@syncfusion/ej2-angular-pdfviewer';

@Component({
  selector: 'app-root',
  // specifies the template string for the PDF Viewer component
  template: `<div class="content-wrapper">
  <button (click)="addAnnotation()">Highlight Text</button>
  <button (click)="setNone()">None</button>
  <ejs-pdfviewer
    id="pdfViewer"
    [documentPath]='document'
    [serviceUrl]='service'
    style="height:640px;display:block">
  </ejs-pdfviewer>
</div>`,
  providers: [ LinkAnnotationService, BookmarkViewService, MagnificationService,
               ThumbnailViewService, ToolbarService, NavigationService,
               TextSearchService, TextSelectionService, PrintService,
               AnnotationService, FormDesignerService, FormFieldsService, PageOrganizerService]
})
export class AppComponent implements OnInit {
    public document = 'https://cdn.syncfusion.com/content/pdf/pdf-succinctly.pdf';
    public service: string = 'https://document.syncfusion.com/web-services/pdf-viewer/api/pdfviewer';
    ngOnInit(): void {
    }
    addAnnotation() {
      var pdfviewer = (<any>document.getElementById('pdfViewer')).ej2_instances[0];
      pdfviewer.annotationModule.setAnnotationMode('Highlight');
  }
  setNone() {
      var pdfviewer = (<any>document.getElementById("pdfViewer")).ej2_instances[0];
      pdfviewer.annotationModule.setAnnotationMode("None");
  }
}
```

--------------------------------

### Start the development server

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/Excel/Spreadsheet/React/getting-started.md

Execute this command in the terminal to initiate the development environment for the React application.

```bash
npm run dev
```

--------------------------------

### Install .NET SDK on Ubuntu

Source: https://github.com/syncfusion-content/document-processing-docs/blob/development/Document-Processing/PDF/PDF-Viewer/blazor-classic/getting-started/wsl-application.md

Commands to download and install the .NET SDK 6.0 on an Ubuntu WSL instance.

```bash
    wget https://packages.microsoft.com/config/ubuntu/22.10/packages-microsoft-prod.deb -O packages-microsoft-prod.deb

    sudo dpkg -i packages-microsoft-prod.deb

    rm packages-microsoft-prod.deb

    sudo apt-get update && \
    sudo apt-get install -y dotnet-sdk-6.0
```
Tokens:
Raw