C # export Excel,

C # export Excel,

C # For Beginners, because the project requires Excel operations. I searched the internet and found a lot of materials. However, the writing is too redundant, and it is a big headache to cut off the code,

Summary: I forgot to add the deficiencies.

Considering compatibility issues, for office2003 operations

--- Required library Microsoft. Office. Interop. Excel. dll (Attachment)

---- Classes used in the code

C # code  

1. Using System;
2. Using System. Drawing;
3. Using System. Collections;
4. Using System. ComponentModel;
6. Using System. Data;
7. Using System. IO;
8. Using System. Text;
9. Using System. Windows;
10. Using System. Reflection;
11. Using System. Runtime. InteropServices;
12. Using Excel = Microsoft. Office. Interop. Excel;

 

Create a new Excel File

 

(Code snippet 1)

C # code  

1. Object missing = Missing. Value;
3. Excel. Application m_objExcel = new Excel. Application ();
4. Excel. Workbooks m_objWorkBooks = m_objExcel.Workbooks;
6. Excel. Workbook m_objWorkBook = m_objWorkBooks.Add (true );
7. Excel. Sheets m_objWorkSheets = m_objWorkBook.Sheets ;;
8. Excel. Worksheet m_objWorkSheet = (Excel. Worksheet) m_objWorkSheets [1];
9. Try
10. {
11. M_objExcel.Save ("f: 129.xls ");
12. }
13. Catch (Exception e)
14. {
16. }
17. Finally {
18. M_objWorkBooks.Close ();
19. M_objExcel.Quit ();
20. }

------ Operate the cell to navigate by horizontal and vertical coordinates

Add the following code before try {} catch () {}

(Code snippet 2)

C # code  

1. M_objExcel.Cells [1, 1] = "Building Energy evaluation and calculation report"; // value assignment in the first column of the first line

------ Merge cells (Add the following code before try {} catch)

 

C # code  

1. M_objExcel.Cells [1, 1] = "Building Energy conservation evaluation and calculation report ";
2. Excel. Range range = m_objExcel.get_Range (m_objExcel.Cells [1, 1], m_objExcel.Cells [1, 10]);
3. Range. Merge (Type. Missing); // Merge Cells

--- Operation font size, color, cell background color. Border color (Add the following code before try {} catch)

 

 

 

Java code  

1. M_objExcel.Cells [1, 1] = "Building Energy conservation evaluation and calculation report ";
2. Excel. Range range = m_objExcel.get_Range (m_objExcel.Cells [1, 1], m_objExcel.Cells [1, 10]);
3. Range. Merge (Type. Missing); // Merge Cells
4. Range. Font. Size = 25; // Font Size
5. Range. HorizontalAlignment = Excel. Constants. xlCenter; // align
6. Range. Font. Bold = 17; // Font size
7. // Range. Borders. LineStyle = Excel. XlLineStyle. xlContinuous; // border
8. // Range. Borders. Color = ColorTranslator. ToOle (Color. Red); // border Color
10. // Range. Interior. ColorIndex = 34; background color

 

 

• Dll.rar (166.8 KB)

In the C language, what is the symbol (->) and how to use it?

This is a symbol in the struct pointer. Write a program to explain it, for example:
# Include <stdio. h>
Struct STU // define a struct
{
Int num;
} Stu;
Int main ()
{
Struct STU * p; // defines a struct pointer.
P = stu; // p points to the struct variable stu.
Stu. num = 100; // attaches an initial value to the struct member num.
Printf ("% d", p-> num); // output the num value in stu
Return;
}
As you can see, the-> method is to reference the variable in the struct !!
Format: p-> struct member (such as p-> num)
The function is equivalent to stu. num or (* p). num.
I don't know. You don't understand, and don't understand call me. O (∩ _ ∩) O ~
Hope to adopt it.

In the C language, what is the symbol (->) and how to use it?

This is a symbol in the struct pointer. Write a program to explain it, for example:
# Include <stdio. h>
Struct STU // define a struct
{
Int num;
} Stu;
Int main ()
{
Struct STU * p; // defines a struct pointer.
P = stu; // p points to the struct variable stu.
Stu. num = 100; // attaches an initial value to the struct member num.
Printf ("% d", p-> num); // output the num value in stu
Return;
}
As you can see, the-> method is to reference the variable in the struct !!
Format: p-> struct member (such as p-> num)
The function is equivalent to stu. num or (* p). num.
I don't know. You don't understand, and don't understand call me. O (∩ _ ∩) O ~
Hope to adopt it.