private void IncreaseFileName() { string prev = IntToStringConversionByBase.IntToStringConversion(Counter); Counter++; string added = IntToStringConversionByBase.IntToStringConversion(Counter); string newFilePath = FilePath.Substring(0, FilePath.IndexOf(".") - prev.Length) + added + ".txt"; CheckIfFileExistOrDeleteItAndSetIt(newFilePath); }
public void WriteCollectionCounting(ICollection <int> list) { var worksheets = getWorkSheet(package); var worksheet = worksheets[1]; int cnt = 0 + offset; foreach (var i in list) { string pos = IntToStringConversionByBase.IntToStringConversion(cnt, off: startExcelReadPosition.default_setReader_Col_start) + (startExcelReadPosition.default_setReader_Row_start + row).ToString(); WriteCellValue(worksheet, pos, i); cnt++; } row++; }
public Tuple <gameGroup, gameGroup> ReturnNumberSet() { gameGroup ret = new gameGroup(); gameGroup ret2 = new gameGroup(); gameArgs firstGameArgs = ReadGameArgsAndGroupNumberFromWorkSheet((int)Sheet.AGROUPPAGE); gameArgs secGameArgs = ReadGameArgsAndGroupNumberFromWorkSheet((int)Sheet.BGROUPPAGE); var worksheets = getWorkSheet(package); for (int k = (int)Sheet.AGROUPPAGE; k <= (int)Sheet.BGROUPPAGE; k++) { var worksheet = worksheets[k]; var gameargs = firstGameArgs; if (k == 3) { gameargs = secGameArgs; } for (int i = 0; i < gameargs.gameNumber; i++) { List <byte> number_Set = new List <byte>(); for (int j = 0; j < gameargs.setSize; j++) { string pos = IntToStringConversionByBase.IntToStringConversion (j, 26, startExcelReadPosition.default_setReader_Col_start) + (startExcelReadPosition.default_setReader_Row_start + i).ToString(); number_Set.Add(byte.Parse(ReadCellValue(worksheet, pos).ToString())); } if (k == 2) { ret.numberSet.Add(number_Set); } else { ret2.numberSet.Add(number_Set); } } } ret.gameargs = firstGameArgs; ret.gameargs = secGameArgs; return(new Tuple <gameGroup, gameGroup>(ret, ret2)); }
public void write_Set(gameGroup B) { var worksheets = getWorkSheet(package); var worksheet = worksheets[1]; var list_list = B.numberSet; foreach (var i in list_list) { offset = i.Count + 2; int cnt = 0; foreach (var j in i) { string pos = IntToStringConversionByBase.IntToStringConversion(cnt, off: startExcelReadPosition.default_setReader_Col_start) + (startExcelReadPosition.default_setReader_Row_start + row).ToString(); WriteCellValue(worksheet, pos, j); cnt++; } row++; } row = 0; }