static void Main(string[] args) { var path = @"E:\workspace\projects\桑特液压\documents\需求文件\刀具功能\Powermill\M001\P002\ST5267-A000M-FM1-ASM0_setup_1.xls"; try { var td = ExcelFileHelper.ReadExcelToCSVFormat(path); } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.ReadKey(); }
public static string[] ReadExcelToCSVFormat(string path) { var stringLines = new List <string>(); var lineBuilder = new StringBuilder(); var td = ExcelFileHelper.ReadExcelToTable(path); var columnCount = td.Columns.Count; for (int i = 0; i < td.Rows.Count; i++) { lineBuilder.Clear(); for (int j = 1; j <= td.Columns.Count; j++) { lineBuilder.Append($"{td.Rows[i][$"F{j}"].ToString()},"); } stringLines.Add(lineBuilder.ToString()); } return(stringLines.ToArray()); }