public void TestExcel2007MultipleSheetEqualJustOneSheet() { var p = new Person { Name = "Andrei Ignat", WebSite = "http://msprogrammer.serviciipeweb.ro/", CV = "http://serviciipeweb.ro/iafblog/content/binary/cv.doc" }; var list = new List <Person>() { p }; var export = new ExportExcel2007 <Person>(); var data = export.ExportResult(list); var data1 = export.ExportMultipleSheets(new IList[] { list }); Assert.IsTrue(Math.Abs(data.Length - data1.Length) < 100); }
//[TestMethod] public void TestExcel2007MultipleSheets() { var p = new Person { Name = "Andrei Ignat", WebSite = "http://msprogrammer.serviciipeweb.ro/", CV = "http://serviciipeweb.ro/iafblog/content/binary/cv.doc" }; var list = new List <Person>() { p }; var kvp = new List <Tuple <string, string> >(); for (int i = 0; i < 10; i++) { var q = new Tuple <string, string>("This is key " + i, "Value " + i); kvp.Add(q); } var export = new ExportExcel2007 <Person>(); var data = export.ExportMultipleSheets(new IList[] { list, kvp }); File.WriteAllBytes("multiple.xlsx", data); Process.Start("multiple.xlsx"); }
private static void Advanced_MultipleSheets() { 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 }; var kvp = new List <Tuple <string, string> >(); for (int i = 0; i < 10; i++) { var q = new Tuple <string, string>("This is key " + i, "Value " + i); kvp.Add(q); } var export = new ExportExcel2007 <Person>(); var data = export.ExportMultipleSheets(new IList[] { list, kvp }); if (!writeAndStartFile("multiple.xlsx", data)) { Console.WriteLine(" !!!!!!!!!!Could not delete multiple.xlsx"); } //export dataset var ds = new DataSet(); var table = new DataTable("programmers"); var idColumn = table.Columns.Add("ID", typeof(int)); table.Columns.Add("Name", typeof(string)); table.Columns.Add("WebSite", typeof(string)); table.PrimaryKey = new DataColumn[] { idColumn }; table.Rows.Add(new object[] { 1, "Andrei Ignat", "http://msprogrammer.serviciipeweb.ro" }); table.Rows.Add(new object[] { 2, "Scott Hanselman", "http://www.hanselman.com/blog/" }); ds.Tables.Add(table); 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 "); ds.Tables.Add(dta); export = new ExportExcel2007 <Person>(); data = ExportFactory.ExportDataSet(ds, ExportToFormat.Excel2007); if (!writeAndStartFile("multipleDataSet.xlsx", data)) { Console.WriteLine(" !!!!!!!!!!Could not delete multipleDataSet.xlsx"); } }