public void TestWithPersonHeader()
{
var p = new Person {Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"};
var export = new ExportExcel2003<Person>();
var data = export.ExportResult(new List<Person>() {p});
var str = Encoding.Unicode.GetString(data);
Assert.IsTrue(str.Contains(export.ExportHeader),"must contain the header");
}
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 ExportExcel2003<Person>();
var data = export.ExportResult(new List<Person>() { p});
var str = Encoding.Unicode.GetString(data);
Assert.IsTrue(str.Contains("http://serviciipeweb.ro/iafblog/content/binary/cv.doc"),"must contain the cv");
}
public void TestConstructorItemWithPerson()
{
var t = new Person {Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"};
var export = new ExportExcel2003<Person>();
Assert.AreEqual(@"<Row>
<Cell><Data ss:Type='String'>@Model.Name</Data></Cell>
<Cell><Data ss:Type='String'>@Model.WebSite</Data></Cell>
<Cell><Data ss:Type='String'>@Model.CV</Data></Cell>
</Row>", export.ExportItem);
}
public void TestConstructorHeaderWithPerson()
{
var t = new Person {Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"};
var export = new ExportExcel2003<Person>();
Assert.AreEqual(@"<Row>
<Cell ss:StyleID='s21'><Data ss:Type='String'>Name</Data></Cell>
<Cell ss:StyleID='s21'><Data ss:Type='String'>WebSite</Data></Cell>
<Cell ss:StyleID='s21'><Data ss:Type='String'>CV</Data></Cell>
</Row>", export.ExportHeader);
}
//[TestMethod]
public void TestExcel()
{
var p = new Person { Name = "Andrei Ignat", WebSite = "http://msprogrammer.serviciipeweb.ro/", CV = "http://serviciipeweb.ro/iafblog/content/binary/cv.doc" };
var export = new ExportExcel2003<Person>();
var data = export.ExportResult(new List<Person>() { p });
var str = Encoding.Unicode.GetString(data);
File.WriteAllText("a.xls",str);
Process.Start("a.xls");
}
public void TestConstructorItemWithPerson()
{
var t = new Person {
Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"
};
var export = new ExportExcel2003 <Person>();
Assert.AreEqual(@"<Row>
<Cell><Data ss:Type='String'>@System.Security.SecurityElement.Escape((((object)Model.Name) ?? """").ToString())</Data></Cell>
<Cell><Data ss:Type='String'>@System.Security.SecurityElement.Escape((((object)Model.WebSite) ?? """").ToString())</Data></Cell>
<Cell><Data ss:Type='String'>@System.Security.SecurityElement.Escape((((object)Model.CV) ?? """").ToString())</Data></Cell>
</Row>".Replace("\r", "").Replace("\n", ""), export.ExportItem.Replace("\r", "").Replace("\n", ""));
}
public void TestConstructorHeaderWithPerson()
{
var t = new Person {
Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"
};
var export = new ExportExcel2003 <Person>();
Assert.AreEqual(@"<Row>
<Cell ss:StyleID='s21'><Data ss:Type='String'>Name</Data></Cell>
<Cell ss:StyleID='s21'><Data ss:Type='String'>WebSite</Data></Cell>
<Cell ss:StyleID='s21'><Data ss:Type='String'>CV</Data></Cell>
</Row>", export.ExportHeader);
}
public void TestConstructorItemWithPerson()
{
var t = new Person {
Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"
};
var export = new ExportExcel2003 <Person>();
Assert.AreEqual(@"<Row>
<Cell><Data ss:Type='String'>@Model.Name</Data></Cell>
<Cell><Data ss:Type='String'>@Model.WebSite</Data></Cell>
<Cell><Data ss:Type='String'>@Model.CV</Data></Cell>
</Row>", export.ExportItem);
}
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 ExportExcel2003 <Person>();
var data = export.ExportResult(new List <Person>()
{
p
});
var str = Encoding.Unicode.GetString(data);
Assert.IsTrue(str.Contains("http://serviciipeweb.ro/iafblog/content/binary/cv.doc"), "must contain the cv");
}
public void TestWithPersonHeader()
{
var p = new Person {
Name = "andrei", WebSite = "http://msprogrammer.serviciipeweb.ro/"
};
var export = new ExportExcel2003 <Person>();
var data = export.ExportResult(new List <Person>()
{
p
});
var str = Encoding.Unicode.GetString(data);
Assert.IsTrue(str.Contains(export.ExportHeader), "must contain the header");
}
//[TestMethod]
public void TestExcel()
{
var p = new Person {
Name = "Andrei Ignat", WebSite = "http://msprogrammer.serviciipeweb.ro/", CV = "http://serviciipeweb.ro/iafblog/content/binary/cv.doc"
};
var export = new ExportExcel2003 <Person>();
var data = export.ExportResult(new List <Person>()
{
p
});
var str = Encoding.Unicode.GetString(data);
File.WriteAllText("a.xls", str);
Process.Start("a.xls");
}
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");
}
}
