Stimulsoft Reports .Net的Designer.EXE连接Excel操作方式及代码:
在选择OleDb Connection的时候复制下面代码:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"; 或者: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";
答案来源:http://www.evget.com/zh-cn/evquestions/viewinfo.aspx?qid=1955