public static byte[] ExportOpmlRSS(string dataOPML, ExportToFormat exportFormat, params KeyValuePair <string, object>[] additionalData) { if (exportFormat != ExportToFormat.Excel2007) { throw new ArgumentException("ready just for Excel 2007"); } XDocument rssDoc; if (Uri.IsWellFormedUriString(dataOPML, UriKind.Absolute)) { rssDoc = XDocument.Load(dataOPML); } else { rssDoc = XDocument.Parse(dataOPML); } var dataNodes = rssDoc.XPathSelectElements("//outline[@type='rss']").ToArray(); var count = dataNodes.Length; var listData = new List <IList>(count); for (int i = 0; i < count; i++) { var rss = dataNodes[i].Attribute("xmlUrl").Value; var jsonArray = ExportFactory.GetDataFromRSS(rss); listData.Add(FromJson(jsonArray)); } var export = new ExportExcel2007 <Tuple <string> >(); var data = export.ExportMultipleSheets(listData.ToArray(), additionalData); return(data); }
public static byte[] ExportDataSet(DataSet ds, ExportToFormat exportFormat, params KeyValuePair <string, object>[] additionalData) { if (exportFormat != ExportToFormat.Excel2007) { throw new ArgumentException("ready just for Excel 2007"); } var export = new ExportExcel2007 <Tuple <string> >(); return(export.ExportMultipleSheets(ds)); }
public static byte[] ExportData <T>(List <T> data, ExportToFormat exportFormat, params KeyValuePair <string, object>[] additionalData) where T : class { Export <T> export; switch (exportFormat) { case ExportToFormat.Word2003XML: export = new ExportWord2003 <T>(); break; case ExportToFormat.Excel2003XML: export = new ExportExcel2003 <T>(); break; case ExportToFormat.HTML: export = new ExportHtml <T>(); break; case ExportToFormat.PDFiTextSharp4: export = new ExportPdfiTextSharp4 <T>(); break; case ExportToFormat.Word2007: export = new ExportWord2007 <T>(); break; case ExportToFormat.Excel2007: export = new ExportExcel2007 <T>(); break; case ExportToFormat.ODT: export = new ExportODT <T>(); break; case ExportToFormat.ODS: export = new ExportODS <T>(); break; default: //throw new ArgumentOutOfRangeException(nameof(exportFormat), exportFormat, null); throw new ArgumentOutOfRangeException("exportFormat", exportFormat, null); } return(export.ExportResult(data, additionalData)); }