/* * Exports the selected query data to excel; use random file name by timestamp */ private void ExportDataTableToExcel(DataTable sInputTable) { // export to Excel // create random timestamp TimeSpan sTime = DateTime.Now - new DateTime(1970, 1, 1, 0, 0, 0); string timeStamp = ((long)sTime.TotalMilliseconds).ToString(); ExcelManager em = new ExcelManager(); if (em.ExcelExport(sInputTable, null, "RelationalReport_" + timeStamp + ".xls")) { LabelStatus.Text = "Success!"; } }
private void ExportDataTableToExcel(DataTable sInputTable) { // export to Excel // create random timestamp TimeSpan sTime = DateTime.Now - new DateTime(1970, 1, 1, 0, 0, 0); string timeStamp = ((long)sTime.TotalMilliseconds).ToString(); ExcelManager em = new ExcelManager(); if (em.ExcelExport(sInputTable, null, "OlapReport_" + timeStamp + ".xls")) LabelStatus.Text = "Success!"; }