private void RenameListsButton_Click(object sender, EventArgs e)
{
Excel excel = OpenFileAt(1);
output.WriteLine("Rename Lists : Coordinates | Current Name | Rename ");
for (int i = 2; i < Program.GetMax(); i++)
{
if (!string.IsNullOrEmpty(excel.ReadCellString(i, 6)))
{
output.Write(excel.ReadCellString(i, 6) + " | "); //location
}
if (!string.IsNullOrEmpty(excel.ReadCellString(i, 7)))
{
output.Write(excel.ReadCellString(i, 7) + " | ");//before
}
if (!string.IsNullOrEmpty(excel.ReadCellString(i, 8)))
{
output.Write("/namecolony " + excel.ReadCellString(i, 8));//after
}
if (!string.IsNullOrEmpty(excel.ReadCellString(i, 6)) || !string.IsNullOrEmpty(excel.ReadCellString(i, 7)) || !string.IsNullOrEmpty(excel.ReadCellString(i, 8)))
{
output.WriteLine("");
}
}
output.Flush();
excel.Close();
MessageBox.Show("Rename lists added to Output.txt", "Completed");
}
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 DoubleDomeListButton_Click(object sender, EventArgs e)
{
Excel excel = OpenFileAt(1);
output.WriteLine("Double Domes Lists: Candidates | Double Domes: ");
for (int i = 2; i < Program.GetMax(); i++)
{
if (!string.IsNullOrEmpty(excel.ReadCellString(i, 18)))
{
output.Write(excel.ReadCellString(i, 18) + " | "); //Candidates
}
if (!string.IsNullOrEmpty(excel.ReadCellString(i, 19)))
{
output.Write(excel.ReadCellString(i, 19) + " | ");//double doems
}
if (!string.IsNullOrEmpty(excel.ReadCellString(i, 18)) || !string.IsNullOrEmpty(excel.ReadCellString(i, 19)))
{
output.WriteLine("");
}
}
output.Flush();
excel.Close();
MessageBox.Show("Double Domes list added to Output.txt", "Completed");
}
/// <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();
}
}
private void ClearBuildsButton_Click(object sender, EventArgs e)
{
Excel excel = OpenFileAt(11);
Clearer.ClearBuildList(excel);
MessageBox.Show("Build List Cleared!", "Message");
excel.Close();
}
private void SortBuildsButton_Click(object sender, EventArgs e)
{
Excel excel = OpenFileAt(11);
int totalBuilds = excel.ReadCellInt(1, 15); //amount of builds num
string[,] planets = new string[totalBuilds, 8];
Console.WriteLine(planets.GetLength(0) + " " + planets.GetLength(1));
for (int i = 1; i <= planets.GetLength(0); i++) //establish the array
{
bool tempBools = false;
//Console.WriteLine(i);
planets[i - 1, 0] = excel.ReadCellString(i, 2);
planets[i - 1, 1] = excel.ReadCellString(i, 3);
planets[i - 1, 2] = excel.ReadCellString(i, 4);
tempBools = excel.ReadCellBool(i, 5);
planets[i - 1, 3] = tempBools.ToString();
tempBools = excel.ReadCellBool(i, 6);
planets[i - 1, 4] = tempBools.ToString();
tempBools = excel.ReadCellBool(i, 7);
planets[i - 1, 5] = tempBools.ToString();
tempBools = excel.ReadCellBool(i, 8);
planets[i - 1, 6] = tempBools.ToString();
int tempInt = excel.ReadCellInt(i, 9);
planets[i - 1, 7] = tempInt.ToString();
}
//Clearer.ClearBuildList(excel);
Coordinates origin;
origin = Algorithms.GetCoordinates("(0,0)");
ColonyInfo[] colInfo = Algorithms.SortPlanetsByXAndY(planets, origin, Algorithms.GetCoordinates(planets[totalBuilds - 1, 0])); //get the sorted array
Clearer.ClearBuildList(excel);
Console.WriteLine("This algorithm is bad its making tons of duplicates"); /*
* for (int i = 0; i < planets.GetLength(0); i++)
* {
* for (int j = 0; j < planets.GetLength(0); j++)
* {
* Coordinates oldList = Algorithms.GetCoordinates(planets[j, 0]);
* if ((colInfo[i].coords.x == oldList.x) && (colInfo[i].coords.y == oldList.y))
* {
* //Console.WriteLine(planets[i, 0] + " ");
* Adder.AddToBuilds(excel, planets[j, 0], planets[j, 1], planets[j, 2], planets[j, 3], planets[j, 4], planets[j, 5], planets[j, 6], planets[j, 7]);
* }
* }
* }
*/
excel.Close();
MessageBox.Show("Build List Sorted by System", "Completed");
}
private void NeedsDefensesButton_Click(object sender, EventArgs e)
{
Excel excel = OpenFileAt(1);
output.WriteLine("Needs Defense List: ");
for (int i = 2; i < Program.GetMax(); i++)
{
output.WriteLine(excel.ReadCellString(i, 14)); //needs defense column
}
output.Flush();
excel.Close();
MessageBox.Show("Needs Defense List added to Output.txt", "Completed");
}
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);
}
}
/// <summary>
/// Finds and outputs the planet info if the string matches
/// </summary>
/// <param name="find"></param>
/// <param name="column"></param>
private void WriteAllPlanetInfoIf(string 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
{
if (excel.ReadCellString(planet, column).Equals(find))
{
WriteAllPlanetInfo(planet, excel);
}
}
excel.Close();
}
}
/// <summary>
/// OBSOLETE USE REPLACER.REPLACEPLANET
/// </summary>
/// <param name="sheet"></param>
/// <param name="planetName"></param>
public static void AddPlanet(int sheet, string planetName)
{
Excel excel = OpenFileAt(sheet);
int planet = excel.ReadCellInt(1, 8); //read p Tally
int temp = planet + 1; //get it ot the next row
excel.WriteToCell(temp, 1, temp.ToString()); //updates the number next to the cell
excel.WriteToCell(temp, 2, planetName); //put the planet in the box
if (excel.ReadCellInt(1, 8) < temp)
{
excel.WriteToCell(1, 8, temp.ToString()); //updates the planet number
}
//MessageBox.Show(planetName + " added to row " + temp + " sheet " + sheet, "Completed");
excel.Close();
}
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");
}
public static string BuildZoundsDestroy(string colonyInfo, bool resources, bool defended)
{
Excel excel = OpenFileAt(11); // build list
StringReader reader = new StringReader(colonyInfo);
string line;
string planetType = null;
string coordinates = null; // C
string planetName = null; // D
string colonyName = null; // E
string discoveries = null; // K
int research = -1; // J
bool[] buildableHolder = new bool[4];
bool zoundsable = false;
bool medium = false;
bool questionable = false;
bool deconstruct = false;// F , G, H, I
buildableHolder[0] = zoundsable;
buildableHolder[1] = medium;
buildableHolder[2] = questionable;
buildableHolder[3] = deconstruct;
for (int i = 0; i < colonyInfo.Length; i++)
{
line = reader.ReadLine();
if (line != null)
{
if (i == 0)
{
colonyName = line;
Console.WriteLine(line);
}
else if (i == 3)
{
string[] temp = line.Split(':');
planetType = temp[1];
planetType = RemoveSpaces(planetType);
}
else if (i == 4)
{
string[] temp = line.Split(':');
temp = temp[1].Split('(');
planetName = temp[0];
coordinates = temp[1];
coordinates = "(" + coordinates;
}
else if (i == 40)
{
string[] temp = line.Split('/');
temp[0] = RemoveLetters(temp[0]);
temp[0] = RemoveParenthesisColonComma(temp[0]);
research = int.Parse(temp[0]);
}
else if (i >= 41)
{
discoveries = discoveries + '\n' + line;
}
}
}
bool noDuplicate = true;
for (int i = 1; i <= excel.ReadCellInt(1, 15); i++)
{
if (planetName.Equals(excel.ReadCellString(i, 3)))
{
noDuplicate = false;
excel.Close();
return("Duplicate Found");
}
}
if (research >= 1 && noDuplicate)
{
buildableHolder = Checkers.Buildable(discoveries, planetType);
zoundsable = buildableHolder[0];
medium = buildableHolder[1];
questionable = buildableHolder[2];
deconstruct = buildableHolder[3];
int totalBuilds = excel.ReadCellInt(1, 15);
totalBuilds += 1;
Console.WriteLine(totalBuilds);
//excel.WriteToCell(1, 15, totalBuilds.ToString());
//excel.WriteToCell(totalBuilds, 1, totalBuilds.ToString());
excel.WriteToCell(totalBuilds, 2, coordinates);
excel.WriteToCell(totalBuilds, 3, planetName);
excel.WriteToCell(totalBuilds, 4, colonyName);
excel.WriteToCell(totalBuilds, 5, zoundsable.ToString());
excel.WriteToCell(totalBuilds, 6, medium.ToString());
excel.WriteToCell(totalBuilds, 7, questionable.ToString());
excel.WriteToCell(totalBuilds, 8, deconstruct.ToString());
excel.WriteToCell(totalBuilds, 9, research.ToString());
excel.WriteToCell(totalBuilds, 10, resources.ToString());
excel.WriteToCell(totalBuilds, 11, defended.ToString());
excel.Close();
return("build added");
}
else
{
Console.WriteLine(colonyName + " is Not Finished Researching.");
excel.Close();
return(colonyName + " is Not Finished Researching.");
}
}
public static string AddColonyInfo(int sheet, string info, int planetNum)
{
Excel excel = OpenFileAt(sheet);
string colonyName = null;
string planetName = null; //K
int pop = -1; //L Population
int morale = 9999; // M
string gov = null; //N government
int treasury = -1; //O
int hourlyIncome = 0; //P
string taxRate; // Q
string pollution = null; //R
int disastas = 0; // S
string pollutionRate = null; //T
string construction = null; //U
string research = null; //V
string military = null; //W
string harvesting = null; //X
string building = null; //Y
int metal = -1; // Z
int anae = -1; // AA
int meds = -1; // AB
int orgs = -1; // AC
int oil = -1; // AD
int uri = -1; // AE
int equi = -1; // AF
int spice = -1; // AG
int nukes = -1; // AH
int cMines = -1; // AI
int lasers = -1; // AJ
int solarShots = -1; // AK
int solarRate = -1; //AL
string discovered = null; //AM
//StringBuilder stringBuilder = new StringBuilder();
//stringBuilder.AppendLine("");
StringReader reader = new StringReader(info);
string line;
//string firstLine = reader.ReadLine();
for (int i = 0; i < info.Length; i++)
{
line = reader.ReadLine();
if (line != null)
{
if (i == 0)
{
colonyName = line;
Console.WriteLine(line);
}
if (i == 4)
{
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals(':'))
{
line = line.Substring(j + 7); //takes everything after the colon
}
else if (line[j].Equals('('))
{
line = line.Substring(0, j); //removes everything after the parenthesis
}
}
planetName = line;
Console.WriteLine(planetName);
}
else if (i == 8)
{
string[] temp = line.Split(':');
temp = temp[1].Split('('); //temp[1] is the growth rate
temp[0] = RemoveSpaces(temp[0]);
temp[0] = RemoveParenthesisColonComma(temp[0]);
Console.WriteLine(temp[0]);
pop = int.Parse(temp[0]);
}
else if (i == 9)
{
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals('('))
{
line = line.Substring(0, j);
}
}
line = RemoveParenthesisColonComma(line);
line = RemoveLetters(line);
Console.WriteLine(line);
morale = int.Parse(line);
}
else if (i == 10)
{
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals(':'))
{
line = line.Substring(j + 5); //takes everything after the colon
}
}
gov = RemoveSpaces(line);
Console.WriteLine(gov);
}
else if (i == 11)
{
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals(':'))
{
line = line.Substring(j + 7); //takes everything after the colon
}
}
string[] temp = line.Split('(');
temp[0] = RemoveParenthesisColonComma(temp[0]);
temp[0] = RemoveSpaces(temp[0]);
treasury = int.Parse(temp[0]);
temp[1] = RemoveParenthesisColonComma(temp[1]);
temp[1] = RemoveLetters(temp[1]);
if (temp[1].Equals(null) || temp[1].Equals(""))
{
}
else
{
hourlyIncome = int.Parse(temp[1]);
}
Console.WriteLine(temp[0] + " " + temp[1] + "/hr");
}
else if (i == 12)
{
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals(':'))
{
line = line.Substring(j + 6); //takes everything after the colon
}
}
string[] temp = line.Split('(');
pollution = temp[0];
if (temp.Length > 2)
{
string trim = RemoveParenthesisColonComma(temp[1]);
disastas = int.Parse(trim);
pollutionRate = temp[2];
}
else
{
pollutionRate = temp[1];
}
pollutionRate = RemoveLetters(pollutionRate);
pollutionRate = RemoveParenthesisColonComma(pollutionRate);
pollutionRate = RemoveSlashes(pollutionRate);
Console.WriteLine(pollution + " " + disastas);
Console.WriteLine(pollutionRate);
}
else if (i == 15)
{
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals(':'))
{
line = line.Substring(j + 3); //takes everything after the colon
}
}
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals('('))
{
line = line.Substring(0, j); //removes everything after the parenthesis
}
}
Console.WriteLine(line);
line = RemoveSpaces(line);
construction = line;
}
else if (i == 16)
{
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals(':'))
{
line = line.Substring(j + 7); //takes everything after the colon
}
}
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals('('))
{
line = line.Substring(0, j); //removes everything after the parenthesis
}
}
Console.WriteLine(line);
line = RemoveSpaces(line);
research = line;
}
else if (i == 17)
{
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals(':'))
{
line = line.Substring(j + 7); //takes everything after the colon
}
}
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals('('))
{
line = line.Substring(0, j); //removes everything after the parenthesis
}
}
Console.WriteLine(line);
line = RemoveSpaces(line);
military = line;
}
else if (i == 18)
{
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals(':'))
{
line = line.Substring(j + 5); //takes everything after the colon
}
}
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals('('))
{
line = line.Substring(0, j); //removes everything after the parenthesis
}
}
Console.WriteLine(line);
line = RemoveSpaces(line);
harvesting = line;
}
else if (i == 20)
{
for (int j = 0; j < line.Length; j++)
{
if (line[j].Equals(':'))
{
line = line.Substring(j + 7); //takes everything after the colon
}
}
building = line;
Console.WriteLine(building);
}
else if (i == 30)
{
//metal and anae on thsir ow
string[] temp = line.Split(':');
temp[1] = RemoveLetters(temp[1]);
temp[2] = RemoveSpaces(temp[2]);
metal = int.Parse(temp[1]);
anae = int.Parse(temp[2]);
Console.WriteLine(temp[1] + '\n' + temp[2]);
}
else if (i == 31)
{
//meds & orgs
string[] temp = line.Split(':');
temp[1] = RemoveLetters(temp[1]);
temp[2] = RemoveSpaces(temp[2]);
meds = int.Parse(temp[1]);
orgs = int.Parse(temp[2]);
Console.WriteLine(temp[1] + '\n' + temp[2]);
}
else if (i == 32)
{
//oil and uri
string[] temp = line.Split(':');
temp[1] = RemoveLetters(temp[1]);
temp[2] = RemoveSpaces(temp[2]);
oil = int.Parse(temp[1]);
uri = int.Parse(temp[2]);
Console.WriteLine(temp[1] + '\n' + temp[2]);
}
else if (i == 33)
{
//equi and spice
string[] temp = line.Split(':');
temp[1] = RemoveLetters(temp[1]);
temp[2] = RemoveSpaces(temp[2]);
equi = int.Parse(temp[1]);
spice = int.Parse(temp[2]);
Console.WriteLine(temp[1] + '\n' + temp[2]);
}
else if (i == 36)
{
if (line.Equals("No weapons factory present."))
{
for (int j = i; j < info.Length; j++)
{
if (line != null)
{
if (j == 38)
{
string[] temp = line.Split('(');
temp[0] = RemoveLetters(temp[0]);
temp[0] = RemoveParenthesisColonComma(temp[0]);
temp[1] = RemoveLetters(temp[1]);
temp[1] = RemoveParenthesisColonComma(temp[1]);
if (temp[1] == null || temp[1].Equals(""))
{
temp[1] = "0";
}
solarShots = int.Parse(temp[0]);
solarRate = int.Parse(temp[1]);
Console.WriteLine(temp[0] + '\n' + temp[1]);
}
line = reader.ReadLine();
if (j >= 39 && j <= 50)
{
discovered = discovered + '\n' + line;
}
}
}
Console.WriteLine("No Weapons Factory");
break;
}
else
{
//nukes
string[] temp = line.Split(':');
temp[1] = RemoveSpaces(temp[1]);
temp[1].Trim();
nukes = int.Parse(temp[1]);
Console.WriteLine(temp[1]);
}
}
else if (i == 39)
{
//cmines
string[] temp = line.Split(':');
temp[1] = RemoveSpaces(temp[1]);
cMines = int.Parse(temp[1]);
Console.WriteLine(temp[1]);
}
else if (i == 41)
{
//lasers
string[] temp = line.Split(':');
temp[1] = RemoveSpaces(temp[1]);
lasers = int.Parse(temp[1]);
Console.WriteLine(temp[1]);
}
else if (i == 46)
{
//solar
string[] temp = line.Split('(');
temp[0] = RemoveLetters(temp[0]);
temp[0] = RemoveParenthesisColonComma(temp[0]);
temp[1] = RemoveLetters(temp[1]);
temp[1] = RemoveParenthesisColonComma(temp[1]);
solarShots = int.Parse(temp[0]);
solarRate = int.Parse(temp[1]);
Console.WriteLine(temp[0] + '\n' + temp[1]);
}
else if (i >= 48 && i <= 59)
{
discovered = discovered + '\n' + line;
//Console.WriteLine(line);
}
}
}
Console.Write(discovered);
string message = Replacer.ReplacePlanetMethod(excel, sheet, planetNum, colonyName);
excel.WriteToCell(planetNum, 10, planetName);
excel.WriteToCell(planetNum, 11, pop.ToString());
excel.WriteToCell(planetNum, 12, morale.ToString());
excel.WriteToCell(planetNum, 13, gov);
excel.WriteToCell(planetNum, 14, treasury.ToString());
excel.WriteToCell(planetNum, 15, hourlyIncome.ToString());
//skip 16 this is a calculation
excel.WriteToCell(planetNum, 17, pollution);
excel.WriteToCell(planetNum, 18, disastas.ToString());
excel.WriteToCell(planetNum, 19, pollutionRate);
excel.WriteToCell(planetNum, 20, construction);
excel.WriteToCell(planetNum, 21, research);
excel.WriteToCell(planetNum, 22, military);
excel.WriteToCell(planetNum, 23, harvesting);
excel.WriteToCell(planetNum, 24, building);
excel.WriteToCell(planetNum, 25, metal.ToString());
excel.WriteToCell(planetNum, 26, anae.ToString());
excel.WriteToCell(planetNum, 27, meds.ToString());
excel.WriteToCell(planetNum, 28, orgs.ToString());
excel.WriteToCell(planetNum, 29, oil.ToString());
excel.WriteToCell(planetNum, 30, uri.ToString());
excel.WriteToCell(planetNum, 31, equi.ToString());
excel.WriteToCell(planetNum, 32, spice.ToString());
excel.WriteToCell(planetNum, 33, nukes.ToString());
excel.WriteToCell(planetNum, 34, cMines.ToString());
excel.WriteToCell(planetNum, 35, lasers.ToString());
excel.WriteToCell(planetNum, 36, solarShots.ToString());
excel.WriteToCell(planetNum, 37, solarRate.ToString());
excel.WriteToCell(planetNum, 38, discovered);
excel.Close();
return(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");
}
}
