C#数据导出器

最新推荐文章于 2021-09-23 09:23:49 发布
最新推荐文章于 2021-09-23 09:23:49 发布
阅读量1.8k 收藏 3
点赞数
分类专栏： C#.Net 精华文章 文章标签： c# path dataset string excel object
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/juejue1984/article/details/1548900
版权

      看到网上不少介绍有关数据导出的方法，但是总显得凌乱、琐碎，用起来也很不爽。索性一起收集起来，整合到一块。 下面介绍一个整合导出到word、excel、text的导出控件，具体做法是用一个扩展的按钮固化上一个菜单及其事件，程序员需要做的仅仅是赋予此控件一个DataTable类型的属性实例。

    以下初始资源均来自网上，本人代为整合和优化，如有错误，欢迎来信批评。

  

 

using System;

using System.Windows.Forms;

using System.ComponentModel;

using System.Data;

using System.Drawing;

namespace JueJue2007

{

       /**

        * Author: Liu Juejue

        * Date:     2007-3-9

        * Description: Export the data to word or excel or txt file.

        * Copyleft: Liu Juejue

        **/

       /// <summary>

       /// 导出数据到Word、Excel、Text

       /// </summary>

       public class ExporterButton : MyXPButton

       {     

              public ExporterButton()

              {

                     this.InitializeComponent();

              }

 

              #region 字段

              //菜单

              private ContextMenu contextMenu1;

              private MenuItem menuItem2;

              private MenuItem menuItem3;

              private MenuItem menuItem4;

              private YuanFeiSoftware.YuanFeiXPControls.DNetMenu dNetMenu1;

 

              string category = string.Empty;

 

              /// <summary>

              /// 数据源

              /// </summary>

              private DataTable dataSource = null;

 

              /// <summary>

              /// 存放路径

              /// </summary>

              private string path = string.Empty;

 

              /// <summary>

              /// 标题

              /// </summary>

              private string caption = "朗远软件";

 

              #endregion

 

              #region 属性

 

              /// <summary>

              /// 存放路径

              /// </summary>

              public string Path

              {

                     get

                     {

                            return this.path;

                     }

                     set

                     {

                            path = value;

                     }

              }

 

              /// <summary>

              /// 要导出的数据

              /// </summary>

              public DataTable DataSource

              {

                     get

                     {

                            return this.dataSource;

                     }

                     set

                     {

                            this.dataSource = value;

                     }

              }

 

              [ Category( "导出项" ), Description( "指定导出内容的标题" ), DefaultValue( "朗远软件" ) ]

              public string Caption

              {

                     get

                     {

                            return this.caption;

                     }

                     set

                     {

                            this.caption = value;

                     }

              }

 

              #endregion

 

              #region 实例化控件变量

              private void InitializeComponent()

              {

                     this.contextMenu1 = new System.Windows.Forms.ContextMenu();

                     this.menuItem2 = new System.Windows.Forms.MenuItem();

                     this.menuItem3 = new System.Windows.Forms.MenuItem();

                     this.menuItem4 = new System.Windows.Forms.MenuItem();

                     this.dNetMenu1 = new YuanFeiSoftware.YuanFeiXPControls.DNetMenu();

 

                     //

                     // contextMenu1

                     //

                     this.contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {

       this.menuItem2,

       this.menuItem3,

       this.menuItem4});

                     //

                     // menuItem2

                     //

                     this.menuItem2.Index = 0;

                     this.dNetMenu1.SetSideBarForeColor(this.menuItem2, System.Drawing.Color.Cornsilk);

                     this.dNetMenu1.SetSideBarGradientColorOne(this.menuItem2, System.Drawing.SystemColors.InactiveCaption);

                     this.dNetMenu1.SetSideBarGradientColorTwo(this.menuItem2, System.Drawing.SystemColors.ActiveCaption);

                     this.dNetMenu1.SetSideBarText(this.menuItem2, null);

                     this.menuItem2.Text = "Word文档";

                     this.menuItem2.Click += new EventHandler( ExportData );

                     //

                     // menuItem3

                     //

                     this.menuItem3.Index = 1;

                     this.dNetMenu1.SetSideBarForeColor(this.menuItem3, System.Drawing.Color.Cornsilk);

                     this.dNetMenu1.SetSideBarGradientColorOne(this.menuItem3, System.Drawing.SystemColors.InactiveCaption);

                     this.dNetMenu1.SetSideBarGradientColorTwo(this.menuItem3, System.Drawing.SystemColors.ActiveCaption);

                     this.dNetMenu1.SetSideBarText(this.menuItem3, null);

                     this.menuItem3.Text = "文本文件";

                     this.menuItem3.Click += new EventHandler( ExportData );

                     //

                     // menuItem4

                     //

                     this.menuItem4.Index = 2;

                     this.dNetMenu1.SetSideBarForeColor(this.menuItem4, System.Drawing.Color.Cornsilk);

                     this.dNetMenu1.SetSideBarGradientColorOne(this.menuItem4, System.Drawing.SystemColors.InactiveCaption);

                     this.dNetMenu1.SetSideBarGradientColorTwo(this.menuItem4, System.Drawing.SystemColors.ActiveCaption);

                     this.dNetMenu1.SetSideBarText(this.menuItem4, null);

                     this.menuItem4.Text = "Excel文件";

                     this.menuItem4.Click += new EventHandler( ExportData );

                     //

                     // dNetMenu1

                     //

                     this.dNetMenu1.CheckBorderColor = System.Drawing.SystemColors.Highlight;

                     this.dNetMenu1.CheckBoxColor = System.Drawing.Color.White;

                     this.dNetMenu1.GradientColorOne = System.Drawing.Color.White;

                     this.dNetMenu1.GradientColorTwo = System.Drawing.Color.LightBlue;

                     this.dNetMenu1.Location = new System.Drawing.Point(46, 78);

                     this.dNetMenu1.MenuBorderColor = System.Drawing.SystemColors.ControlDark;

                     this.dNetMenu1.Name = "dNetMenu1";

                     this.dNetMenu1.SelectionBorderColor = System.Drawing.Color.FromArgb(((System.Byte)(10)), ((System.Byte)(36)), ((System.Byte)(106)));

                     this.dNetMenu1.SelectionColor = System.Drawing.Color.FromArgb(((System.Byte)(182)), ((System.Byte)(189)), ((System.Byte)(210)));

                     this.dNetMenu1.Size = new System.Drawing.Size(32, 32);

                     this.dNetMenu1.StripeColor = System.Drawing.Color.FromArgb(((System.Byte)(219)), ((System.Byte)(216)), ((System.Byte)(209)));

                     this.dNetMenu1.TabIndex = 3;

                     this.dNetMenu1.TopMenuBackColor = System.Drawing.SystemColors.Control;

                     this.dNetMenu1.TopMenuHotBorder = System.Drawing.Color.FromArgb(((System.Byte)(10)), ((System.Byte)(36)), ((System.Byte)(106)));

                     this.dNetMenu1.TopMenuHotColor = System.Drawing.Color.FromArgb(((System.Byte)(182)), ((System.Byte)(189)), ((System.Byte)(210)));

                    this.dNetMenu1.TopMenuSelectedColor = System.Drawing.Color.FromArgb(((System.Byte)(182)), ((System.Byte)(189)), ((System.Byte)(210)));

 

                     this.Controls.Add(this.dNetMenu1);

                     this.Name = "JueJue2007";

                     this.Text = "导出到……";

                     this.Size = new Size( 138, 23);

                     this.ContextMenu = this.contextMenu1;

                     this.SuspendLayout();

              }

              #endregion

 

              /// <summary>

              /// 覆盖单击事件

              /// </summary>

              /// <param name="e">数据</param>

              protected override void OnClick(EventArgs e)

              {

                     this.contextMenu1.Show( this, new Point( 0, this.Height + 1) );

              }

 

              private void ExportData( object sender, System.EventArgs e )

              {

                     MenuItem m = sender as MenuItem;

                     category = m.Text;

 

                     //多线程处理

                     System.Threading.Thread t = new System.Threading.Thread( new System.Threading.ThreadStart( this.ExportDataThread ) );

                     t.Start();

              }

 

              private void ExportDataThread( )

              {

                     if( this.DataSource == null || this.DataSource.Rows.Count == 0 )

                     {

                            MessageBox.Show( "没有找到需要导出的数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation );

                            return;

                     }

                    

                     // 1 WORD

                     if( category == "Word文档" )

                     {

                            SaveFileDialog of = new SaveFileDialog();

                            of.Filter = "Word文档|*.doc";

                            if( of.ShowDialog() == DialogResult.OK )

                            {

                                   string path = of.FileName;

                                   //DataTable dt = Oracle.GetDataTable( "select  t.id as ID, t.code 代码, t.py_code 拼音码, t.wb_code 五笔码, t.ITEM_NAME 项目名称, t.COMMENTS 备注   from base_zykj_xm t " );

                                   Manipulate.ExportToWord( this,  DataSource, path, Caption );

                            }

                     }

                     // 2 EXCEL

                     else if( category == "Excel文件" )

                     {

                            SaveFileDialog of = new SaveFileDialog();

                            of.Filter = "Excel文件|*.xls";

                            if( of.ShowDialog() == DialogResult.OK )

                            {

                                   string path = of.FileName;

                                   //DataTable dt = Oracle.GetDataTable( "select  t.id as ID, t.code 代码, t.py_code 拼音码, t.wb_code 五笔码, t.ITEM_NAME 项目名称, t.COMMENTS 备注   from base_zykj_xm t " );

                                   Manipulate.ExportToExcel( this, DataSource, path, Caption );

                            }

                     }

                     // 3 文本文件

                     else

                     {

                            SaveFileDialog of = new SaveFileDialog();

                            of.Filter = "文本文件|*.txt";

                            if( of.ShowDialog() == DialogResult.OK )

                            {

                                   string path = of.FileName;

                                   //DataTable dt = Oracle.GetDataTable( "select  t.id as ID, t.code 代码, t.py_code 拼音码, t.wb_code 五笔码, t.ITEM_NAME 项目名称, t.COMMENTS 备注   from base_zykj_xm t " );

                                   Manipulate.ExportToText( DataSource, path, Caption );

                            }

                     }

       }

 

       }

}

// 具体的导出方法

using System;

using System.IO;

using System.Data;

using System.Windows.Forms;

using e = Microsoft.Office.Interop.Excel;

using w = Microsoft.Office.Interop.Word;

 

 

namespace JueJue2007

{

       /// <summary>

       /// 整合一组导出方法

       /// </summary>

       public class Manipulate

       {

              #region EXCEL

              /// <summary>

              /// 导出文件到EXCEL

              /// </summary>

              /// <param name="dt">要导出的数据</param>

              /// <param name="path">存放路径</param>

              public static void ExportToExcel( Button b, DataTable dt, string path, string caption )

              {

                     object Nothing = System.Reflection.Missing.Value;

                     e.Application app = new e.ApplicationClass();

                     app.Workbooks.Add( Nothing );

 

                     try

                     {

                            int ColumnLen = dt.Columns.Count;

                            int RowLen = dt.Rows.Count;

 

                            app.Cells[1, 1 ] = caption;

 

                            //写列名

                            for( int m = 0; m < ColumnLen; m ++ )

                            {

                                   app.Cells[ 2, 1 + m ] = dt.Columns[ m ].ColumnName;

                            }

 

                            //写行

                            int ii = dt.Rows.Count;

                            b.Text = "剩余" + ii.ToString() + "条数据";

                            for( int n = 0; n < RowLen; n ++ )

                            {

                                   for( int j = 0; j < ColumnLen; j ++ )

                                   {

                                          app.Cells[ 3 + n, 1 + j ] = dt.Rows[ n ][ j ].ToString();

                                   }

                                   ii -= 1;

                                   b.ForeColor = System.Drawing.Color.Blue;

                                   b.Text = "剩余" + ii.ToString() + "条数据";

                                   b.Refresh();

                            }

                            b.Text = "导出到……";

                            b.Refresh();

 

                            try

                            {

                                   //保存

                                   app.ActiveWorkbook._SaveAs( path, Nothing, Nothing, Nothing, Nothing, Nothing, e.XlSaveAsAccessMode.xlExclusive, Nothing, Nothing, Nothing, Nothing );

                            }

                            catch

                            {

                                   System.Windows.Forms.MessageBox.Show("系统找不到指定目录下的文件：  " + path );

                                   return;

                            }

 

                            //app.Visible = true; //让其打开

                     }

                     catch(Exception e)

                     {

                            System.Windows.Forms.MessageBox.Show("向excel文件中写入数据出错：  " + e.Message + e.StackTrace + e.Source );

                     }

 

                     app.Workbooks.Close();

 

                     MessageBox.Show( "已经成功导出到：/n" + path + ".", "操作成功",  MessageBoxButtons.OK, MessageBoxIcon.Information  );

              }

 

              #endregion

 

      

             

              #region WORD

 

              /// <summary>

              /// 导出数据到WORD文件中

              /// </summary>

              /// <param name="dt">数据</param>

              /// <param name="path">存放路径</param>

              public static void ExportToWord( Button b, DataTable dt, string path, string caption )

              {

                     object tableBehavior = w.WdDefaultTableBehavior.wdWord9TableBehavior;

                     object autoFitBehavior = w.WdAutoFitBehavior.wdAutoFitFixed;

 

                     object unit = w.WdUnits.wdStory;

                     object extend = System.Reflection.Missing.Value;

                     object breakType = (int)w.WdBreakType.wdSectionBreakNextPage;

 

                     object count = 1;

                     object character = w.WdUnits.wdCharacter;

 

                     object Nothing =  System.Reflection.Missing.Value;

   

                     try

                     {

                            b.Text = dt.Rows.Count.ToString();

    

                            //创建一个word文件，文件名用系统时间生成精确到毫秒

                            w.Application myWord= new w.ApplicationClass();

                            w._Document myDoc = new w.DocumentClass();

                            myDoc = myWord.Documents.Add(ref Nothing,ref Nothing,ref Nothing,ref Nothing);

                            myDoc.Activate();

 

                            //向把dataset中的表插入到word的文件中   

                            myWord.Application.Selection.TypeText( caption );

                            myWord.Application.Selection.TypeParagraph();    

                            myWord.Application.Selection.TypeParagraph();

                            w.Range para = myWord.Application.Selection.Range;

                            myDoc.Tables.Add(para, dt.Rows.Count+1,dt.Columns.Count,ref tableBehavior,ref autoFitBehavior);

 

 

                            int ii = dt.Rows.Count;

                            b.Text = "剩余" + ii.ToString() + "条数据";

                            for(int column = 0; column< dt.Columns.Count;column++)

                            {

                                   myDoc.Tables[ 1 ].Cell(1,column+1).Range.InsertBefore( dt.Columns[column].ColumnName.Trim() );

                            }   

                            for( int row = 0; row < dt.Rows.Count; row ++ )

                            {

                                   for( int column = 0; column<dt.Columns.Count; column++ )

                                   {

                                          myDoc.Tables[ 1 ].Cell( row+2, column+1 ).Range.InsertBefore(dt.Rows[row][column].ToString().Trim() );

                                   }

                                   ii -= 1;

                                   b.ForeColor = System.Drawing.Color.Blue;

                                   b.Text = "剩余" + ii.ToString() + "条数据";

                                   b.Refresh();

                            }

                            b.Text = "导出到……";

                            b.Refresh();

 

                            myWord.Application.Selection.EndKey(ref unit,ref extend);

                            myWord.Application.Selection.TypeParagraph();

                            myWord.Application.Selection.TypeParagraph();

                            myWord.Application.Selection.InsertBreak(ref breakType);   

                            myWord.Application.Selection.TypeBackspace();

                            myWord.Application.Selection.Delete(ref character,ref count);

                            myWord.Application.Selection.HomeKey(ref unit,ref extend);

   

                            //保存word文件到指定的目录下

                            try

                            {

                                   object PATH = path;

                                   myDoc.SaveAs( ref PATH,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing, ref Nothing , ref Nothing , ref Nothing , ref Nothing , ref Nothing  );

                                   //myWord.Visible = true; //打开WORD文件

                            }

                            catch

                            {

                                   System.Windows.Forms.MessageBox.Show("系统找不到指定目录下的文件：  " + path );

                                   return;

                            }

                            //

                            //关闭WordDoc文档对象

                            myDoc.Close(ref Nothing, ref Nothing, ref Nothing);

                            //关闭WordApp组件对象

                            myWord.Quit(ref Nothing, ref Nothing, ref Nothing);

                     }

                     catch(Exception ex)

                     {

                            System.Windows.Forms.MessageBox.Show("向word文件中写入数据出错：  " + ex.Message);

                     }

 

                     MessageBox.Show( "已经成功导出到：/n" + path + ".", "操作成功",  MessageBoxButtons.OK, MessageBoxIcon.Information  );

              }

 

              #endregion

 

              #region Text

              public static void ExportToText( DataTable dt, string path, string caption )

              {

                     int DATADISTANCE = 5;

                     int TABDISTANCE = 8;

 

                     //创建一个.txt文件，文件名用系统时间生成精确到毫秒

                     FileInfo file = new FileInfo( path );

                     StreamWriter textFile = null;

                     try

                     {

                            textFile = file.CreateText();

                     }

                     catch

                     {

                            System.Windows.Forms.MessageBox.Show("系统找不到指定目录下的文件：  " + path );

                            return;

                     }

 

 

                     //统计当前表的行数

                     int row = dt.Rows.Count;

 

                     //统计当前表的列数

                     int column = dt.Columns.Count;

 

                     //用于统计当前表中每列记录中字符数最长的字符串的长度之和

                     int totalLength = 0;

 

                     //用于统计标题的长度（dataset中的表名的length+"表的数据如下"的length）

                     int titleLength = 0;

 

                     //统计每列记录中字符数最长的字符串的长度

                     int[] columnLength = new int[column];

                     for( int i = 0; i < column; i ++ )

                     {

                            columnLength[i] = dt.Columns[i].ColumnName.ToString().Length;

                     }

                     for(int i = 0;i<row;i++)

                     {

                            for(int j = 0;j<column;j++)

                            {

                                   if(dt.Rows[i][j].ToString().Length > columnLength[j] )

                                   {

                                          columnLength[j] = dt.Rows[i][j].ToString().Length;

                                   }

                            }

                     }

 

 

                     //统计当前表中每列记录中字符数最长的字符串的长度之和

                     for(int i = 0;i<column;i++)

                     {

                            totalLength = totalLength+columnLength[i]+DATADISTANCE;

                     }

 

                     totalLength = totalLength+2 * TABDISTANCE - DATADISTANCE;

 

                     //统计标题的长度（dataset中的当前表名的length+"表的数据如下"的length）

                     titleLength = dt.TableName.ToString().Length+"表的数据如下".Length*2;

 

                     //把标题写入.txt文件中

                     for(int i = 0;i<(int)((totalLength-titleLength)/2);i++)

                     {

                            textFile.Write(' ');

                     }

                     textFile.Write( caption );

                     textFile.WriteLine();

                     for(int i = 0;i<totalLength;i++)

                     {

                            textFile.Write('*');

                     }

                     textFile.WriteLine();

                     textFile.Write("/t");

 

                     //把dataset中当前表的字段名写入.txt文件中

                     for(int i = 0;i<column;i++)

                     {

                            textFile.Write(dt.Columns[i].ColumnName.ToString());

                            for(int k = 0;k<columnLength[i]-dt.Columns[i].ColumnName.ToString().Length+DATADISTANCE;k++)

                            {

                                   textFile.Write(' ');

                            }

                     }

                     textFile.WriteLine();

                     for(int i = 0;i<totalLength;i++)

                     {

                            textFile.Write('-');

                     }

                     textFile.WriteLine();

                     textFile.Write("/t");

 

                     //把dataset中当前表的数据写入.txt文件中

                     for(int i = 0;i<row;i++)

                     {

                            for(int j = 0;j<column;j++)

                            {

                                   textFile.Write(dt.Rows[i][j].ToString());

                                   for(int k = 0;k<columnLength[j]-dt.Rows[i][j].ToString().Length+DATADISTANCE;k++)

                                   {

                                          textFile.Write(' ');

                                   }

                            }

                            textFile.WriteLine();

                            textFile.Write("/t");

                     }

                     textFile.WriteLine();

                     for(int i = 0;i<totalLength;i++)

                     {

                            textFile.Write('-');

                     }

                     textFile.WriteLine();

                     textFile.WriteLine();

                     textFile.WriteLine();

 

                     //关闭当前的StreamWriter流

                     textFile.Close();

                     MessageBox.Show( "已经成功导出到：/n" + path + ".", "操作成功",  MessageBoxButtons.OK, MessageBoxIcon.Information  );

              }

             

              #endregion

       }

}

 
juejue1984
关注
专栏目录
C#（dataGridView按Excel模板导出）控件
08-14
不是直接导出表格，而是导出像人事档案，请假条之类的表格形式，客户在EXCEL中自行定义导出的字段和式样。
C#导出Excel,利用第三方控件，改变导出样式，字体等
07-25
C#导出Excel，利用第三方的dll文件，可以改变导出数据的样式，有实例代码。
C# 数据流导出功能（cs/bs）
weixin_30564901的博客
06-20 414
cs导出（方法一） StringBuilder sb = new StringBuilder(); sb.Append("select sjdh as '送检单号',linename as '线列',partname as '零件名称',partlh as '零件料号',"); sb.Append("partbs as '零件标识',stat...
C#利用数据流实现导入导出excle文件的类
06-29
这个是一个利用数据流实现数据库中的数据导入导出的功能的类
c#导出文件，下载文件,命名下载后的文件名
djmf9265的博客
07-20 185
Page.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(Path.GetFileName(filePath), System.Text.Encoding.UTF8)); 想要下载后文件显示什么文件名，在filename= 这里设置 转载于:http...
C#大量数据导出到Excel自动分页导出
最新发布
04-25
C#大量数据导出到Excel，超过65536行时自动分页导出
C#百万数据导出Demo
10-07
本文将深入探讨如何在C#环境中高效地处理百万级别的数据导出，并结合“C#百万数据导出Demo”进行详细解析。 首先，我们需要了解Excel文件的存储格式。通常，我们使用的Excel文件有两种主要格式：.xls（Excel 97-...
C#导出数据到Excel文件的方法
09-03
在C#编程中，将数据导出到Excel文件是一项常见的任务，特别是在数据分析、报表生成或数据备份等场景中。本文将详细介绍如何使用C#来实现这个功能，主要涉及Microsoft.Office.Interop.Excel库，这是一个允许C#代码与...
C# 将数据导出到excel模板 自定义字段
06-29
本主题聚焦于如何利用C#将数据导出到Excel模板，并自定义字段，这是一个常见的需求，尤其是在数据分析、报告生成和数据共享的场景中。 在C#中，我们可以利用各种库来操作Excel，如EPPlus、NPOI或Microsoft.Office....
C#导出数据到CSV文件的通用类实例
09-03
总的来说，`CSVHelper`类是一个实用的工具，它简化了C#程序中将数据导出到CSV文件的过程，通过封装常用操作，使得代码更加简洁，同时也提高了代码的可维护性和可扩展性。开发者可以根据实际需求，对其进行定制或扩展...
C#导出数据到Excel的几种方法
jaylongli的专栏
05-10 2105
  1.首先声明，这些方法也都是本人搜集的资料，然后为已所用，程序中不足之处，还请高手指点.2.网上有好多关于用SQL语句导入导出的例子，这里不再重复写了。方法1:调用com组件,导出access数据到Excel,就是直接调用access的导出功能,此方法速度超级快using Access;Access.ApplicationClass oAccess = new Access.A
C#遍历界面控件名称和值,xml导入导出
qq_43169363的博客
05-26 881
C#遍历界面控件名称和值，本来是想遍历所有控件名称用来切换语言用的，后来感觉也可以整体保存界面参数，于是就写到xml里面导入导出算了。 主要代码类： public class XmlHelp { Dictionary<string, string> control = new Dictionary<string, string>();//界面控件键值对（控件名，值） Dictionary<string, string> xmlInfro = new Dic
C# 导出一个控件的矢量图
weixin_33951761的博客
11-07 517
　　调用Control.DrawToBitmap(Bitmap) 方法是很容易得到控件的图形的。 但是bitmap是栅格化图形。栅格化图形有很多缺点，比如文件体积比较大、 放大后失真、 不易编辑等等。 这里将给出导出一个控件的矢量图的过程。 一、两个概念 Windows MetaFile windows MetaFile 是windows 下面的一...
C# 使用微软自带控件导出excel
HinataHazuki的博客
08-07 1272
导出excel：使用微软默认的dll，通过点击导出按钮启用js的open方法新建出一个ashx页面将文件导出到浏览器进行下载，此处放出部分代码以大概表示出顺序，完整代码见https://www.cnblogs.com/Brambling/p/6854731.html，写得可以说是非常详细了。就是别忘了导出到浏览器下载要删除目录下的缓存文件，这个是先保存到本地再输出到浏览器下载的。 ...
WinForm应用界面开发 - 如何使用第三方库以各种格式导出控件
需要界面开发、IDE工具研发中文教程资料的小伙伴，记得私信我~
09-23 840
打印库允许您将DevExpress.NET控件导出为各种文档格式（PDF、HTML、MHT、TXT、CSV、XLS、RTF）和图像格式（BMP、JPEG、GIF、TIFF、PNG、EMF），本文演示如何使用Print Preview窗口和代码将控件导出为PDF格式。 获取工具下载 - DevExpress WinForm v21.1 提示：请注意，XtraPrinting 库无法将某些控件导出为特定格式，但是所有控件都可以导出为 PDF 或图像格式。 使用Print Preview窗口导出 您可以.
C#Winform如何在控件中输入输出数据（第六周）
Suqing49的博客
10-17 2350
下拉框控件（Combobox） this.cmb_Class.DataSource = classTable; //将班级下拉框的数据源设为班级数据表； this.cmb_Class.DisplayMember = &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;Name&amp;amp;amp
c#键盘DELETE实现BACKSPACE效果
loworth的专栏
11-25 2127
网上查资料要替换delete为backspace（空格）需要写个自定义的textbox，然后重写它的ProcessCmdKey啦、WndProc啦之类的方法。如果只是要实现这样的效果。可以在textbox的keydown事件里采用如下几句代码即可            TextBox tbx = (TextBox)sender;            if (e.KeyCode == Keys.D
C# 数据导出到Excel详细教程
"这篇教程主要介绍了如何使用C#语言将数据导出到Excel，涵盖了两种主要方法：一种是将文件保存在服务器并提供下载链接，另一种是直接通过Response输出流到浏览器。这两种方法都可以实现从ASP.NET应用中导出数据到...
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值