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 Ð¡ÃØÊé
***********************************************************
Ïà¹ØÎÊ´ð£º
ÇëÎÊVFPÖÐÈçºÎµ÷ÓÃC/C++º¯Êý£¿
ÄãÒªµ÷ÓÃʲô¹¦Äܵĺ¯Êý£¿Òª¿´¿´VFPÖÐÓÐûÓжÔÓ¦µÄº¯Êý£¬Èç¹ûÓоÍÊ¡×ÅÔÙµ÷ÓÃÁË¡£Èç¹ûûÓУ¬¿ÉÒÔ½«C/C++º¯Êýд¸öDLL»òFLL£¬È»ºóÔÚVFPµ÷Óü´¿É¡£
Ê®¶¹Èý ÀÏʦ£¬Ôõô²ÅÄÜÐÞ¸Ä×Ô¼ºµÄ ......
ÈçÌ⣬C/C++ÖеÄexeclÔõôµ÷ÓÃдºÃµÄjava³ÌÐò£¬
execl("/opt/java1.5/bin/java","MyClass",NULL);
ÕâÑùµÄ²»ÐÐŶ¡£
²»»á.
ÔËÐÐjava³ÌÐò
ÕÒ¹¤¾ß²é¿´Ò»ÏÂÄǸö³ÌÐòµÄÃüÁîÐÐ
ËÑË÷Ï£ºjni ......
visual c++2008Ëٳɰ棬²»ÄܱàÒëC³ÌÐòÂð£¿Èç¹ûÄÜÊÇÔõô¿ªÊ¼µÄ°¡£¿ÓÃËü´øµÄÃüÁîÌáʾµ¥Ôª³ýÍâ ¡£
н¨¹¤³Ì£¨¿Õ¹¤³Ì»òwin32¿ØÖÆÌ¨£©
¾ø¶Ô¿ÉÒÔ¡£½¨Á¢win32¿ØÖÆÌ¨³ÌÐò¾Í¿ÉÒÔ
ÒýÓÃ
н¨¹¤³Ì£¨¿Õ¹¤³Ì»òwin32¿ØÖÆÌ¨£ ......
ÎÒ¸Õ°ÑÌ·ºÆÇ¿µÄµÚÈý°æµÄÊéѧÍ꣬ÎÒÖªµÀµÄÓÐC++£¬CºÍÖ¸Õë CȱÏݺÍÏÝÚå Cר¼Ò±ä³É£¬»¹ÓÐÊý¾Ý½á¹¹£¬ÎÒÏëÎÊÎÊÎÒÓ¦¸ÃÒÔʲô˳ÐòÀ´Ñ§ÄØ
CȱÏݺÍÏÝÚå Cר¼Ò±à³Ì
Êǽø½×µÄ£¬²»Óü±×Å¿´
ÖÁÓÚ
CºÍÖ¸Õë
Äã²»Àí½âÖ ......