-
编辑 删除
OWC: ChartSpace
ArrayCategory0 = new Array( "Spring", "Summer", "Automn", "Winter");ArrayValue0 = new Array( 100, 278, 389, 500 );var chtNewChart0 = ChartSpace0.Charts.Item(0);chtNewChart0.SetData ( ChartSpace0.Constants.chDimCategories,ChartSpace0.Constants.chDataLiteral , ArrayCategory0 );chtNewChart0.SeriesCollection(0).SetData ( ChartSpace0.Constants.chDimValues,ChartSpace0.Constants.chDataLiteral , ArrayValue0 );[@more@]
-
编辑 删除
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); maxcol
