//转换选择的记事本为表格
private void userButton6_Click(object sender, EventArgs e)
{
if (comboBox4.SelectedItem != null)
{
string path = @"D:\Ftp\tm-x\result\SD1_000";
string fullpath = path + comboBox4.SelectedItem;
string fileExt = Path.GetFileNameWithoutExtension(fullpath);//获取文件的名子
if (File.Exists(fullpath))
{
try
{
HSSFWorkbook wk = new HSSFWorkbook();
//创建一个sheet
ISheet sheet = wk.CreateSheet("data");
var list = File.ReadAllLines(fullpath).ToList();
// DataTable dataTable = new DataTable();
int sc = 0;
for (int i = 0; i < list.Count / 20 + 1; i++)
{
//在第一行创建行
IRow row = sheet.CreateRow(i);
for (int j = 0; j < 20; j++)
{
//在第一行的第一列创建单元格
ICell cell = row.CreateCell(j);
if (sc >= list.Count)
{
sc = list.Count - 1;
}
cell.SetCellValue(list[sc]);
sc++;
}
}
using (FileStream fs = File.OpenWrite("D:\\Ftp\\" + fileExt + ".xls"))
{
wk.Write(fs);
}
MessageBox.Show("已新建和保存excel文件");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
else
{
MessageBox.Show("请选择");
}
}
//读取记事本
private void button46_Click(object sender, EventArgs e)
{
if (Directory.Exists(@"D:\Ftp\tm-x\result\SD1_000"))
{
List<string> ts = new List<string> { };
var dir = Directory.GetFiles(@"D:\Ftp\tm-x\result\SD1_000", "*.*", SearchOption.AllDirectories).Where(s => s.EndsWith(".txt"));//Directory.GetFileSystemEntries(@"C:/test/", "*.xlsx",searchOption: SearchOption.AllDirectories); //Directory.GetFiles(@"C:/test/", "*.xlsx");//Directory.GetFileSystemEntries(@"C:/test/", "*Text*.xlsx");
foreach (var item in dir)
{
//取得拷贝的文件名,只取文件名,地址截掉。
string strFileName = item.Substring(item.LastIndexOf("/") + 1);
ts.Add(strFileName);
}
comboBox4.DataSource = ts;
}
}