Programming

Showing category "Excel" (Show all posts)

The Method to Import Data to Excel from DataTable and Export Excel Data

Posted by SunnyWhite on Friday, September 16, 2011, In : Excel 

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 ...


Continue reading ...
 

Method Write and Read Excel Image with C#

Posted by SunnyWhite on Monday, September 5, 2011, In : Excel 

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 ...


Continue reading ...
 

How to Protect Excel by Using MS and C#

Posted by SunnyWhite on Wednesday, June 15, 2011, In : Excel 

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...


Continue reading ...
 

How to Set Excel Text Alignment

Posted by SunnyWhite on Friday, March 11, 2011, In : Excel 

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...


Continue reading ...
 

How to Add a Formula for Excel

Posted by SunnyWhite on Tuesday, February 15, 2011, In : Excel 

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...


Continue reading ...
 

How to Use C# to Set Excel Font

Posted by SunnyWhite on Wednesday, January 5, 2011, In : Excel 

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...


Continue reading ...
 

Method to Use C#.Net to Set Excel Font

Posted by SunnyWhite on Tuesday, January 4, 2011, In : Excel 

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 ...


Continue reading ...
 

Using C# Excel Interop Class

Posted by SunnyWhite on Tuesday, December 28, 2010, In : Excel 

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...


Continue reading ...
 

Excel Worksheet Object in .Net

Posted by SunnyWhite on Monday, December 27, 2010, In : Excel 

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...


Continue reading ...
 

C# .Net Used in Excel

Posted by SunnyWhite on Wednesday, December 22, 2010, In : Excel 
We often use Excel during working to record or deal with data for it has a powerful function to calculate data. Usually, we export or update data to Excel manually. It will be a big project if there is thousand of information needed to deal with. VBA macro helps users to realize Excel automation by using object and offers kinds a large number of methods and properties of each object class to control Excel. However, it is also a trouble when we want to get data from outside source even if usin...

Continue reading ...
 
 

About Me


Recent Posts