代码改变世界

随笔分类 -  数据解析

PDF

2013-07-11 22:39 by hongjiumu, 251 阅读, 收藏, 编辑
摘要: Converting PDF to Text in C#http://www.codeproject.com/Articles/12445/Converting-PDF-to-Text-in-CPDF File Analyzer With C# Parsing Classeshttp://www.codeproject.com/Articles/450254/PDF-File-Analyzer-With-Csharp-Parsing-ClassesPDF文件格式分析http://www.2cto.com/Article/201011/77380.html 阅读全文

(转)c#中判断是不是数字和字母

2013-06-30 05:53 by hongjiumu, 3069 阅读, 收藏, 编辑
摘要: 一、判断字母string str = Console.ReadLine();if (char.isLetter(str)){}else if (char.IsDigit(str)){}if(ch>='a'&&ch='A'&&ch255 因为汉字是大字符集二、判断输入的是不是数字try{int n = 0;n = int.Parse(this.textBox1.Text.Trim());}catch{MessageBox.Show("你输入的不是数字~!");}也可以用Char.isNumber(str[i 阅读全文

Excel 电子表格文件格式剖析

2013-06-28 23:08 by hongjiumu, 1040 阅读, 收藏, 编辑
摘要: Excel 电子表格文件格式,这种Excel和其他的Excel是不同的。他的本质上是一个Xml文件(用英文版的UtraEdit可以看到),所以他可以保存任何符号的字符,包括&(它在Xml文件中是一种特殊字符。所以用aspose等工具是不能读取这种字符的)。反过来说,我们从中可以得到一种快速生成带有多个Worksheet的Workbook的Excel,从xml文件处理的个角度入手。Gary LimFalseFalseReport InformationMoAddressSN=Eri3G,RNC=BORNC01Data Date6/23/2013 3:25:00 AMReport Crea 阅读全文

aspose读Excel

2013-03-15 22:11 by hongjiumu, 2620 阅读, 收藏, 编辑
摘要: private string ReadExcelCell(string path, int row, int column) { Workbook workbook = new Workbook(); workbook.Open(path); Cells cells = workbook.Worksheets[0].Cells; for (int i = 0; i < cells.MaxDataRow + 1; i++) { if (i ... 阅读全文

数据解析02-20

2013-02-19 23:09 by hongjiumu, 177 阅读, 收藏, 编辑
摘要: 数据解析02-20 阅读全文

数据解析01-15

2013-01-14 22:37 by hongjiumu, 196 阅读, 收藏, 编辑
摘要: 数据解析01-15 阅读全文

快速实现进度条

2013-01-14 22:36 by hongjiumu, 163 阅读, 收藏, 编辑
摘要: 快速实现进度条:private void ShowProgress(){ if (Worker._vProgress == null) { Worker._vProgress = new Progress(); Worker._vProgress.TotalCount = Worker.VLstDataTable.Count; } Worker._vProgress.OnProgressChanged += e => { this.Invoke((MethodInvoker)delegate() { ... 阅读全文

A .NET State Machine Toolkit - Part I

2013-01-08 23:15 by hongjiumu, 272 阅读, 收藏, 编辑
摘要: A .NET State Machine Toolkit - Part Ihttp://www.codeproject.com/Articles/11663/A-NET-State-Machine-Toolkit-Part-I 阅读全文

High Performance Multi-threaded Work Item / Event Scheduling Engine

2013-01-04 23:46 by hongjiumu, 186 阅读, 收藏, 编辑
摘要: http://www.codeproject.com/Articles/24423/High-Performance-Multi-threaded-Work-Item-Event-Sc 阅读全文

c#字定义异常处理类

2013-01-04 23:46 by hongjiumu, 217 阅读, 收藏, 编辑
摘要: public class DataLoaderException:Exception { private LogLevel _vLevel = LogLevel.None; private string _vsMessage = string.Empty; public LogLevel Level { get { return _vLevel; } } public string Message { get { return _vsMessa... 阅读全文

数据解析01-02

2013-01-01 21:53 by hongjiumu, 152 阅读, 收藏, 编辑
摘要: 数据解析01-02 阅读全文

Thread并发数控制

2013-01-01 16:28 by hongjiumu, 851 阅读, 收藏, 编辑
摘要: using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace ConsoleApplication1{ public class LimitedConcurrencyLevelTaskScheduler : System.Threading.Tasks.TaskScheduler { #region Memeber Declarations /// <summary> /// Whether the current th... 阅读全文

xml file parser

2012-12-29 12:01 by hongjiumu, 145 阅读, 收藏, 编辑
摘要: xml file parserhttp://vtd-xml.sourceforge.net/all byte handled 阅读全文

通过Assembly来创建Type Instance

2012-12-29 11:58 by hongjiumu, 489 阅读, 收藏, 编辑
摘要: 通过Assembly来创建Type Instance1,object obj=System.Reflection.Assembly.Load("assemblyname").CreateInstance("namespace.classname");//Assembly.Load takes a assembly name, not a file path(not include the tail of ".dll")ClassLib.User user=obj as ClassLib.User;Result:user is not 阅读全文

字符定位

2012-12-24 23:30 by hongjiumu, 257 阅读, 收藏, 编辑
摘要: private void SetPositionReference(string input) { _vdPostionReference.Clear(); int currentIndex = 0; char currentChar; int iStartIndex = 0, iEndIndex = 0; string tempColumnName = string.Empty; int iColumnIndex = 0; w... 阅读全文

Aspose.cells.dll编译时的问题

2012-12-21 01:00 by hongjiumu, 421 阅读, 收藏, 编辑
摘要: Aspose.cells.dll编译时的问题:Error 1 The type or namespace name 'Aspose' could not be found (are you missing a using directive or an assembly reference?) D:\work\1220\work\Solution1\ConsoleApplication1\XlsxReader.cs 6 7 ConsoleApplication1解决办法:<?xml version="1.0"?><configuration 阅读全文

树型数据结构设计处理

2012-12-21 00:58 by hongjiumu, 411 阅读, 收藏, 编辑
摘要: 怎么解析?树型数据结构设计处理:3个表来吧!(1)one subnetworkSubNetwork | Attribute[] | Container[]string | Guid1,Guid2,Guid3 | Guid1,Guid2,Guid3依次排列 依次排列(2)one container(container a id)Identity | IdPath | Attribute[]Guid | Id1^Id2^Id3 | Guid1,Guid2,Gui3层次关系 依次排列(3)one attributeIdentity | vsDataType | vsDataFormateVer... 阅读全文

Constraints for override and explicit interface implementation methods are inherited from the base method, so they cannot be specified directly

2012-12-20 00:29 by hongjiumu, 583 阅读, 收藏, 编辑
摘要: Constraints for override and explicit interface implementation methods are inherited from the base method, so they cannot be specified directlyFrom:http://stackoverflow.com/questions/283824/constraints-for-explicit-interface-implementation解决办法:使用范型类,不能在这里使用范型方法。 阅读全文

取得表名以h_开头的表,要使用left,不要使用like

2012-12-18 22:19 by hongjiumu, 297 阅读, 收藏, 编辑
摘要: 取得表名以h_开头的表:SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' andLEFT(TABLE_NAME,2)='h_'and TABLE_SCHEMA='p'特别注意:不能使用TABLE_NAME like 'h_%'因为sql2008会得到hh_开头的表。要注意! 阅读全文

12月16日

2012-12-16 21:14 by hongjiumu, 186 阅读, 收藏, 编辑
摘要: 12月16日 阅读全文