/// <summary> /// Export Data to CSV document. /// </summary> /// <returns>ExportDataInfo</returns> public static ExportDataInfo ExportToCsvDocument(QueryResult queryResult) { byte[] bytesInStream = CreateCsvDocument(queryResult); var export = new ExportDataInfo { FileStream = bytesInStream }; return(export); }
/// <summary> /// Export to word document. /// </summary> /// <param name="dataTable">Data table</param> /// <returns>ExportInfo</returns> public static ExportDataInfo ExportToWord(QueryResult queryResult, string reportName) { MemoryStream ms = new MemoryStream( ); ms = CreateWordDocument(queryResult, reportName); //Convert the memory stream to the byte array. byte[] bytesInStream = new byte[ms.Length]; ms.Position = 0; ms.Read(bytesInStream, 0, bytesInStream.Length); ExportDataInfo export = new ExportDataInfo( ); export.FileStream = bytesInStream; ms.Close( ); return(export); }
/// <summary> /// Export Data to Excel document. /// </summary> /// <param name="queryResult">The query data.</param> /// <returns>ExportDataInfo</returns> public static ExportDataInfo ExportToExcelDocument(QueryResult queryResult) { var ms = CreateExcelDocument(queryResult); // Convert the memory stream to the byte array. var bytesInStream = new byte[ms.Length]; ms.Position = 0; ms.Read(bytesInStream, 0, bytesInStream.Length); var export = new ExportDataInfo { FileStream = bytesInStream }; ms.Close( ); return(export); }