Question

将List<List<String>>写入到Excel

List<>中的里List<String>是读取excel的sheet得到的进过筛选得到的集合现在想把筛选过后的重新生成为excel

Answer 1

就是写文件啊，循环list string str = Guid.NewGuid().ToString(); string strPath = "C:\\Program Files\\衫升" + str + ".xls"; FileStream fs = File.Create(strPath); StreamWriter sw = new StreamWriter(fs, Encoding.Unicode); string strLine = ""; //孝芹 写入列标题 for (int i = 0; i < colNames.Length; i++) { string[] col = colNames[i].Split('='); strLine = strLine + col[1].ToString() + Convert.ToChar(9); } sw.WriteLine(strLine); strLine = ""; // 写入报表数据 for (int i = 0; i < dt.Rows.Count; i++) { //巧塌毕 for (int j = 0; j < colNames.Length; j++) { string[] col = colNames[j].Split('='); strLine = strLine + dt.Rows[i][col[0]].ToString() + Convert.ToChar(9); } sw.WriteLine(strLine); strLine = ""; } sw.Close(); fs.Close();

追问

不是很懂没有做过写入文件