Category: export

Exporter–new functionalities

 

I have added to the export to Excel,Word , Pdf, Html,CSV new functionalities:

Export multiple lists to multiple sheets in the same Excel: Wiki at https://github.com/ignatandrei/Exporter/wiki/Export-multiple-sheets-in-Excel , video demo at https://youtu.be/ZLjnZvP9m0U

Export from Powershell: Wiki at https://github.com/ignatandrei/Exporter/wiki/Export—Powershell , video Demo at https://youtu.be/PhBdnnaAbr0

Export DataSet to Excel: Wiki at https://github.com/ignatandrei/Exporter/wiki/Export-DataSet , video demo at https://youtu.be/mvlDjF1TeVc

.NET 4.0 version available at https://github.com/ignatandrei/Exporter/tree/branchNet4

Enjoy !

Exporter–added RSS and IDataReader

 

I have added to the Exporter

 

  1. Export RSS into Word/Excel/PDF  – see https://github.com/ignatandrei/Exporter/wiki/Export-RSS and video at https://youtu.be/AJWIJRAs_Xc 
  2. Export IDataRerader(SqlDataReader ) -  see https://github.com/ignatandrei/Exporter/wiki/Export-IDataReader and video at https://youtu.be/kDfNjY1Lfkg

 

Also , the RSS could be tested at http://exporter.azurewebsites.net/Home/ExportData 

The code source is free and all on https://github.com/ignatandrei/Exporter

Export to Excel,Word , Pdf, Html,CSV–work in progress

In my previous post I have announced the application / package that exports data ( classes/datatable/csv/json) to Word/Excel/PDF.

I have made also videos for show some features – the playlist is at https://www.youtube.com/playlist?list=PL4aSKgR4yk4MqsH5M-f1f5YLVG-nwr4FG&jct=8gXZuQaCYGLOsL6t5dNN9rEx5r_8vQ

The playlist contains:

Export Json To Excel Word PDF from javascript

 

Export List Objects To ExcelWordPDF

Export CSV To Excel Word PDF


Export DataTable to Excel Word PDF

 

Also, the documentation shows how add data that not belong to the Model ( that is, an array/list of objects / json) – here: https://github.com/ignatandrei/Exporter/wiki/Export-other-data-that-does-not-belong-to-the-model 

( also added a test for this)

Enjoy!

Export to Excel,Word , Pdf, Html,CSV

I have made an application / package that exports data ( classes/datatable/csv/json) to Word/Excel/PDF.

I have made several tries in the past , however now is the definitive source for .NET 4.x It is FULL code source, with tests and tutorials..

 

The code is at https://github.com/ignatandrei/Exporter 

The NuGet package is at https://www.nuget.org/packages/ExporterWordExcelPDF

The demo online is at http://exporter.azurewebsites.net/ 

The documentation is at https://github.com/ignatandrei/Exporter/wiki 

You can help with the project – please read https://github.com/ignatandrei/Exporter/wiki/Help-the-project 

So if you need Excel / Word / PDF to export, please consider this open source project.

MVC Export List of objects to Excel-Word-PDF-CSV-HTML-XML–Razor style

This is the second part of the demo of the Exporter  in action  – this time in MVC .

It is a little more complicated, because you need to show to the exporter the full path where to put the generated file

string filePathExport = Server.MapPath(“~/exports/a” + ExportBase.GetFileExtension((ExportToFormat)id));

All others are the same easy stuff  -add Nuget package and export in 3 lines – and all action code is 6 lines long:

            List<Electronics> list = Electronics.GetData();
            ExportList<Electronics> exp = new ExportList<Electronics>();
            exp.PathTemplateFolder = Server.MapPath("~/ExportTemplates/electronics");
            string filePathExport = Server.MapPath("~/exports/a" + ExportBase.GetFileExtension((ExportToFormat)id));
            exp.ExportTo(list, (ExportToFormat)id, filePathExport);
            return this.File(filePathExport, "application/octet-stream", System.IO.Path.GetFileName(filePathExport));

 

 

 

 

GitHub Demo at https://github.com/ignatandrei/Export_Word_Excel_PDF_CSV_HTML

The Nuget package is at http://www.nuget.org/packages/Exporter/

YouTube demo at http://youtu.be/DHNRV9hzG_Y

Export to Word / Excel / PDF / CSV / HTML

I have made a NuGet package that exports a List to Word(2003/2007) / Excel(2003/2007) / PDF  / CSV / HTML.

It is made with Razor Templating – interpreted by WestWind Razor Engine ( source code at https://github.com/RickStrahl/Westwind.RazorHosting )

What it does it generates templates in Razor ( that can  be freely modified after) and it generates the specific output.

The whole code is that simple

List<Electronics> list = Electronics.GetData();
            List<Electronics> list = Electronics.GetData();
            ExportList<Electronics> exp = new ExportList<Electronics>();
            exp.PathTemplateFolder = Path.Combine(Environment.CurrentDirectory, "templates/electronics");
            //export
            exp.ExportTo(list, ExportToFormat.HTML, "a.html");
            exp.ExportTo(list, ExportToFormat.CSV, "a.csv");
            exp.ExportTo(list, ExportToFormat.XML, "a.xml");
            exp.ExportTo(list, ExportToFormat.Word2003XML, "a_2003.doc");
            exp.ExportTo(list, ExportToFormat.Excel2003XML, "a_2003.xls");
            exp.ExportTo(list, ExportToFormat.Excel2007, "a.xlsx");
            exp.ExportTo(list, ExportToFormat.Word2007, "a.docx");
            exp.ExportTo(list, ExportToFormat.itextSharpXML, "a.xml");
            exp.ExportTo(list, ExportToFormat.PDFtextSharpXML, "a.pdf");

GitHub Console Demo at https://github.com/ignatandrei/Export_Word_Excel_PDF_CSV_HTML

The Nuget package is at http://www.nuget.org/packages/Exporter/

YouTube demo at http://youtu.be/2CBdn6ru47M

Andrei Ignat weekly software news(mostly .NET)

* indicates required

Please select all the ways you would like to hear from me:

You can unsubscribe at any time by clicking the link in the footer of our emails. For information about our privacy practices, please visit our website.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp's privacy practices here.