读取xls

读写

xlsx"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + serverFilename + "';Extended Properties='Excel 12.0;HDR=YES'";

xls "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + serverFilename + "';Extended Properties='Excel 8.0;HDR=YES;'";

读取xls里的换行符(第一行为列名)(只读)

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + serverFilename + "';Extended Properties='Excel 12.0;HDR=YES;IMEX=1'";

xls表里第一行为数据 (只读)

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + serverFilename + "';Extended Properties='Excel 12.0;HDR=NO;IMEX=1'"; 

posted @ 2011-08-02 11:23  死 神  阅读(312)  评论(0)  编辑  收藏  举报