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 ¿Ø¼þ¡ ......
// °´Ä£°æ±ÈÀýÉú³ÉËõÂÔͼ£¨ÒÔÁ÷µÄ·½Ê½»ñȡԴÎļþ£©
//Éú³ÉËõÂÔͼº¯Êý
//˳Ðò²ÎÊý£ºÔ´Í¼ÎļþÁ÷¡¢ËõÂÔͼ´æ·ÅµØÖ·¡¢Ä£°æ¿í¡¢Ä£°æ¸ß
//×¢£ºËõÂÔͼ´óС¿ØÖÆÔÚÄ£°æÇøÓòÄÚ
public static void MakeSmallImg(System.IO.Stream fromFileStream,string fileSaveUrl,System.Double templateWidth,System.Double templateHeight)
{ ......
ĬÈÏÇé¿öÏ£¬ASP.NET ÍøÕ¾µ¼º½Ê¹ÓÃÒ»¸öÃûΪ Web.sitemap µÄ XML Îļþ£¬¸ÃÎļþÃèÊöÍøÕ¾µÄ²ã´Î½á¹¹¡£µ«ÊÇ£¬Äú¿ÉÄÜҪʹÓöà¸öÕ¾µãµØÍ¼Îļþ»òÕ¾µãµØÍ¼Ìṩ³ÌÐòÀ´ÃèÊöÕû¸öÍøÕ¾µÄµ¼º½½á¹¹¡£
ÀýÈ磬Äú¿ÉÒÔ¾ßÓÐÒýÓÃ×ÓÕ¾µãµØÍ¼µÄÖ÷Õ¾µãµØÍ¼¡£Ö÷Õ¾µãµØÍ¼¿ÉÒÔÊÇ£º
<?xml version="1.0" encoding ......
¼ò½é
¡¡¡¡Cookie Ϊ Web Ó¦ÓóÌÐò±£´æÓû§Ïà¹ØÐÅÏ¢ÌṩÁËÒ»ÖÖÓÐÓõķ½·¨¡£ÀýÈ磬µ±Óû§·ÃÎÊÄúµÄÕ¾µãʱ£¬Äú¿ÉÒÔÀûÓà Cookie ±£´æÓû§Ê×Ñ¡Ïî»òÆäËûÐÅÏ¢£¬ÕâÑù£¬µ±Óû§Ï´ÎÔÙ·ÃÎÊÄúµÄÕ¾µãʱ£¬Ó¦ÓóÌÐò¾Í¿ÉÒÔ¼ìË÷ÒÔǰ±£´æµÄÐÅÏ¢¡£
¡¡¡¡±¾ÎĸÅÒª½éÉÜ Cookie ÔÚ ASP.NET Ó¦ÓóÌÐòÖеÄÓ¦Óã¬ÎªÄúչʾÔÚ ASP.NET ÖÐÓ¦Óà Cookie ......
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
  ......