txt Excel 读写

来源：互联网发布：下载软件大全编辑：程序博客网时间：2024/06/05 14:31

http://www.51zxw.net/study.asp?vip=11181777]５１自学网－专业培训老师录制的视频教程，让学习变得很轻松

</pre><pre code_snippet_id="130479" snippet_file_name="blog_20131227_1_5257510" name="code" class="csharp">using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.IO;using System.Data;using Microsoft.Office.Interop.Excel;using System.Windows.Forms;using System.Data.OleDb;using System.Reflection;namespace util{    class FileUtil    {        /// <summary>        /// 当前路径。        /// </summary>        public string currPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);        /// <summary>        /// 写入TXT        /// </summary>        /// <param name="fileName">文件名</param>        /// <param name="listView">文件内容 list(string)</param>        /// <returns></returns>        public static bool WriteToFile(string fileName, List<string> listView)        {            StreamWriter SW = null;            try            {                string directory = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase); //Directory.GetCurrentDirectory();                //  MessageBox.Show(directory);                directory = directory.Replace("file:\\", "");                // MessageBox.Show(directory + "\\" + fileName);                bool isExist = File.Exists(fileName);                //MessageBox.Show(isExist+"");                if (isExist)                {//文件是否存在。                    SW = new StreamWriter(directory + "\\" + fileName, true);                    //SW = System.IO.File.AppendText(directory + "\\" + fileName);                }                else                {                    SW = System.IO.File.CreateText(directory + "\\" + fileName);                }                foreach (string s in listView)                {                    SW.WriteLine(s);                }                SW.Close();                return true;            }            catch (System.Exception e)            {                MessageBox.Show("保存文件失败!" + e);                return false;            }            finally            {                SW.Close();            }        }        /// <summary>        /// ListView反向填充DataTable数据项        /// </summary>        /// <param name="lv">ListView控件</param>        /// <param name="dt">DataTable</param>        public static System.Data.DataTable listViewToDataTable(ListView lv)        {            if(lv.Items.Count==0){                return null;            }            System.Data.DataTable dt = new System.Data.DataTable();            DataRow dr;            dt.Clear();            dt.Columns.Clear();            for (int k = 0; k < lv.Columns.Count; k++)            {                dt.Columns.Add(lv.Columns[k].Text.Trim().ToString());//生成DataTable列头            }            for (int i = 0; i < lv.Items.Count; i++)            {                dr = dt.NewRow();                for (int j = 0; j < lv.Columns.Count; j++)                {                    dr[j] = lv.Items[i].SubItems[j].Text.Trim();                }                dt.Rows.Add(dr);//每行内容            }            return dt;        }        public static System.Data.DataTable readExcel(String filePath)//更新中**********************        {             Microsoft.Office.Interop.Excel.Workbook wb = null;             Microsoft.Office.Interop.Excel.Worksheet ws = null;             Microsoft.Office.Interop.Excel.Range r = null;            object missing = Missing.Value;            System.Data.DataTable data = new System.Data.DataTable();            ApplicationClass app = new ApplicationClass();            wb = app.Workbooks.Open(filePath, false, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);            app.Visible = false;//读Excel不显示出来影响用户体验            //得到WorkSheet对象            ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets.get_Item(1);            int i = 1;            //读取A1单元格内容            while (ws.get_Range("A"+i, Type.Missing)!=null)            {                r = ws.get_Range("A" + i, Type.Missing);                if(r.Value2 == null ){                   break;                }                string strA1 = r.Value2.ToString();                MessageBox.Show(strA1);                i++;            }                       app.Quit();//退出            return data;        }        /// <summary>        /// 保存Excel        /// </summary>        /// <param name="excelTable"></param>        /// <param name="filePath"></param>        /// <returns></returns>        public static bool writeFileToExcel(System.Data.DataTable excelTable, string filePath) {            if(excelTable ==null){                MessageBox.Show("列表内容为空！");                return false;            }            ApplicationClass app = new ApplicationClass();            try            {                app.Visible = false;//不显示 Excel 文件,如果为 true 则显示 Excel 文件                Workbook wBook = app.Workbooks.Add(true);//添加一个工作薄                Worksheet wSheet = wBook.Worksheets[1] as Worksheet;//添加一个工作表                int size = excelTable.Columns.Count;//列  表格台头                for (int i = 0; i < size; i++)                {                    wSheet.Cells[1, 1 + i] = excelTable.Columns[i].ColumnName;                }                //表格内容                if (excelTable.Rows.Count > 0)                {                    int row = 0;                    row = excelTable.Rows.Count;//行                    int col = excelTable.Columns.Count;//列                    for (int i = 0; i < row; i++)                    {                        for (int j = 0; j < col; j++)                        {                            string str = excelTable.Rows[i][j].ToString();                            wSheet.Cells[i + 2, j + 1] = str;                        }                    }                }                //设置禁止弹出保存和覆盖的询问提示框                 app.DisplayAlerts = false;                app.AlertBeforeOverwriting = false;                //保存工作簿                 wBook.Save();                //保存excel文件                 app.Save(filePath);                app.SaveWorkspace(filePath);                app.Quit();                app = null;                return true;            }            catch (Exception err)            {                MessageBox.Show("导出Excel出错！错误原因：" + err.Message, "提示信息",                    MessageBoxButtons.OK, MessageBoxIcon.Information);                return false;            }            finally            {            }                        }        /// <summary>        /// 读取文件        /// </summary>        /// <param name="fileName"></param>        /// <returns></returns>        public static List<string> readFileToList(String fileName)        {            List<string> list = new List<string>();            if (File.Exists(fileName))            {                StreamReader setReader = new StreamReader(fileName);                string str;                while ((str = setReader.ReadLine()) != null)                {                    list.Add(str);                }                setReader.Close();            }            return list;        }        /// <summary>        /// 删除文件        /// </summary>        /// <param name="fileName"></param>        public static void removeFile(String fileName)        {            if (File.Exists(fileName))            {                File.Delete(fileName);            }        }        internal static void WriteToFile(string p, object p_2)        {            throw new NotImplementedException();        }    }}

0 0