public Program() { filereader = new Filereader(); string inPath = AppDomain.CurrentDomain.BaseDirectory + "in.xlsx"; Console.WriteLine(inPath); Excel excel = new Excel(inPath); try { for (int i = 0; i < excel.getRows() && i < 10; i++) { excel.WriteCell(i, 0, FixRow(excel.ReadCell(i, 0))); } } catch (Exception e) { Console.WriteLine(e.Message); } Console.WriteLine(); Console.WriteLine("Finished! Used time: " + (DateTime.UtcNow - Process.GetCurrentProcess().StartTime.ToUniversalTime()) + "!"); excel.Save(); excel.Close(); }
//helpers // read textures.txt and process data static bool loadGraphics(string address) { Filereader filereader = new Filereader(address); filereader.processTextures(); return(true); }
public void GetNamesFromFileByDate_FileFound_ReturnsName() { var result = Filereader.GetNamesFromFileByDate("2.9.", Path.Combine( Directory.GetCurrentDirectory(), "nimet.csv")); Assert.Equal("Sinikka, Sini, Justus", result); }
public void GetNamesFromFileByDate_FileNotFound_ThrowsException() { Exception ex = Assert.Throws <Exception>(() => Filereader.GetNamesFromFileByDate("2.9.", Path.Combine( Directory.GetCurrentDirectory(), "asdasd.dsa"))); Assert.Equal("File not found.", ex.Message); }
public void GetNamesFromFileByDate_FileFormatWrong_ThrowsException() { Exception ex = Assert.Throws <Exception>(() => Filereader.GetNamesFromFileByDate("2.9.", Path.Combine( Directory.GetCurrentDirectory(), "NameDay.pdb"))); Assert.Equal("File is in incorrect format.", ex.Message); }
public void GetNamesByDate_DateOnList_ReturnsName() { var result = Filereader.GetNamesByDate(NamesAndDates.AsQueryable(), "30.11."); Assert.Equal("Antti, Atte", result); }
public void GetNamesByDate_DateNotOnList_ReturnsNotFound() { var result = Filereader.GetNamesByDate(NamesAndDates.AsQueryable(), "11.11."); Assert.Equal("No names found on given date.", result); }