'Excel, Word, PDF components for .NET' Blog RSS Feed

Parse HTML document in .NET

EleriumSoft — Tue, 07 May 2013 23:37:11 -0700

HyperText Markup Language (HTML) is the main markup language for creating web pages and other information that can be displayed in a web browser. HTML is written in the form of HTML elements consisting of tags enclosed in angle brackets, within the web page content. HTML elements form the building blocks of all websites.

Very often, developers need to parse HTML documents into components for data analysis or automatic operation with HTML pages without user intervention. To analyze the structure of the document, developer can use regular expressions. But this is not the best solution, because HTML is not a regular language. Also it is almost impossible to compose the regular expression that similar to the HTML markup. That why developers use special tools to parse HTML files. An example of such tool is Elerium HTML .NET Parser.

Elerium HTML .NET Parser component, new release 1.6 has been introduced by Elerium Software. It has several important changes:

- Improved the algorithm of the HTML Parser.

- Fixed some issues of HTML saving.

- Extended the list of encoded chars of HTML document.

What are the features of the HTML Parser? The component has a wide set of functions and properties to operate with HTML document. For example, Elerium HTML .NET Parser allows to get or set attributes of html tags. This sample shows how to find specified attribute of the html element and change its value:

C# Example:

using System;  
using System.Collections.Generic;  
using System.Linq;  
using System.Text;  
using Docs.Html;  

namespace CreateHtmlDoc  
{  
    class Program  
    {  
        static string indent = "";  
        static void Main(string[] args)  
        {  
            string htmltext = "<div><b>Bold text</b> before <span style=\"font-style:italic;\">Italic text</span></div>";  
            // Build DOM of the html
            HtmlDoc html = HtmlDoc.ParseHTML(htmltext);  
            // The function changes text style from italic to underline  
            ScanHtmlTree(html.Nodes);  
            // Show the tree of the html  
            ViewHtmlDOM(html.Nodes);  
            Console.ReadLine();  
        }  
        static void ScanHtmlTree(HtmlNodeCollection nodes)  
        {  
            foreach (HtmlNode node in nodes)  
            {  
                if (node.IsElement)  
                {  
                    HtmlTag tag = node as HtmlTag;  
                    if (tag.Attributes.IndexOf("style") != -1)  
                        tag.Attributes["style"].Value = "text-decoration:underline;";  
                    ScanHtmlTree(tag.Nodes);  
                }  
            }  
        }  
        static void ViewHtmlDOM(HtmlNodeCollection nodes)  
        {  
            foreach (HtmlNode node in nodes)  
            {  
                if (node.IsText)  
                {  
                    HtmlText text = node as HtmlText;  
                    Console.WriteLine(indent + text.ToString());  
                }  
                else  
                {  
                    HtmlTag tag = node as HtmlTag;  
                    Console.WriteLine(indent + tag.ToString());  
                    indent += "  ";  
                    ViewHtmlDOM(tag.Nodes);  
                    indent = indent.Substring(0, indent.Length - 2);  
                    Console.WriteLine(indent + "");  
                } } } 
	} 
}

About Elerium Software

Elerium Software develops professional solutions for use in .NET projects (C#, VB.NET, ASP.NET) that aimed to read/write/convert different office/web documents and formats. Elerium Software components are based on the unique design and fast algorithms that allow being independent from the third-party applications and libraries.

For more information about the component please visit the product page:

http://www.eleriumsoft.com/HTML_NET/HTMLParser/Default.aspx

The easy method to convert HTML to PDF in ASP.NET

EleriumSoft — Tue, 07 May 2013 23:33:10 -0700

HTML format is simple and easy to use and allows to create complex reports from the raw data with a minimum of effort. But the appearance of HTML documents can be quite different depending on the browser. Also HTML documents do not have any protection. Therefore, the best choice for the provision of important reports to end users is a PDF document. Appearance of the PDF document is always the same and does not depend on the viewing software and security measures can be easily added to a PDF document.

When a developer creates an application or site, he can create a PDF document manually to understand the format specification, but it is a very long and laborious process. On the other side, the developer can use ready-made libraries for working with the PDF. One of these solutions is Elerium HTML to PDF .NET component.

Elerium HTML to PDF .NET component, new release 2.5 has been introduced by Elerium Software. It has several important changes:

- Improved the CSS parser of Html to PDF converter.

- Added a parsing of tabs in HTML files.

- Improved rendering of images in the PDF document.

- Fixed issues of image alignment at PDF rendering.

- Fixed issues of carrying the image over to the next line.

How to convert an HTML file to a PDF document? This is very easy. First of all, a developer must install HTML to PDF .NET component to the project:

1. Add HTML to PDF .Net component to the solution. Simply put Docs.PDF.dll into /bin folder of the project.

2. nitialize the HtmlToPdf instance.

When the component is connected to the project a developer can convert HTML to PDF:

ASP.NET example

// Initialize the string variables of input and output files   
string file_html = @"C:\hdoc.html";  
string file_pdf = @"C:\new.pdf";  
try  
{  
// Create a new instance of the HtmlToPdf class        
Docs.Pdf.HtmlToPdf conv = new Docs.Pdf.HtmlToPdf();  
// Open the Html source 
conv.OpenHTML(file_html); 
// Convert html to pdf and save pdf to certain path and file name 
conv.SavePDF(file_pdf);  
 }  
catch (Exception ex)  
{  
Response.Write(ex.Message);
}

Most often a developer need to convert dynamically generated HTML string to the PDF. It is also very easy:

C# + ASP.NET example

Docs.Pdf.HtmlToPdf conv = new Docs.Pdf.HtmlToPdf();  
conv.BasePath = MapPath("~/");  
conv.PageInfo.PageFormat = Docs.Pdf.ePageFormat.A4;  
conv.PageInfo.PageOrientation = Docs.Pdf.ePageOrientation.Portrait;  
conv.OpenHTML(@"<table width='100%'>
                  <tr>  
                    <td width='19%'><strong>Last update:</strong></td>  
                    <td width='81%'> 23 Jun 2009 - 01:22</td>  
                  </tr>  
                </table>");  
conv.SavePDF(MapPath("~/pdf/") + "report.pdf");

How to read data and formatting of Word documents in .NET

EleriumSoft — Tue, 02 Apr 2013 22:34:22 -0700

MS Word documents are one of the most popular formats for the reporting. It allows presenting information with different styles and formatting exactly such as it should look on a paper. Often MS Word is not installed on the server/computer, nevertheless a developer wants to process these reports inside C#/VB.NET/ASP.NET project. The best way is using a professional .NET library that includes various Word API functions. One of these libraries is introduced by Elerium Software.

Elerium Word .NET Reader presents an easy way to read data and formatting of Word documents. Here are the basic steps of getting the text of the document.

First off all, a developer must install Elerium Word .NET Reader to the project:

1. Download the latest version of the component from this link:

http://www.eleriumsoft.com/Word_NET/WordReader/Default.aspx

2. Extract the downloaded archive and put the Word.dll component into /bin folder of the project.

3. Add the component to the “using” section:

using Docs.Word;

After that developer can easily read data from the Word document.

C# example:

using System;  
using System.Collections.Generic;  
using System.Linq;  
using System.Text;  
using Docs.Word;  
namespace OpenDocument  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            // Creates an instance of Document class  
            Document Doc = new Document();  
            // Reads a .doc file into internal document structure  
            Doc.ReadDoc(@"..\..\Data\DocFile.doc");  
            // Gets text of 1st paragraph of 1st section of the document  
            string Text = ((Paragraph)Doc.Sections[0].Nodes[0]).Text;  
            // Writes gotten text to console  
            Console.WriteLine(Text);  
            Console.ReadKey();  
        }  }  }

VB.NET Example:

Imports Docs.Word  
Module Module1  
    Sub Main()  
        ' Creates an instance of Document class  
        Dim Doc As New Document()  
        ' Reads a .doc file into internal document structure  
        Doc.ReadDoc("..\..\Data\DocFile.doc")  
        ' Gets text of 1st paragraph of 1st section of the document  
        Dim Text As String = DirectCast(Doc.Sections(0).Nodes(0), Paragraph).Text  
        ' Writes gotten text to console  
        Console.WriteLine(Text)  
        Console.ReadKey()  
    End Sub  
End Module

This sample demonstrates the reading of different text formatting such as Font Name, Size, Color, Background color, Footnotes etc.

C# Example:

using System;  
using System.Collections.Generic;  
using System.Text;  
using System.Windows.Forms;  
using Docs.Word;  
namespace TextRun_Styles  
{  
        private void Form1_Load(object sender, EventArgs e)  
        {  
            // Creates a new instance of Document class and reads a .doc file into this structure  
            Document Doc = new Document();  
            Doc.ReadDoc(@"..\..\Data\WordTextFormatting.doc");  
            // Gets two first text runs, in this example - two sentences  
            for (int i = 0; i < 2; i++)  
            {  
                // Gets text run  
                TextRun tTextRun = ((Paragraph)Doc.Sections[0].Nodes[0]).TextRuns[i];  
                // Writes its properties  
                textBox1.Text += "=== Text run " + (i+1) + " ===" + "\r\n";  
                textBox1.Text += "Text          : " + tTextRun.Text + "\r\n";  
                textBox1.Text += "Font name     : " + tTextRun.Style.FontName + "\r\n";  
                textBox1.Text += "Font size (in half-point) : " + tTextRun.Style.FontSize + "\r\n";  
                textBox1.Text += "Text color            : " + tTextRun.Style.TextColor + "\r\n";  
                textBox1.Text += "Bold          : " + tTextRun.Style.FontStyle.Bold + "\r\n";  
                textBox1.Text += "Italic            : " + tTextRun.Style.FontStyle.Italic + "\r\n";  
                textBox1.Text += "Underlined        : " + tTextRun.Style.FontStyle.Underlined + "\r\n";  
                textBox1.Text += "Strike-out            : " + tTextRun.Style.FontStyle.StrikeOut + "\r\n\r\n";  
            }      }     }     }

VB.NET Example:

Imports Docs.Word  
Public Class Form1  
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load  
        ' Creates a new instance of Document class and reads a .doc file into this structure  
        Dim Doc As New Document()  
        Doc.ReadDoc("..\..\Data\WordTextFormatting.doc")  
        ' Gets two first text runs, in this example - two sentences  
        For i As Integer = 0 To 1  
            ' Gets text run  
            Dim tTextRun As TextRun = DirectCast(Doc.Sections(0).Nodes(0), Paragraph).TextRuns(i)  
            ' Writes its properties  
            textBox1.Text += "=== Text run " & (i + 1).ToString & " ===" & vbCr & vbLf  
            textBox1.Text += "Text" & vbTab & vbTab & vbTab & ": " + tTextRun.Text & vbCr & vbLf  
            textBox1.Text += "Font name" & vbTab & vbTab & ": " + tTextRun.Style.FontName & vbCr & vbLf  
            textBox1.Text += "Font size" & vbTab & "(in half-point)" & vbTab & ": " + tTextRun.Style.FontSize.ToString & vbCr & vbLf  
            textBox1.Text += "Text color" & vbTab & vbTab & vbTab & ": " + tTextRun.Style.TextColor.ToString & vbCr & vbLf  
            textBox1.Text += "Bold" & vbTab & vbTab & vbTab & ": " + tTextRun.Style.FontStyle.Bold.ToString & vbCr & vbLf  
            textBox1.Text += "Italic" & vbTab & vbTab & vbTab & ": " + tTextRun.Style.FontStyle.Italic.ToString & vbCr & vbLf  
            textBox1.Text += "Underlined" & vbTab & vbTab & ": " + tTextRun.Style.FontStyle.Underlined.ToString & vbCr & vbLf  
            textBox1.Text += "Strike-out" & vbTab & vbTab & vbTab & ": " + tTextRun.Style.FontStyle.StrikeOut.ToString & vbCr & vbLf & vbCr & vbLf  
        Next  
    End Sub  
End Class

Word documents in .NET

EleriumSoft — Tue, 02 Apr 2013 22:27:29 -0700

Elerium Word .NET component, new release 2.0 has been introduced by Elerium Software.

Elerium Word .NET is a full managed .NET component which enables C#/VB.NET/ASP.NET developers to create, read, write and convert MS Word documents (DOC, DOCX, RTF, TXT) from any .NET projects. Elerium Word .NET provides full support of Word 97-2003, Word 2007-2012 formats and allows converting it between each other. The installation package of the component contains C# and VB.NET samples for quick start.

The component parses the Word document and presents it to developer as a tree. The root of the tree includes the sections which contain all tables and paragraphs of the document. The minimal element of the tree is a textrun. Textrun may have a char, word or a whole sentence. Each node of the tree has properties. For example, with help of the textrun properties a developer is able to set text font settings, color or background color.

Elerium Word .NET is an independent .NET component that compatible with .NET 2.0 and higher and does not depend on third-party libraries and Microsoft Office Automation.

Key features:

- File formats doc, docx, rtf, text.

- Generate and save Word documents (Word 97-2003, Word 2007 and Word 2010).

- Methods for Reading / Writing word files (see C# VB.NET examples).

- Converting options between the following Word formats DOC, DOCX, RTF, Text document.

- Get, edit or create document sections.

- Get, edit or create word header or footer.

- Get, edit or create document content (tables, paragraphs, images, textboxes, etc.)

- Get, edit or create word footnotes.

- Get, edit or create word endnotes.

- Settings of word page (width, height, margins, orientations etc.)

- Sections properties.

- Page numbering.

- Footnotes properties (position, numbering mode, etc.)

- Endnote properties (number style, numbers offset, etc.)

- Paragraph manipulations (create, delete, etc.)

- Paragraph Indents.

- Paragraph spacing.

- Paragraph borders.

- Text run manipulations (add, delete, etc.)

- Textrun font and color styles.

- Textrun formatting (bold, italic, underlined, etc.)

- Textrun special properties (borders, Extra space, horizontal scale)

- Table manipulations (create, delete, etc.)

- Table common properties (alignment, auto fit, etc.)

- Table rows properties (borders, height, alignment, etc.)

- Table cell properties (width, height, borders, etc.)

- Merged cells.

- Embedded tables.

- Find and replace specified paragraphs or tables in the word document.

- Extract objects (texts, comments, images etc.) from the word document.

- Word Document Protection.

- Form fields manipulations (checkbox, edit box, buttons, etc.)

- Format form fields (checked state, inner text, etc.)

Also please look at Key Advantages that deserve mention:

- Free future support.

- Free future updates.

- Royalty-free agreement.

- Does not require additional libraries.

- Works on server with medium trust level.

About Elerium Software

Elerium Software develops professional solutions for use in .NET projects (C#, VB.NET, ASP.NET) that aimed to read/write/convert different office/web documents and formats. Elerium Software components are based on the unique design and fast algorithms that allow being independent from the third-party applications and libraries.

For more information about the component please visit the product page:

http://www.eleriumsoft.com/Word_NET/WordNet/Default.aspx

If you have any questions or concerns about component, let us know:

http://eleriumsoft.com/Company/Contact.aspx

Export Excel to HTML – component for .NET

EleriumSoft — Wed, 06 Mar 2013 22:35:57 -0700

There are a lot of data contained in tables. Time to time, it is required to work with it for viewing, editing and calculations. The best solution is the Microsoft Excel. But when need to present result data on an online document, presentation, or webpage, it is reasonable to convert data into HTML format.

The simplest way to convert Excel to HTML is to use the Excel "Save as Web Page" function. But what if it is needed to convert files inside C#/VB.NET/ASP.NET project and MS Excel is not installed? The best and the fastest way is a using some .Net libraries. One of these libraries is introduced by Elerium Software. Elerium Excel to HTML .NET is a high performance component enabling developer to convert Excel to HTML files. The converter supports the following excel formats: XLS, XLSX, CSV.

First of all, a developer must install Excel to HTML .NET component to the project:

1. Download the latest version of the component from this link: http://www.eleriumsoft.com/Excel_NET/Excel2HTML/Default.aspx

2. Extract the downloaded archive and put the Excel.dll component into /bin folder of the project.

3. Add the component to the “using” section:

using Docs.Excel; 
using Docs.Excel.Converting;

When the component is connected to the project, a developer can convert the whole excel spreadsheet or only range of excel cell to HTML file. This code will display how simple to convert full excel spreadsheet to html file:

using System;  
using System.Collections.Generic;  
using System.Text;  
using Docs.Excel;  
using Docs.Excel.Converting;  
namespace ExportToHTML  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            //Read excel file.  
            ExcelWorkbook wbook = ExcelWorkbook.ReadXLSX(@"..\..\..\List.xlsx");  
            ExcelToHtml converter = new ExcelToHtml(wbook);  
            //Display mesh grid.  
            converter.Worksheets[0].ShowGrid = true;  
            //Save specified worksheet to HTML file.   
            string html_file = @"..\..\..\ExportExcelToHtml.html";  
            converter.Worksheets[0].SaveHTML(html_file);  
            //Open specified file.  
            System.Diagnostics.Process.Start(html_file);  
        }  
    }  
}

Convert only a range of excel cells:

using System;  
using System.Collections.Generic;  
using System.Text;  
using Docs.Excel;  
using Docs.Excel.Converting;  
namespace RangeSettings  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            //Read excel file.  
            ExcelWorkbook wbook = ExcelWorkbook.ReadXLSX(@"..\..\..\ExcelRange.xlsx");  
            ExcelToHtml converter = new ExcelToHtml(wbook);  
            converter.Worksheets[0].ShowGrid = true;  
            // Set index of first displayed row.  
            converter.Worksheets[0].StartRow = 2;  
            // Set index of last displayed row.  
            converter.Worksheets[0].EndRow = 4;  
            // Set index of first displayed column.  
            converter.Worksheets[0].StartColumn = 1;  
            // Set index of last displayed column.  
            converter.Worksheets[0].EndColumn = 2;  
            //Save specified worksheet to HTML file.   
            string html_file = @"..\..\..\ExcelToHtml.html";  
            converter.Worksheets[0].SaveHTML(html_file);  
            //Open specified file.  
            System.Diagnostics.Process.Start(html_file);  
        }  
    }  
}

About Elerium Software

Elerium Software develops professional solutions for use in .NET projects (C#, VB.NET, ASP.NET) that aimed to read/write/convert different office/web documents and formats. Elerium Software components are based on the unique design and fast algorithms that allow being independent from the third-party applications and libraries.

For more information about the component please visit the product page:
http://www.eleriumsoft.com/Excel_NET/Excel2HTML/Default.aspx

If you have any questions or concerns about component, let us know:
http://eleriumsoft.com/Company/Contact.aspx

Export HTML to Excel – component for .NET

EleriumSoft — Wed, 06 Mar 2013 22:30:31 -0700

Today a lot of data in internet is stored in HTML format. This is very handy when it’s required to display a report or presentation. But the processing of such data is extremely difficult. In most cases the data that require analyze is presented in tabular form, so the best solution for their processing is to convert document into a Microsoft Excel format. Microsoft Excel is the industry standard for spreadsheet software and it gives the ability to analyze large amount of data. Microsoft Excel is a very powerful and versatile tool and can be used for many different purposes: report, calendar, schedule, financial tools, pricelist, budget and etc.

If a small amount of data, it can be moved in the Excel spreadsheet manually. But what if it is needed to convert a lot of HTML documents inside C#/VB.NET/ASP.NET project? The best and the fastest way is a using of different .Net libraries. One of these libraries is introduced by Elerium Software. Elerium HTML to Excel .NET component offers full support for HTML formatting, including tables, CSS, graphics, tables, borders and is able to convert HTML to Excel files (XLS, XLSX, CSV).

First of all, a developer must install HTML to Excel .NET component to the project:

1. Download the latest version of the component from this link:
http://www.eleriumsoft.com/Excel_NET/HTML2Excel/Default.aspx

2. Extract the downloaded archive and put the Excel.dll component into /bin folder of the project.

3. Add the component to the “using” section:

using Docs.Html;
using Docs.Converting;
using Docs.Spreadsheet;

When the component is connected to the project, a developer can convert HTML to Excel spreadsheet. This code will display how simple it is to convert HTML file to Excel workbook with formatting:

using System;   
using System.Collections.Generic;   
using System.Linq;   
using System.Text;   
using Docs.Html;   
using Docs.Converting;   
using Docs.Spreadsheet;   
namespace PreserveFormatting   
{   
    class Program   
    {   
        static void Main(string[] args)   
        {   
            // Read the specified html file.   
            HtmlDoc html = HtmlDoc.ReadHTML(@"..\..\..\Capitals.html");   
            // Convert Html table to Excel with formatting preservation   
            HtmlToExcel htmlexcel = new HtmlToExcel();   
            htmlexcel.PreserveFormatting = true;   
            ExcelWorkbook excel = htmlexcel.Convert(html);   
            //Add text and save Excel file as XLSX format.   
            excel.WriteXLSX(@"..\..\..\Export_Html.xlsx");   
            //Open specified file in MS Excel.   
            System.Diagnostics.Process.Start(@"..\..\..\Export_Html.xlsx");   
        }   
    }   
}

Also the component allows editing the resulting Excel file and placing the resulting table to a certain place on the page:

using System;   
using System.Collections.Generic;   
using System.Text;   
using Docs.Html;   
using Docs.Converting;   
using Docs.Spreadsheet;   
namespace SetPositionTable   
{   
    class Program   
    {   
        static void Main(string[] args)   
        {   
            // Read the specified html file.   
            HtmlDoc html = HtmlDoc.ReadHTML(@"..\..\..\HorseRider.html");   
            // Set position Row 2, Column 1   
            HtmlToExcel htmlexcel = new HtmlToExcel();   
            htmlexcel.RowStart = 2;   
            htmlexcel.ColumnStart = 1;   
            // Convert Html table to Excel starting from cell "B3"   
            ExcelWorkbook excel = htmlexcel.Convert(html);   
            //Add text and save Excel file as XLSX format.   
            excel.Worksheets[0].Cells["B2"].Value = "HTML to Excel .NET converter";   
            excel.Worksheets[0].Cells["B2"].Style.Font.Bold = true;   
            excel.WriteXLSX(@"..\..\..\ExcelConverter.xlsx");   
            //Open specified file in MS Excel.   
            System.Diagnostics.Process.Start(@"..\..\..\ExcelConverter.xlsx");   
        }   
    }   
}

The editing of Excel formulas in C#/VB.NET without MS Excel installed.

EleriumSoft — Wed, 06 Mar 2013 22:24:41 -0700

Microsoft Excel is the industry standard for spreadsheet software and it gives the ability to analyze large amounts of data to discover trends and patterns that will influence decisions. MS Excel can create reports with full formatting, which include graphics, text, hyperlinks, etc. Reports can automatically analyze data, it requires only enter data and formulas for treatment. Next, you can only change the input data and Excel will automatically calculate all data for a given algorithm. Microsoft Excel is a very versatile tool and can be used for many different purposes: report, calendar, schedule, financial tools, pricelist, budget and etc.

Formula is a core of excel automation and allows to organize a complex applications. The easiest and fastest way to work with formula from C#/VB.NET/ASP.NET project is to use third-party components, like Excel .NET introduced by Elerium Software. Elerium Excel .NET component can create, read and calculate formulas.

First off all a developer must install Excel .NET to the project:

1. Download the latest version of the component from this link: http://eleriumsoft.com/Excel_NET/ExcelNET/Download.aspx.

2. Extract the downloaded archive and put the Excel.dll component into /bin folder of the project.

3. Add the component to the “using” section:

using Docs.Excel;

When the component is connected to the project, a developer can create/open excel files and work with its content, including formulas:

using System;  
using System.Collections.Generic;  
using System.Text;  
using Docs.Excel;  
namespace Formula  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            //Create a new workbook.  
            ExcelWorkbook Wbook = new ExcelWorkbook(); 
            //Add new worksheet to workbook.  
            Wbook.Worksheets.Add("Sheet1");  
            //Set width of columns.  
            Wbook.Worksheets[0].Columns[0].Width = 200;  
            Wbook.Worksheets[0].Columns[1].Width = 15;  
            Wbook.Worksheets[0].Columns[2].Width = 90;  
            //Column headings.  
            Wbook.Worksheets[0].Cells[0, 0].Value = "Formula";  
            Wbook.Worksheets[0].Cells[0, 2].Value = "Result";  
            //Writes formulas.  
            Wbook.Worksheets[0].Cells[1, 0].Value = "7+3=";  
            Wbook.Worksheets[0].Cells[1, 2].Value = "=7+3";  
            Wbook.Worksheets[0].Cells[2, 0].Value = "(2*2^2)%=";  
            Wbook.Worksheets[0].Cells[2, 2].Value = "=(2*2^2)%";  
            Wbook.Worksheets[0].Cells[3, 0].Value = "SUM(SIN(3);TAN(4);LOG(5;5))=";  
            Wbook.Worksheets[0].Cells[3, 2].Value = "=SUM(SIN(3);TAN(3);LOG(5;5))";  
            Wbook.Worksheets[0].Cells[4, 0].Value = "CEILING(12.35;0.1)=";  
            Wbook.Worksheets[0].Cells[4, 2].Value = "=CEILING(12.35;0.1)";  
            Wbook.Worksheets[0].Cells[5, 0].Value = "PI()=";  
            Wbook.Worksheets[0].Cells[5, 2].Value = "=PI()";  
            Wbook.Worksheets[0].Cells[6, 0].Value = "TODAY()=";  
            Wbook.Worksheets[0].Cells[6, 2].Value = "=TODAY()";  
            Wbook.Worksheets[0].Cells[6, 2].Style.StringFormat = "MMM-DD-YYYY";  
            Wbook.Worksheets[0].Cells[7, 0].Value = "TRUE()=";  
            Wbook.Worksheets[0].Cells[7, 2].Value = "=TRUE()";  
            // XSL  
            Wbook.WriteXLS(@"..\..\..\ExcelFormula.xls");  
            // XSLX  
            Wbook.WriteXLSX(@"..\..\..\ExcelFormula.xlsx");  
            //Open specified file in MS Excel.  
            System.Diagnostics.Process.Start(@"..\..\..\ExcelFormula.xlsx");  
        }  
    }  
}

Supported Excel formulas:

1. Function of Date & Time: DATE / DATEVALUE / DAY / HOUR / MINUTE / MONTH / NOW / SECOND / TIME / TIMEVALUE / TODAY / WEEKDAY /YEAR

2. Financial function: SLN / SYD

3. Logical function: AND / FALSE / IF / NOT / OR / TRUE

4. Text function: CHAR / CODE / CONCATENATE / DOLLAR / EXACT / FIXED / LEFT / LEN / LOWER / MID / PROPER / REPLACE / REPT / RIGHT / SUBSTITUTE / TEXT / TRIM / UPPER / VALUE

5. Math & Trig function: ABS / ACOS / ASIN / ATAN / ATAN2 / CEILING / COMBIN / COS / COSH / DEGREES / EVEN / EXP / FACT / FLOOR / INT / LN / LOG / LOG10 /MOD / ODD / PI / POWER / PRODUCT / RADIANS / RAND / ROUND / ROUNDDOWN / ROUNDUP / SIGN / SIN / SINH / SQRT / SUM / SUMSQ / TAN / TANH / TRUNC /

6. Statistical function: AVERAGE / COUNT / MAX / MIN

About Elerium Software

Elerium Software develops professional solutions for use in .NET projects (C#, VB.NET, ASP.NET) that aimed to read/write/convert different office/web documents and formats. Elerium Software components are based on the unique design and fast algorithms that allow to be independent from the third-party applications and libraries.

For more information about the component please visit the product page:
http://www.eleriumsoft.com/Excel_NET/ExcelNET

If you have any questions or concerns about component, let us know:
http://eleriumsoft.com/Company/Contact.aspx

HTML Parser in .NET, C#, VB.NET, ASP.NET

EleriumSoft — Tue, 29 Jan 2013 22:04:53 -0700

Elerium HTML .NET Parser component, new release 2.4 has been introduced by Elerium Software.

HyperText Markup Language (HTML) is the main markup language for displaying web pages and other information that can be displayed in a web browser. HTML is written in the form of HTML elements consisting of tags enclosed in angle brackets (like ), within the web page content. HTML elements form the building blocks of all websites. HTML allows images and objects to be embedded and can be used to create interactive forms. It provides a means to create structured documents by denoting structural semantics for text such as headings, paragraphs, lists, links, quotes and other items. It can embedscripts written in languages such as JavaScript which affect the behavior of HTML web pages. The main advantage of HTML is its wide use. HTML is the most search engine friendly and show up on most browsers around the world.

HTML document can also refer to Cascading Style Sheets (CSS) to define the appearance and layout of text and other material. Cascading Style Sheets (CSS) is a style sheet language used for describing the presentation semantics(the look and formatting) of a document written in a markup language. CSS makes it possible to describe a set of rules to display the same elements. It has a much wider array of attributes than HTML, which allows more flexibility to customize the appearance of pages . CSS allows to reduce the amount of code on a Web page, so that pages are loaded and run faster.

Elerium HTML .NET Parser is a .NET component to parse and manipulation of HTML /XML documents and Cascading Style Sheets (CSS). The HTML Parser can be used in WinForms and ASP.NET (C#, VB.NET) applications. Component is fully independent and requires only .NET Framework.

Elerium HTML .NET Parser is available in two versions: Lite and Pro. The Lite version includes HTML Parser without CSS parser and does not allow to manipulate CSS files.

Elerium HTML .NET Parser key features:

- Easy in use API of HTML Parser.

- DOM tree structure of an HTML document.

- Scanning the HTML file tag by tag. Parsing tag attributes and their values.

- Features for common queries: document links, images, tables etc.

- Imbedded CSS parser helps to analyze style attribute or corresponding CSS styles for certain HTML tag, class, id (see C# VB.NET examples).

- The parsing of badly formatted HTML, which makes the component ideal for use with "real-world" HTML that chokes other parsers.

- Variety of source data type: string, stream, file, URL. HTML parser can parse HTML content directly from a web site or offline HTML pages.

About Elerium Software

Elerium Software develops professional solutions for use in .NET projects (C#, VB.NET, ASP.NET) that aimed to read/write/convert different office/web documents and formats.
Elerium Software components are based on the unique design and fast algorithms that allow to be independent from the third-party applications and libraries.

For more information about the component please visit the product page:
http://www.eleriumsoft.com/HTML_NET/HTMLParser

Convert HTML to Excel XLS XLSX in .NET, C#, VB.NET, ASP.NET

EleriumSoft — Mon, 28 Jan 2013 04:42:30 -0700

Elerium HTML to Excel .NET component, new release 2.4 has been introduced by Elerium Software.

Elerium HTML to Excel .NET is a professional component that can be used in any type of .NET (C#, VB.NET) projects. The component converts HTML to Excel files (XLS, XLSX, CSV) and can be implemented in ASP.NET / WinForms projects. Elerium HTML to Excel .NET offers full support for HTML formatting, including tables, CSS, graphics, tables, borders (see C# VB.NET examples).

Elerium HTML to Excel .NET is compatible with .NET 2.0 and higher and does not required any additional components.

Elerium HTML to Excel .NET key features:
Document Features:

- Different Excel formats: XLS, XLSX, CSV.

- Load and Save CSV files delimited with comma, tab, semicolon or any other separator.

- Find and Replace data in Workbook.

- Preserve Pictures and Charts.

Converting Features:

- Export HTML files to Excel Files XLS, XLSX, CSV.

- Creating a strong copy of HTML table.

- Preservation of formatting of source HTML files.

- Choosing the index of exporting table from HTML file.

Worksheet Features:

- Create and access Worksheet.

- Move a Worksheet to a specific location in the Workbook.

- Set the name of Worksheet.

- Freeze Panes.

- Page Breaks and Settings.

- Set Headers and Footers.

- Adjust Row Height according to your desire.

- Adjust Column Width as required.

- Insert or Delete Rows and Columns.

- Access any Cell in the worksheet.

- Add data to desired Cells at runtime.

- Retrieve data from cells according to their data types.

- Address to Cell Range.

Formatting Features:

- Apply different Styles on the Cells.

- Copy Styles.

- Apply Number Format Settings for the Cells.

- Format Cell as a Date.

- Custom Formatting of the Cells.

- Set Text Alignment.

- Set Text Rotation and Direction in the Cells.

- Merge multiple Cells into single one.

- Unmerge the Cells.

- Apply different kinds of Font Settings for the Cells.

- Apply different Colors to Cells, Fonts, Gridlines, Fill to Drawings.

- Set Rich Text in a Single Cell.

- Apply different Border Settings on Cells.

- Apply different Background Patterns on Cells.

- Apply Format Settings on a Row or Column.

Advance Features:

- Supports Formula Calculations using robust Formula Calculation Engine.

- Create and change Hyperlink (URL, FilePath, email etc.).

- Preservation of different kinds of Charts.

- Supporting of Custom Charts.

- Preservation of Pictures.

- Add Pictures to Worksheets at runtime.

For more information about the component please visit the product page:
http://www.eleriumsoft.com/Excel_NET/HTML2Excel

If you have any questions or concerns about component, let us know:
http://eleriumsoft.com/Company/Contact.aspx

Excel Reader (XSL,XLSX,CSV) in .NET, C#, VB.NET, ASP.NET

EleriumSoft — Mon, 28 Jan 2013 04:37:14 -0700

Elerium Excel .NET Reader component, new release 2.4 has been introduced by Elerium Software.

Elerium Excel .NET Reader is a professional .Net component that allows developers to read Excel spreadsheet files XLS, XLSX, CSV from .NET applications or ASP.NET websites (C#, VB.NET). It works really fast and can process the dozens of files in seconds. Elerium Excel. NET Reader allows to get access to the cell range of all Excel Worksheets including styles, fonts, borders etc. Also it has methods to export data from Excel to Database (see C# VB.NET examples).

Elerium Excel .NET Reader is compatible with .NET 2.0 and higher and does not require any additional software. The component is completely managed and available in projects either C#, VB.NET or ASP.NET.

Elerium Excel .NET Reader key features:

- Various cell data types (numbers, strings, dates, floating point etc.)

- Multiple worksheets.

- Number formatting (number, currency, date, time, fraction etc.)

- Font formatting (size, color, font type, italic and strikeout properties, boldness, underlining, subscript and superscript).

- Cell alignment (vertical, horizontal).

- Rich Text for worksheet cells.

- Cell Background and Fill Pattern.

- Cell borders (color, style).

- Merged cells.

- Opens Excel files protected by PASSWORD.

- Reads protected worksheets.

- Reads hidden Excel Worksheets / Rows / Columns.

- Export to DataTable.

- CSV files (delimited with comma, tab, semicolon or any other separator).

- Reading files XLSX, XLS.

- ASP.NET online Web Demo (C# source code is available in installation package).

- Open Excel files XLSX,XLS,CSV online.

Extra Excel Options:

- Right-to-left text(Arabic)

- Defined cell names

- Excel worksheet headers and footers

- Panes (vertical, horisantal, both)

- Multithreading support

For more information about the component please visit the product page:
http://www.eleriumsoft.com/Excel_NET/ExcelReader

If you have any questions or concerns about component, let us know:
http://eleriumsoft.com/Company/Contact.aspx

Convert Excel to HTML in .NET

EleriumSoft — Tue, 22 Jan 2013 01:38:12 -0700

Elerium Excel to HTML .NET component, new release 2.4 has been introduced by Elerium Software.

Elerium Excel to HTML .NET is a high performance component enabling developer to convert Excel files (XLS, XLSX, CSV) to HTML document. The component can be implemented in C#, VB.NET or ASP.NET projects/websites. The PRO version of Elerium Excel to HTML .NET provides developers with the ability to read, write, and edit Excel files (XLS, XLSX, CSV) before converting.

Elerium Excel to HTML .NET is completely independent and does not depend on third-party libraries and Microsoft Office Automation.

Elerium Excel to HTML .NET key features:

Converting Features:

- Supported Excel files XLS, XLSX, CSV.

- Creating a strong copy of Excel spreadsheet as an HTML file.

- Preservation of formatting of source Excel spreadsheet.

- Choosing the index of Excel spreadsheet for export to HTML file.

Worksheet Features:
- Create and access Worksheet.

- Move a Worksheet to a specific location in the Workbook.

- Set the name of Worksheet.

- Freeze Panes.

- Page Breaks and Settings.

- Set Headers and Footers.

- Adjust Row Height according to your desire.

- Adjust Column Width as required.

- Insert or Delete Rows and Columns.

- Access any Cell in the worksheet.

- Add data to desired Cells at runtime.

- Retrieve data from cells according to their data types.

- Address to Cell Range.

Formatting Features:
- Apply different Styles on the Cells.

- Copy Styles.

- Apply Number Format Settings for the Cells.

- Format Cell as a Date.

- Custom Formatting of the Cells.

- Set Text Alignment.

- Set Text Rotation and Direction in the Cells.

- Merge multiple Cells into single one.

- Unmerge the Cells.

- Apply different kinds of Font Settings for the Cells.

- Apply different Colors to Cells, Fonts, Gridlines, Fill to Drawings.

- Set Rich Text in a Single Cell.

- Apply different Border Settings on Cells.

- Apply different Background Patterns on Cells.

- Apply Format Settings on a Row or Column.

Document Features:
- Open Excel files of different format types XLS, XLSX, CSV.

- Load and Save CSV files delimited with comma, tab, semicolon or any other separator.

- Find and Replace data in Workbook.

- Preserve Pictures and Charts of Excel file.

Advance Features:
- Supports Formula Calculations using robust Formula Calculation Engine.

- Create and change Hyperlink (URL, FilePath, email etc.)

- Preservation of different kinds of Charts.

- Supporting of Custom Charts.

- Preservation of Pictures.

- Add Pictures to Worksheets at runtime.

About Elerium Software

Elerium Software develops professional solutions for use in .NET projects (C#, VB.NET, ASP.NET) that aimed to read/write/convert different office/web documents and formats.
Our components are based on unique design and fast algorithms that allow to be independent from the third-party applications and libraries.

For more information about the component please visit the product page:
http://www.eleriumsoft.com/Excel_NET/Excel2HTML

If you have any questions or concerns about component, let us know:
http://eleriumsoft.com/Company/Contact.aspx

Convert HTML to PDF in .NET, C#, VB.NET, ASP.NET

EleriumSoft — Wed, 16 Jan 2013 00:12:59 -0700

Elerium HTML to PDF .NET component, new release 2.4 has been introduced by Elerium Software.

Elerium HTML to PDF .NET is a professional component that can be used in any type of .NET (C#, VB.NET) projects, either ASP.NET web sites or WinForms application. The component is able to convert HTML to PDF as a file or as a stream. Elerium HTML to PDF .NET offers full support for tables, styles, graphs, images, hyperlinks, fonts etc.

The component is based on .NET Framework and compatible with .NET 2.0 and higher. Elerium HTML to PDF .NET component is absolutely independent and does not require any additional components or libraries. The installation package contains C# and VB.NET samples for quick start. Developers can easily add the component to their projects and start to convert HTML to PDF.

Elerium HTML to PDF .NET key features

- Direction of conversion:

   -HTML / HTMLX to PDF

   -ASP / ASPX to PDF

   -URL to PDF

   -TXT to PDF

- HTML file can include formatting CSS styles that will be correctly converted to PDF.

- PDF compression to reduce PDF document sizes.

- Converts a Web Site URL and HTML to PDF.

- Methods allow to convert:

from: - File    to:    File

      - Url            Stream

      - Stream         Byte array

      - String         String

- Developed in 100% managed C# code and tested in ASP.NET web applications.

- Makes the best use of invalid or bad formed HTML file.

- Does not require installed Microsoft Office ® or Adobe Acrobat ®.

- Supports .NET 2.0 and higher.

About Elerium Software

Elerium Software develops professional solutions for use in .NET projects (C#, VB.NET, ASP.NET) that aimed to read/write/convert different office/web documents and formats.
Our components are based on unique design and fast algorithms that allow to be independent from the third-party applications and libraries.

We work closely with our customers that help us to continually improve our products, making them more flexible and satisfying any user requirements.
The individual approach to each client and reasonable prices make our products one of the best on the market.

For more information about the component please visit the product page:
http://www.eleriumsoft.com/PDF_NET/HTML2PDF

If you have any questions or concerns about component, let us know:
http://eleriumsoft.com/Company/Contact.aspx

Word Reader of DOC/DOCX/RTF in .NET, C#, VB.NET, ASP.NET

EleriumSoft — Tue, 15 Jan 2013 01:57:36 -0700

Elerium Word .NET Reader component, new release 2.4 has been introduced by Elerium Software.

Elerium Word. NET Reader is a handy tool for C#, VB.NET and ASP.NET developers that allows to easily and effectively read Word documents (DOC, DOCX, RTF), without the need to install additional applications and Microsoft Word. The Word Reader can be easily implemented in C#, VB.NET or ASP.NET projects/websites. The installation package of the Word Reader contains C# and VB.NET samples for quick start.

Elerium Word .NET Reader component is compatible with .NET 2.0 and higher and does not require any additional software. The component is completely managed and available in projects either C# VB.NET or ASP.NET.

Elerium Word. NET Reader key features:

Word. NET Reader has an intuitive document object model, which allows a developer to read DOC, DOCX or RTF document, get document content and formatting styles, fonts, colors, borders etc. (see C# VB.NET examples)
- Reads Word Documents DOC, DOCX, RTF.
- Getting DOM Tree of the document (C# VB.NET examples are presented).
- Paragraph formatting.
- Alignment, Margins, Line Spacing, Shadings, Tab Stops etc.
- Sections and Properties.
- Header and Footer.
- Page Settings.
- Getting Paragraph, Text, Lists, Hyperlinks.
- Operate with Table, Rows, Cells, Embedded Tables.
- List Properties.
- List Id, Level, StartAt.
- List Bullet/Number Styles.
- Text formatting.
- Text Font Name, Color, Size.
- Background color, Hyperlink, Footnote, Borders etc.
- Style Sheet, predefined and user Styles.
- Columns.
- Column Properties: Count, Widths and Spaces.
- Table Content and Properties.
- Collection of Rows and Cells.
- Width, Height, Borders, Shading, Span Rows/Columns etc.

About Elerium Software

Elerium Software develops professional solutions for use in .NET projects (C#, VB.NET, ASP.NET) that aimed to read/write/convert different office/web documents and formats.
Our components are based on unique design and fast algorithms that allow to be independent from the third-party applications and libraries.

We work closely with our customers that help us to continually improve our products, making them more flexible and satisfying any user requirements.
The individual approach to each client and reasonable prices make our products one of the best on the market.

For more information about the component please visit the product page:
http://www.eleriumsoft.com/Word_NET/WordReader

If you have any questions or concerns about component, let us know:
http://eleriumsoft.com/Company/Contact.aspx

Read/Write Excel XLS XLSX CSV in .NET, C#, VB.NET, ASP.NET.

EleriumSoft — Tue, 15 Jan 2013 01:51:08 -0700

Elerium Excel .NET component, new release 2.4 has been introduced by Elerium Software.

Elerium Excel .NET is a professional .NET component that can be used in any type of .NET (C#, VB.NET) projects. Developers can easily add functionality of create/read/write Excel files (XLS, XLSX, CSV) to WinForms / ASP.NET applications. Elerium Excel .NET has rich set of methods to edit the cells of Excel Worksheets either XLS XLSX or CSV files. Code Examples (C#, VB.NET) show how to adjust cell styles, fonts, borders etc.

Elerium Excel .NET is a standalone component that compatible with .NET 2.0 and higher and does not depend on third-party libraries and Microsoft Office Automation.

Elerium Excel .NET key features:

- Excel files XLSX, XLS, CSV.
- Methods for Reading / Writing Excel files (see C# VB.NET examples).
- Various cell data types (numbers, strings, dates, floating point etc.)
- Multiple Excel worksheets.
- Number formatting (number,currency, date, time, fraction etc.)
- Font formatting (size, color, font type, italic and strikeout properties, boldness, underlining, subscript and superscript).
- Cell alignment (vertical, horizontal).
- Excel spreadsheet Row height and Column width.
- Cell styles (rotation, indentation, text wrapping).
- Cell borders (color, style).
- Cell Background and Fill Pattern.
- Merged Cells in Excel spreadsheet.
- Rich Text for excel cells.
- Excel Encryption / Decryption.
- PASSWORD protection of Excel file.
- Worksheet protection.
- Hiding / Showing an excel worksheet.
- The ability to hide and unhide Row/Column.
- Calculation of math expressions.
- Excel Formulas.
- Unicode support, international characters.
- Right-to-left text(Arabic).
- Defined cell names.
- Excel worksheet Headers/Footers.
- Excel Panes (vertical, horizontal, both).
- Multithreading support.
- Export data between Excel and DataTable.
- Template support (create new workbooks using existing workbook as a template).

About Elerium Software

Elerium Software develops professional solutions for use in .NET projects (C#, VB.NET, ASP.NET) that aimed to read/write/convert different office/web documents and formats.
Our components are based on unique design and fast algorithms that allow to be independent from the third-party applications and libraries.

We work closely with our customers that help us to continually improve our products, making them more flexible and satisfying any user requirements.
The individual approach to each client and reasonable prices make our products one of the best on the market.

For more information about the component please visit the product page:
http://www.eleriumsoft.com/Excel_NET/ExcelNET

If you have any questions or concerns about component, let us know:
http://eleriumsoft.com/Company/Contact.aspx