public void ExportRandomColBook() { var file1 = new FileInfo("./files/xlsx/查岗12_05.xlsx"); var outFilePath = "./files/xlsx/查岗_test1.xlsx"; if (File.Exists(outFilePath)) { File.Delete(outFilePath); } var outFile = new FileInfo(outFilePath); int targetCol = 1; int targetSheetIndex = 1; Sheet sheet = null; bool headTitle = false; string colName = null; List <object> dataList = new List <object>(); using (ExcelPackage package = new ExcelPackage(file1)) { var worksheet = package.Workbook.Worksheets[targetSheetIndex]; var sp = new SheetProvider(worksheet, headTitle); sheet = sp.Get(targetCol); dataList = sheet.Rows.Select(t => t.Identity).ToList(); if (headTitle) { colName = sheet.Columns[targetCol].Name; } } using (ExcelPackage package = new ExcelPackage(outFile)) { ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet1"); int length = dataList.Count, rowIndex = 1; if (headTitle) { worksheet.Cells[rowIndex, 1].Value = sheet.Columns[targetCol - 1].Name; rowIndex++; } for (int i = 1; i <= length; i++, rowIndex++) { worksheet.Cells[rowIndex, 1].Value = GetRandomFromList(dataList); } package.Save(); } }