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");
}
}
