コード例 #1
0
 public void TestWithPersonHeader()
 {
     var p = new Person {Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"};
     var export = new ExportPdfiTextSharp4<Person>();
     var data = export.ExportResultStringPart(new List<Person>() {p});
     var str = data;
     Assert.IsTrue(str.Contains(export.ExportHeader),"must contain the header");
 }
コード例 #2
0
            public void TestWithPersonData()
            {
                var p = new Person { Name = "Andrei Ignat", WebSite = "http://msprogrammer.serviciipeweb.ro/", CV = "http://serviciipeweb.ro/iafblog/content/binary/cv.doc" };
                var export = new ExportPdfiTextSharp4< Person >();
                var data = export.ExportResultStringPart(new List<Person>() { p});
                var str = data;
                Assert.IsTrue(str.Contains("http://serviciipeweb.ro/iafblog/content/binary/cv.doc"),"must contain the cv");

            }
コード例 #3
0
            //[TestMethod]
            public void TestPDFiTextSharp()
            {
                var p = new Person { Name = "Andrei Ignat", WebSite = "http://msprogrammer.serviciipeweb.ro/", CV = "http://serviciipeweb.ro/iafblog/content/binary/cv.doc" };
                var export = new ExportPdfiTextSharp4< Person >();
                var data = export.ExportResult(new List<Person>() { p });
                //var str = Encoding.Unicode.GetString(data);
                File.WriteAllBytes("a.pdf",data);
                Process.Start("a.pdf");

            }
コード例 #4
0
            public void TestConstructorItemWithPerson()
            {
                var t = new Person {Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"};
                var export = new ExportPdfiTextSharp4<Person>();
                Assert.AreEqual(@"<row>
    <cell><phrase font='Times New Roman' size='8'>@Model.Name</phrase></cell>
    <cell><phrase font='Times New Roman' size='8'>@Model.WebSite</phrase></cell>
    <cell><phrase font='Times New Roman' size='8'>@Model.CV</phrase></cell>
</row>", export.ExportItem);
            }
コード例 #5
0
            public void TestConstructorHeaderWithPerson()
            {
                var t = new Person {Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"};
                var export = new ExportPdfiTextSharp4<Person>();
                Assert.AreEqual(@"<row>
<cell><phrase font='Arial' size='12' style='bold'>Name</phrase></cell>
<cell><phrase font='Arial' size='12' style='bold'>WebSite</phrase></cell>
<cell><phrase font='Arial' size='12' style='bold'>CV</phrase></cell>
</row>", export.ExportHeader);
            }
コード例 #6
0
            public void TestConstructorItemWithPerson()
            {
                var t = new Person {
                    Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"
                };
                var export = new ExportPdfiTextSharp4 <Person>();

                Assert.AreEqual(@"<row>
    <cell><phrase font='Times New Roman' size='8'>@Model.Name</phrase></cell>
    <cell><phrase font='Times New Roman' size='8'>@Model.WebSite</phrase></cell>
    <cell><phrase font='Times New Roman' size='8'>@Model.CV</phrase></cell>
</row>", export.ExportItem);
            }
コード例 #7
0
            public void TestConstructorHeaderWithPerson()
            {
                var t = new Person {
                    Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"
                };
                var export = new ExportPdfiTextSharp4 <Person>();

                Assert.AreEqual(@"<row>
<cell><phrase font='Arial' size='12' style='bold'>Name</phrase></cell>
<cell><phrase font='Arial' size='12' style='bold'>WebSite</phrase></cell>
<cell><phrase font='Arial' size='12' style='bold'>CV</phrase></cell>
</row>", export.ExportHeader);
            }
コード例 #8
0
            public void TestConstructorItemWithPerson()
            {
                var t = new Person {
                    Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"
                };
                var export = new ExportPdfiTextSharp4 <Person>();

                Assert.AreEqual(@"<row>
    <cell><phrase font='Times New Roman' size='8'>@System.Security.SecurityElement.Escape((((object)Model.Name) ?? """").ToString())</phrase></cell>
    <cell><phrase font='Times New Roman' size='8'>@System.Security.SecurityElement.Escape((((object)Model.WebSite) ?? """").ToString())</phrase></cell>
    <cell><phrase font='Times New Roman' size='8'>@System.Security.SecurityElement.Escape((((object)Model.CV) ?? """").ToString())</phrase></cell>
</row>".Replace("\r", "").Replace("\n", ""), export.ExportItem.Replace("\r", "").Replace("\n", ""));
            }
コード例 #9
0
            public void TestWithPersonData()
            {
                var p = new Person {
                    Name = "Andrei Ignat", WebSite = "http://msprogrammer.serviciipeweb.ro/", CV = "http://serviciipeweb.ro/iafblog/content/binary/cv.doc"
                };
                var export = new ExportPdfiTextSharp4 <Person>();
                var data   = export.ExportResultStringPart(new List <Person>()
                {
                    p
                });
                var str = data;

                Assert.IsTrue(str.Contains("http://serviciipeweb.ro/iafblog/content/binary/cv.doc"), "must contain the cv");
            }
コード例 #10
0
            public void TestWithPersonHeader()
            {
                var p = new Person {
                    Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"
                };
                var export = new ExportPdfiTextSharp4 <Person>();
                var data   = export.ExportResultStringPart(new List <Person>()
                {
                    p
                });
                var str = data;

                Assert.IsTrue(str.Contains(export.ExportHeader), "must contain the header");
            }
コード例 #11
0
        static void Main(string[] args)
        {
            var p = new Person {
                Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/", CV = "http://serviciipeweb.ro/iafblog/content/binary/cv.doc"
            };

            Export <Person> export = new ExportHtml <Person>();
            var             data   = export.ExportResult(new List <Person>()
            {
                p
            });

            File.WriteAllBytes("a.html", data);
            Process.Start("a.html");

            export = new ExportExcel2007 <Person>();
            data   = export.ExportResult(new List <Person>()
            {
                p
            });
            File.WriteAllBytes("a.xlsx", data);
            Process.Start("a.xlsx");


            export = new ExportWord2007 <Person>();
            data   = export.ExportResult(new List <Person>()
            {
                p
            });
            File.WriteAllBytes("a.docx", data);
            Process.Start("a.docx");


            export = new ExportPdfiTextSharp4 <Person>();
            data   = export.ExportResult(new List <Person>()
            {
                p
            });
            File.WriteAllBytes("a.pdf", data);
            Process.Start("a.pdf");


            //or you can use the factory
            data = ExportFactory.ExportData(new List <Person>()
            {
                p
            }, ExportToFormat.Excel2007);
            File.WriteAllBytes("b.xlsx", data);
            Process.Start("b.xlsx");
        }
コード例 #12
0
            //[TestMethod]
            public void TestPDFiTextSharp()
            {
                var p = new Person {
                    Name = "Andrei Ignat", WebSite = "http://msprogrammer.serviciipeweb.ro/", CV = "http://serviciipeweb.ro/iafblog/content/binary/cv.doc"
                };
                var export = new ExportPdfiTextSharp4 <Person>();
                var data   = export.ExportResult(new List <Person>()
                {
                    p
                });

                //var str = Encoding.Unicode.GetString(data);
                File.WriteAllBytes("a.pdf", data);
                Process.Start("a.pdf");
            }
コード例 #13
0
ファイル: Program.cs プロジェクト: lodim/Exporter
        static void Main(string[] args)
        {
            var p = new Person { Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/" , CV = "http://serviciipeweb.ro/iafblog/content/binary/cv.doc" };

            Export<Person> export = new ExportHtml<Person>();
            var data = export.ExportResult(new List<Person>() { p });            
            File.WriteAllBytes("a.html",data);
            Process.Start("a.html");

            export = new ExportExcel2007<Person>();
            data = export.ExportResult(new List<Person>() { p });
            File.WriteAllBytes("a.xlsx", data);
            Process.Start("a.xlsx");


            export = new ExportWord2007<Person>();
            data = export.ExportResult(new List<Person>() { p });
            File.WriteAllBytes("a.docx", data);
            Process.Start("a.docx");


            export = new ExportPdfiTextSharp4<Person>();
            data = export.ExportResult(new List<Person>() { p });
            File.WriteAllBytes("a.pdf", data);
            Process.Start("a.pdf");


            //or you can use the factory
            data = ExportFactory.ExportData(new List<Person>() { p }, ExportToFormat.Excel2007);
            File.WriteAllBytes("b.xlsx", data);
            Process.Start("b.xlsx");

            //export from JSON
            string dataJson = @"[
    { 'Name':'Andrei Ignat', 
        'WebSite':'http://msprogrammer.serviciipeweb.ro/',
        'CV':'http://serviciipeweb.ro/iafblog/content/binary/cv.doc'        
    },
{ 'Name':'Andrei Ignat', 
        'WebSite':'http://msprogrammer.serviciipeweb.ro/',
        'CV':'http://serviciipeweb.ro/iafblog/content/binary/cv.doc'        
    }
]";

            data = ExportFactory.ExportDataJson(dataJson, ExportToFormat.Excel2007);
            File.WriteAllBytes("bJson.xlsx", data);
            Process.Start("bJson.xlsx");


            //or from CSV
            var dataCSV = new List<string>();
            dataCSV.Add("Name,WebSite,CV");
            dataCSV.Add("Andrei Ignat,http://msprogrammer.serviciipeweb.ro/,http://serviciipeweb.ro/iafblog/content/binary/cv.doc");
            dataCSV.Add("Andrei Ignat,http://msprogrammer.serviciipeweb.ro/,http://serviciipeweb.ro/iafblog/content/binary/cv.doc");

            data = ExportFactory.ExportDataCsv(dataCSV.ToArray(), ExportToFormat.Excel2007);
            File.WriteAllBytes("bCSV.xlsx", data);
            Process.Start("bCSV.xlsx");

            var dta = new DataTable("andrei");
            dta.Columns.Add(new DataColumn("ID", typeof(int)));
            dta.Columns.Add(new DataColumn("Data", typeof(string)));
            
            dta.Rows.Add(1, "test 1 ");
            dta.Rows.Add(2, "test 2 ");
            dta.Rows.Add(3, "test 3 ");

            data = ExportFactory.ExportDataFromDataTable(dta, ExportToFormat.Excel2007);
            File.WriteAllBytes("dta.xlsx",data);
            Process.Start("a.xlsx");

            //advanced - modifying templates - in this case , added Number
            export = new ExportExcel2007<Person>();
            //File.WriteAllText("Excel2007Header.txt",export.ExportHeader);
            //File.WriteAllText("Excel2007Item.txt", export.ExportItem);
            //File.WriteAllText("Excel2007Collection.txt", export.ExportCollection);
            export.ExportHeader = File.ReadAllText("Excel2007Header.txt");
            export.ExportItem = File.ReadAllText("Excel2007Item.txt");
            export.ExportCollection = File.ReadAllText("Excel2007Collection.txt");
            data = export.ExportResult(new List<Person>() { p });
            File.WriteAllBytes("WithId.xlsx", data);
            Process.Start("WithId.xlsx");

        }
コード例 #14
0
ファイル: Program.cs プロジェクト: gitter-badger/Exporter
        static void Main(string[] args)
        {
            var p = new Person { Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/" , CV = "http://serviciipeweb.ro/iafblog/content/binary/cv.doc" };

            Export<Person> export = new ExportHtml<Person>();
            var data = export.ExportResult(new List<Person>() { p });            
            File.WriteAllBytes("a.html",data);
            Process.Start("a.html");

            export=new ExportExcel2007<Person>();
            data = export.ExportResult(new List<Person>() { p });
            File.WriteAllBytes("a.xlsx", data);
            Process.Start("a.xlsx");


            export = new ExportWord2007<Person>();
            data = export.ExportResult(new List<Person>() { p });
            File.WriteAllBytes("a.docx", data);
            Process.Start("a.docx");


            export = new ExportPdfiTextSharp4<Person>();
            data = export.ExportResult(new List<Person>() { p });
            File.WriteAllBytes("a.pdf", data);
            Process.Start("a.pdf");


            //or you can use the factory
            data = ExportFactory.ExportData(new List<Person>() {p}, ExportToFormat.Excel2007);
            File.WriteAllBytes("b.xlsx", data);
            Process.Start("b.xlsx");

            //export from JSON
            string dataJson = @"[
    { 'Name':'Andrei Ignat', 
        'WebSite':'http://msprogrammer.serviciipeweb.ro/',
        'CV':'http://serviciipeweb.ro/iafblog/content/binary/cv.doc'        
    },
{ 'Name':'Andrei Ignat', 
        'WebSite':'http://msprogrammer.serviciipeweb.ro/',
        'CV':'http://serviciipeweb.ro/iafblog/content/binary/cv.doc'        
    }
]";

            data= ExportFactory.ExportDataJson(dataJson, ExportToFormat.Excel2007);
            File.WriteAllBytes("bJson.xlsx", data);
            Process.Start("bJson.xlsx");


            //or from CSV
            var dataCSV = new List<string>();
            dataCSV.Add("Name,WebSite,CV");
            dataCSV.Add("Andrei Ignat,http://msprogrammer.serviciipeweb.ro/,http://serviciipeweb.ro/iafblog/content/binary/cv.doc");
            dataCSV.Add("Andrei Ignat,http://msprogrammer.serviciipeweb.ro/,http://serviciipeweb.ro/iafblog/content/binary/cv.doc");

            data= ExportFactory.ExportDataCsv(dataCSV.ToArray(), ExportToFormat.Excel2007);
            File.WriteAllBytes("bCSV.xlsx", data);
            Process.Start("bCSV.xlsx");


        }
コード例 #15
0
ファイル: Program.cs プロジェクト: xlgwr/Exporter
        static void SeeAllExport()
        {
            var p = new Person {
                Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/", CV = "http://serviciipeweb.ro/iafblog/content/binary/cv.doc"
            };
            var p1 = new Person {
                Name = "you", WebSite = "http://yourwebsite.com/"
            };
            var list = new List <Person>()
            {
                p, p1
            };
            Export <Person> export = new ExportHtml <Person>();
            var             data   = export.ExportResult(list);

            if (!writeAndStartFile("a.html", data))
            {
                Console.WriteLine(" !!!!!!!!!!Could not delete a.html");
            }

            export = new ExportExcel2003 <Person>();
            data   = export.ExportResult(list);
            if (!writeAndStartFile("a.xls", data))
            {
                Console.WriteLine(" !!!!!!!!!!Could not delete a.xls");
            }

            export = new ExportODS <Person>();
            data   = export.ExportResult(list);
            if (!writeAndStartFile("a.ods", data))
            {
                Console.WriteLine(" !!!!!!!!!!Could not delete a.ods");
            }


            export = new ExportExcel2007 <Person>();
            data   = export.ExportResult(list);
            if (!writeAndStartFile("a.xlsx", data))
            {
                Console.WriteLine(" !!!!!!!!!!Could not delete a.xlsx");
            }

            export = new ExportWord2003 <Person>();
            data   = export.ExportResult(list);
            if (!writeAndStartFile("a.doc", data))
            {
                Console.WriteLine(" !!!!!!!!!!Could not delete a.doc");
            }



            export = new ExportWord2007 <Person>();
            data   = export.ExportResult(list);
            if (!writeAndStartFile("a.docx", data))
            {
                Console.WriteLine(" !!!!!!!!!!Could not delete a.docx");
            }


            export = new ExportPdfiTextSharp4 <Person>();
            data   = export.ExportResult(list);
            if (!writeAndStartFile("a.pdf", data))
            {
                Console.WriteLine(" !!!!!!!!!!Could not delete a.pdf");
            }


            export = new ExportODT <Person>();
            data   = export.ExportResult(list);
            if (!writeAndStartFile("a.odt", data))
            {
                Console.WriteLine(" !!!!!!!!!!Could not delete a.odt");
            }


            //or you can use the factory
            data = ExportFactory.ExportData(list, ExportToFormat.Excel2007);
            if (!writeAndStartFile("b.xlsx", data))
            {
                Console.WriteLine(" !!!!!!!!!!Could not delete b.xlsx");
            }

            //export from JSON
            string dataJson = @"[
    { 'Name':'Andrei Ignat', 
        'WebSite':'http://msprogrammer.serviciipeweb.ro/',
        'CV':'http://serviciipeweb.ro/iafblog/content/binary/cv.doc'        
    },
{ 'Name':'Andrei Ignat', 
        'WebSite':'http://msprogrammer.serviciipeweb.ro/',
        'CV':'http://serviciipeweb.ro/iafblog/content/binary/cv.doc'        
    }
]";

            data = ExportFactory.ExportDataJson(dataJson, ExportToFormat.Excel2007);
            if (!writeAndStartFile("bJson.xlsx", data))
            {
                Console.WriteLine(" !!!!!!!!!!Could not delete bJson.xlsx");
            }


            //or from CSV
            var dataCSV = new List <string>();

            dataCSV.Add("Name,WebSite,CV");
            dataCSV.Add("Andrei Ignat,http://msprogrammer.serviciipeweb.ro/,http://serviciipeweb.ro/iafblog/content/binary/cv.doc");
            dataCSV.Add("Andrei Ignat,http://msprogrammer.serviciipeweb.ro/,http://serviciipeweb.ro/iafblog/content/binary/cv.doc");

            data = ExportFactory.ExportDataCsv(dataCSV.ToArray(), ExportToFormat.Excel2007);
            if (!writeAndStartFile("bCSV.xlsx", data))
            {
                Console.WriteLine(" !!!!!!!!!!Could not delete bCSV.xlsx");
            }

            var dta = new DataTable("andrei");

            dta.Columns.Add(new DataColumn("ID", typeof(int)));
            dta.Columns.Add(new DataColumn("Data", typeof(string)));

            dta.Rows.Add(1, "test 1 ");
            dta.Rows.Add(2, "test 2 ");
            dta.Rows.Add(3, "test 3 ");

            data = ExportFactory.ExportDataFromDataTable(dta, ExportToFormat.Excel2007);
            if (!writeAndStartFile("dta.xlsx", data))
            {
                Console.WriteLine(" !!!!!!!!!!Could not delete a.xlsx");
            }
        }