Online Edit
Quick Start
Run Spire.Cloud Online Editor in Your Web Application
Getting Started with Spire.Cloud Online Editor
Spire.Cloud Word Editor
How to Add a Watermark to Word
How to Insert and Customize Footnotes
How to Insert a WordArt
How to Insert a Picture in Word
How to Insert a Link in Word
How to Add Comments in Word
How to Add a Column to Word
Spire.Cloud Excel Editor
How to Create a Table in Excel
How to Insert a Chart in Excel
Web API
.NET
Spire.Cloud.Word
Replace Text in Word Using Spire.Cloud.Word
Add, Remove or Edit Paragraphs in Word Using Spire.Cloud.Word
Convert Word to PDF or XPS Using Spire.Cloud.Word
Encrypt Word Documents Using Spire.Cloud.Word
Add Text and Image Watermarks to Word using Spire.Cloud.Word
Remove Watermarks from Word using Spire.Cloud.Word
Set Background Color and Image for Word using Spire.Cloud
Spire.Cloud.Excel
Freeze or Unfreeze Excel Columns and Rows Using Spire.Cloud.Excel
Add or Delete Excel Comments Using Spire.Cloud.Excel
Convert Excel to PDF or XPS Using Spire.Cloud.Excel
Set or Remove Excel Document Properties Using Spire.Cloud.Excel
Encrypt or Decrypt Excel Documents Using Spire.Cloud.Excel
Merge and Unmerge Excel Cells using Spire.Cloud.Excel
Protect or Unprotect Excel Worksheet using Spire.Cloud.Excel
Replace Text in Excel in C# using Spire.Cloud.Excel
Spire.Cloud.PowerPoint
Add a Table to PowerPoint Using Spire.Cloud.PowerPoint
Add an Image to PowerPoint Using Spire.Cloud.PowerPoint
Set or Remove PowerPoint Document Properties Using Spire.Cloud.PowerPoint
Convert PowerPoint to PDF or Images Using Spire.Cloud.PowerPoint
Add Background Color or Image to Slides Using Spire.Cloud.PowerPoint
Add, Update and Remove Speaker Notes in PowerPoint using Spire.Cloud.PowerPoint
Replace Text in PowerPoint using Spire.Cloud.PowerPoint
Spire.Cloud.PDF
Merge or Split PDF Documents Using Spire.Cloud.PDF
Add and Delete PDF Document Properties using Spire.Cloud.PDF
Add or Extract Images in PDF Using Spire.Cloud.PDF
Install Spire.Cloud Web API via NuGet
How to Use Spire.Cloud Web API in .NET
Java
Spire.Cloud.Word
Create a Blank Word Document using Spire.Cloud.Word
Merge Word documents in Java using Spire.Cloud.Word
Encrypt Word Documents Using Spire.Cloud.Word
Add Table to Word Document using Spire.Cloud.Word
Remove Watermark in Word Document using Spire.Cloud.Word
Replace Text in a Word document Using Spire.Cloud.Word
Convert Word to HTML in Java using Spire.Cloud.Word
Add Digital Signature to Word using Spire.Cloud.Word
Add and Delete Shapes in Word Using Spire.Cloud.Word
Add and Delete Images in Word Using Spire.Cloud.Word
Add, Get and Delete Custom Document Properties in Word using Spire.Cloud.Word
Add/Replace/Delete Paragraphs in Word Document Using Spire.Cloud.Word
Spire.Cloud.Excel
Freeze or Unfreeze Excel Rows and Columns using Spire.Cloud.Excel
Merge Excel Cells and Set Cell Format using Spire.Cloud.Excel
Spire.Cloud.Excel Encrypt/Decrypt Excel Documents
Rename Excel Worksheet Using Spire.Cloud.Excel
Add or Delete Comments in Excel Worksheets
Set and Delete Excel Document Properties Using Spire.Cloud.Excel
Spire.Cloud.PowerPoint
Add Image to a PowerPoint Document using Spire.Cloud.PowerPoint
Create a table in PowerPoint using Spire.Cloud.PowerPoint
Convert PPT(X) to PDF using Spire.Cloud.PowerPoint
Convert PPT(X) to PNG using Spire.Cloud.PowerPoint
Set and Delete PowerPoint Document Properties Using Spire.Cloud.PowerPoint
Replace Text in PowerPoint in Java using Spire.Cloud.PowerPoint
Spire.Cloud.PDF
Add/ Delete PDF Page Using Spire.Cloud.PDF
Convert PDF to Image using Spire.Cloud.PDF
Draw Shapes in PDF Using Spire.Cloud.PDF
Convert PDF to Word Document Using Spire.Cloud.PDF
Add, Update and Delete PDF Document Properties using Spire.Cloud.PDF
Add an Image to PDF Document Using Spire.Cloud.PDF
Merge and Split PDF Documents Using Spire.Cloud.PDF
Add Lists to PDF using Spire.Cloud.PDF
Add, Update, Get and Delete Bookmarks in PDF
Install Spire.Cloud Web API from Maven Repository
How to Use Spire.Cloud Web API in Java
API Documentation
Spire.Cloud.Word API
Spire.Cloud.Excel API
Spire.Cloud.PowerPoint API
Spire.Cloud.PDF API

Merge Excel Cells and Set Cell Format using Spire.Cloud.Excel

Spire.Cloud.Excel provides developers with the CellsApi interface to manipulate cells in Excel document. This article will demonstrate how to merge excel cells and set cell format by using Spire.Cloud.Excel API.

The original Excel document is shown as below:

Merge Excel Cells and Set Cell Format using Spire.Cloud.Excel

Merge Excel Cells


import spire.cloud.excel.sdk.ApiException;
import spire.cloud.excel.sdk.Configuration;
import spire.cloud.excel.sdk.api.CellsApi;

public class MergeCells {

    static String appId = "APP ID";
    static String appKey = "APP Key";
    static String baseUrl = "https://api.cloudxdocs.com";

    //Create a Configuration object based on App ID, App Key and base Url
    static Configuration configuration = new Configuration(appId, appKey, baseUrl);
    //Create an instance of CellsApi
    static CellsApi cellsApi = new CellsApi(configuration);

    public static void main(String[] args) throws ApiException {

        //Specify the name of the input document
        String name = "test.xlsx";
        //Specify the first worksheet
        String sheetName = "Sheet1";
        //Specify the folder where the input document is stored, set it to null if there's none
        String folder = "input";
        //Store the document in the 2G default storage space offered by E-iceblue Cloud
        String storage = null;

        //Merge cells from row 2 to row 5 in column 3 with the mergeCells method
        int startRow = 2;
        int startColumn = 3;
        int totalRows = 4;
        int totalColumns = 1;
        cellsApi.mergeCells(name, sheetName, startRow, startColumn, totalRows, totalColumns, folder, storage);

        //Repeat the above steps and Merge cells from row 6 to row 8 in column 3
        startRow = 6;
        startColumn = 3;
        totalRows = 3;
        totalColumns = 1;
        cellsApi.mergeCells(name, sheetName, startRow, startColumn, totalRows, totalColumns, folder, storage);
    }
}

Merge Excel Cells and Set Cell Format using Spire.Cloud.Excel

Set Cell Format

import spire.cloud.excel.sdk.ApiException;
import spire.cloud.excel.sdk.Configuration;
import spire.cloud.excel.sdk.api.CellsApi;
import spire.cloud.excel.sdk.model.*;

public class FormatCell {

    static String appId = "APP ID";
    static String appKey = "App Key";
    static String baseUrl = "https://api.cloudxdocs.com";

    //Create a Configuration object based on App ID, App Key and base Url
    static Configuration configuration = new Configuration(appId, appKey, baseUrl);
    //Create an instance of CellsApi
    static CellsApi cellsApi = new CellsApi(configuration);

    public static void main(String[] args) throws ApiException {

        //Specify the name of the input document
        String name = "test.xlsx";
        //Specify the worksheet
        String sheetName = "Sheet1";
        //Specify the Excel cell
        String cellName = "C2";

        //Set the font style of cell C2
        Style style = new Style();
        Font font = new Font();
        font.setIsBold(true);
        font.setUnderline("Single");
        font.setName("Times New Roman");
        font.setSize(11);
        style.setFont(font);

        //Set the background color of cell C2
        style.setBackgroundColor(new Color(255,169,208,142));
        //Set the alignment of cell C2
        style.setHorizontalAlignment("Left");

        //Specify the folder where the input document is stored, set it to null if there's none
        String folder = "input";
        //Store the document in the 2G default storage space offered by E-iceblue Cloud
        String storage = null;

        //Set cell format with the setCellStyle method
        cellsApi.setCellStyle(name, sheetName, cellName, style, folder, storage);
    }
}

Merge Excel Cells and Set Cell Format using Spire.Cloud.Excel