In MS Excel, we can create charts according to imported data. Actually, a chart likes an image and it can present data more intuitively. Excel provides several chart styles. One of the most frequently used charts is bar chart.

Bar chart is used to show comparison between items. The items are presented by vertical or horizontal bars. There are three elements to draw a bar chart, group number, group width and group limit.

In this post, I want to introduce the method to export data to Exce...

Access

Access, developed by Microsoft, one of Office applications, is a relational database management system (RDBMS).

Access offers seven things to build objects of database system. They are table, query, form, report, page, macro and template. Also, in order to standardize operation to save, query data, design interface and generate report, it provides users with various guides, builders and templates. Access is very convenient and easy to use because users don’t need to write code ...

Traditionally, watermark is formed when marking paper. It is not printed on the face of paper but in the middle. Therefore, it can present others from forging the paper which watermark has been added.

Gradually, watermark is applied for electronic documents. As is known, along with sharp development of internet, people often share useful material with Word or other documents online. However, some people may steal the documents. So, the original owners need to take measures to protect the...

Generally speaking, we may set formatting for a Word document to make it be more readable, especially font and color. For example, if there are several sections in the document, we may set different font or color for the section title. Sometimes, in order to highlight key words, we can set it with bigger font size or bright color. With well formatting, readers can learn more clearly about the idea of each part and the layout will be more appealed after printing.

How to set Word font and ...

Tiff is one kind of image format to save photo and art pictures. This format is flexible and adaptable. It can deal with several images and data in one file through “tag” in file header. Tag can indicate size of image and define how to arrange image data.

Actually, Tiff is the most complicated bitmap file format. One tiff image can occupy large space because it saves lots of contents. At present, it is widely applied to saving and changing images which has high picture quality.

So...

Mail Merge is very useful for generating template file in bulk, such as transcript, questionnaire, invoice and so on.

How to use mail merge in MS Office? Firstly, we need to create a template, which is used to generate frame and main contents of file. Then, we need to have data source. Generally speaking, we can export data from database or create a new Excel file with essential data information. Secondly, set mail merge type and link to data source. Finally, generate mail merge files an...

Microsoft Excel is an essential tool for office workers. It is very powerful on managing and calculating data. For example, if there are some data about sales information, we can use Excel to calculate average sales and total sales within one quarter. Also, it is convenient for printing if the data in Excel is well formatted.

Actually, if we want to display and operate data, we must import data to Excelfirstly. Where can we get the data? Sometimes, we can type data in Excel, but most of ...

We can find that the blog post with images is more attractive than plain text post. Therefore, people may insert some appropriate images in their posts or documents. Generally speaking, the images are related to contents. For example, if your document has mentioned a series of data, you can insert one image, like analysis chart to make reader be clearer about the data information.

Although we can display data information with chart, sometimes we may need to insert image which shows data ...

It is necessary to have some images in one document to show information more intuitively. Also, the beautiful images with words are more appealed to readers than text only.

Generally speaking, we can insert images in documents directly. And then adjust images’ size or direction according to the requirements. But sometimes, there are not appropriate images for contents so that we may need to draw one. For example, if there must be a chart in a document, we should draw one based on the d...

Template is offered to people who don’t know how to set format for one document or table. Users can fill with contents according to the template or modify it to get better format.

Generally speaking, one template document may include font style and color, spacing and alignment. If the document has several pages, the template may include page number, header and footer of each page.

PDF is one of the most frequently used formats. Therefore, I want to talk something about PDF template,...

At present, more and more e-books and e-magazines are created with PDF because people can insert beautiful images, flash or some other attractive elements in PDF, which make the e-books or e-magazines be more appealed for readers.

Besides inserting images or flash, sometimes, people may draw shapes or tables in PDF document according to the document contents. For example, if one paragraph has shown much data information, the author may create a data table to make reader learn clearly abo...

As is known, one book includes cover, back cover, category and contents. Therefore, if we want to create an electronic book, the above elements are needed to be contained. And firstly we should learn how to paginate.

Generally speaking, the electronic books are PDF books. So, in this article, I want to talk how to create PDF pagination.

It is common to use Adobe Acrobat to edit the PDF book. Open it and count pages. Then click advanced. Select document Operation and then choose Pagina...

Generally speaking, people may protect one important document or file by giving a password for it, especially some important or secret files. For office workers, they often record important data in Excel. Therefore, they need to know clearly about how to protect Excel file.

There are several methods to protect Excel file. We can lock the whole worksheet to prevent others from opening or editing it. Also, we can just protect specified Excel rangeor cells.

Firstly, I want to talk somethi...

If a word document has many pages, people may add header or footer to show the page number. Sometimes, the header or footer may be symbols which are the topic of the document talk about or the owner of the document.

It is simple to insert add header and footer. Open a Word document. Then click Header and footer on File menu. Type the text or use the format Word provides.

Then, I want to show something about how to add Word header and footer with C#.  

Using the code:

#region add W...

In PDF, we can insert image to make the contents be colorful and attractive. And it is possible that one image is one PDF document, especially in PDF form. Therefore, we may need to convert image to PDF sometimes.

Except Adobe Acrobat, which is the professional tool to manipulate PDF, there are lots of converters which specialize in converting image to PDF online. The tools are easy to use and the developers will show the guide about how to use the converters. Choose the image you want to...

Introduction

We often format an Excel worksheet to make it be convenient for reading. Usually, we complete Excel formatting through setting cells styles. For example, if the text in one cell is the title of one column or row, we may set its size to be larger than other cells. Also, we may give a color for text in one cell to show that i...

What is PDF

PDF (Portable Document Format) is one kind of electronic document format. PDF is the ideal document format to publish electronic document and deliver digital information on internet for it has nothing to do with operation system. PDF file format can package font, format, color and image in a file. Also, it can include hyperl...

Introduction

In an Excel Worksheet, we may import a great deal of data. Sometimes, we need to calculate the data to get another numbers we need. Formula is the mail tool to calculate...

Basic Knowledge about XML

When talking about XML, we may think of HTML. Actually, XML is similar to HTML are tag-based languages. The difference between XML and HTML is that the tags which XML uses are not predefined. If we want to create own tags within XML, we need to follow a few rules.

Firstly, only one root element is contained in XML document. The root element is often taken as document element and appears after the prolog section. Besides, all the XML elements should contain end ...

We may set one password for a file if we don't want others to open it, especially the secrete document. Generally speaking, we are used to writing articles or papers in Microsoft Word. And we may need to encrypt Word document if it is very important for security. Also, when we operate Word by using C#/VB.NET, to encrypt Word document is ...

In order to show a good-looking Excel file or emphasize one part of Excel, different font styles for cells, which include characters, are needed. Generally speaking, the frequently used styles contain font type, size and color.

Also, developers need to set Excel Font Style in C# during the process to operate Excel, the Excel file is com...

When I use Microsoft Word to write an article or paper, I would like to set the font style, for example, setting characters size, color and so on. Generally, I will make the title be larger than other part or give the keywords a specified color to make it be obvious. As the same, we also need to set Excel font for the formatted Excel file ...

Sometimes we need to control c# .net excel class in our program in order to make the Microsoft Office c# excel interop assembly working properly. The application program must process a batch of spreadsheets and deal with excel worksheets. Here I would like to offer some tips on c# excel interop performance and introduce you some fundamen...

Excel object plays an important role when we operate Excel in .Net for we often need to use Excel object in .Net to realize Excel automation. There are four Excel object classes frequently used, Application, Workbook, Worksheet and Range. I want to discuss something about Worksheet of Excel object.

As one class of Excel object, Workshee...

We save an Excel file after creating it. We have many methods to save an Excel file, which is often called workbook. Generally, workbook will be saved in the current folder with the name it was given when it was created if we don’t save it by specifying a path. Also, we can save a copy of the workbook without modifying the open workbook in memory.

The first way is to save a workbook without changing the path associated with a document-level customization.

Call the Save method of the This...

We save an Excel file after creating it. We have many methods to save an Excel file, which is often called workbook. Generally, workbook will be saved in the current folder with the name it was given when it was created if we don’t save it by specifying a path. Also, we can save a copy of the workbook without modifying the open workbook in memory.

The first way is to save a workbook without changing the path associated with a document-level customization.

Call the Save method of the This...