Several methods of operating Excel data under .NET.

xiaoxiao2021-03-06  92

1, ADO.NET

Related connection strings:

ODBC

"Driver = {Microsoft Excel Driver (* .xls)}; driverid = 790; dbq = c: /myexcel.xls; defaultdir = c: / mypath;"

OLE DB

"Provider = microsoft.jet.Oledb.4.0; data source = c: /myexcel.xls; extended proties = excel 8.0; hdr = yes;"

Related articles:

http://www.microsoft.com/china/msdn/library/office/office/odatanet2.mspx

-------------------------------------------------- ------------------------------

2, Excel.Applicant

There are related presentation code in this directory:

Microsoft Visual Studio .NET 2003 / SDK / V1.1 / Samples / Technologies / Interop / Applications / Office / Excel / CS

-------------------------------------------------- ------------------------------

3, XML XSLT

Articles on Chinese MSDN:

http://www.microsoft.com/china/msdn/library/office/office/odc_xlxmlhowto_.mspx

-------------------------------------------------- ------------------------------

转载请注明原文地址:https://www.9cbs.com/read-122613.html

New Post(0)