What is the command to open an excel sheet in C

string excelname= excelfileurl();The path to return to excel.

string filename = excelname;Save the file path of Excle.

object missing = ;

false;If the displayalerts property is set to false, the warning will not appear.

workbook = , open excel workbooks = ; //

workbook = ;Workbooks.

sheets = ;Instance**.

worksheet = (;The first**.

shell("Destination path and name")

string excelname= excelfileurl();The path to return to excel.

string filename = excelname;Save the file path of Excle.

object missing = ;

The value of the class is passed as if it were a function of the first **type is .

What do you want? Is it that the excel data is read out and displayed in the datagirlview and then stored in the database, or is it or the excel is directly taken to the program?

1. Select and open the "Controls Toolbox" toolbar.

2. Select the button tool, add a button to the worksheet, and set the button name;

3. Double-click the button to enter ** (enter the click event by default);

4. Enter under Private Sub CommandButton1 Click().

shell ("c:\windows\ e:"The shell is a function that starts the explorer (c:

Windows is a resource manager, and the windows directory is different if you modify it yourself), the e: (there is a space in front of it) is to open the e: disk, and you want to open it.

5. Click the first button of the "Control Toolbox" (exit the design mode) and close the "Control Toolbox".

6. Ok, click the button to try!

(1) Connect to the database first.

2) Bind the database.

3) Execute SQL statements. For example, select * from or insert into xx .

If you want to open an excel file and compile it directly, you need specific controls.,I don't seem to see a free one.。

Yes, excel has a special class library, which can be referenced in C, and then manipulate objects such as application, sheet, workbook, etc. This is better developed with VB, because the book circle is Office has VBA, you can record macros, Ziji** is Sun Collapse VBS, and VB is basically the same, it is very convenient to convert to VB**.