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,¾Í¿ÉÒÔ½âÕâ¸öÎÊÌâÁË!
Ïà¹ØÎĵµ£º
ǰһ¶Îʱ¼äÊÔ×ÅÓÃÕâÈýÖÖÓïÑÔ¼òµ¥µÄдÁ˹ØÓÚÎļþ¿½±´µÄ³ÌÐò£¬·¢ÏÖc#ºÍpythonµÄapi¾ªÈ˵ÄÏàËÆ£¬¶ÔÓÚÎļþµÄ²Ù×÷ÕâÁ½ÖÖÓïÑԷdz£µÄ·½±ã¡£¶¼Ã»ÓмÓÒì³£µÄ´¦Àí
C#Ô´´úÂ룺
public static void CopyFile(string source, string destination)
& ......
Ò»¡¢ÈÏʶWeb.configÎļþ
Web.config ÎļþÊÇÒ»¸öXMLÎı¾Îļþ£¬ËüÓÃÀ´´¢´æ ASP.NET Web Ó¦ÓóÌÐòµÄÅäÖÃÐÅÏ¢£¨Èç×î³£ÓõÄÉèÖÃASP.NET Web Ó¦ÓóÌÐòµÄÉí·ÝÑéÖ¤·½Ê½£©£¬Ëü¿ÉÒÔ³öÏÖÔÚÓ¦ÓóÌÐòµÄÿһ¸öĿ¼ÖС£µ±Äãͨ¹ý.NETн¨Ò»¸öWebÓ¦ÓóÌÐòºó£¬Ä¬ÈÏÇé¿öÏ»áÔÚ¸ùĿ¼×Ô¶¯´´½¨Ò»¸öĬÈϵÄWeb.configÎļþ£¬°üÀ¨Ä¬ÈÏ ......
1.ÈçºÎÔÚJavaScript·ÃÎÊC#º¯Êý?
ÎÊÌâ1´ð°¸ÈçÏ£º
javaScriptº¯ÊýÖÐÖ´ÐÐC#´úÂëÖеĺ¯Êý£º
·½·¨Ò»£º1¡¢Ê×ÏȽ¨Á¢Ò»¸ö°´Å¥£¬ÔÚºǫ́½«µ÷Óûò´¦ÀíµÄÄÚÈÝдÈëbutton_clickÖÐ;
2¡¢ÔÚǰ̨дһ¸öjsº¯Êý£¬ÄÚÈÝΪdocument.getElementById("btn1").click();
......
´´½¨Ò»¸öWinformÓû§¿Ø¼þ UserControl1
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Text;
using System.Windows.Forms;
using System.Runtime.InteropServices;
using System.Reflection;
namespace MyActiveT ......
XmlDocument doc = new XmlDocument();
XmlDeclaration dec = doc.CreateXmlDeclaration("1.0", "GB2312", null);
doc.AppendChild(dec);
//´´½¨Ò»¸ö¸ù½Úµã£¨Ò»¼¶£©
XmlElement root = doc.CreateElement("First");
doc.AppendChild(root);
//´´½¨½Úµã£ ......