Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

asp.netµÄcom·½Ê½µ¼³öexcel

×î½ü×ö¸öÏîÄ¿£¬ÐèÒªµ¼³öexcel£¬ÒªÖ÷´Ó±íÒ»Æðµ¼³öµÄ£¬¾Í´óÖÂдÁËÒ»¸ö·½·¨£¬¿ÉÄܸñʽ·½Ã滹ÊÇ»á½øÐÐÐ޸ģ¬ÏÈÌù³öÀ´·½±ãÒÔºó²é¿´
ÏîÄ¿ÒýÓÃ΢ÈíexcelµÄcomµÄdll¼´¿É
/// <summary>
/// ¹¦ÄÜ£ºµ¼³öÎļþ£¨Í¨¹ýÊý¾ÝÔ´µ¼³ö,¿ÉÖ÷´Ó±íµ¼³ö£©
/// </summary>
/// <param name="strTitle">ÎļþÃû×Ö</param>
/// <param name="mainDT">Ö÷±íÊý¾ÝÔ´</param>
/// <param name="dtParams">´Ó±íÊý¾ÝÔ´¼¯ºÏ</param>
public static void Export(string strTitle, System.Data.DataTable mainDT, params System.Data.DataTable[] dtParams)
{
GC.Collect();
Application oApp = new Application();
Workbooks oBooks = oApp.Workbooks;
Workbook oBook = oBooks.Add(true);
Worksheet oSheet = (Worksheet)oBook.ActiveSheet;
int _rowIndex = 4;//ÐÐË÷Òý
int _cellIndex = 1;//ÁÐË÷Òý
int _maxCellIndex = 1;//×î´óÁÐË÷Òý
int _mainRowIndex = 4;//Ö÷±íÐÐË÷Òý
//»æÖƱêÌâ
oSheet.Cells[2, 2] = strTitle;
//»æÖÆÖ÷±íÊý¾Ý
foreach (DataColumn col in mainDT.Columns)
{
_cellIndex++;
//ÉèÖÃÒ»ÐÐÁ½ÁÐ
if (_cellIndex > 17)
{
_rowIndex++;
_cellIndex = 2;
}
oSheet.Cells[_rowIndex, _cellIndex] = col.ColumnName+":";
oSheet.get_Range(oSheet.Cells[_rowIndex, _cellIndex], oSheet.Cells[_rowIndex, _cellIndex + 2]).Select();
oSheet.get_Range(oSheet.Cells[_rowIndex, _cellIndex], oSheet.Cells[_rowIndex, _cellIndex + 2]).HorizontalAlignment = XlHAlign.xlHAlignCenterAcrossSelection;
_cellIndex = _cellIndex + 3;
if (col.DataType == System.Type.GetType("System.DateTime"))// ÈÕÆÚ¸ñʽ
{
oSheet.Cells[_rowIndex, _cellIndex] =Convert.ToDateTime(mainDT.R


Ïà¹ØÎĵµ£º

ASP.net¿ª·¢ÏµÁÐÖ®¿ªÆª

²¿ÃÅÒª×öÒ»¸öÍøÕ¾£¬ÎÒÒÔǰÓõÄÊÇphp»òasp×öµÄ£¬Õâ»ØÏë¸ÄÓÃasp.net×ö£¬Ö÷Òª»ùÓÚÁ½µã¿¼ÂÇ£¬µÚÒ»£ºÏëͨ¹ýasp.netѧϰc#¼°Æä.net¿ò¼Ü¡£µÚ¶þ£º×Ô¼ºÓÖÏë͵ÀÁ£¬²»Ïë´ÓÍ·¿ªÊ¼×öÍøÕ¾£¬ÓÚÊǾÍÏëÓÿªÔ´µÄnetcmsÀ´¸Ä¸Ä¡£ÓÚÊÇÓÐÁËÎÒµÄϵÁÐÎÄÕ¡£¸ù¾ÝÎÒµÄѧϰ½ø¶ÈÎÒ»áÿÌì¸üУ¬ÇëÅóÓÑÃǹØ×¢¡£ ......

ASP.NET MVCСÂÛ

ǰÑÔ
      ASP.NET MVC×÷Ϊ΢Èí¹Ù·½µÄ.NETƽ̨ÏÂMVC½â¾ö·½°¸£¬×Ôµ®ÉúÆð¾ÍÎüÒýÁËÖÚ¶à.NETƽ̨¿ª·¢ÈËÔ±µÄÑÛÇò¡£ÔÚ¾­ÀúÁËÂþ³¤Previewºó£¬ÉϸöÔÂ΢ÈíÖÕÓÚ·¢²¼ÁËÆäbeta°æ¡£Ó¦¸Ã˵£¬Í¨¹ýÎÒÇ×Éíʵ¼ù£¬ÎÒÈÏΪÕâ¸ö¿ò¼ÜµÄÉè¼Æ»¹ÊÇÏ൱ÓÅÐãµÄ£¬ÖÁÉÙ´ÓÒ×ÓÃÐÔÀ´Ëµ£¬ASP.NET MVCÒªÓÅÓÚJavaƽ̨ÉϵÄStrutsºÍStr ......

ÐÂÊÖÈçºÎѧϰc#¡¢asp.net¡¢ado.netºÍ.NET

ÐÂÊÖÈçºÎѧϰc#¡¢asp.net¡¢ado.netºÍ.NET
   Èç¹ûÄãÒѾ­Óн϶àµÄÃæÏò¶ÔÏ󿪷¢¾­Ñé£¬Ìø¹ýÒÔÏÂÕâÁ½²½£º
   µÚÒ»²½¡¡ÕÆÎÕÒ»ÃÅ.NETÃæÏò¶ÔÏóÓïÑÔ£¬C££»òVB.NET¡£
   ÔÚûϵͳѧ¹ýÒ»ÃÅÃæÏò¶ÔÏó£¨OO£©ÓïÑÔµÄǰÌáÏÂȥѧASP.NET¡£
   ASP.NETÊÇÒ»¸öÈ«ÃæÏò¶ÔÏóµÄ¼¼Êõ£¬²»¶®OO£¬ÄǾø¶Ôѧ ......

ASP.NET»­ÃæÌø×ªÊµÏÖ¼°Æä´«ÖµÎÊÌâ½â¾ö·½°¸


±¾ÎĽéÉÜÁËASP.NET»­ÃæÌø×ªµÄʵÏÖÒÔ¼°Æä´«ÖµÎÊÌâµÄ½â¾ö·½°¸¡£»­ÃæÌø×ªºÍ´«ÖµÎÊÌ⣬һֱÒÔÀ´¶¼ÔÚÀ§ÈÅןոսӴ¥asp.net webÓ¦ÓóÌÐòµÄ¿ª·¢Õߣ¬Ï£Íû±¾ÎÄÄܶԳõѧÕßÃÇÓÐËù°ïÖú¡£
»­ÃæÌø×ªºÍ´«ÖµÎÊÌ⣬һֱÒÔÀ´¶¼ÔÚÀ§ÈÅןոսӴ¥asp.net webÓ¦ÓóÌÐòµÄ¿ª·¢Õߣ¬ÏÖÂÞÁÐÌø×ª·½·¨ºÍ´«Öµ·½Ê½¹©´ó¼Ò²Î¿¼£»ÒòΪÎÒ±¾Éí²ÎÓëµÄÏîÄ¿¹¦Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ