android操作excel（续）

       上次写的那个对excel的操作，有读和写两部分。不过还是不能满足项目需求，然后今天做了一点点改进，就是不用自己写的读取表格，而是用别人写好的程序来打开，然后查询。

        这里就有一点，就是怎么从程序中打开一个文件，这里是打开excel文件，同理，还有别的文件打开问题，网上给出了两个方案，我总结了下，我用的是第一种。我这里是设计一个button键，然后跳转到打开这个excel文件，用的是手机自带的软件。

/** 
     * 根据文件后缀名获得对应的MIME类型。 
     * @param file 
     */  
    private String getMIMEType(File file) {  
          
        String type="*/*";  
        String fName = file.getName();  
        //获取后缀名前的分隔符"."在fName中的位置。  
        int dotIndex = fName.lastIndexOf(".");  
        if(dotIndex < 0){  
            return type;  
        }  
        /* 获取文件的后缀名 */  
        String end=fName.substring(dotIndex,fName.length()).toLowerCase();  
        if(end=="")return type;  
        //在MIME和文件类型的匹配表中找到对应的MIME类型。  
        for(int i=0;i<MIME_MapTable.length;i++){ //MIME_MapTable??在这里你一定有疑问，这个MIME_MapTable是什么？  
            if(end.equals(MIME_MapTable[i][0]))  
                type = MIME_MapTable[i][1];  
        }         
        return type;  
    }  

    private final String[][] MIME_MapTable={  
            //{后缀名， MIME类型}  
            {".3gp",    "video/3gpp"},  
            {".apk",    "application/vnd.android.package-archive"},  
            {".asf",    "video/x-ms-asf"},  
            {".avi",    "video/x-msvideo"},  
            {".bin",    "application/octet-stream"},  
            {".bmp",    "image/bmp"},  
            {".c",  "text/plain"},  
            {".class",  "application/octet-stream"},  
            {".conf",   "text/plain"},  
            {".cpp",    "text/plain"},  
            {".doc",    "application/msword"},  
            {".docx",   "application/vnd.openxmlformats-officedocument.wordprocessingml.document"},  
            {".xls",    "application/vnd.ms-excel"},   
            {".xlsx",   "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"},  
            {".exe",    "application/octet-stream"},  
            {".gif",    "image/gif"},  
            {".gtar",   "application/x-gtar"},  
            {".gz", "application/x-gzip"},  
            {".h",  "text/plain"},  
            {".htm",    "text/html"},  
            {".html",   "text/html"},  
            {".jar",    "application/java-archive"},  
            {".java",   "text/plain"},  
            {".jpeg",   "image/jpeg"},  
            {".jpg",    "image/jpeg"},  
            {".js", "application/x-javascript"},  
            {".log",    "text/plain"},  
            {".m3u",    "audio/x-mpegurl"},  
            {".m4a",    "audio/mp4a-latm"},  
            {".m4b",    "audio/mp4a-latm"},  
            {".m4p",    "audio/mp4a-latm"},  
            {".m4u",    "video/vnd.mpegurl"},  
            {".m4v",    "video/x-m4v"},   
            {".mov",    "video/quicktime"},  
            {".mp2",    "audio/x-mpeg"},  
            {".mp3",    "audio/x-mpeg"},  
            {".mp4",    "video/mp4"},  
            {".mpc",    "application/vnd.mpohun.certificate"},        
            {".mpe",    "video/mpeg"},    
            {".mpeg",   "video/mpeg"},    
            {".mpg",    "video/mpeg"},    
            {".mpg4",   "video/mp4"},     
            {".mpga",   "audio/mpeg"},  
            {".msg",    "application/vnd.ms-outlook"},  
            {".ogg",    "audio/ogg"},  
            {".pdf",    "application/pdf"},  
            {".png",    "image/png"},  
            {".pps",    "application/vnd.ms-powerpoint"},  
            {".ppt",    "application/vnd.ms-powerpoint"},  
            {".pptx",   "application/vnd.openxmlformats-officedocument.presentationml.presentation"},  
            {".prop",   "text/plain"},  
            {".rc", "text/plain"},  
            {".rmvb",   "audio/x-pn-realaudio"},  
            {".rtf",    "application/rtf"},  
            {".sh", "text/plain"},  
            {".tar",    "application/x-tar"},     
            {".tgz",    "application/x-compressed"},   
            {".txt",    "text/plain"},  
            {".wav",    "audio/x-wav"},  
            {".wma",    "audio/x-ms-wma"},  
            {".wmv",    "audio/x-ms-wmv"},  
            {".wps",    "application/vnd.ms-works"},  
            {".xml",    "text/plain"},  
            {".z",  "application/x-compress"},  
            {".zip",    "application/x-zip-compressed"},  
            {"",        "*/*"}    
        };  

       这是别人的程序，我没有修改，所以本文是转载的啦，不算原创。

       效果就是，按下跳转button然后就跳转到提示问你，选择一个程序打开这个文件，你选择自己安装好的打开下就可以了。

       方法二就是通过intent，然后打开别人的程序的包文件，这个如果是自己的程序打开自己的程序，很简单，你知道主activity和包名，别人的你要用PackageInfo得到的想要启动的应用的包名，然后才行。这里我不多写了，给出我看到的一个别人的链接，不知道靠谱不。我没测试，我保怀疑态度。（http://blog.csdn.net/xiezhenxiang/article/details/7608752）