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