利用pb的saveas匯出的excel dw_1.saveas('ct.xls',Excel5!,true)
然后通過以下連接
db="ct.xls"
ExcelConn.Open = "provider=Microsoft.jet.OLEDB.4.0;Data source=" &server.MapPath(db)&" ;Extended Properties=Excel 5.0;"
set rsexcel=excelconn.execute("SELECT * FROM [ct$]")
無法打開
但是如果我用excel程式打開這個excel檔案，再保存一下，選擇保留格式，就可以打開了，請問為什么？？？？？？
uj5u.com熱心網友回復：
PowerBuilder enumerated value Web DataWindow or Java field Numeric value MeaningExcel! Excel (Web DW only) 0 Microsoft Excel format
Text! Text (Web DW only) 1 (Default) Tab-separated columns with a return at the end of each row
CSV! CSV (Web DW only) 2 Comma-separated values
SYLK! SYLK (Web DW only) 3 Microsoft Multiplan format
WKS! WKS (Web DW only) 4 Lotus 1-2-3 format
WK1! WK1 (Web DW only) 5 Lotus 1-2-3 format
DIF! DIF (Web DW only) 6 Data Interchange Format
dBASE2! dBASE2 (Web DW only) 7 dBASE-II format
dBASE3! dBASE3 (Web DW only) 8 dBASE-III format
SQLInsert! SQLInsert (Web DW only) 9 SQL syntax
Clipboard! Clipboard (Web DW only) 10 Save an image of the graph to the clipboard
PSReport! PSReport 11 Powersoft Report (PSR) format
WMF! WMF (Web DW only) 12 Windows Metafile format
HTMLTable! HTMLTable 13 HTML TABLE, TR, and TD elements
Excel5! Excel5 (Web DW only) 14 Microsoft Excel Version 5 format
uj5u.com熱心網友回復：
dw_1.saveas('ct.xls',Excel!,true)試試.
uj5u.com熱心網友回復：
表示關注！uj5u.com熱心網友回復：
樓主在陳述句先加入下面陳述句試試int result
ole_object = CREATE OLEObject
any nr
string f_name //excel檔案名
IF ole_object.ConnectToNewObject("Excel.Application") <> 0 THEN
MessageBox('OLE錯誤','Excel尚未安裝!')
RETURN
END IF
ole_object.workbooks.open(f_name)
Ole_object.application.visible=true
uj5u.com熱心網友回復：
用低版本格式保存，用高版本驅動打開吧。。。閉著眼睛回答你的問題，因為很困了。。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/86497.html
標籤：腳本語言