public void CellsUsedIncludeStyles2()
{
IXLWorksheet ws = new XLWorkbook().Worksheets.Add("Sheet1");
ws.Row(2).Style.Fill.BackgroundColor = XLColor.Red;
ws.Column(2).Style.Fill.BackgroundColor = XLColor.Red;
ws.Cell(3, 3).Value = "ASDF";
var range = ws.RangeUsed(true).RangeAddress.ToString();
Assert.AreEqual("B2:C3", range);
}
//>>>>>>>> scaniruu file i zapisyvau v array
string versatile_selection(string cellFrom, string cellTo, int rowFrom, int rowTo)
{
int cellFrom_int = Convert.ToInt32(cellFrom);
int cellTo_int = Convert.ToInt32(cellTo);
var ws = new XLWorkbook("2016.xlsx").Worksheet("Лист1"); // TODO pridumat kak otkryvat odin raz
string value_of_cell = "";
#region TODO sdelat imya kolonki
/*string cellName = "";
for (int i = 1; i <= 3; i++)
{
cellName = ws.Row(rowFrom - i).Cell(cell).Value.ToString();
if (cellName != "")
{
listValues.Add(cellName);
textBox1.AppendText(cellName + ":\n");
textBox1.AppendText("\n");
break;
}
}*/
#endregion
int r = 0; // budet otschityvat kolichestvo vseh ryadov v massive kotoryi sobiraet vse dannye po tipy {1},{name,weight,age,}
int col_in_row = 0; // budet otschityvat colonki v [1,col_in_row] massive, t.e. {},{col_in_row, col_in_row}
int prev_r = 10000000;
int how_much_symbols_in_file = how_much_symbols_have_to_check();
int how_much_symbols_in_file2 = how_much_symbols_in_file;
bool symbol_neravenstva = false;
for (int i = rowFrom; i <= rowTo; i++)// kajdyi ryad po odnoi kolonke prosmatrivaem
{
how_much_symbols_in_file2 = how_much_symbols_in_file;
col_in_row = 0;
textBox1.AppendText(i + " \n");
for (int c = cellFrom_int; c < cellTo_int; c++)
{
value_of_cell = ws.Row(i).Cell(c.ToString()).Value.ToString();// simvol v doke, kotoryi budet sravnivatsya
data_from_file[r, col_in_row] = value_of_cell; //zagonyaem v massive, chto by mojno bylo ves ryad zapomnit
// proverit sovpadaet li colonka i zatem sovpadaet li simvol
// esli simvol sovpadaet i ryad ne pomenyalsya, to zapominaem ves ryad
if (data_from_nastroiki[c] != null) // znachit sovpadaet colonka
{
//dobavit proverku simvola < >
//symbol_neravenstva =
string s = check_symbol_neravenstva(c); //tut vydal simvol neravensta v string. proveryaem est li simvol '<' || '>' v data_from_nastroiki[c]
textBox1.AppendText(i + " " + c + " check_symbol_neravenstva >>>>>> //" + s + "//\n");
int bez_simvola_neravenstva = (s == ">"||s == "<")? udalit_simvol_neravenstva(data_from_nastroiki[c]):0; // dlya togo, chto by sravnit s chislov v yacheike;
//int for_compare_format = (Convert.ToInt32(value_of_cell));
bool q = s == ">" && Convert.ToDouble(value_of_cell) >= bez_simvola_neravenstva;
bool w = s == "<" && Convert.ToDouble(value_of_cell) <= bez_simvola_neravenstva;
bool e = s == "0" && data_from_nastroiki[c] == value_of_cell;
if (s == ">") {
textBox1.AppendText(i + " ");
}
if (q || w || e)
{ //znachit sovpadaet simvol
how_much_symbols_in_file2--;
//textBox1.AppendText(c + " how_much_symbols_in_file2 >> " + how_much_symbols_in_file2 + "\n");
textBox1.AppendText(i + " " + c + " sovpadaet >> " + value_of_cell + " == " + data_from_nastroiki[c] + "\n");
// kak roiverut cto sovpadaut i ostalnye simvoly? znat kolichestvo kotoroe doljno sovpast
if (prev_r != r && how_much_symbols_in_file2 <= 0)
{
mark_array_row.Add(r); //esli sovpadaet, zapominaem nomer ryada iz array data_from_file
prev_r = r; // chto by povtory ne sohranyalis, naidennye po drugim priznakam teje ludi
}
}
else // ne sovpalo, vybrasyvaem ryad dlya uskoreniya
{
textBox1.AppendText(i + " " + c + " ne sovpadaet >> //" + value_of_cell + "// !=//" + bez_simvola_neravenstva + "//\n");
//break;
}
}
else {
//textBox1.AppendText(c+" == null >> " + data_from_nastroiki[c] + "\n");
}
col_in_row++;
}
r++;
}
return value_of_cell;
} // end versatile_selection
