/// <summary> /// Finds and compares the number and outprints all the planet info if true /// </summary> /// <param name="find"></param> /// <param name="column"></param> private void WriteAllPlanetInfoIf(int compare, int column, bool greaterThan, bool lessThan, bool equalTo) { for (int j = 2; j <= 10; j++) // goes through each sheet { Excel excel = OpenFileAt(j); int planet = (int)excel.ReadCellDouble(1, 8); for (int i = 1; i <= planet; i++) // goes through the planet list { double temp = excel.ReadCellDouble(planet, column); if (temp < compare && lessThan) { WriteAllPlanetInfo(planet, excel); } else if (temp > compare && greaterThan) { WriteAllPlanetInfo(planet, excel); } else if (temp == compare && equalTo) { WriteAllPlanetInfo(planet, excel); } } excel.Close(); } }
public static string ReplacePlanetMethod(Excel excel, int sheet, int row, string newPlanetName) { if (excel.ReadCellString(row, 2).Equals("") || excel.ReadCellString(row, 2).Equals(null)) // if the box was empty { excel.WriteToCell(row, 2, newPlanetName); //planet in box excel.WriteToCell(row, 1, row.ToString()); // update number next to it if (row > excel.ReadCellDouble(1, 8)) //if the new numbeer is greater than the total { excel.WriteToCell(1, 8, row.ToString()); //update number return(newPlanetName + " added to" + " slot " + row + " on sheet " + sheet + " Totals updated to " + row); } else { return(newPlanetName + " added to" + " slot " + row + " on sheet " + sheet); } } else if (excel.ReadCellString(row, 2).Equals(newPlanetName)) { return(newPlanetName + " information updated "); } else { string oldPlanetName = excel.ReadCellString(row, 2); excel.WriteToCell(row, 2, newPlanetName); //put the planet in the box return(newPlanetName + " replaced " + oldPlanetName + " in slot " + row + " on" + " sheet " + sheet); } }
private void ParadisesButton_Click(object sender, EventArgs e) { int.TryParse(numberTextBox.Text, out int temp); if (temp > 0) { int planetNumber = Int32.Parse(numberTextBox.Text); Excel excel = OpenFileAt(8); string planet = excel.ReadCellString(planetNumber, 2); //read row planet number column c excel.Close();//dellocate numberTextBox.Text = planet; RetrievePicture("IGP", planetNumber); } else { Excel excel = OpenFileAt(8); int planet = (int)excel.ReadCellDouble(1, 8); //amount of planets output.WriteLine("Paradises: "); for (int i = 1; i <= planet; i++) { WriteAllPlanetInfo(i, excel); } output.Flush(); excel.Close(); MessageBox.Show("Paradises added to " + outputPath, "Completed"); } }
private void WriteAllPlanetInfo(int planetNum, Excel excel) { output.Write(excel.ReadCellString(planetNum, 2) + " | "); //column C //Console.WriteLine(excel.ReadCellString(planetNum, 2)); for (int i = 10; i <= 38; i++) { //Console.WriteLine(i); if (i == 11 || i == 12 || (i >= 14 && i <= 19) || (i >= 25 && i <= 37)) { var temp = excel.ReadCellDouble(planetNum, i); output.Write(temp + " | "); } else if (i == 38) { string temp = excel.ReadCellString(planetNum, i); output.Write(temp); } else { string temp = excel.ReadCellString(planetNum, i); output.Write(temp + " | "); } } output.WriteLine(""); }
private void BuildListButton_Click(object sender, EventArgs e) { Excel excel = OpenFileAt(11); int planetsToBuild = (int)excel.ReadCellDouble(1, 15); for (int i = 1; i <= planetsToBuild; i++) //planet tally is in P column { //output.Write("Coordinates: "); output.Write(excel.ReadCellString(i, 2)); //coordinates output.Write(" | "); //output.Write("Planet Name: "); output.Write(excel.ReadCellString(i, 3)); //colony name output.Write(" | "); //output.Write("Colony Name: "); output.Write(excel.ReadCellString(i, 4));//Planet Name output.Write(" | "); output.Write("Zounds: "); output.Write(excel.ReadCellBool(i, 5));//Zoundsable output.Write(" | "); output.Write("Medium: "); output.Write(excel.ReadCellBool(i, 6));//Medium output.Write(" | "); output.Write("?: "); output.Write(excel.ReadCellBool(i, 7));//Questionable output.Write(" | "); output.Write("Decconstruct: "); output.Write(excel.ReadCellBool(i, 8));//Deconstruct output.Write(" | "); //output.Write("Research x/10: "); output.Write((int)excel.ReadCellDouble(i, 9)); //Research output.Write(" | "); output.WriteLine(""); } output.Flush(); MessageBox.Show("Build List added to output", "Message"); }
/// <summary> /// Finds and outputs the planet info if the integer matches /// </summary> /// <param name="find"></param> /// <param name="column"></param> private void WriteAllPlanetInfoIf(int find, int column) { for (int j = 2; j <= 10; j++) // goes through each sheet { Excel excel = OpenFileAt(j); int planet = (int)excel.ReadCellDouble(1, 8); for (int i = 1; i <= planet; i++) // goes through the planet list { int temp = (int)excel.ReadCellDouble(planet, column); if (temp.Equals(find)) { WriteAllPlanetInfo(planet, excel); } } excel.Close(); } }
private void LowMetalButton_Click(object sender, EventArgs e) { for (int j = 2; j <= 10; j++) // goes through each sheet { Excel excel = OpenFileAt(j); int planet = (int)excel.ReadCellDouble(1, 8); for (int i = 1; i <= planet; i++) // goes through the planet list { if (excel.ReadCellInt(i, 26) <= 5000) { } } } }
public static void ClearBuildList(Excel excel) { int planets = (int)excel.ReadCellDouble(1, 15); //excel.WriteToCell(1, 15, ""); for (int i = 1; i <= planets; i++) { excel.WriteToCell(i, 1, ""); excel.WriteToCell(i, 2, ""); excel.WriteToCell(i, 3, ""); excel.WriteToCell(i, 4, ""); excel.WriteToCell(i, 5, ""); excel.WriteToCell(i, 6, ""); excel.WriteToCell(i, 7, ""); excel.WriteToCell(i, 8, ""); excel.WriteToCell(i, 9, ""); excel.WriteToCell(i, 10, ""); excel.WriteToCell(i, 11, ""); } Console.WriteLine("Build List Cleared"); }
public static string ReplacePlanetMethod(int sheet, int row, string newPlanetName) { Excel excel = OpenFileAt(sheet); if (excel.ReadCellString(row, 2).Equals("") || excel.ReadCellString(row, 2).Equals(null)) // if the box was empty { excel.WriteToCell(row, 2, newPlanetName); //planet in box excel.WriteToCell(row, 1, row.ToString()); // update number next to it if (row > excel.ReadCellDouble(1, 8)) //if the new numbeer is greater than the total { excel.WriteToCell(1, 8, row.ToString()); //update number excel.Close(); return(newPlanetName + " added to" + " slot " + row + " on sheet " + sheet + " Totals updated to " + row); } else { excel.Close(); return(newPlanetName + " added to" + " slot " + row + " on sheet " + sheet); } } else if (excel.ReadCellString(row, 2).Equals(newPlanetName)) { excel.Close(); return("Identitcal planet found! Nothing has been added"); } else { string oldPlanetName = excel.ReadCellString(row, 2); excel.WriteToCell(row, 2, newPlanetName); //put the planet in the box excel.Close(); return(newPlanetName + " replaced " + oldPlanetName + " in slot " + row + " on" + " sheet " + sheet); } }
private void SameSystemListButton_Click(object sender, EventArgs e) { Coordinates system = Algorithms.GetCoordinates(numberTextBox.Text); for (int j = 2; j <= 10; j++) // goes through each sheet { Excel excel = OpenFileAt(j); int planet = (int)excel.ReadCellDouble(1, 8); for (int i = 1; i <= planet; i++) // goes through the planet list { string planetName = excel.ReadCellString(i, 2); Coordinates planetCoords = Algorithms.GetCoordinates(planetName); if (system.x == planetCoords.x && system.y == planetCoords.y) { output.WriteLine(planetName); } } excel.Close(); } output.Flush(); MessageBox.Show("Colonies in the Same System to output", "Message"); }
private void VolcanicsButton_Click(object sender, EventArgs e) { int.TryParse(numberTextBox.Text, out int temp); if (temp > 0) { int planetNumber = Int32.Parse(numberTextBox.Text); Excel excel = OpenFileAt(10); string planet = excel.ReadCellString(planetNumber, 2); //read row planet number column c excel.Close();//dellocate numberTextBox.Text = planet; RetrievePicture("Vol", planetNumber); } else if (VolcanicZoundsCheckBox.Checked && VolcanicsCheckBox.Checked) //both { Excel excel = OpenFileAt(10); int planet = (int)excel.ReadCellDouble(1, 8); //amount of planets output.WriteLine("Volcanics: "); for (int i = 1; i <= planet; i++) { WriteAllPlanetInfo(i, excel); } output.Flush(); excel.Close(); MessageBox.Show("Volcanics added to " + outputPath, "Completed"); } else if (VolcanicZoundsCheckBox.Checked && !VolcanicsCheckBox.Checked) //Volcanic Zounds only { Excel excel = OpenFileAt(10); int planet = (int)excel.ReadCellDouble(2, 8); //amount of zounds output.WriteLine("Volcanic Zounds: "); for (int i = 1; i <= planet; i++) { output.WriteLine(excel.ReadCellString(i, 5)); //column F } output.Flush(); excel.Close(); MessageBox.Show("Volcanics Zounds added to " + outputPath, "Completed"); } else if (!VolcanicZoundsCheckBox.Checked && VolcanicsCheckBox.Checked) //normies only { Excel excel = OpenFileAt(10); int planet = (int)excel.ReadCellDouble(1, 8); //amount of planets output.WriteLine("Volcanic Non-Zounds: "); for (int i = 1; i <= planet; i++) { string box = excel.ReadCellString(i, 2); for (int j = 0; j < box.Length; j++)//go through string { if (box[j].Equals('.')) { if (j + 5 < box.Length && !box[j + 5].Equals('Z')) { output.WriteLine(excel.ReadCellString(i, 2)); //column C } else if (j + 3 == box.Length - 1 && !box[j - 4].Equals('.')) { output.WriteLine(excel.ReadCellString(i, 2)); //column C } } } } output.Flush(); excel.Close(); MessageBox.Show("Volcanics without Zounds added to " + outputPath, "Completed"); } else { MessageBox.Show("Nothing was selected"); } }