public static void Run()
{
// ExStart:1
CellsApi cellsApi = new CellsApi(Common.APP_KEY, Common.APP_SID, Common.BASEPATH);
StorageApi storageApi = new StorageApi(Common.APP_KEY, Common.APP_SID, Common.BASEPATH);
String fileName = "Sample_Test_Book.xls";
String sheetName = "Sheet1";
String storage = "";
String folder = "";
WorksheetMovingRequest body = new WorksheetMovingRequest();
body.DestinationWorksheet = "Sheet5";
body.Position = "after";
try
{
// Upload source file to aspose cloud storage
storageApi.PutCreate(fileName, "", "", System.IO.File.ReadAllBytes(Common.GetDataDir() + fileName));
// Invoke Aspose.Cells Cloud SDK API to move excel worksheets
WorksheetsResponse apiResponse = cellsApi.PostMoveWorksheet(fileName, sheetName, storage, folder, body);
if (apiResponse != null && apiResponse.Status.Equals("OK"))
{
Console.WriteLine("WorkSheet moved!");
Console.ReadKey();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("error:" + ex.Message + "\n" + ex.StackTrace);
}
// ExEnd:1
}
public void CellsWorksheetsPostMoveWorksheetTest()
{
string name = "Book1.xlsx";
string sheetName = "SHEET1";
WorksheetMovingRequest moving = new WorksheetMovingRequest();//"SHEET3", "after"
moving.DestinationWorksheet = "SHEET3";
moving.Position = "after";
string folder = null;
new Config().UpdateDataFile(folder, name);
var response = instance.CellsWorksheetsPostMoveWorksheet(name, sheetName, moving, folder);
Console.WriteLine(response);
}
public void CellsWorksheetsPostMoveWorksheetTest()
{
// TODO uncomment below to test the method and replace null with proper value
string name = BOOK1;
string sheetName = SHEET1;
WorksheetMovingRequest moving = new WorksheetMovingRequest();//SHEET3, "after"
moving.DestinationWorksheet = SHEET3;
moving.Position = "after";
string folder = TEMPFOLDER;
UpdateDataFile(instance, folder, name);
var response = instance.CellsWorksheetsPostMoveWorksheet(name, sheetName, moving, folder);
Assert.IsInstanceOf <WorksheetsResponse>(response, "response is WorksheetsResponse");
Assert.AreEqual(response.Code, 200);
}
