|
发表于 2016-7-28 10:46:53
|
显示全部楼层
如果是不符,可以用其他方法试试。如先保存为xlsx文件,然后安装扩展库中的sevenZip.cmd,注意:将var src = "替换为需要查看的EXCEL表.xlsx"
- import console;
- import process.popen;
- import fsys;
- var _,libDir = ..io.libpath("sevenZip.cmd");
- var zPath = fsys.joinpath(libDir ,".bin\7za.dll" );
- var src = "替换为需要查看的EXCEL表.xlsx";
- var dst = "";
-
- if( io.exist(dst + "workbook.xml") ){
- io.remove(dst + "workbook.xml");
- }
- var prcs = process.popen(zPath,
- '"' + zPath + '" '
- + ' e "' + ..io.fullpath(src) + '" '
- + ' -o"' + ..io.fullpath(dst) + '" '
- + ' "workbook.xml" '
- + ' -r'
- )
- var str = prcs.read(-1) //读取返回数据;
- if(io.exist(dst + "workbook.xml")){
- str = string.load(dst + "workbook.xml");
- var p = //\<sheet name="(.+?)"
- var n = 1;
- for name in string.gmatch(str ,p ) {
- console.log("sheet-" ++ n ++ ":",name,'\r\n' );
- n++;
- }
- }
- else {
- console.log("文件格式不正确:",str )
- }
- console.pause(true);
复制代码 |
|