Tuesday, 30 October 2012 02:03

Payment Details

Payment method we accept

We accept all the online payments supported by Paypal or 2Checkout. And we also accept the other payments. Such as Bank/Wire transfer, PO, Check/Money Order etc.

Online Payment Process

Paypal

  • Choose your item and click the button "Add to cart."
  • Enter the coupon code if you have.
  • In the "Please select Payment Method", Choose Paypal.
  • Proceed the payment by using Paypal.

2Checkout

  • Choose your item and click the button "Add to cart."
  • In the "Please select Payment Method", Choose 2Checkout.
  • Proceed the payment by using 2Checkout.
  • Enter the coupon code if you have.

Purchase Order payment Process

  • Customer sends inquiry and insists to purchase via Purchase Order
  • We send the product quotation sheet
  • Customer confirms and send purchase order sheet
  • We confirm and sends customer Bank information
  • Customer Pay via Bank Transfer
  • We check payment and send license file once we confirm the payment
  • We Send Invoice to customer

Purchase Security

It is 100% secure to do business with us. The Payment platform we utilize is Paypal and 2Checkout. They are the most trusted global online payment system in the world. The order of your private information, such as credit card number, addresses and so on will never be disclosed without your specific permission. Over the years, there have not been one single complaint so far against the account security.

How and When does the ordered software been sent out

Once you complete the online order, our support team will send the license file to your registered email address via email directly; usually it is less than 18 hours.

Regular file we provide

We provide the regular file including quotation sheet, sales contract and invoice to our customers. Please contact our sales team according to your own requirements.

Refund Policy

We hold the 14-day money back guarantee if our products cannot work normally with error or bug. But sometimes the software doesn't work well due to improper operation. We strongly suggest you contact our support team for help first with detailed problem description. In addition, we do not accept gratuitous refund and the purchase with discount.

Tuesday, 30 October 2012 01:33

How to Get Discount

Overview

We always very thank for long-term support from our customers and would like consider more for customer to get our product with a more acceptable price. Therefore, we launch a discount system for offering customers the best value for money.

No Discount After Sale

We are not able to provide discounts once the order finished due to the cost involved to refund the partial payment. It is very important to contact our sales team(sales@e-iceblue.com) for coupon code before purchasing our products.

Purchase Quantity

You will get 12% off discount automatically to buy 2+ same licenses (no license type limit) of any products in our store.

Small Business

You can pay by installment if you are a small business company. At the beginning, pay 60% of the price to get a half-year limited license. Before or until your license expires, you can pay the other 40% to get another half-year limited license.

Competitive Discount

We offer 30% discount for customers who would like to switch to use E-iceblue products from other component vendors. Also, we are very appreciated if you share your views or opinions to help us improve our products.
For getting the competitive discount, you need to follow the following principles.

  • It is not available to or through resellers.
  • Just one time for one address or company.
  • We must verify if you have used the products of our competitors before, so please share with us the invoice or any other document that proves you were/are using a similar product.
  • We will ask for reasons why you would like to use our products rather than your current products.

For applying the competitive discount, you need to send a request to our sales team. Please show the following points in your post:

  • The product you are using right now
  • The reason you would like to have a change
  • The proof you purchase the products from our competitors.

Our staff will send you the coupon code after reviewing and approving your request.

Share your Story with others via Video about using our products

If you have tried our product and found it useful, you are welcomed to make a video by sharing your reviews or steps by using our product. Then send it to sales@e-iceblue.com for us to review it. We will offer you a competitive discount for purchasing our product.

For More Discount

  • Certain Discount-Purchase through reseller in your country
  • 5% to 8% Discount-Write and publish review of our products on your website or professional reviews website
  • 2% to 5% discount-Share our company link on your website or facebook

Discount for Non-Profit Organizations

If you are non-profit, educational organizations or government agency, please send a discount request to our sales team. Please provide all of your organization details in the request, including organization name, local address, website, Email address etc. After checking your request, our staff will send you the coupon code.
If you still have questions, please don’t hesitate to contact our sales team. We will reply you within 1 business day.

Monday, 29 October 2012 01:11

Create Barcode in Word in C#, VB.NET

Barcode is formed by several blanks and black stripes with a specified order. It presents the brief information of one product, including manufacturer, product name, category, price etc. At present, barcode is widely used in commodity circulation. Also, people can create barcode in Word and print.

Spire.Doc for .NET, a stand-alone professional .NET Word component, enables users to create barcode in Word by using C#, VB.NET. So, this guide will show you the method about how to create via Spire.Doc for .NET.

At first, you need to install barcode font on your system. Then, add barcode text through invoking p.AppendText(string) method and then set text format properties for it, such as FontName, FontSize, TextColor etc. After running, we can get result as following screenshot.

Create Word Barcode

Download and install Spire.Doc for .NET and then use the following code to create barcode in Word.

[C#]
using System.Drawing;
using Spire.Doc;
using Spire.Doc.Documents;
using Spire.Doc.Fields;

namespace WordBarcode
{
    class BarCode
    {
        static void Main(string[] args)
        {
            //Create Document
            Document document = new Document();
            Paragraph p = document.AddSection().AddParagraph();

            //Add Barcode and Set Format
            TextRange txtRang = p.AppendText("H63TWX11072");
            txtRang.CharacterFormat.FontName = "C39HrP60DlTt";
            txtRang.CharacterFormat.FontSize = 80;
            txtRang.CharacterFormat.TextColor = Color.SeaGreen;

            //Save and Launch
            document.SaveToFile("barcode.docx", FileFormat.Docx);
            System.Diagnostics.Process.Start("barcode.docx");
        }
    }
}
[VB.NET]
Imports System.Drawing
Imports Spire.Doc
Imports Spire.Doc.Documents
Imports Spire.Doc.Fields

Namespace WordBarcode
    Friend Class BarCode
        Shared Sub Main(ByVal args() As String)
            'Create Document
            Dim document As New Document()
            Dim p As Paragraph = document.AddSection().AddParagraph()

            'Add Barcode and Set Format
            Dim txtRang As TextRange = p.AppendText("H63TWX11072")
            txtRang.CharacterFormat.FontName = "C39HrP60DlTt"
            txtRang.CharacterFormat.FontSize = 80
            txtRang.CharacterFormat.TextColor = Color.SeaGreen

            'Save and Launch
            document.SaveToFile("barcode.docx", FileFormat.Docx)
            System.Diagnostics.Process.Start("barcode.docx")
        End Sub
    End Class
End Namespace

Spire.Doc is a Microsoft Word component, which enables users to perform a wide range of Word document processing tasks directly, such as generate, read, write and modify Word document in WPF, .NET and Silverlight.

Thursday, 25 October 2012 02:09

Renew Subscription

Why to Renew the Subscription

The One Year Subscription only guarantees your one year products update and prior technology/sales support. When the subscription expires, any latest products release or hotfix can’t be enjoyed any more.

When to Renew the Subscription

Generally, you can renew your subscription anytime you want. However we usually send an email to the register email address to remind you to renew your subscription before your subscription goes expired. To renew an existed subscription only costs 60% of the current price, while to re-activate an expired subscription costs 75% of the current product price.

How to Renew the Subscription

You just need to log in to our website with the username with which you bought the product , place a new order of the subscription which needs renewal, apply the coupon code and finish the payment.

If you bought the product from our resellers, you can contact them to renew it or purchase a new subscription.

If you have any problems or any changes, please contact our sales department and we will help you.

Monday, 22 October 2012 02:51

Insert Background Image in WPF

Excel Background Image, one kind of page layout setting, is used to beautify files. Actually, with a beautiful background image, the Excel file will be more attractive to readers. Also, different from inserting image in Excel directly, background image will not cover data information. It means that all the data in Excel can be displayed even though background image is inserted.

Spire.XLS for WPF, a professional component to operate Excel files in WPF applications, enables users to insert background image in Excel. This guide will focus on how to realize this function by using C#, VB.NET.

Assign value for BackgroundImage property of PageSetup in Worksheet class to insert background image. Because the type of BackgroundImage is Bitmap, so the assigned value must be bitmap image. The following screenshot shows result after inserting background image.

Insert Excel Background Image

Download and install Spire.XLS for WPF. Then add a button in MainWindow. Double click the button to use the following code to insert background image in Excel.

[C#]
         Bitmap bm = new Bitmap(Image.FromFile(@"E:\Work\Documents\SampleImage\Flower.jpg"));
            sheet.PageSetup.BackgoundImage = bm;
[VB.NET]
         Dim bm As New Bitmap(Image.FromFile("E:\Work\Documents\SampleImage\Flower.jpg"))
        sheet.PageSetup.BackgoundImage = bm

Spire.XLS allows user to operate Excel document directly such as save to stream, save as web response, copy, lock/unlock worksheet, set up workbook properties, etc. As a professional WPF/.NET/Silverlight Excel component, it owns the ability of inserting content into Excel document, formatting cells and converting Excel documents to popular office file formats. Spire.XLS for WPF supports Excel 97-2003, Excel 2007 and Excel 2010.

Monday, 15 October 2012 07:24

Convert RTF to HTML in WPF

This section will show you a detail solution to easily convert RTF to HTML in your WPF application via a .NET Word component. Only two lines of core code in total will be used to realize your RTF to HTML task in this solution.

Spire.Doc for WPF, as a professional MS Word component on WPF, enables you to accomplish RTF to HTML task through following two methods: Document.LoadFromFile(string fileName, FileFormat fileFormat) called to load your RTF file from system and Document. SaveToFile(string ilename, FileFormat fileFormat) is used to save the RTF file as HTML.

Now, you can download Spire.Doc for WPF and then, view the effect of RTF to HTML task as below picture:

RTF to HTML

Sample Code:

[C#]
using Spire.Doc;
using Spire.Doc.Documents;

namespace wpfrtftohtml
{
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            //Load RTF file
            Document document = new Document();
            document.LoadFromFile(@"..\wpfrtftohtml.rtf", FileFormat.Rtf);
            //Convert rtf to html
            document.SaveToFile("rtftohtml.html", FileFormat.Html);
        }
    }
}
[VB.NET]
Imports Spire.Doc
Imports Spire.Doc.Documents

Namespace wpfrtftohtml
    
    Public Class MainWindow
        Inherits Window
        Public Sub New()
            MyBase.New
            InitializeComponent
        End Sub
        
        Private Sub button1_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
            'Load RTF file
            Dim document As Document = New Document
            document.LoadFromFile("..\wpfrtftohtml.rtf", FileFormat.Rtf)
            'Convert rtf to html
            document.SaveToFile("rtftohtml.html", FileFormat.Html)
        End Sub
    End Class
End Namespace
Monday, 08 October 2012 05:33

Convert CSV to Excel in C#, VB.NET

This section will show you a very simple solution to quickly convert CSV to Excel(xls/xlsx) with C#, VB.NET. The whole CSV to Excel task can be realized by only three lines' of key code via a .NET Excel component.

Spire.XLS for .NET, as a professional .NET Excel component built from C#, VB.NET, enables you to mainly convert CSV to Excel by calling two methods: One method is Spire.Xls.Workbook.LoadFromFile(string fileName, string separator, int row, int column) which is used to load CSV file from system. The other is Workbook. SaveToFile(string fileName, ExcelVersion version) to save the CSV file just loaded as Excel. In the solution, Sheet1 is named to be "csv to excel" by setting the Property: Spire.Xls.Worksheet.Name. Besides, Excel background color is added in the target Excel file by Worksheet.Range[].Style.Color.

Before displaying the whole code, please download Spire.XLS for .NET and view the target Excel file as below picture:

CSV to Excel

[C#]
using Spire.Xls;

namespace csvtoxls
{
    class Program
    {
        static void Main(string[] args)
        {
         Workbook workbook = new Workbook();
         workbook.LoadFromFile(@"D:\michelle\my file\csv2xls.csv", ",", 1, 1);
         Worksheet sheet = workbook.Worksheets[0];
         sheet.Name = "csv to excel";
         //set the backgroundcolor=LightBlue of Range["A1:E1"]
         sheet.Range["A1:E1"].Style.Color = Color.Chocolate;
         //set the backgroundcolor=LightBlue of Range["A2:E6"]
         sheet.Range["A2:E6"].Style.Color = Color.SpringGreen;
         //set the backgroundcolor=Silver of Range["A7:E12"]
         sheet.Range["A7:E12"].Style.Color = Color.SkyBlue;
         //set the backgroundcolor=Silver of Range["A13:E19"]
         sheet.Range["A13:E19"].Style.Color = Color.Yellow;
         workbook.SaveToFile("result.xls", ExcelVersion.Version97to2003);        
        }
    }
}
[VB.NET]
Imports Spire.Xls

Namespace csvtoxls
    
    Class Program
        
        Private Shared Sub Main(ByVal args() As String)
            Dim workbook As Workbook = New Workbook
            workbook.LoadFromFile("D:\michelle\my file\csv2xls.csv", ",", 1, 1)
            Dim sheet As Worksheet = workbook.Worksheets(0)
            sheet.Name = "csv to excel"
            'set the backgroundcolor=LightBlue of Range["A1:E1"]
            sheet.Range("A1:E1").Style.Color = Color.Chocolate
            'set the backgroundcolor=LightBlue of Range["A2:E6"]
            sheet.Range("A2:E6").Style.Color = Color.SpringGreen
            'set the backgroundcolor=Silver of Range["A7:E12"]
            sheet.Range("A7:E12").Style.Color = Color.SkyBlue
            'set the backgroundcolor=Silver of Range["A13:E19"]
            sheet.Range("A13:E19").Style.Color = Color.Yellow
            workbook.SaveToFile("result.xls", ExcelVersion.Version97to2003)
        End Sub
    End Class
End Namespace
Friday, 21 September 2012 05:34

Freeze Excel Panes in C#, VB.NET

Excel Freeze Pane allows users to freeze row or column to keep one area always visible when scrolling. It is usual to freeze top row or left column. Also, users can freeze specified rows or columns in one area. For example, we can freeze the first three rows which contain labels to keep them always visible when scrolling down to get other data information in worksheet.

Spire.XLS for .NET, a professional component to operate Excel files, enables uses to freeze panes in Excel. And this guide will show you how to freeze by using C#, VB.NET. Users can invoke sheet.FreezePanes(int rowIndex, int columnIndex) method to set freezing area. The following screenshot shows the result after freezing panes.

Freeze Excel Panes

Download and install Spire.XLS for .NET and use the following code to freeze panes.

Code Sample:

[C#]
using System;
using Spire.Xls;
using System.Drawing;

namespace FreezePane
{
    class Program
    {
        static void Main(string[] args)
        {
            //Load File
            Workbook workbook = new Workbook();
            workbook.LoadFromFile

(@"E:\Work\Documents\ExcelFiles\PartSalesInfo.xlsx");
            Worksheet sheet = workbook.Worksheets[0];

            //Freeze Top Row
            sheet.FreezePanes(2, 1);

            //Save and Launch
            workbook.SaveToFile("FreezePane.xlsx", ExcelVersion.Version2010);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}
[VB.NET]
Imports System
Imports Spire.Xls
Imports System.Drawing

Namespace FreezePane
    Friend Class Program
        Shared Sub Main(ByVal args() As String)
            'Load File
            Dim workbook As New Workbook()
            workbook.LoadFromFile

("E:\Work\Documents\ExcelFiles\PartSalesInfo.xlsx")
            Dim sheet As Worksheet = workbook.Worksheets(0)

            'Freeze Top Row
            sheet.FreezePanes(2, 1)

            'Save and Launch
            workbook.SaveToFile("FreezePane.xlsx", ExcelVersion.Version2010)
            System.Diagnostics.Process.Start(workbook.FileName)
        End Sub
    End Class
End Namespace

The above code is used to freeze top row, if you want to freeze the first column, please use this line of code: sheet.FreezePanes(1,2);

Spire.XLS is a professional Excel component which enables developers/programmers to fast generate, read, write and modify Excel document for .NET and Silverlight. It supports C#, VB.NET, ASP.NET, ASP.NET MVC and Silverlight.

Wednesday, 19 September 2012 01:15

Find and Highlight Data in Excel in C#, VB.NET

Find function in Excel enables developers/programmers to find appointed data in Excel worksheet, and highlight function makes the data founded more observably. Find and highlight function gives developers and programmers more convenience of analyzing the data. This section demonstrates a clear introduction of find and highlight data in Excel worksheet via a .NET Excel component with C#, VB.NET.

Spire.XLS for .NET, as a .NET Excel component, enables users to quickly and easily find and highlight data in excel file. By calling Worksheet class method: public CellRange[] FindAllNumber(double doubleValue, bool formulaValue), users can find a certain value in cell range and then, highlight the value by setting the style property CellRange.Style.Color.

Please download Spire.XLS for .NET and install it on your system, add Spire.XLS.dll as reference in the downloaded Bin folder thought the below path: "..\Spire.XLS\Bin\NET4.0\ Spire.XLS.dll". And then, preview the effect of find and highlight task as below picture:

Example:

Find and Highlight Excel Data

[C#]
using Spire.Xls;

namespace fandh
{
    class Program
    {
        static void Main(string[] args)
        {
            //load an excel file from system
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"D:\my file\FandH.xlsx", ExcelVersion.Version2010);

            //find and highlight excel data
            Worksheet sheet = workbook.Worksheets[0];
            foreach (CellRange range in sheet.FindAllNumber(1502,true))
            {
                range.Style.Color = Color.LawnGreen;
            }
            //save and launch the project
            workbook.SaveToFile("result.xlsx", ExcelVersion.Version2010);
            System.Diagnostics.Process.Start("result.xlsx");

        }
    }
}
[VB.NET]
Imports Spire.Xls

Namespace fandh
    
    Class Program
        
        Private Shared Sub Main(ByVal args() As String)
            'load an excel file from system
            Dim workbook As Workbook = New Workbook
            workbook.LoadFromFile("D:\my file\FandH.xlsx", ExcelVersion.Version2010)
            'find and highlight excel data
            Dim sheet As Worksheet = workbook.Worksheets(0)
            For Each range As CellRange In sheet.FindAllNumber(1502, true)
                range.Style.Color = Color.LawnGreen
            Next
            'save and launch the project
            workbook.SaveToFile("result.xlsx", ExcelVersion.Version2010)
            System.Diagnostics.Process.Start("result.xlsx")
        End Sub
    End Class
End Namespace
Thursday, 13 September 2012 09:21

Remove and Change Excel Comments in C#, VB.NET

This section will introduce a very simple solution to remove and change excel comment to better satisfy the need of deleting and modifying excel comment information. By using a .NET Excel component, the whole procedure can be realized by main two parts: remove excel comment and change excel comment.

Spire.XLS for .NET allows users to generate, read, write and modify Excel files without using MS Excel Automation. Using Spire.XLS for .NET, you can remove excel comment by calling the method:

Spire.Xls.Workbook.Worksheets[0].Comments[1].Remove();

Change excel comment by setting the Property:

Spire.Xls.Workbook.Worksheets[0].Comments[0]. Text= value;

Please view the original excel file which contains two excel comments as below picture:

Remove and Change Excel Comments

Now, please download Spire.XLS for .NET and see the key code of the task below:

Remove Excel Comment

[C#]
workbook.Worksheets[0].Comments[1].Remove()
[VB.NET]
workbook.Worksheets(0).Comments(1).Remove()

Change Excel Comment

[C#]
ExcelComment comment0 = workbook.Worksheets[0].Comments[0];
Comment0.Text = "The Sales Manager is Mishirna"
[VB.NET]
Dim comment0 As ExcelComment = workbook.Worksheets(0).Comments(0)
Comment0.Text = "The Sales Manager is Mishirna"

Friendly Reminder: workbook.Worksheets[0].Comments[0] means the first comment you insert in the first worksheet you created. So the first comment here may be not the first comment that you see in worksheet. In this Excel file, A8 is the first comment inserted in the worksheet, while A5 is the second comment.

After perform the code, please look at the effect of removing and changing excel comment task:

Remove and Change Excel Comments