How to render pdfs using C# [OpenOffice & C#] Mailmerge using OpenOffice. Home of PDFsharp and MigradDoc Foundation - PDFsharp & MigraDoc. Create pdf in .NET using PDFCreator. Download PDFCreator software for free at SourceForge.net. Wkhtmltopdf - Convert html to pdf using webkit (qtwebkit) EPPlus-Create advanced Excel 2007 spreadsheets on the server. EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).
EPPlus supports: Cell Ranges Cell styling (Border, Color, Fill, Font, Number, Alignments) Charts Pictures Shapes Comments Tables Protection Encryption Pivot tables Data validation Conditional formatting VBA Formula calculation Many more... Overview This project started with the source from ExcelPackage. It was a great project to start from. It had the basic functionality needed to read and write a spreadsheet. Advantages over other: Totally rewritten using dictionaries Can now load 50 000 cells in seconds Complete integration with .NET Donate to EPPlus Examples To see how this works let’s do a short walkthrough of sample 6 that creates a report on a directory in the file system.
EPPlus also supports enumeration of cells.... EPPlus and Linq Heres an example how you can use EPPlus in a webapplication... Web Applications Here's a few screenshots from the sample project... Screenshots License. Home ExtremeML. Coding Light: A Simple DocBrowser Control. A Fast CSV Reader. Introduction One would imagine that parsing CSV files is a straightforward and boring task. I was thinking that too, until I had to parse several CSV files of a couple GB each. After trying to use the OLEDB JET driver and various Regular Expressions, I still ran into serious performance problems.
At this point, I decided I would try the custom class option. I scoured the net for existing code, but finding a correct, fast, and efficient CSV parser and reader is not so simple, whatever platform/language you fancy. I say correct in the sense that many implementations merely use some splitting method like String.Split(). And, this led to the CSV reader class I present in this article. Benchmarking it against both OLEDB and regex methods, it performs about 15 times faster, and yet its memory usage is very low. To give more down-to-earth numbers, with a 45 MB CSV file containing 145 fields and 50,000 records, the reader was processing about 30 MB/sec.
Read about the latest updates here History. Converting PDF to Text in C# Update April 20, 2015: The article and the Visual Studio project are updated and work with the latest PDFBox version (1.8.9).
It's also possible to download the project with all dependencies (resolving the dependencies proved to be a bit tricky). February 27, 2014: This article originally described parsing PDF files using PDFBox. It has been extended to include samples for IFilter and iTextSharp. How to Parse PDF Files There are several main methods for extracting text from PDF files in .NET: Microsoft IFilter interface and Adobe IFilter implementation. iTextSharp PDFBox None of these PDF parsing solutions is perfect. 1. In order to parse PDF files using IFilter interface you need the following:
Reflective Code. Net Developer Cheat Sheets. Open XML SDK Ankush's Blog. Consider a scenario, you want to insert a hyperlink in Excel 2010 (or Excel 2007) file programmatically using a web application.
You should not use Office Object Model in a web application, Please refer So what we can do?? As we know that Office 2007 and 2010 file format is XML based (just rename any Office 2007/2010 document to .zip and you can see a lots of XML files which makes a document and they are simply zipped in a one file). To manipulate these files, MS has introduced a library, Open XML SDK 2.0. The SDK is built on the System.IO.Packaging API and provides strongly-typed classes to manipulate documents that adhere to the Office Open XML File Formats Specification. The Office Open XML File Formats specification is an open, international, ECMA-376, Second Edition and ISO/IEC 29500 standard. The Open XML SDK 2.0 simplifies the task of manipulating Open XML packages and the underlying Open XML schema elements within a package.
Is also important to know that what SDK CAN’T do: