China DOS Union

-- Unite DOS · Advance DOS · Grow DOS --
Union site: www.cn-dos.net　Forum site: www.cn-dos.net/forum

中国DOS联盟论坛
The time now is 2026-08-02 06:51

48,037 topics / 350,122 posts / today 2 new / 48,250 members

DOS批处理 & 脚本技术（批处理室） » [WSH] View Excel Files Without Installing Office

Floor1　electronixtar	Posted 2006-08-27 15:38
铂金会员　Posts 2,672　Credits 7,493
Hehe, saw it on MS newsgroup. Although we all know how to use ADO when learning it normally, it's still difficult to recall it in critical moments. Can you think of ADO without using Excel.Application? Sample code Dim oADO, oRS, sSQL, sConn sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Ray\SomeExcelFile.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""" sSQL = "SELECT this, that FROM " Set oADO = CreateObject("ADODB.Connection") oADO.Open sConn Set oRS = oADO.Execute(sSQL) If Not oRS.EOF Then WScript.Echo oRS.GetString(2,,",",vbCRLF,"") oRS.Close : Set oRS = Nothing oADO.Close : Set oADO = Nothing [ Last edited by electronixtar on 2006-8-27 at 15:41 ]

Floor2　Kinglion	Posted 2006-08-29 00:18
铂金会员　Posts 1,924　Credits 5,798　From 金獅電腦軟體工作室
Hehe. Actually, there are many similar codes on MSDN for everyone to learn.

Floor3　holyman	Posted 2006-10-25 00:44
初级用户　Posts 20　Credits 42
Unfortunately, there are not many applications that solve practical problems.

Floor4　electronixtar	Posted 2006-10-25 04:40
铂金会员　Posts 2,672　Credits 7,493
Sweat～～Still can't solve the problem? A script of a few bytes can avoid the installation of hundreds of megabytes of programs.

Floor5　zts59	Posted 2006-10-26 03:29
中级用户　Posts 104　Credits 387
There are dedicated programs for viewing Excel, which are not hundreds of megabytes but around ten megabytes.

Floor6　electronixtar	Posted 2006-10-26 03:36
铂金会员　Posts 2,672　Credits 7,493
Mine is only a few kilobytes. With a little modification, it can modify Excel content.