Example #1
0
        public void CellsWorksheetsPutWorkSheetCommentTest()
        {
            string  name      = "Book1.xlsx";
            string  sheetName = "SHEET1";
            string  cellName  = "C1";
            Comment comment   = new Comment();

            comment.Author = "roy";
            WorkbookEncryptionRequest encryption = new WorkbookEncryptionRequest();

            encryption.Password       = "******";
            encryption.KeyLength      = 128;
            encryption.EncryptionType = "XOR";
            string folder = null;

            new Config().UpdateDataFile(folder, name);
            var response = instance.CellsWorksheetsPutWorksheetComment(name, sheetName, cellName, comment, folder);

            Console.WriteLine(response);
        }
        public void CellsWorksheetsPutWorkSheetCommentTest()
        {
            // TODO uncomment below to test the method and replace null with proper value
            string  name      = BOOK1;
            string  sheetName = SHEET1;
            string  cellName  = "C1";
            Comment comment   = new Comment();

            comment.Author = "roy";
            WorkbookEncryptionRequest encryption = new WorkbookEncryptionRequest();

            encryption.Password       = "******";
            encryption.KeyLength      = 128;
            encryption.EncryptionType = "XOR";
            string folder = TEMPFOLDER;

            UpdateDataFile(folder, name);
            var response = instance.CellsWorksheetsPutWorksheetComment(name, sheetName, cellName, comment, folder);

            Assert.IsInstanceOf <CommentResponse>(response, "response is CommentResponse");
            Assert.AreEqual(response.Code, 200);
        }