C#关于Excel文件转TXT文本的实现

 

C#关于Excel文件转TXT文本的实现

没什么可介绍的,但是要注意文件的地址别写错了,如下是具体实现代码:

private DataTable FileToDataTable(string fileName,string sheetName)
        {
            Monster m = new Monster();
            DataSet dst = new DataSet();
            DataTable dt = new DataTable();

            dt = m.XlsxToDataTable(fileName, sheetName);

            return dt;
        }
        public ExecutionResult DataTableToTxt(DataTable vContent, string vOutputFilePath)
        {
            ExecutionResult sResult = new ExecutionResult();
            StringBuilder sTxtContent;

            try
            {
                if (File.Exists(vOutputFilePath))
                    File.Delete(vOutputFilePath);

                sTxtContent = new StringBuilder();

                //数据
                foreach (DataRow row in vContent.Rows)
                {
                    for (int i = 0; i < vContent.Columns.Count; i++)
                    {
                        sTxtContent.Append(row[i].ToString().Trim());
                        sTxtContent.Append(i == vContent.Columns.Count - 1 ? "\r\n" : "\t");
                    }
                }
                File.WriteAllText(vOutputFilePath, sTxtContent.ToString(), Encoding.Unicode);
                sResult.Status = true;
            }
            catch (Exception ex)
            {
                sResult.Message = ex.Message;
                sResult.Status = false;
            }
            return sResult;
        }

 

posted on 2020-05-19 11:03  農碼一生  阅读(324)  评论(0编辑  收藏

导航

统计