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; }
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/36076.html
標籤：C#
下一篇：【C#】使用 System.Globalization.DateTimeFormatInfo 屏蔽系統時間格式對代碼的影響