private void MakeCSVFromExcelFiles()
{
currDate = System.DateTime.Now.Date.ToString("dd.MM.yyyy");
var processes = from p in Process.GetProcessesByName("EXCEL") select p;
if (processes.Count() == 0)
{
directories = ReadConfig();
SelectFilesForm sff = new SelectFilesForm(directories);
sff.ShowDialog();
BuildCSVFromExcelFiles mkCSV = new BuildCSVFromExcelFiles();
mkCSV.ReadSelected();
while (!ListCounter.Finished)
{
}
int count = Directory.GetFiles(@".\reports\", $@"*{currDate}*").Count() - 1;
Print(@".\reports\report-" + currDate + "-" + count + ".csv");
processes = from p in Process.GetProcessesByName("EXCEL")
select p;
foreach (var process in processes)
{
process.Kill();
}
}
else
{
MessageBox.Show("Закройте все Excel!!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void AddCSVRerpotFromExcelFile(string path)
{
var dirInfo = new DirectoryInfo(@".\reports").GetFiles("report-*.csv").OrderByDescending(d => d.CreationTime).ToList();
if (dirInfo.Count > 0)
{
List <string> fullnames = new List <string>();
foreach (var item in dirInfo)
{
fullnames.Add(item.FullName);
}
files = fullnames.ToArray();
}
string old = string.Empty;
using (StreamReader sr = new StreamReader(files[0]))
{
old = sr.ReadToEnd();
sr.Close();
}
using (StreamWriter sw = new StreamWriter(files[0]))
{
sw.Write(old);
BuildCSVFromExcelFiles CSVBuilder = new BuildCSVFromExcelFiles();
var result = CSVBuilder.ReadOneFile(path);
sw.Write(result);
}
string tmp = string.Empty;
using (StreamReader sr = new StreamReader(@".\IndexedFiles.csv"))
{
tmp = sr.ReadToEnd();
sr.Close();
}
using (StreamWriter sw = new StreamWriter(@".\IndexedFiles.csv"))
{
sw.Write(tmp);
sw.WriteLine($"{File.GetCreationTime(path)},{File.GetLastWriteTime(path)},{Path.GetFileName(path)}");
sw.Close();
}
Print(files[0]);
}
