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

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

Posted

2013-09-16

export

ignatandrei

Tags:

Comments

26 responses to “Export to Word / Excel / PDF / CSV / HTML”

Exportarea unei liste din .NET in Excel * Word * PDF | Jurnal de programator

2013-09-16

[…] Postul original il gasiti in engleza la http://msprogrammer.serviciipeweb.ro/2013/09/16/export-to-word-excel-pdf-csv-html/ […]

Reply
Bill Elliott

2014-02-20

Hello!

I just “Nuget installed” the Exporter tool (Feb 20, 2014) into my website application (MVC w/.NET 4), but there seems to be a little trouble.

My website’s “Target framework” is .Net 4, but the ExporterObjects tool seems to have been built on .Net 4.5. The description in the Nuget Package Installer states that the tool is dependent on .Net 4, but once I install it, implement the few lines of code (as you have demonstrated), my Visual Studio 12 compile stops with the following error message;

Warning 2 The primary reference “ExporterObjects” could not be resolved because it was built against the “.NETFramework,Version=v4.5” framework. This is a higher version than the currently targeted framework “.NETFramework,Version=v4.0”. Moneta.Global

Do you have a build that is tied back to .Net 4, instead of the current build?

Reply
1. Andrei Ignat
  
  2014-02-21
  
  Sent by email
  
  Reply
  1. SSA
    
    2014-03-04
    
    Hi Andrei,
    Can you also send the build for .net 4 to me, same problem as @Bill Elliott. Can not compile from source.
    Thanks
    
    Reply
    1. Andrei Ignat
      
      2014-03-04
      
      Check your email
      
      Reply
      1. SSA
        
        2014-03-05
        
        Hi Ignat,
        Is ExportDataTable only available in version 2?
        Thanks,
        Sandeep Sharma
MS

2014-05-16

Hi Andrei,
Can you also send the build for .net 4 also to me, same problem as @Bill Elliott. Can not compile from source.
Thanks

Reply
1. Enoch
  
  2014-06-19
  
  Hi Andrei,
  I have the same problem the other folks have. Can you also send the .net 4 vesion. Thanks much.
  
  Reply
  1. Andrei Ignat
    
    2014-06-21
    
    Send me an email to Ignatandrei@yahoo.com
    
    Reply
    1. Mahesh
      
      2014-10-26
      
      Hi Andrei,
      Can you please send code for Export to Word / Excel / PDF / CSV / HTML with MVC(.net framework 4.0 version). Thanks Mahesh
      
      Reply
      1. Andrei Ignat
        
        2014-10-26
        
        I will put ASAP to github – or codeplex
Mohebbo

2014-07-18

Hi Andrei,
Can you also send the .net 4 vesion. Thanks Mohebbo

Reply
1. Andrei Ignat
  
  2014-07-18
  
  Send me an email to Ignatandrei@yahoo.com
  
  Reply
Murat

2015-02-26

Hi Andrei,
Additional information: Template File doesn’t exist.
How do I solve this error

Reply
1. Andrei Ignat
  
  2015-03-07
  
  Look at source code
  
  Reply
Nicolas Ottaviano

2015-05-04

Hi!! i need to add an image to the exported files, it’s that possible?

Reply
1. Andrei Ignat
  
  2015-05-05
  
  Add the same file
  
  Reply
Ahmed

2015-05-30

Can You Share the source code on github

Reply
Arumugam

2015-06-17

an you please send me the .Net 4.0 build of ExporterObjects file.

Reply
Nader Michael

2015-07-07

Can you please send me the .Net 4.0 build of ExporterObjects file.

Reply
sarath

2015-08-01

Hi Andrei,

I Used the Same Exporter i can able to see the cshtml file but there is no file created in the extension exls , Can you please provide me the issue

Reply
Andrew

2017-01-13

Hi Andre,

How can I have exporter preserve the data types of the columns being exported into Excel? Right now it just exports everything to “General” type columns in Excel.

Thanks,
Andrew

Reply
1. Andrei Ignat
  
  2017-01-14
  
  By modifying the template: https://github.com/ignatandrei/Exporter/wiki/Export-Modifying-Templates
  
  Reply
Sven Leuschner

2021-01-26

o/ .. is there a simple way to support language specific date while exporting to CSV using ExporterObjects ?

our customer Database speaks German, I’ve overworked the JS and CS controller functions to support / convert german date format, PDF export works fine, and the html tables as well – only CSV export still gives british(?) date 1/1/2019 for example – can I somehow influence the used formatter ?

Reply
1. Andrei Ignat
  
  2021-01-27
  
  Modify the Current Thread Culture / UICulture to German 😉
  
  Reply
  1. Sven Leuschner
    
    2021-01-27
    
    Hey Andrei,
    after twiddling with your hint – and finding the “correct place” to implement it .. it works wonderfully
    
    thank you so much
    
    Reply

Export to Word / Excel / PDF / CSV / HTML

Comments

26 responses to “Export to Word / Excel / PDF / CSV / HTML”

Leave a Reply to Andrew Cancel reply