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();
}
}
