c# 导入导出excel

最新推荐文章于 2024-04-19 10:51:42 发布
最新推荐文章于 2024-04-19 10:51:42 发布
阅读量3.9k 收藏 4
点赞数
分类专栏： winform 文章标签： c# excel string exception properties
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lenovore/article/details/8065501
版权

#region 导入导出excel

        private SaveFileDialog SaveDialog;
        private OpenFileDialog OpenDialog;
        private Thread InvokeThread;
        private DialogResult InvokeResult;
        bool issave = false;
        private void Invoker()
        {

            if (issave)
                SaveDialog = new SaveFileDialog();
            else
                OpenDialog = new OpenFileDialog();
            InvokeThread = new Thread(new ThreadStart(InvokeMethod));
            InvokeThread.SetApartmentState(ApartmentState.STA);
            InvokeResult = DialogResult.None;
        }

        private DialogResult InvokeDialogResult()
        {
            InvokeThread.Start();
            InvokeThread.Join();
            return InvokeResult;
        }

        private void InvokeMethod()
        {
            if (issave)
                InvokeResult = SaveDialog.ShowDialog();
            else
                InvokeResult = OpenDialog.ShowDialog();

        }

        /// <summary>
        /// //excel 导入datatable
        /// </summary>
        /// <param name="bn">导入按钮</param>
        /// <param name="process">当前操作进度信息</param>
        /// <param name="error">错误信息</param>
        /// <returns></returns>
        public System.Data.DataTable ImportExcel(System.Windows.Forms.Button bn, System.Windows.Forms.TextBox process, System.Windows.Forms.TextBox error)
        {
            process.Text = "";
            error.Text = "";
            bn.Enabled = false;
            issave = false;
            Invoker();
            OpenDialog.Filter = "Excel(2000-2007) (*.xls)|*.xls|Excel(2010) (*.xlsx)|*.xlsx";
            OpenDialog.FilterIndex = 0;
            OpenDialog.RestoreDirectory = true;
            //OpenDialog.Title = "导入文件路径";
            System.Data.DataTable dt = null;
            if (InvokeDialogResult() == DialogResult.OK)
            {
                string strName = OpenDialog.FileName;
                string strcon = "";
                try
                {
                    FileInfo file = new FileInfo(strName);
                    if (!file.Exists)
                    {
                        error.Text = GetErrorMSG("D0014", "");
                        return null;
                    }
                    string extension = file.Extension;
                    //不同版本的连接字符串
                    switch (extension)
                    {
                        case ".xls":
                        //strcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strName + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
                        //break;
                        case ".xlsx":
                            strcon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strName + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1;'";
                            break;
                        default:
                            strcon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strName + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1;'";
                            break;
                    }
                    OleDbConnection olecon = new OleDbConnection(strcon);
                    olecon.Open();
                    //返回Excel的架构，包括各个sheet表的名称等　
                    System.Data.DataTable dtSheetName = olecon.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
                    string[] strTableNames = new string[dtSheetName.Rows.Count];
                    for (int k = 0; k < dtSheetName.Rows.Count; k++)
                    {
                        strTableNames[k] = dtSheetName.Rows[k]["TABLE_NAME"].ToString();
                        OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [" + strTableNames[k] + "]", strcon);
                        dt = new System.Data.DataTable();
                        da.Fill(dt);
                        if (dt.Rows.Count != 0)
                        {
                            bn.Enabled = true;
                            olecon.Close();
                            return dt;
                        }
                    }
                }
                catch (Exception ex)
                {
                    bn.Enabled = true;
                    error.Text = ex.Message;
                }
            }
            bn.Enabled = true;
            return dt;
        }


        /// <summary>
        /// DataGridView 导出到Excel
        /// </summary>
        /// <param name="bn">导出按钮</param>
        /// <param name="gridView"></param>
        /// <param name="process">当前操作进度信息</param>
        /// <param name="error">错误信息</param>
        /// <param name="sheetname">sheet名称</param>
        public void ExportToExcel(System.Windows.Forms.Button bn, DataGridView gridView, System.Windows.Forms.TextBox process, System.Windows.Forms.TextBox error, string sheetname)
        {
            //导出到execl  
            try
            {
                process.Text = "";
                error.Text = "";
                issave = true;
                Invoker();
                SaveDialog.Filter = "Excel(2000-2007) (*.xls)|*.xls|Excel(2010) (*.xlsx)|*.xlsx";
                SaveDialog.FilterIndex = 0;
                SaveDialog.RestoreDirectory = true;
                SaveDialog.Title = "导出文件保存路径";
                if (InvokeDialogResult() == DialogResult.OK)
                {
                    bn.Enabled = false;
                    string strName = SaveDialog.FileName;
                    if (strName.Length != 0)
                    {
                        //没有数据的话就不往下执行   
                        if (gridView.Rows.Count == 0)
                        {
                            bn.Enabled = true;
                            error.Text = GetErrorMSG("D0015", "");
                            return;
                        }
                        //ProgressBar toolStripProgressBar1=new ProgressBar();
                        //toolStripProgressBar1.Visible = true;

                        System.Reflection.Missing miss = System.Reflection.Missing.Value;
                        Microsoft.Office.Interop.Excel.ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass();
                        excel.Application.Workbooks.Add(true); ;
                        excel.Visible = false;//若是true，则在导出的时候会显示EXcel界面。
                        excel.SheetsInNewWorkbook = 1;//只有一个sheet
                        if (excel == null)
                        {
                            bn.Enabled = true;
                            error.Text = GetErrorMSG("D0016", "");
                            return;
                        }
                        Microsoft.Office.Interop.Excel.Workbooks books = (Microsoft.Office.Interop.Excel.Workbooks)excel.Workbooks;
                        Microsoft.Office.Interop.Excel.Workbook book = (Microsoft.Office.Interop.Excel.Workbook)(books.Add(miss));
                        Microsoft.Office.Interop.Excel.Worksheet sheet = (Microsoft.Office.Interop.Excel.Worksheet)book.ActiveSheet;
                        sheet.Name = sheetname;

                        System.Data.DataTable dt = new System.Data.DataTable();
                        for (int i = 0; i < gridView.Columns.Count; i++)
                        {
                            //if (gridView.Columns[i].Name == "cb" || !gridView.Columns[i].Visible)
                            //{
                            //    gridView.Columns.Remove(gridView.Columns[i]);
                            //    i--;
                            //}
                            if (gridView.Columns[i].Name != "cb" && gridView.Columns[i].Visible)
                            {
                                dt.Columns.Add(gridView.Columns[i].HeaderText);
                            }
                        }
                        for (int i = 0; i < gridView.Rows.Count; i++)
                        {
                            System.Data.DataRow dr = dt.NewRow();
                            for (int j = 0; j < dt.Columns.Count; j++)
                            {
                                if (gridView.Rows[i].Cells[dt.Columns[j].Caption].Value.GetType() == typeof(string))
                                {
                                    dr[j] = "'" + Functions.GetStringValue(gridView.Rows[i].Cells[dt.Columns[j].Caption].Value);
                                }
                                else if (gridView.Rows[i].Cells[dt.Columns[j].Caption].Value.GetType() == typeof(DateTime))
                                {
                                    dr[j] = "'" + Convert.ToDateTime(gridView.Rows[i].Cells[dt.Columns[j].Caption].Value).ToString("yyyy/MM/dd HH:mm");
                                }
                                else
                                {
                                    dr[j] = Functions.GetStringValue(gridView.Rows[i].Cells[dt.Columns[j].Caption].Value);
                                }
                            }
                            dt.Rows.Add(dr);
                        }
                        //生成列名称
                        //for (int i = 0; i < gridView.Columns.Count; i++)
                        //{
                        //    excel.Cells[1, i + 1] = gridView.Columns[i].HeaderText;
                        //}

                        for (int i = 0; i < dt.Columns.Count; i++)
                        {
                            excel.Cells[1, i + 1] = dt.Columns[i].Caption;
                        }
                        float percent = 0;
                        int count = 0;

                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            for (int j = 0; j < dt.Columns.Count; j++)
                            {
                                //if (dt.Rows[i][j].GetType() == typeof(string))
                                //{
                                //    excel.Cells[i + 2, j + 1] = "'" + dt.Rows[i][j].ToString();
                                //}
                                //else if (dt.Rows[i][j].GetType() == typeof(DateTime))
                                //{
                                //    excel.Cells[i + 2, j + 1] = "'" + Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy/MM/dd HH:mm");
                                //}
                                //else
                                //{
                                excel.Cells[i + 2, j + 1] = Functions.GetStringValue(dt.Rows[i][j]);
                                //}
                                //自动换行
                                //excel.get_Range(excel.Cells[i + 2, j + 1], excel.Cells[j + 1, j + 1]).Columns.WrapText = true;
                                //自动加行高
                                //excel.get_Range(excel.Cells[i + 2, j + 1], excel.Cells[i + 2, j + 1]).Rows.AutoFit();
                                //System.Windows.Forms.Application.DoEvents();

                            }

                            //toolStripProgressBar1.Value += 100 / gridView.RowCount;
                            count++;
                            percent = ((float)(100 * count)) / dt.Rows.Count;
                            process.Text = GetErrorMSG("D0017", "") + "[" + percent.ToString("0.00") + "%]...";

                        }

                        //填充数据
                        //for (int i = 0; i < gridView.Rows.Count; i++)
                        //{
                        //    for (int j = 0; j < gridView.Columns.Count; j++)
                        //    {
                        //        if (gridView[j, i].Value.GetType() == typeof(string))
                        //        {
                        //            excel.Cells[i + 2, j + 1] = "'" + gridView[j, i].Value.ToString();
                        //        }
                        //        else if (gridView[j, i].Value.GetType() == typeof(DateTime))
                        //        {
                        //            excel.Cells[i + 2, j + 1] = "'" + Convert.ToDateTime(gridView[j, i].Value).ToString("yyyy/MM/dd HH:mm");
                        //        }
                        //        else
                        //        {
                        //            excel.Cells[i + 2, j + 1] = gridView[j, i].Value.ToString();
                        //        }
                        //        //自动换行
                        //        //excel.get_Range(excel.Cells[i + 2, j + 1], excel.Cells[j + 1, j + 1]).Columns.WrapText = true;
                        //        //自动加行高
                        //        //excel.get_Range(excel.Cells[i + 2, j + 1], excel.Cells[i + 2, j + 1]).Rows.AutoFit();
                        //        //System.Windows.Forms.Application.DoEvents();

                        //    }

                        //    //toolStripProgressBar1.Value += 100 / gridView.RowCount;
                        //    count++;
                        //    percent = ((float)(100 * count)) / gridView.Rows.Count;
                        //    process.Text = GetErrorMSG("D0017", "") + "[" + percent.ToString("0.00") + "%]...";

                        //}
                        sheet.SaveAs(strName, miss, miss, miss, miss, miss, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, miss, miss, miss);
                        book.Close(false, miss, miss);
                        books.Close();
                        excel.Quit();
                        System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet);
                        System.Runtime.InteropServices.Marshal.ReleaseComObject(book);
                        System.Runtime.InteropServices.Marshal.ReleaseComObject(books);
                        System.Runtime.InteropServices.Marshal.ReleaseComObject(excel);
                        bn.Enabled = true;
                        GC.Collect();
                        process.Text = GetErrorMSG("D0018", "");
                        //toolStripProgressBar1.Value = 0;
                        //toolStripProgressBar1.Visible = false;
                        System.Diagnostics.Process.Start(strName);
                    }
                }

            }
            catch (Exception ex)
            {
                error.Text = ex.Message;
                bn.Enabled = true;
            }
        }


        /// <summary>
        /// datatable 导出到Excel
        /// </summary>
        /// <param name="bn">导出按钮</param>
        /// <param name="gridView"></param>
        /// <param name="process">当前操作进度信息</param>
        /// <param name="error">错误信息</param>
        /// <param name="sheetname">sheet名称</param>
        public void DataTableToExcel(System.Windows.Forms.Button bn, System.Data.DataTable dt, System.Windows.Forms.TextBox process, System.Windows.Forms.TextBox error, string sheetname)
        {
            //导出到execl  
            try
            {
                process.Text = "";
                error.Text = "";
                issave = true;
                Invoker();
                SaveDialog.Filter = "Excel(2000-2007) (*.xls)|*.xls|Excel(2010) (*.xlsx)|*.xlsx";
                SaveDialog.FilterIndex = 0;
                SaveDialog.RestoreDirectory = true;
                SaveDialog.Title = "导出文件保存路径";
                if (InvokeDialogResult() == DialogResult.OK)
                {
                    bn.Enabled = false;
                    string strName = SaveDialog.FileName;
                    if (strName.Length != 0)
                    {
                        //没有数据的话就不往下执行   
                        if (dt.Rows.Count == 0)
                        {
                            bn.Enabled = true;
                            error.Text = GetErrorMSG("D0015", "");
                            return;
                        }
                        System.Reflection.Missing miss = System.Reflection.Missing.Value;
                        Microsoft.Office.Interop.Excel.ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass();
                        excel.Application.Workbooks.Add(true); ;
                        excel.Visible = false;//若是true，则在导出的时候会显示EXcel界面。
                        excel.SheetsInNewWorkbook = 1;//只有一个sheet
                        if (excel == null)
                        {
                            bn.Enabled = true;
                            error.Text = GetErrorMSG("D0016", "");
                            return;
                        }
                        Microsoft.Office.Interop.Excel.Workbooks books = (Microsoft.Office.Interop.Excel.Workbooks)excel.Workbooks;
                        Microsoft.Office.Interop.Excel.Workbook book = (Microsoft.Office.Interop.Excel.Workbook)(books.Add(miss));
                        Microsoft.Office.Interop.Excel.Worksheet sheet = (Microsoft.Office.Interop.Excel.Worksheet)book.ActiveSheet;
                        sheet.Name = sheetname;
                        //生成列名称
                        for (int i = 0; i < dt.Columns.Count; i++)
                        {
                            excel.Cells[1, i + 1] = dt.Columns[i].Caption;
                        }
                        float percent = 0;
                        int count = 0;

                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            for (int j = 0; j < dt.Columns.Count; j++)
                            {
                                excel.Cells[i + 2, j + 1] = Functions.IsNull(dt.Rows[i][j]) ? "" : "'" + dt.Rows[i][j].ToString();
                            }
                            count++;
                            percent = ((float)(100 * count)) / dt.Rows.Count;
                            process.Text = GetErrorMSG("D0017", "") + "[" + percent.ToString("0.00") + "%]...";

                        }
                        sheet.SaveAs(strName, miss, miss, miss, miss, miss, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, miss, miss, miss);
                        book.Close(false, miss, miss);
                        books.Close();
                        excel.Quit();
                        System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet);
                        System.Runtime.InteropServices.Marshal.ReleaseComObject(book);
                        System.Runtime.InteropServices.Marshal.ReleaseComObject(books);
                        System.Runtime.InteropServices.Marshal.ReleaseComObject(excel);
                        bn.Enabled = true;
                        GC.Collect();
                        process.Text = GetErrorMSG("D0018", "");
                        System.Diagnostics.Process.Start(strName);
                    }
                }

            }
            catch (Exception ex)
            {
                error.Text = ex.Message;
                bn.Enabled = true;
            }
        }


        /// <summary>
        /// datatable 导出到Excel (excel模板导出)
        /// </summary>
        /// <param name="bn">导出按钮</param>
        /// <param name="gridView"></param>
        /// <param name="process">当前操作进度信息</param>
        /// <param name="error">错误信息</param>
        /// <param name="sheetname">sheet名称</param>
        public void CLToExcel(System.Windows.Forms.Button bn, System.Data.DataTable dt, System.Windows.Forms.TextBox process, System.Windows.Forms.TextBox error, string sheetname,string date)
        {
            //导出到execl  
            try
            {
                process.Text = "";
                error.Text = "";
                //调用的模板文件
                string path = "";
#if DEBUG
                path = @"..\..\Data\材料导出.xlsx";
#else
            path=Application.StartupPath + @"\Data\材料导出.xlsx";
#endif
                FileInfo mode = new FileInfo(path);
                Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
                if (app == null)
                {
                    return;
                }
                app.Application.DisplayAlerts = false;
                app.Visible = false;
                if (mode.Exists)
                {
                    Microsoft.Office.Interop.Excel.Workbook tworkbook;
                    Object missing = System.Reflection.Missing.Value;
                    app.Workbooks.Add(missing);
                    //调用模板
                    tworkbook = app.Workbooks.Open(mode.FullName, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
                    Microsoft.Office.Interop.Excel.Worksheet tworksheet = (Microsoft.Office.Interop.Excel.Worksheet)tworkbook.Sheets[1];
                    DateTime time = Convert.ToDateTime(date);
                    //配置文件中显示的日期数
                    int defaultday = Functions.GetInt(GetNode("/configuration/DayOfWeek/day"));
                    for (int i = 0; i < defaultday; i++)
                    {
                        tworksheet.Cells[1, i + 7] = time.AddDays(i);
                    }
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        tworksheet.Cells[i + 3, 1] = "'" + Functions.GetStringValue(dt.Rows[i][0]);
                        tworksheet.Cells[i + 3, 2] = "'" + Functions.GetStringValue(dt.Rows[i][1]);
                        tworksheet.Cells[i + 3, 7] = "'" + Functions.GetStringValue(dt.Rows[i][2]);
                    }
                    issave = true;
                    Invoker();
                    SaveDialog.Filter = "Excel(2000-2007) (*.xls)|*.xls|Excel(2010) (*.xlsx)|*.xlsx";
                    SaveDialog.FilterIndex = 0;
                    SaveDialog.RestoreDirectory = true;
                    SaveDialog.Title = "导出文件保存路径";
                    if (InvokeDialogResult() == DialogResult.OK)
                    {
                        bn.Enabled = false;
                        string strName = SaveDialog.FileName;
                        if (strName.Length != 0)
                        {
                            tworksheet.SaveAs(strName, missing, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing);
                            tworkbook.Close(false, mode.FullName, missing);
                            app.Workbooks.Close();
                            app.Quit();
                            bn.Enabled = true;
                            tworkbook = null;
                            app = null;
                            GC.Collect();
                            process.Text = GetErrorMSG("D0018", "");
                            System.Diagnostics.Process.Start(strName);
                        }
                    }
                }

            }
            catch (Exception ex)
            {
                error.Text = ex.Message;
                bn.Enabled = true;
            }
        }
        #endregion

lenovore
关注
  • 0
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
如何在ASP.NET Core 3.0中将数据导出到Excel
cxu0262的博客
07-04 1474
在构建Web应用程序时，通常将需要从Word或Excel文档中导入或导出数据。 有多种方法可以实现此目的，并且有很多NuGet软件包可与Word或Excel一起使用。 本文讨论了如何在ASP.NET Core中使用ClosedXML将数据导出到Excel。 若要使用本文提供的代码示例，您应该在系统中安装Visual Studio 2019。 如果您还没有副本，则可以在此处下载Visual ...
C#基础：用ClosedXML实现Excel写入
m0_67412019的博客
01-23 1048
直接在控制台输出，确保安装了该第三方库。
C# 操作Excel（导入，导出及对数据处理）
01-31
C# 操作Excel，包含数据导入，数据导出到Excel，及对数据判断处理。
C#导入导出excel文件案例 c#经典案例.pdf
05-07
C#导入导出excel文件案例 c#经典案例.pdf
C#导入导出Excel数据的两种方法
12-31
本文为大家分享了C#导入导出Excel数据的具体代码，供大家参考，具体内容如下 注：对于实体类对象最好新建一个并且继承原有实体类，这样可以将类型进行修改； 方法一：此种方法是用EPPLUS中的FileInfo流进行读取的（是不是流我还真不太了解，若有懂得请留言，非常感谢了） using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Abp.Extensions; namespace HYZT.Ltxy.I
C#导入导出excel基础型
12-13
基础的导入导出功能，代码中没有房任何控件，需要验证可以自己添加。
在C#中导出与导入Excel的方法
搬砖工老肖的博客
12-03 796
 导出Excel的方法： 众所周知，操作Excel一般分两种，其一就是用类似连接数据库的方式，将EXCEL文件当作小型数据库操作，这种方式我想大多数程序员都很喜欢；另一种就是用Microsoft.Office.Interop.Excel组件,引用组件则需要using Microsoft.Office.Interop.Excel，以下就是引用组件的方法： 方法一： #
C#导入Excel|读取Excel方法总结
FL1623863129的博客
10-06 769
C#导入Excel|读取Excel方法总结      1.  StreamReader 方法 这种方法一般不用，因为他读出来的是流，一般是转成字符串 代码如下： ? 01 02
C#中使用 ClosedXML 进行 Excel 操作
weixin_50011679的博客
12-08 1264
首先，确保你的项目已经引用了 ClosedXML 库。通过以上实例，你可以更好地了解如何使用 ClosedXML 进行 Excel 文件的创建、导出和读取。确保在实际项目中根据具体需求进行适当的调整。这个简单的示例创建了一个名为 “Sample.xlsx” 的 Excel 文件，其中包含名字和年龄的示例数据。这个示例演示了如何将包含复杂数据的 C# 对象列表导出到 Excel 文件，并在读取时将其还原。这个例子展示了如何打开之前创建的 Excel 文件，并读取单元格中的数据。
C#ClosedXML读写Excel文件
weixin_55764338的博客
09-28 2934
关键词：C#；ClosedXML；Excel表格数据的读写。
开发一个小工具重温C#经典问题
网站开发初中级代码参考-转载
12-26 114
利用业余时间为公司的国际化开发一个小工具，功能很简单，但可以重新温习C#的一些经典问题。 1. 两个基本功能 根据源文件和新文件对比，生成对比结果文件。 对比结果要包括：新文件中更改的词条、新加的词条、删除的词条。 输入文件格式：文件开头有些注释，正文的每行由id号、空格、引号围绕的词条三部分。 对比结果文件格式： 实例1： txt1.txt（源文件） --...
C# Excel导入导出
08-07
C#调用NPOI进行Excel导入、导出。 文件为一个解决方案，包含了所有开发源码。 文章为：http://www.cnblogs.com/polk6/p/4425620.html
c#Excel导入导出
01-16
c#使用npoi导入导出Excel示例，支持asp.net core/asp.net,示例使用asp.Net core
C#导入导出EXCEL文件的代码实例
09-04
主要介绍了C#导入导出EXCEL文件代码实例,代码的流程和方法都很详细,需要的朋友可以参考下
C# 导出 Excel 的各种方法总结
刘欢的博客
03-30 7636
第一种：使用 Microsoft.Office.Interop.Excel.dll 首先需要安装 office 的 excel，然后再找到Microsoft.Office.Interop.Excel.dll 组件，添加到引用。 View Code View Code 第一种方法性能实在是不敢恭维，而且局限性太多。首先必须要安装 office（如果计算机上面没有的话），而且导出时需要指定文件保存的路径。也可以输出到浏览器下载，当然前提是已经保存写入数据。 第二种：使用Aspose....
C#导入导出Excel
fangyuan621的专栏
08-13 2034
Excel导入导出在项目运用中并不少见，传统的情况一般都是采用插件的形式走流程，像这种的网上一大把就不再复述。这里就写出完整的思路以及代码，供大家借鉴。 一、添加引用dotnet4（网上有，可以自行下载） 二、添加导入导出类Entities.cs 1 public class Entities:IDisposable 2 { 3 private string fileName = null; //文件名 4 private static
C# Excel导入数据和导出数据
互联网民工手记
07-26 2349
MiniExcel简单、高效避免OOM的.NET处理Excel查、写、填充数据工具。环境：.NET6.0。
c#创建安装windows服务
最新发布
IT深耕十余载，大道之简
04-19 439
工具来安装服务，或者你也可以在项目中添加安装程序来简化安装过程。安装服务后，你可以使用“服务”管理工具来启动、停止和卸载服务。的文件，这个文件包含了服务的主体。在这个类中，你可以重写。方法来定义服务启动时和停止时要执行的逻辑。编译你的服务项目以生成可执行文件（通常是。在项目中，你会看到有一个名为。
关于C#程序（Windows窗体应用）的退出询问
wanganqiqi的博客
04-17 355
关于C#程序（Windows窗体应用）的退出询问
c#datagridview 导入和导出excel
07-23
在 C# 中，您可以使用以下代码实现 DataGridView 数据的导入和导出 Excel 文件的功能。 导入 Excel 文件到 DataGridView： ```csharp using System; using System.Data; using System.Windows.Forms; using Excel ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值