using NPOI.HSSF.UserModel;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
public static void MergeExcel(List<PDFSourceFileConfig> files, string destinationFile)
{
HSSFWorkbook product = new HSSFWorkbook();
int itemIndex = 1;
foreach (var strFile in files)
{
if (!File.Exists(strFile.ReportFilePath))
{
continue;
}
//NPOICOPY(strFile, i, destinationFile);
byte[] byteArray = File.ReadAllBytes(strFile.ReportFilePath);
using (MemoryStream stream = new MemoryStream())
{
stream.Write(byteArray