OWC: 在网页中用SpreadSheet控件显示Excel文件 (CopyFromRecordset方法)
xlsOleDBConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + fn + ";"
+ "Extended Properties='Excel 8.0;IMEX=1';";
try {
oCon= new ActiveXObject("ADODB.Connection");
oCon.ConnectionString = xlsOleDBConnectionString;
oCon.Open ();
var oRst = new ActiveXObject( "ADODB.Recordset");
oRst =oCon.Execute ( "SELECT * FROM [EXPORTED DATA$]");
apsheet.Rows.CopyFromRecordset (oRst);
maxcolumn = oRst.Fields.Count;
oRst.Close ();
oCon.Close();
apsheet.Columns(1).ColumnWidth=10;
apsheet.Columns(2).ColumnWidth=10;
apsheet.Columns(3).ColumnWidth=10;
} catch (e)
{
window.alert ( e.message );
}
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11445597/viewspace-974116/ ，如需转载，请注明出处，否则将追究法律责任。
