示例#1
0
        public async Task SetTemplateValues()
        {
            SpreadsheetDocument document = SpreadSheetExtensions.ExcelDocument();
            SheetData           sheet    = document.GetSheetData(@"Entity");
            List <KeyValuePair <string, object> > data = new List <KeyValuePair <string, object> >(3)
            {
                new KeyValuePair <string, object>(@"{{Name}}", @"Israel"),
                new KeyValuePair <string, object>(@"{{Age}}", DateTime.Now.AddYears(-27)),
                new KeyValuePair <string, object>(@"{{Email}}", @"*****@*****.**")
            };
            await sheet.SetTemplateValues(data);

            Assert.True(!document.IsNotValid());
        }