asp.netÖдò¿ªExcelÉÏ´«Îļþ,¶ÁÈ¡Êý¾ÝµÄ·½·¨
´úÂë:
/// <summary>
/// ´ò¿ªExcelÎļþ
/// </summary>
/// <param name="ExcelFileName">ÎļþÃû</param>
private void OpenExcelFile(string ExcelFileName)
{
Excel.Application App = new Excel.Application();
if (App == null)
{
return; //ExcelÉÐδ°²×°
}
Excel.Workbook workbook = App.Workbooks.Open(@ExcelFileName,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing);
CultureInfo CurrentCI = System.Threading.Thread.CurrentThread.CurrentCulture;
try
{
App.Visible = false;
App.DisplayAlerts = false;
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
ProcessExcelData(workbook);
}
finally
{
App.
Ïà¹ØÎĵµ£º
¿Éͨ¹ý½« XmlDataSource ¿Ø¼þµÄ XPath ÊôÐÔÉèÖÃΪ XPath ɸѡ±í´ïʽ£¬À´É¸Ñ¡¸Ã¿Ø¼þ¹«¿ªµÄ XML Êý¾Ý¡£Èç¹ûÒÑÖ¸¶¨¿ÉÀ©Õ¹Ñùʽ±íÓïÑÔ (XSL) Ñùʽ±íÀ´×ª»» XmlDataSource ¿Ø¼þ¹«¿ªµÄÊý¾Ý£¬ÔòÔÚת»»ºó»áÓ¦Óà XPath ɸѡ±í´ïʽ¡£
ÏÂÃæµÄ´úÂëʾÀýÑÝʾ°ó¶¨µ½ TreeView ¿Ø¼þµÄ XmlDataSource ¿Ø¼þ¡ ......
TreeView Web ·þÎñÆ÷¿Ø¼þÌṩÁ˼¸¸ö¿É½øÐбà³ÌµÄʼþ¡£ÕâʹÄúÄܹ»ÔÚ·¢ÉúʼþʱÔËÐÐ×Ô¶¨ÒåÀý³Ì¡£
Ò»¡¢Ê¼þ
Ö»ÓÐÓû§Í¨¹ýһЩ²Ù×÷£¨ÈçÑ¡Ôñ¡¢Õ¹¿ª»òÕÛµþ½Úµã£©Óë¿Ø¼þ½»»¥Ê±£¬²Å»áÒý·¢ TreeView ¿Ø¼þʼþ¡£Èç¹ûÒÔ±à³Ì·½Ê½µ÷ÓÃÑ¡Ôñ¡¢Õ¹¿ª»òÕÛµþ·½·¨£ ......
ʹÓà ASP.NET TreeView ¿Ø¼þ¿ÉÒÔÇáËɵذ󶨵½Ö§³Ö IHierarchicalDataSource ½Ó¿ÚµÄÊý¾ÝÔ´£¬ÀýÈ磺XmlDataSource ÀàºÍ SiteMapDataSource Àà¡£´ËÍ⣬Äú»¹¿ÉÒÔÍêÈ«¿ØÖƽ«Êý¾ÝÔ´µÄÄÄЩ×Ö¶ÎÓÃÓÚ Text¡¢Value ºÍÆäËû TreeNode ÊôÐÔ¡£
Ò»¡¢°ó¶¨µ½ XML Îļþ
TreeView ¿Ø¼þÖ§³Öµ½ XML ......
±¨´íÐÅÏ¢ÈçÏ£º
¼ìË÷ COM À๤³§ÖÐ CLSID Ϊ {00024500-0000-0000-C000-000000000046} µÄ×é¼þʱʧ°Ü£¬ÔÒòÊdzöÏÖÒÔÏ´íÎó: 80070005¡£
ÍøÉÏÕÒÌù½â¾öÈçÏ£¬×ªÌù×÷¼Ç~~
ת×Ô£ºhttp://blog.csdn.net/happy_ddm/archive/2007/07/09/1683207.aspx
½â¾ö·½·¨£º
ÔÚDCOM×é¼þ·þÎñÖиøMICROSOFT.EXCEL×é¼þ¸³ÓèASP.NETµÄ²Ù×÷ȨÏÞ£¬ ......