The implementation code is as follows:
Using System;
Using System. Collections. Generic;
Using System. Text;
Using System. Windows. Forms;
// Introduce the office excel namespace
Using Excel = Microsoft. Office. Interop. Excel;
Using System. Reflection;
Using System. Data;
Using System. IO;
Using System. Diagnostics;
Using System. Collections;
Using System. Runtime. InteropServices;
Namespace TestLib
{
Public class ExcelOperation
{
Private DateTime beforeTime; // time before Excel start
Private DateTime afterTime; // time after Excel startup
Excel. Application myExcel = new Excel. Application ();
Excel. Workbook myBook;
Excel. Worksheet mySheet1;
Excel. Range range;
Excel. Range range1;
Excel. Range range2;
Excel. TextBox textBox;
Public int sheetCount = 1; // Number of WorkSheet instances
Private string sheetPrefixName = "page ";
# Region Public attributes
/// <Summary>
/// WorkSheet prefix name. For example, if the prefix is "page", the names of WorkSheet are "Page-1, page-2" in sequence"
/// </Summary>
Public string SheetPrefixName
{
Set {this. sheetPrefixName = value ;}
}
/// <Summary>
/// Number of WorkSheet instances
/// </Summary>
Public int WorkSheetCount
{
Get {return myBook. Sheets. Count ;}
}
# Endregion
Public