C#讀È¡Excel - .NET¼¼Êõ / C#
C# code:
public DataTable getExcelDataSet(string strxls, string strSheetName)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+strxls+";Extended Properties='Excel8.0;HDR=Yes;IMEX=1'";
OleDbConnection myOleConn = new System.Data.OleDb.OleDbConnection(strConn);
OleDbDataAdapter MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [" + strSheetName + "$]", myOleConn);
DataTable table = new DataTable();
MyCommand.Fill(table);
myOleConn.Close();
return table;
}
Ìáʾ£ºCould not find installable ISAM.
Èç¹ûÊÇstring strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+strxls+";Extended Properties='Excel8.0;'";
ÄǾÍ沒錯誤¡£µ«ÊÇ這種·½·¨無·¨讀³öһЩ單Ô¸ñ.
謝謝
http://www.xue5.com/itedu/200802/107307.html Õâ¸ö ÓÐÓô¦
»»Ò»¸ö·½Ê½¶ÁÈ¡°É,,,***********************************************************
»¶ÓʹÓà CSDN Ð¡ÃØÊé
¡¡CSDN Ð¡ÃØÊé
***********************************************************
Ïà¹ØÎÊ´ð£º
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
SHIFT¼ÓF10ÓëÄǸö¼üÓÒctrl±ßÉϵÄÄǸö¼ü¹¦ÄÜÒ»Ñù£¬ÏëÆÁÕâ¸ö
µ«²»ÖªÒªÔõôдÄǸö×éºÏ¼ü£¡
ÓÐûÄĸö´óÏÀ·ÅÒ»¶ÎÕâ¸öµÄ´úÂë»òдһ¶Î
http://topic.csdn.net/u/20090609/15/7dc9fb70-243f-4070-9cfd-34e48b66e6c6.html
......
ÎÒÓÐÒ»¸öÀàËÆµÄxmlµÄ string£¬Ïëͨ¹ý±éÀúÔõô¸öxml Êä³öÎÒÏëÒªµÄelementµÄÖµ
xml Ϊ£º
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_ME ......
ÎÒ¸Õ°ÑÌ·ºÆÇ¿µÄµÚÈý°æµÄÊéѧÍ꣬ÎÒÖªµÀµÄÓÐC++£¬CºÍÖ¸Õë CȱÏݺÍÏÝÚå Cר¼Ò±ä³É£¬»¹ÓÐÊý¾Ý½á¹¹£¬ÎÒÏëÎÊÎÊÎÒÓ¦¸ÃÒÔʲô˳ÐòÀ´Ñ§ÄØ
CȱÏݺÍÏÝÚå Cר¼Ò±à³Ì
Êǽø½×µÄ£¬²»Óü±×Å¿´
ÖÁÓÚ
CºÍÖ¸Õë
Äã²»Àí½âÖ ......