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 = 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 = 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)