public void excelGenStart(string tableName, string header, int[] excelNums, int[] dateNums, int startingNum)
{
//Get Shipment Files
string[] files = rf.ProcessDirectory(Directory.GetCurrentDirectory());
files = fc.filterNoName(files, ".csv", ".xlsx");
string path = files[0];
string date = DateTime.Now.ToString("MM-dd-yyyy");
//Process Excel Doc
object[,] excelValues = em.excelMasterStart(path);
//Setup loop for insert querys
excelValues = em.filterExcel(excelValues, excelNums, startingNum);
for (int i = startingNum; i < em.rowCountF + 1; i++)
{
string excelInsert = $"Insert into {tableName} ({header}) VALUES (";
string valueHolder = "";
//Convert Columns to dates
for (int index = 1; index < dateNums.Length + 1; index++)
{
excelValues[i, index] = dc.dateConvertStart(excelValues[i, index].ToString(), "Date");
}
for (int index = 1; index < em.colCountF + 1; index++)
{
valueHolder = valueHolder + excelValues[i, index].ToString();
//If it is not the last item in the column, add a comma
if (index != em.colCountF)
{
valueHolder = valueHolder + ", ";
}
}
//combine all parts
excelInsert = $"{excelInsert} {valueHolder})";
Console.WriteLine(excelInsert);
//add to query array
master[mcount] = excelInsert;
mcount++;
}
master = master.Where(x => !string.IsNullOrWhiteSpace(x)).ToArray();
System.IO.File.WriteAllLines(Directory.GetCurrentDirectory() + $@"\{osdate}_EXCELTOSQL_output.txt", master);
}
