How to import Excel in C winform

Are you importing data from Excel to Winform? If so, it can be like this: after referencing the component, application; This is a client.

workbooks;All workbooks.

worksheet;Worksheet.

workbook;The worksheet used void isrunex(){openfiledialog openfilediaglog = new openfiledialog(); }

xls file|*.xls";

if ( ==

fieldname = ;

workbooks = ;

workbook = returnworkbook(fieldname, workbooks);

worksheet = (;Select the first table.

range range = , 8] as range;This is the content of the eighth column of the first row selected.

range rangee = , 9] as range;This is the content of the first line to the ninth column string str1=; string str2=;All you have to do is ...fieldname, ;

Exit to close the resource.

private workbook returnworkbook(string filename,workbooks works) Here is a worksheet.

wk=filename, ,return wk;

Read the excel template first, get the data in winfrom according to the identifier in the excel template, fill in the corresponding cells, and then save excel as.

In fact, this is mainly the operation of excel, and there are many specific operation tutorials for excel on the Internet, and there are them in any search.

When you go to the exported Excel to write the condition, first merge the 0th row, and write the "personal information table", and then write a condition, if you loop to the first line, fill in the title, and the third line starts to read the data in Winform.

It is recommended to use pageoffice, there are many examples on the Internet.

1.Can you read excel?

2.After reading and reading, can you load the dataset after reading excel?

3.I'm the most wordy, do you see?

4.Isn't it OK to read the dataset?

5.Are you right?

I wrote it as well.

1.Connect to Excel

2.Parsing data in Excel (which returns a dataset).

3.The data is organized and assigned to an array.

Search pageoffice on the Internet, there are many examples of it**, it can help you solve it.

The Microsoft SDK has a ready-made demo source code.

provider=;data source=" filepath + extended properties='excel ;imex=1'";

Finally, add a pure posture hdr=yes, do silver excel also make sure that the row is the row punch column is the column, the title is at the top.