// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
namespace Aspose.Cells.Cloud.SDK.Example
{
    using Aspose.Cells.Cloud.SDK.Api;
    using Aspose.Cells.Cloud.SDK.Request;
    using System;

    public partial class CellsApiExample
    {
        public void PostWorksheetMergeExample()
        {
            CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret"));
            PostWorksheetMergeRequest request = new PostWorksheetMergeRequest { name = "Book1.xlsx", sheetName = "Sheet1",  startColumn=0, startRow=0, totalColumns=10, totalRows=10, folder = "TestData/In" };
            cellsApi.PostWorksheetMerge(request);
        }
    }
}
//  Obsolet
//CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
//string name = BOOK1;
//string sheetName = SHEET1;
//int? startRow = 1;
//int? startColumn = 1;
//int? totalRows = 4;
//int? totalColumns = 4;
//string folder = TEMPFOLDER;
//instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
//var response = instance.CellsPostWorksheetMerge(name, sheetName, startRow, startColumn, totalRows, totalColumns, folder);
//Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
//Assert.AreEqual(response.Status, "OK");