c#²Ù×÷Excel һЩÎÊÌâ ×Ö·û±äΪnull½â¾ö·½·¨
C#¶ÁÈ¡ExcelÓöµ½ÎÞ·¨¶ÁÈ¡µÄ½â¾ö·½·¨£º
1.ÔÚµ¼ÈëÊý¾ÝÁ¬½Ó×Ö·û´®ÖУ¬½«IMEX=1¼ÓÈ룬“Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Data.xls";Extended Properties="Excel 8.0;HDR=Yes;IMEX=1; ”£¬ÕâÑù¾Í¿ÉÒÔ¡£
C#¶ÁÈ¡ExcelÐèҪעÒâµÄ£º
IMEX=1£º»ìºÏģʽ
HDR=Yes; ÊÇ·ñÈõÚÒ»ÐÐ×÷ΪÁÐÍ·
Á½Õß±ØÐëÒ»ÆðʹÓá£
±¾ÒÔΪÕâÑù¾ÍOKÁË¡£
µ«ÔÚʵ¼ÊʹÓùý³ÌÖУ¬ÕâÑùÉèÖû¹ÊDz»ÐУ¬²éÔÄÁ˲»ÉÙ×ÊÁϲŷ¢ÏÖ£¬ÔÀ´»¹ÓÐÒ»¸ö×¢²á±íÀïµÄÐÅÏ¢ÐèÒªÐ޸ģ¬
ÕâÑù´øÄÜÈÃexcel²»ÔÙʹÓÃǰ8ÐеÄÄÚÈÝÀ´È·¶¨¸ÃÁеÄÀàÐÍ¡£
C#¶ÁÈ¡ExcelÖ®×¢²á±íÐÞ¸ÄÄÚÈÝÈçÏ£º
ÔÚHKLM\Software\Microsoft\Jet\4.0\Engines\ExcelÓÐÒ»¸öTypeGuessRowsÖµ,Ô¤ÉèÊÇ8,±íʾ»áÏȶÁȡǰ8ÁÐÀ´¾ö¶¨Ã¿Ò»¸öÀ¸Î»µÄÐÍ̬,ËùÒÔÈç¹ûǰ8ÁеÄ×ÊÁ϶¼ÊÇÊý×Ö,µ½Á˵Ú9ÁÐÒÔºó³öÏÖµÄÎÄ×Ö×ÊÁ϶¼»á±ä³Énull,ËùÒÔÈç¹ûÒª½â¾öÕâ¸öÎÊÌâ,Ö»Òª°ÑTypeGuessRows»úÂëÖµ¸Ä³É0,¾Í¿ÉÒÔ½âÕâ¸öÎÊÌâÁË!
Ïà¹ØÎĵµ£º
MSSQL:
declare @begin datetime
declare @End datetime
set @begin=getdate()
--Ö´ÐеÄÓï¾äдÔÚÕâÀï
set @End=getdate()
select datediff(millisecond,@begin,@End) as Ö´ÐеÄʱ¼ä
--millisecond±íʾºÁÃë Èç¹û¿´Ãë¿ÉÒÔʹÓÃss
C#:
ºÜ¶àʱº ......
Ò»¡¢ÈÏʶWeb.configÎļþ
Web.config ÎļþÊÇÒ»¸öXMLÎı¾Îļþ£¬ËüÓÃÀ´´¢´æ ASP.NET Web Ó¦ÓóÌÐòµÄÅäÖÃÐÅÏ¢£¨Èç×î³£ÓõÄÉèÖÃASP.NET Web Ó¦ÓóÌÐòµÄÉí·ÝÑéÖ¤·½Ê½£©£¬Ëü¿ÉÒÔ³öÏÖÔÚÓ¦ÓóÌÐòµÄÿһ¸öĿ¼ÖС£µ±Äãͨ¹ý.NETн¨Ò»¸öWebÓ¦ÓóÌÐòºó£¬Ä¬ÈÏÇé¿öÏ»áÔÚ¸ùĿ¼×Ô¶¯´´½¨Ò»¸öĬÈϵÄWeb.configÎļþ£¬°üÀ¨Ä¬ÈÏ ......
ͨ¹ýxslת»»´óxmlÎļþ
Õ⼸ÌìÔÚ×öÕâ¸ö£¬ÍøÉϵö·½·¨ÎÒ¶¼ÊÔ¹ýÁË£¬»ã×ÜÈçÏÂ
·½·¨Ò»£º
XPathDocument myXPathDoc = new XPathDocument(tbXMLFile.Text);
XslCompiledTransform myXslTrans = new XslCompiledTransform();
myXslTrans.Load(tbXSLFile.Text);
XmlTextWriter myWriter = new XmlTextWrit ......
¡¡¡¡´ó¼ÒÔÚʵ¼Ê¹¤×÷ѧϰC#µÄʱºò£¬¿ÉÄÜ»áÎÊ£ºÎªÊ²Ã´ÎÒÃÇҪΪһЩÒѾ´æÔڵŦÄÜ£¨±ÈÈçWindowsÖеÄһЩ¹¦ÄÜ£¬C++ÖÐÒѾ±àдºÃµÄһЩ·½·¨£©ÒªÖØÐ±àд´úÂ룬C#ÓÐûÓз½·¨¿ÉÒÔÖ±½Ó¶¼ÓÃÕâЩԱ¾ÒѾ´æÔڵŦÄÜÄØ£¿´ð°¸Êǿ϶¨µÄ£¬´ó¼Ò¿ÉÒÔͨ¹ýC#ÖеÄDllImportÖ±½Óµ÷ÓÃÕâЩ¹¦ÄÜ¡£
¡¡¡¡DllImportËùÔÚµÄÃû×Ö¿Õ¼ä using System.Runt ......