public void TestExcel() { //test exception var mLogExceptionHelper = MyFactory.GetExceptionLogHelper(); mLogExceptionHelper.LogException(MethodBase.GetCurrentMethod(), new Exception("TEST...."), null); //test visitor var mLogVisitorHelper = MyFactory.GetLogVisitorHelper(); var mVisitor = new UserInfo(); mVisitor.UserId = "BBWANG"; mVisitor.UserName = "******"; mLogVisitorHelper.LogUser("Index", mVisitor); //test export var excelExportHelper = MyFactory.GetExportToExcelHelper(); var tab = new DataTable(); tab.Columns.Add(new DataColumn("A", typeof(string))); tab.Columns.Add(new DataColumn("B", typeof(string))); for (var i = 1; i <= 100; i++) { var row = tab.NewRow(); row["A"] = string.Format("Row {0} Column{1}", i, 1); row["B"] = string.Format("Row {0} Column{1}", i, 2); tab.Rows.Add(row); } mCurrentController.ViewBag.DownloadLink = excelExportHelper.ExportToExcel("Test", "TEST-BEN", tab); }