﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>博客园-aTao.Xiang's Blog-最新评论</title><link>http://www.cnblogs.com/atao/CommentsRSS.aspx</link><description /><language>zh-cn</language><pubDate>Sun, 29 Nov 2009 15:01:09 GMT</pubDate><lastBuildDate>Sun, 29 Nov 2009 15:01:09 GMT</lastBuildDate><generator>cnblogs</generator><item><title>Re:2.6.7 用NPOI操作EXCEL－－数据有效性</title><link>http://www.cnblogs.com/atao/archive/2010/07/16/1572170.html#1872617</link><dc:creator>david.dai</dc:creator><author>david.dai</author><pubDate>Fri, 16 Jul 2010 02:51:31 GMT</pubDate><guid>http://www.cnblogs.com/atao/archive/2010/07/16/1572170.html#1872617</guid><description><![CDATA[dataValidate1.CreateErrorBox(&quot;error&quot;, &quot;你必须输入一个日期数据&quot;);  //这里的提示信息不支持中文<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/atao/" target="_blank">david.dai</a> 2010-07-16 10:51 <a href="http://www.cnblogs.com/atao/archive/2010/07/16/1572170.html#1872617#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:2.6.2 用NPOI操作EXCEL－－设置密码</title><link>http://www.cnblogs.com/atao/archive/2010/07/13/1568917.html#1870435</link><dc:creator>星际</dc:creator><author>星际</author><pubDate>Tue, 13 Jul 2010 06:52:59 GMT</pubDate><guid>http://www.cnblogs.com/atao/archive/2010/07/13/1568917.html#1870435</guid><description><![CDATA[楼主你好，现在我遇到一个问题，我整份Excel都是锁定的，现在通过从xls创建新的excel后，会插入一些行，这些行，每个cell都设置了islocked属性，将有些栏位打开可以让用户填写，但是，最终效果是，有几个我没有打开的栏位，用户也可以填写了，不知道为什么？<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/atao/" target="_blank">星际</a> 2010-07-13 14:52 <a href="http://www.cnblogs.com/atao/archive/2010/07/13/1568917.html#1870435#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:2.6.7 用NPOI操作EXCEL－－数据有效性</title><link>http://www.cnblogs.com/atao/archive/2010/07/01/1572170.html#1861346</link><dc:creator>jasonlu</dc:creator><author>jasonlu</author><pubDate>Thu, 01 Jul 2010 03:54:09 GMT</pubDate><guid>http://www.cnblogs.com/atao/archive/2010/07/01/1572170.html#1861346</guid><description><![CDATA[怎么设置decimal限制？<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/atao/" target="_blank">jasonlu</a> 2010-07-01 11:54 <a href="http://www.cnblogs.com/atao/archive/2010/07/01/1572170.html#1861346#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:ASP.NET性能优化（一）压缩你的网页</title><link>http://www.cnblogs.com/atao/archive/2010/06/23/1605694.html#1854795</link><dc:creator>Billy He</dc:creator><author>Billy He</author><pubDate>Wed, 23 Jun 2010 08:03:34 GMT</pubDate><guid>http://www.cnblogs.com/atao/archive/2010/06/23/1605694.html#1854795</guid><description><![CDATA[学习<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/atao/" target="_blank">Billy He</a> 2010-06-23 16:03 <a href="http://www.cnblogs.com/atao/archive/2010/06/23/1605694.html#1854795#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:2.6.8 用NPOI操作EXCEL－－生成下拉列表</title><link>http://www.cnblogs.com/atao/archive/2010/06/21/1572980.html#1852360</link><dc:creator>清凉一夏</dc:creator><author>清凉一夏</author><pubDate>Mon, 21 Jun 2010 06:14:11 GMT</pubDate><guid>http://www.cnblogs.com/atao/archive/2010/06/21/1572980.html#1852360</guid><description><![CDATA[上面：
------------------------------------------------
HSSFName range = hssfworkbook.CreateName();
range.Reference = &quot;ShtDictionary![b]$A1:$A3[/b]&quot;;
range.NameName = &quot;dicRange&quot;;
------------------------------------------------
应该改成
------------------------------------------------
HSSFName range = hssfworkbook.CreateName();
range.Reference = &quot;ShtDictionary![b]$A$1:$A$3[/b]&quot;;
range.NameName = &quot;dicRange&quot;;
------------------------------------------------
否则，可能不是您想要的结果！<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/atao/" target="_blank">清凉一夏</a> 2010-06-21 14:14 <a href="http://www.cnblogs.com/atao/archive/2010/06/21/1572980.html#1852360#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:最佳Excel导入实践（五）</title><link>http://www.cnblogs.com/atao/archive/2010/06/12/1589305.html#1846423</link><dc:creator>清凉一夏</dc:creator><author>清凉一夏</author><pubDate>Sat, 12 Jun 2010 03:52:36 GMT</pubDate><guid>http://www.cnblogs.com/atao/archive/2010/06/12/1589305.html#1846423</guid><description><![CDATA[我导出的xls文件，用office 2007更新后，就不能读取了。
出现如下异常：
Initialisation of record 0x862 left 2 bytes remaining still to be read.
我用的NPOI 1.2.2 for .NET 2.0 版的。
大家还没有比这个更新的版本。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/atao/" target="_blank">清凉一夏</a> 2010-06-12 11:52 <a href="http://www.cnblogs.com/atao/archive/2010/06/12/1589305.html#1846423#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:NPOI 1.2教程（目录）</title><link>http://www.cnblogs.com/atao/archive/2010/03/30/1603528.html#1790574</link><dc:creator>jww</dc:creator><author>jww</author><pubDate>Tue, 30 Mar 2010 09:51:30 GMT</pubDate><guid>http://www.cnblogs.com/atao/archive/2010/03/30/1603528.html#1790574</guid><description><![CDATA[[IOException: Invalid header signature; Read 7888090397404325948, expected -2226271756974174256]
   NPOI.POIFS.Storage.HeaderBlockReader..ctor(Stream stream) +739
   NPOI.POIFS.FileSystem.POIFSFileSystem..ctor(Stream stream) +74
   NPOI.HSSF.UserModel.HSSFWorkbook..ctor(Stream s) +31

导入时报这个错，用excel 2003开个文件正常的，很奇怪<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/atao/" target="_blank">jww</a> 2010-03-30 17:51 <a href="http://www.cnblogs.com/atao/archive/2010/03/30/1603528.html#1790574#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:NPOI 1.2教程（目录）</title><link>http://www.cnblogs.com/atao/archive/2010/03/07/1603528.html#1775446</link><dc:creator>励冰</dc:creator><author>励冰</author><pubDate>Sun, 07 Mar 2010 10:28:00 GMT</pubDate><guid>http://www.cnblogs.com/atao/archive/2010/03/07/1603528.html#1775446</guid><description><![CDATA[弄个插入行，插入列，复制行的实例吧。
这个用得最多了。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/atao/" target="_blank">励冰</a> 2010-03-07 18:28 <a href="http://www.cnblogs.com/atao/archive/2010/03/07/1603528.html#1775446#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:2.4.5 用NPOI操作EXCEL－－插入图片</title><link>http://www.cnblogs.com/atao/archive/2010/01/21/1576044.html#1751674</link><dc:creator>吴某</dc:creator><author>吴某</author><pubDate>Thu, 21 Jan 2010 10:54:09 GMT</pubDate><guid>http://www.cnblogs.com/atao/archive/2010/01/21/1576044.html#1751674</guid><description><![CDATA[博主你好~~我最近在用NPOI，发现非常好用，但是我遇到个问题，就是插入图片的时候怎样能对插入位置进行微调呢，虽然能指定到某个单元格内，但是假如无需要偏离一点哪要怎样设置呢~~<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/atao/" target="_blank">吴某</a> 2010-01-21 18:54 <a href="http://www.cnblogs.com/atao/archive/2010/01/21/1576044.html#1751674#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:NPOI 1.2教程（目录）</title><link>http://www.cnblogs.com/atao/archive/2009/12/02/1603528.html#1712393</link><dc:creator>Tony  Qu</dc:creator><author>Tony  Qu</author><pubDate>Tue, 01 Dec 2009 22:50:49 GMT</pubDate><guid>http://www.cnblogs.com/atao/archive/2009/12/02/1603528.html#1712393</guid><description><![CDATA[NPOI QQ交流群:  78142590

atao:
把这个加到这篇文章头上去，谢谢<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/atao/" target="_blank">Tony  Qu</a> 2009-12-02 06:50 <a href="http://www.cnblogs.com/atao/archive/2009/12/02/1603528.html#1712393#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>
