一、引用的jar包，apache的POI//https://mvnrepository.com/artifact/org.apache.poi/poi-ooxmlcompilegroup:'org.apache.poi',name:'poi-ooxml',version:'3.17'//https://mvnrepository.com/artifact/org.apache.poi/poicompilegroup:'org.apache.poi',name:'poi',version:'3.17' 二、完整的类示例importjava.io.File;importjava.io.FileInputStream;importjava.io.IOException;importjava.io.InputStream;importjava.text.DecimalFormat;importjava.text.SimpleDateFormat;importjava.util.ArrayList;importjava.util.Date;importorg.apache.poi.hs...

book:=TXLSWorkbook.Create;tryifbook.Open(AFIleName)=-1thenbeginraiseException.Create('请检查导入的文件是否存在或Excel已经处于打开状态(如果已经打开，请尝试关闭文件再导入)');end;ws:=book.WorkSheets[1];ifws.UsedRange.Rows.Count=0thenbeginExit;end; ...

由于64位系统已经不支持oledb4.0访问xls1. 未在本地计算机上注册“microsoft.ACE.oledb.12.0”提供程序去http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe下载。 2.SQLServerblockedaccesstoSTATEMENT'OpenRowset/OpenDatasource'ofcomponent'AdHocDistributedQueries'becausethiscomponentisturnedoffaspartofthesecurityconfigurationforthisserver.Asystemadministratorcanenabletheuseof'AdHocDistributedQueries'byusingsp_configure.Formoreinformationaboutenabling'AdHocDistributedQuerie...

procedureTfrmUserV3.ImportUser(constAFileName:string);varbook:IXLSWorkBook;ws:IXLSWorkSheet;i,j:Integer;v:Variant;obj:T_LoginUser;objList:T_LoginUserInf;sCode,sName,sPwd,sGroup:string;beginbook:=TXLSWorkbook.Create;objList:=T_LoginUserInf.Create;tryi:=book.Open(AFileName);ws:=book.WorkSheets[1];ifws.UsedRange.Rows.Count=0thenExit;fori:=2tows.UsedRange.Rows.Count-1dobeginifVarIsNull(ws.UsedRange.Rows[i].Item[1].Value)thenContinue;sCode:=ws.UsedRange.Rows[i].item[1].Value;withws.UsedRange.Rows[i]d...

insertintoT_BirdSystemSku(ID,Sku)selectID,SKUfromOpenRowSet('Microsoft.ACE.OLEDB.12.0','Excel12.0;HDR=Yes;IMEX=1;Database=c:/tp.xlsx','select*from[工作表1$]')whereskunotin(SELECTSkufromT_BirdSystemSku) 可以参考：　http://www.cnblogs.com/xiashengwang/p/3511808.html...

classfunctionT_EShopDataBill.ImportData(constAFileName:String;AList:T_EShopDataModelList;varAErr:string):Boolean;varBook:IXLSWorkbook;ws:IXLSWorksheet;i:Integer;nOrderIDRow,nTrackNoRow:Integer;obj:T_EShopDataModel;tmpIden,tmpTrackNo:String;sSql:String;tmpQry:TADOQuery;beginBook:=TXLSWorkbook.Create;tryi:=Book.Open(AFileName);ws:=Book.WorkSheets[1];ifws.UsedRange.Rows.Count=0thenExit;nOrderIDRow:=0;nTrackNoRow:=0;forI:=1tows.UsedRange.Rows[1].Count-1dobeginifnOrderIDRow=0thenifCompareText(VarToSt...

 把代码备份一下，免得硬盘又坏了，看来已经造成心理阴影了啊。 方式一：//清单范本publicvoidtest1(){//生成说明vards=ExcelHelper.ExcelToDataSet(true,"清单范本.xlsx");vardt=ds.Tables[0];dt.Columns.Remove("序号");//列名List<string>columnNames=newList<string>();PropertyInfo[]pArray=typeof(ListingTemplate).GetProperties();pArray.ToList().ForEach(c=>{columnNames.Add(c.Name);});//Excel的列名修改为属性名for(inti=0;i<dt.Columns.Count;i++){dt.Columns[i].ColumnName=columnNames[i];}List<ListingTemplate>allListingTemplates=newList<L...

  项目结构：  配置文件<?xmlversion="1.0"encoding="utf-8"?><configuration><configSections><sectionname="oracle.manageddataaccess.client"type="OracleInternal.Common.ODPMSectionHandler,Oracle.ManagedDataAccess,Version=4.122.19.1,Culture=neutral,PublicKeyToken=89b483f429c47342"/></configSections><appSettings><!--注意（备注）：特别注意！！！：导入数据前需要删掉触发器和序列（Oracle），或取消自增长ID（SQLServer）如果导入的数据，没有形成树型结构，子节点和根节点在一个层级。原因：没有删除触发器和序列（Oracle）或自增长ID（SQLServer）1、合同段名称必须统一，Ex...

原文：地址忘了百度应该有 Excel的单元格为日期格式，数值型日期，可用下面这个方法得到正常的数据 　　　　　///<summary>///数字格式的时间转换为字符串格式的时间///数字格式的时间如：42095.7069444444/0.650694444444444///</summary>///<paramname="timeStr">数字,如:42095.7069444444/0.650694444444444</param>///<returns>日期/时间格式</returns>publicstringToDateTimeValue(stringstrNumber){if(!string.IsNullOrWhiteSpace(strNumber)){DecimaltempValue;//先检查是不是数字;if(Decimal.TryParse(strNumber,outtempValue)){//天数,取整intday=Convert.ToInt32(Math.Truncate(tem...

 注意一下Excel格式，我平时导入的是xlsx ///<summary>///Excel转换为DataSet///</summary>///<paramname="isFirstRowColumn">首行作为列名</param>///<paramname="fileName"></param>///<paramname="IsSupportFormula">是否支持公式</param>///<returns></returns>publicstaticDataSetExcelToDataSet(boolisFirstRowColumn,stringfileName,boolIsSupportFormula=true){IWorkbookworkbook=null;DataSetds=newDataSet();varfs=newFileStream(fileName,FileMode.Open,FileAccess.Read);#region初始化...

 表 表的创建脚本CREATETABLE[dbo].[TB_PROJECTS_New1]([PROID][decimal](10,0)NOTNULL,[PROJECTNAME][nvarchar](500)NULL,[PROJECTCODE][nvarchar](100)NULL,[PARENTID][decimal](10,0)NULL,[NEXTID][decimal](10,0)NULL,[PROJECTORDER][decimal](10,0)NULL,[ISENABLED][decimal](10,0)NULL,[OWNERID][decimal](10,0)NULL,[CONSTRUCTIONID][decimal](10,0)NULL,[SUPERVISIONID][decimal](10,0)NULL,[CONTRACTID][decimal](10,0)NULL,[LEVEL][decimal](10,0)NULL,[QUANTITY][decimal](10,0)NULL,[VERSIONING][nvarchar](max)NULL,[MILE...

原文地址：https://www.cnblogs.com/liu-xia/p/5230768.html DateTime.FromOADate(double.Parse(range.Value2.ToString()));...

遇到的几个坑，记录一下。隐藏表，隐藏行，隐藏列，单元格合并=>拆分并填充内容， 显示隐藏列，结果那个列还是不显示出来，拖动旁边的列也不显示。结果在旁边的列上，按左右箭头键就出来了，也是郁闷，还是Excel不熟呀。...

原地址忘了需引用NPOI，引用方法：项目引用那儿右键=>管理NuGet程序包=>游览=>输入NPOI=>选中NPOI后安装（一般是第一个） ///<summary>///Excel转换为Datatable///</summary>///<paramname="sheetNum">工作表索引</param>///<paramname="isFirstRowColumn">首行为列</param>///<paramname="fileName">Excel文件路径</param>///<returns></returns>publicDataTableExcelToDataTable(intsheetNum,boolisFirstRowColumn,stringfileName){IWorkbookworkbook=null;ISheetsheet=null;DataTablemyTable=newDataTable();try{varf...

  demo：https://files.cnblogs.com/files/guxingy/Excel%E8%BD%AC%E6%8D%A2%E4%B8%BAJson%E5%AF%B9%E8%B1%A1.rar不太会用博客 待转换的Excel格式 转换后的JSON格式：  Excel转换类：publicclassOperationExcel{///<summary>///Excel转换为Datatable///</summary>///<paramname="sheetNum">工作表索引</param>///<paramname="isFirstRowColumn">首行为列</param>///<paramname="fileName">Excel文件路径</param>///<returns></returns>publicDataTableExcelToDataTable(intsheetNum,bo...