static void Main() { //wczytywanie danych ze strony string url = "https://danepubliczne.imgw.pl/api/data/synop"; JsonToDB jsonToDB = new JsonToDB(url); //wczytywanie danych z excela string excelFilepath = "C:/Users/dell/Desktop/les/2016_As(PM10)_24g.xlsx"; ExcelToSql excelToSql = new ExcelToSql(excelFilepath); DataProcessing dataProcessing = new DataProcessing(); // GetStringFromData getStringFromData = new GetStringFromData(); List <String> dataStringList = new List <string>(); List <String> dataStringList2 = new List <string>(); // tu cos nie dzial //dataString = getStringFromData.StringFromDatabase(); SqlReader sqlReader = new SqlReader(); SqlReader2 sqlReader2 = new SqlReader2(); dataStringList = sqlReader.getDataAS2016procString(); dataStringList2 = sqlReader2.getPogodaString(); System.Console.WriteLine("----------------AS---------"); foreach (String data in dataStringList) { System.Console.WriteLine(data); } System.Console.WriteLine("----------------POGODA---------"); foreach (String data in dataStringList2) { System.Console.WriteLine(data); } //ImportDataClass importDataClass = new ImportDataClass(); //importDataClass.ImportDataFromExcel(excelFilepath); /* * string[] lines = { "First line", "Second line", "Third line" }; */ using (System.IO.StreamWriter file = new System.IO.StreamWriter(@"C:/Users/dell/Desktop/les/textDataForPython.txt")) { file.WriteLine("data1"); foreach (string line in dataStringList) { if (!line.Contains("foobar")) { file.WriteLine(line); } } file.WriteLine("data2"); foreach (string line in dataStringList2) { if (!line.Contains("foobar")) { file.WriteLine(line); } } } Console.WriteLine("zapisano plik"); Console.WriteLine("otwieram pythona"); run_cmd(); void run_cmd() { ProcessStartInfo start = new ProcessStartInfo(); start.FileName = "Python C:/Users/dell/Desktop/les/siec.py"; start.Arguments = string.Format("{0} {1}"); start.UseShellExecute = false; start.RedirectStandardOutput = true; using (Process process = Process.Start(start)) { using (StreamReader reader = process.StandardOutput) { string result = reader.ReadToEnd(); Console.Write(result); } } } //string strCmdText = "Python C:/Users/dell/Desktop/les/siec.py"; //System.Diagnostics.Process.Start("CMD.exe", strCmdText); GetPythonResults getPythonResults = new GetPythonResults(); // Console.WriteLine(File.Exists(pythonResultsPath) ? "File exists." : "File does not exist."); Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Form1()); }