public void TestCreatExcel(string fileName) { AsposeExcelApplication x = new AsposeExcelApplication(fileName); int count = x.Workbook.Worksheets.Count; Assert.True(count > 0); }
public void TestCreateSheet() { string name = Guid.NewGuid().ToString("N").Substring(0, 10); workbook.CreateSheet(name); workbook.Save(); string path = workbook.Workbook.FileName; workbook.Workbook.Dispose(); AsposeExcelApplication workbooktemp = new AsposeExcelApplication(path); bool x = workbooktemp.Workbook.Worksheets.Find(t => t.Name.Equals(name)) != null; Assert.True(x); }
public void TestSetValueInCell(string sheetNmae, int rowIndex, int ColumnIndex, object value) { AsposeExcelApplication aea = new AsposeExcelApplication(fileName); if (value.Equals("datetime")) { var dateValue = DateTime.Now; aea.SetCellValue(sheetNmae, rowIndex, ColumnIndex, dateValue); Assert.Equal(dateValue.ToShortDateString(), aea.GetCellValue(sheetNmae, rowIndex, ColumnIndex).ToString()); } else { aea.SetCellValue(sheetNmae, rowIndex, ColumnIndex, value); Assert.Equal(value.ToString(), aea.GetCellValue(sheetNmae, rowIndex, ColumnIndex).ToString()); } }