2013年07月_gdjlc

11月 10月 09月 08月 07月 06月 05月 03月 02月 01月

原创 NPOI利用多任务模式分批写入多个Excel

接上文NPOI大数据分批写入同个Excel，这次是利用task多任务同时写入到多个Excel。 Form2.cs private void btnExport_Click(object sender, EventArgs e) { try { txtSql.Sa

2013-07-26 14:11:41 2266

原创 NPOI大数据分批写入同个Excel

实现过程：要导出来的数据库数据量很大，一次取出来压力有点大，故分批取出来，导入到同一个Excel。因为Excel2003版最大行数是65536行，Excel2007开始的版本最大行数是1048576行，故NPOI导出时候选择了Excel2007。 Form1.cs /* 引用命名空间： using System.IO; using System.Threading.Tasks; u

2013-07-26 12:31:28 8437

原创 NPV、IRR的计算

净现值(NPV, Net Present Value) 定义：将投资的未来现金流量，全部折现成投资始日的价值，称为该投资的净现金流量，或称为净现值。假设投资的净现值为正数，代表该投资的结果可以增加企业的价值; 反之，如果投资评估的净现值为负数，代表此投资会减少企业的价值，不应该接受。当然净现值为正数仍不代表该接受此投资建议，或许存在其他净现值更高的投资机会。在多项投资案并陈时，应选择净现

2013-07-22 22:48:47 17067 1

PL/SQL美化器规则文件，用于格式美化sql语句

PL/SQL使用方法： 1、工具--首选项--用户界面--PL/SQL美化器--规则文件，选择.br的规则文件，点确定按钮。 2、点击工具栏的“PL/SQL美化器”，会自动把一段SQL语句重新排版美化。

2022-06-09

开源.NET FTP组件edtFTPnet.dll

开源.NET FTP组件edtFTPnet edtFTPnet官方网站： http://www.enterprisedt.com/products/edtftpnet/ 目前最新版本为2.2.3，下载后在bin目录中找到edtFTPnet.dll，在项目中添加引用。用法：http://blog.csdn.net/gdjlc/article/details/12054881

2013-09-26

HTML解析工具Html Agility Pack v1.4.6

http://htmlagilitypack.codeplex.com/ This is an agile HTML parser that builds a read/write DOM and supports plain XPATH or XSLT (you actually don't HAVE to understand XPATH nor XSLT to use it, don't worry...). It is a .NET code library that allows you to parse "out of the web" HTML files. The parser is very tolerant with "real world" malformed HTML. The object model is very similar to what proposes System.Xml, but for HTML documents (or streams).

2013-09-18

文件比对工具WinMerge v2.14

http://winmerge.org/ WinMerge is an Open Source differencing and merging tool for Windows. WinMerge can compare both folders and files, presenting differences in a visual text format that is easy to understand and handle.

2013-09-18

SQLite数据库管理工具SQLiteStudio 2.1.4

http://sqlitestudio.pl/ SQLiteStudio is a SQLite database manager with the following features: Single executable file - no need to install or uninstall. Binary distribution is just the single, ready to use file. Intuitive interface, All SQLite3 and SQLite2 features wrapped within simple GUI, Cross-platform - runs on Windows 9x/2k/XP/2003/Vista/7, Linux, MacOS X, Solaris, FreeBSD and should work on other Unixes (not tested yet). Localizations, currently translated to: English, Polish, Spanish, German, Russian, Japanese, Italian, Dutch, Chinese, Exporting to various formats (SQL statements, CSV, HTML, XML, PDF, JSON, dBase), Importing data from various formats (CSV, dBase, custom text files [regular expressions]), Numerous small additions, like formatting code, history of queries executed in editor windows, on-the-fly syntax checking, and more, UTF-8 support, skinnable (interface can look native for Windows 9x/XP, KDE, GTK, Mac OS X, or draw widgets to fit for other environments, WindowMaker, etc), Configurable colors, fonts and shortcuts. Open source and free - Released under GPLv2 licence.

2013-09-18

.net程序反编译工具ILSpy 2.1

官网：http://ilspy.net/ ILSpy is the open-source .NET assembly browser and decompiler. Development started after Red Gate announced that the free version of .NET Reflector would cease to exist by end of February 2011. ILSpy requires the .NET Framework 4.0.

2013-09-18

读写Excel的组件npoi

官网：http://npoi.codeplex.com/ 介绍： Follow (605) Subscribe This project is the .NET version of POI Java project at http://poi.apache.org/. POI is an open source project which can help you read/write xls, doc, ppt files. It has a wide application. For example, you can use it to a. generate a Excel report without Microsoft Office suite installed on your server and more efficient than call Microsoft Excel ActiveX at background; b. extract text from Office documents to help you implement full-text indexing feature (most of time this feature is used to create search engines). c. extract images from Office documents d. generate Excel sheets that contains formulas

2013-07-26