halcon 将数据保存到excel_通过OleDb将数据保存到Excel

protectedoverridevoidSave(IReportData data, Data.IColumnMappingCollection mappings,stringpath)

{

StringBuilder fieldString=newStringBuilder();

StringBuilder fieldParamStr=newStringBuilder();

StringBuilder fieldStringNovar=newStringBuilder();using(OleDbConnection conn=newOleDbConnection(string.Format(ObjectUtil.SysCulture, CONN_STRING, path)))using(OleDbCommand cmd=newOleDbCommand())

{

cmd.Connection=conn;

conn.Open();foreach(var colinmappings.ColumnMappings)

{

fieldString.Append(",").Append("[").Append(col.DisplayName).Append("]").

Append(ToOledbType(col.DataType).ToString());

fieldStringNovar.Append(",").Append("[").Append(col.DisplayName).Append("]");

fieldParamStr.Append(",@").Append(col.FieldName);

cmd.Parameters.Add(newOleDbP