Beispiel #1
0
        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);
        }
Beispiel #2
0
        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));
        }
Beispiel #3
0
        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));
        }