C# 导入Excel
2021-02-08 11:15
标签：ros 功能 配置参数 style express 图片 手动 factor 统一 项目结构： 配置文件 C# 导入Excel 标签：ros 功能 配置参数 style express 图片 手动 factor 统一 原文地址：https://www.cnblogs.com/guxingy/p/11362870.html
xml version="1.0" encoding="utf-8"?>
configuration>
configSections>
section name="oracle.manageddataaccess.client"
type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
configSections>
appSettings>
add key="OperationType" value="1"/>
add key="ImportExcelName" value="A2合同段"/>
add key="TableName" value="TB_PROJECTS_V2_2"/>
add key="SQLType" value="1"/>
add key="ExportVersion" value="2"/>
add key="DeleteChildNode" value=""/>
add key="OracleConn" value="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.98)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=JJJT)));User ID=CMSP;Password=Oracle1;"/>
add key="SQLServerConn" value="data source=.\sqlexpress;initial catalog=TEST1;user id=sa;password=sa;"/>
add key="CodePrefix" value="LZEEE"/>
add key="ExcelAdditionalAttr_ColumnName" value="false"/>
add key="OneLevelName" value="城开高速公路"/>
add key="OneLevelId" value="510321"/>
add key="TwoLevelNodesName" value="A1合同段,A2合同段,A3合同段,B1合同段,B2合同段,B3合同段,C1合同段,C2合同段,C3合同段"/>
add key="ExcelFirstFilterAttrName" value="砼等级"/>
add key="ExcelAdditionalAttr" value="true"/>
add key="ExcelAdditionalAttr_Cn" value="桩号,构件编码,构件类型,设备编码"/>
add key="ExcelAdditionalAttr_En" value="MileageNo,NComponentCode,ProjectType,EquCode"/>
add key="ExcelAdditionalAttr_AllFieldCheck" value="true"/>
add key="SaveDB" value="true"/>
add key="SaveSQLFile" value="true"/>
add key="IsSupportFormula" value="true"/>
add key="IsAllowCache" value="false"/>
add key="CheckSameCode" value="false"/>
add key="ExcelNeedColumn" value="构件名称,构件编码,砼等级"/>
add key="MinCodeNum" value="5"/>
add key="MinRowHeight" value="200"/>
add key="CheckCodeExist" value="false"/>
appSettings>
startup>
supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2"/>
startup>
system.data>
DbProviderFactories>
remove invariant="Oracle.ManagedDataAccess.Client"/>
add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver"
type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
DbProviderFactories>
system.data>
configuration>