| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> c# >> C# jiang DateTable biao shu ju dao chu dao Excel zhong

C# jiang DateTable biao shu ju dao chu dao Excel zhong

2008-10-25 09:18:33 编辑來源:互联网 评论
 
 
 
本文为【C#将DateTable表数据导出到Excel中】的拼音翻译版
  zai Visual C# zhong tiao yong Excel biao ge , bing bu xiang du qu Excel biao ge zhong de shu ju na me rong yi le , yin wei zai Visual C# zhong tiao yong Excel biao ge yao shi yong dao Excel de COM zu jian 。 yi VS2005 wei li , shou xian tian jia yin yong -- zai COM xuan xiang zhong , tian jia Microsfot Excel 11.0 Objet Library。
  ran hou zai cheng xu zhong yin ru ming ming kong jian ,Using Microsoft.Office.Interop.Excel;
  yi xia mian ji tiao yu ju lai jie shao yi ge Excel lei zhong de ji ge dui xiang 。
  // shi li hua yi ge Excel ying yong cheng xu dui xiang
   Microsoft.Office.Interop.Excel.Application myexcel = new Microsoft.Office.Interop.Excel.Application();
   // tian jia gong zuo biao
   myexcel.Application.Workbooks.Add(true);
   Microsoft.Office.Interop.Excel.Worksheet myworksheet = (Microsoft.Office.Interop.Excel.Worksheet) myexcel.Worksheets["Sheet1"];
   // ding yi yi ge qu yu fan wei
   Microsoft.Office.Interop.Excel.Range myrange = myexcel.get_Range(myexcel.Cells[1, 1], myexcel.Cells[3, 3]);
   // xian shi zhe ge excel cheng xu
   myexcel.Visible = true ;
  dan ci shi de Excel biao ge shi yi ge kong de biao ge , mei you ren he nei rong , xia mian jiu lai jie shao ru he wang Excel biao ge zhong shu ru shu ju 。
  (3). wang Excel biao ge zhong shu ru shu ju :
  zai ming ming kong jian "Excel" zhong , huan ding yi le yi ge lei "Cell", zhe ge lei suo dai biao de jiu shi Excel biao ge zhong de yi ge xia dan yuan 。 tong guo gei cha "Cell" fu zhi , cong er shi xian wang Excel biao ge zhong shu ru xiang ying de shu ju , xia lie dai ma gong neng shi da kai Excel biao ge , bing qie wang biao ge shu ru yi xie shu ju 。
   myexcel.Caption = " hua ming ce ";
   myworksheet .Cells[1, 1] = " hua ming ce ";
   myworksheet .Cells[2, 1] = " xing ming ";
   (4). Visual C# tiao yong Excel biao ge ,
  le jie le shang mian de zhe xie zhi shi , de dao wan cheng shang shu gong neng de cheng xu dai ma jiu xian de bi jiao rong yi le , han shu ju ti ru xia :
   Excel.ApplicationClass Mylxls = new Excel.ApplicationClass();
   Mylxls.Application.Workbooks.Add(true);
   myexcel.Caption = " hua ming ce ";
   myworksheet .Cells[1, 1] = " hua ming ce ";
   myworksheet .Cells[2, 1] = " xing ming ";
   myworksheet .Cells[2, 2] = " xing bie ";
   myworksheet .Cells[2, 3] = " chu sheng nian yue ";
   // he bing dan yuan ge ( di yi xing de di yi lie zhi di 3 lie )
   myworksheet .get_Range(myworksheet .Cells[1, 1], myworksheet .Cells[1, 3]).MergeCells = true;
   // zhu xing xie ru shu ju ,dt wei DataTable dui xiang , cong di san xing kai shi xie shu ju 。
  int i=3;
   foreach(DataRow row in dt.Rows)
   {
   myworksheet .Cells[i, 1] = row[" xing ming "].ToString();
   myworksheet .Cells[i, 2] = row[" xing bie "].ToString();
   myworksheet .Cells[i, 3] = row[" chu sheng nian yue "].ToString();
   i++;
   }【原文】【汉音对照
 
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
   zai Visual C# zhong tiao yong Excel biao ge , bing bu xiang du qu Excel biao ge zhong de shu ju na me rong yi le , yin wei zai Visual C# zhong tiao yong Excel biao ge yao shi yong dao Excel de COM zu jian 。 yi VS2005 wei li , shou xian tian jia yin yong -- zai COM xuan xiang zhong , tian jia Microsfot Excel 11.0 Objet Library。    ran hou zai cheng xu zhong yin ru ming ming kong jian ,Using Microsoft.Office.Interop.Excel;    yi xia mian ji tiao yu ju lai jie shao yi ge Excel lei zhong de ji ge dui xiang 。   // shi li hua yi ge Excel ying yong cheng xu dui xiang Microsoft.Office.Interop.Excel.Application myexcel = new Microsoft.Office.Interop.Excel.Application(); // tian jia gong zuo biao myexcel.Application.Workbooks.Add(true); Microsoft.Office.Interop.Excel.Worksheet myworksheet = (Microsoft.Office.Interop.Excel.Worksheet) myexcel.Worksheets["Sheet1"]; // ding yi yi ge qu yu fan wei Microsoft.Office.Interop.Excel.Range myrange = myexcel.get_Range(myexcel.Cells[1, 1], myexcel.Cells[3, 3]); // xian shi zhe ge excel cheng xu myexcel.Visible = true ;    dan ci shi de Excel biao ge shi yi ge kong de biao ge , mei you ren he nei rong , xia mian jiu lai jie shao ru he wang Excel biao ge zhong shu ru shu ju 。   (3). wang Excel biao ge zhong shu ru shu ju :    zai ming ming kong jian "Excel" zhong , huan ding yi le yi ge lei "Cell", zhe ge lei suo dai biao de jiu shi Excel biao ge zhong de yi ge xia dan yuan 。 tong guo gei cha "Cell" fu zhi , cong er shi xian wang Excel biao ge zhong shu ru xiang ying de shu ju , xia lie dai ma gong neng shi da kai Excel biao ge , bing qie wang biao ge shu ru yi xie shu ju 。 myexcel.Caption = "    hua ming ce "; myworksheet .Cells[1, 1] = "   hua ming ce "; myworksheet .Cells[2, 1] = " xing ming "; (4). Visual C# tiao yong Excel biao ge ,    le jie le shang mian de zhe xie zhi shi , de dao wan cheng shang shu gong neng de cheng xu dai ma jiu xian de bi jiao rong yi le , han shu ju ti ru xia : Excel.ApplicationClass Mylxls = new Excel.ApplicationClass(); Mylxls.Application.Workbooks.Add(true); myexcel.Caption = "    hua ming ce "; myworksheet .Cells[1, 1] = "   hua ming ce "; myworksheet .Cells[2, 1] = " xing ming "; myworksheet .Cells[2, 2] = " xing bie "; myworksheet .Cells[2, 3] = " chu sheng nian yue "; // he bing dan yuan ge ( di yi xing de di yi lie zhi di 3 lie ) myworksheet .get_Range(myworksheet .Cells[1, 1], myworksheet .Cells[1, 3]).MergeCells = true; // zhu xing xie ru shu ju ,dt wei DataTable dui xiang , cong di san xing kai shi xie shu ju 。      int i=3; foreach(DataRow row in dt.Rows) { myworksheet .Cells[i, 1] = row[" xing ming "].ToString(); myworksheet .Cells[i, 2] = row[" xing bie "].ToString(); myworksheet .Cells[i, 3] = row[" chu sheng nian yue "].ToString(); i++; }
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
可爱小魔女
夏日小桃红
琦吖囡半熟乖巧清新写真
天使的微笑
痞子的甘南日记
疑是银河落九天
雪域坝上四——纯美色
冬日恋歌——西城杨柳弄轻柔
 
>>返回首页<<
 
 
 为你推荐
 
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
 
©2005- 王朝网络 版权所有