public void COPsyncPresenceAnyMark() { var xlsxParser = new XlsxSpreadsheetParser(); var baseSpreadsheet = xlsxParser.ParseFromFile("COPsyncPresence.xlsx"); var spreadsheet = baseSpreadsheet.CreateNewParsingHeaders(); var ids = spreadsheet .Where(x => IsTruthy(x["COPsync Enterprise"]) || IsTruthy(x["COPsync911"]) || IsTruthy(x["WARRANTsync"])) .Select(x => x["ElementId"]).ToArray(); var expectedCount = 219; Assert.AreEqual(expectedCount, ids.Count()); }
public void GeneralTest() { var xlsxParser = new XlsxSpreadsheetParser(); var spreadsheet = xlsxParser.ParseFromFile("Book1.xlsx"); Assert.AreEqual(10, spreadsheet.ColumnCount); Assert.AreEqual(10, spreadsheet.RowCount); Assert.AreEqual("ColumnA", spreadsheet[0, 0]); Assert.AreEqual(null, spreadsheet[0, 1]); Assert.AreEqual("Cellb2", spreadsheet[1, 1]); Assert.AreEqual(null, spreadsheet[1, 2]); Assert.AreEqual("100", spreadsheet[2, 2]); Assert.AreEqual(null, spreadsheet[7, 7]); Assert.AreEqual("800", spreadsheet[9, 9]); }
public void WithHeadersTest() { var xlsxParser = new XlsxSpreadsheetParser(); var baseSpreadsheet = xlsxParser.ParseFromFile("Book1.xlsx"); var spreadsheet = baseSpreadsheet.CreateNewParsingHeaders(); Assert.AreEqual(10, spreadsheet.ColumnCount); Assert.AreEqual(9, spreadsheet.RowCount); Assert.AreEqual("1", spreadsheet[0, 0]); Assert.AreEqual("1", spreadsheet[0, "ColumnA"]); Assert.AreEqual("Cellb2", spreadsheet[0, 1]); Assert.AreEqual("100", spreadsheet[1, 2]); Assert.AreEqual("100", spreadsheet[1, "ColumnC"]); Assert.AreEqual(null, spreadsheet[6, 7]); Assert.AreEqual("800", spreadsheet[8, 9]); }
public void COPsyncPresenceCOPsyncEnterpriseIds() { var xlsxParser = new XlsxSpreadsheetParser(); var baseSpreadsheet = xlsxParser.ParseFromFile("COPsyncPresence.xlsx"); var spreadsheet = baseSpreadsheet.CreateNewParsingHeaders(); var ids = spreadsheet .Where(x => IsTruthy(x["COPsync Enterprise"])) .Select(x => x["ElementId"]).ToArray(); #region expected var expected = new[] { "TX_Anderson", "TX_Armstrong", "TX_Bastrop", "TX_Blanco", "TX_Brazos", "TX_Briscoe", "TX_Burleson", "TX_Cameron", "TX_Carson", "TX_Chambers", "TX_Childress", "TX_Collin", "TX_Concho", "TX_Crockett", "TX_Dawson", "TX_Delta", "TX_Dickens", "TX_Ector", "TX_El_Paso", "TX_Falls", "TX_Fayette", "TX_Franklin", "TX_Garza", "TX_Gray", "TX_Hale", "TX_Hamilton", "TX_Hardin", "TX_Hays", "TX_Henderson", "TX_Hockley", "TX_Hopkins", "TX_Hutchinson", "TX_Jeff_Davis", "TX_Jones", "TX_Kent", "TX_Kimble", "TX_Kleberg", "TX_Lampasas", "TX_Lee", "TX_Limestone", "TX_Live_Oak", "TX_Madison", "TX_Maverick", "TX_Menard", "TX_Montague", "TX_Moore", "TX_Nacogdoches", "TX_Ochiltree", "TX_Orange", "TX_Parker", "TX_Pecos", "TX_Randall", "TX_Refugio", "TX_Rusk", "TX_San_Saba", "TX_Scurry", "TX_Sherman", "TX_Sterling", "TX_Sutton", "TX_Taylor", "TX_Terry", "TX_Trinity", "TX_Val_Verde", "TX_Ward", "TX_Wichita", "TX_Willacy", "TX_Winkler", "TX_Zapata" }; #endregion CollectionAssert.AreEqual(expected, ids); }
public void COPsyncPresenceAllIds() { var xlsxParser = new XlsxSpreadsheetParser(); var baseSpreadsheet = xlsxParser.ParseFromFile("COPsyncPresence.xlsx"); var spreadsheet = baseSpreadsheet.CreateNewParsingHeaders(); var allIdsByColumnName = spreadsheet.Select(x => x["ElementId"]).Where(x => x.StartsWith("TX_")).OrderBy(x => x).ToArray(); #region expected var expected = new[] { "TX_Anderson", "TX_Andrews", "TX_Angelina", "TX_Archer", "TX_Arkansas", "TX_Armstrong", "TX_Atascosa", "TX_Austin", "TX_Bailey", "TX_Bandera", "TX_Bastrop", "TX_Baylor", "TX_Bee", "TX_Bell", "TX_Bexar", "TX_Blanco", "TX_Borden", "TX_Bosque", "TX_Bowie", "TX_Brazoria", "TX_Brazos", "TX_Brewster", "TX_Briscoe", "TX_Brooks", "TX_Brown", "TX_Burleson", "TX_Burnet", "TX_Caldwell", "TX_Calhoun", "TX_Callahan", "TX_Cameron", "TX_Camp", "TX_Carson", "TX_Cass", "TX_Castro", "TX_Chambers", "TX_Cherokee", "TX_Childress", "TX_Clay", "TX_Cochran", "TX_Coke", "TX_Coleman", "TX_Collin", "TX_Collingsworth", "TX_Colorado", "TX_Comal", "TX_Comanche", "TX_Concho", "TX_Cooke", "TX_Coryell", "TX_Cottle", "TX_Crane", "TX_Crockett", "TX_Crosby", "TX_Culberson", "TX_Dallam", "TX_Dallas", "TX_Dawson", "TX_Deaf_Smith", "TX_Delta", "TX_Denton", "TX_DeWitt", "TX_Dickens", "TX_Dimmit", "TX_Donley", "TX_Duval", "TX_Eastland", "TX_Ector", "TX_Edwards", "TX_El_Paso", "TX_Ellis", "TX_Erath", "TX_Falls", "TX_Fannin", "TX_Fayette", "TX_Fisher", "TX_Floyd", "TX_Foard", "TX_Fort_Bend", "TX_Franklin", "TX_Freestone", "TX_Frio", "TX_Gaines", "TX_Galveston", "TX_Garza", "TX_Gillespie", "TX_Glasscock", "TX_Goliad", "TX_Gonzales", "TX_Gray", "TX_Grayson", "TX_Gregg", "TX_Grimes", "TX_Guadalupe", "TX_Hale", "TX_Hall", "TX_Hamilton", "TX_Hansford", "TX_Hardeman", "TX_Hardin", "TX_Harris", "TX_Harrison", "TX_Hartley", "TX_Haskell", "TX_Hays", "TX_Hemphill", "TX_Henderson", "TX_Hidalgo", "TX_Hill", "TX_Hockley", "TX_Hood", "TX_Hopkins", "TX_Houston", "TX_Howard", "TX_Hudspeth", "TX_Hunt", "TX_Hutchinson", "TX_Irion", "TX_Jack", "TX_Jackson", "TX_Jasper", "TX_Jeff_Davis", "TX_Jefferson", "TX_Jim_Hogg", "TX_Jim_Wells", "TX_Johnson", "TX_Jones", "TX_Karnes", "TX_Kaufman", "TX_Kendall", "TX_Kenedy", "TX_Kent", "TX_Kerr", "TX_Kimble", "TX_King", "TX_Kinney", "TX_Kleberg", "TX_Knox", "TX_La_Salle", "TX_Lamar", "TX_Lamb", "TX_Lampasas", "TX_Lavaca", "TX_Lee", "TX_Leon", "TX_Liberty", "TX_Limestone", "TX_Lipscomb", "TX_Live_Oak", "TX_Llano", "TX_Loving", "TX_Lubbock", "TX_Lynn", "TX_Madison", "TX_Marion", "TX_Martin", "TX_Mason", "TX_Matagorda", "TX_Maverick", "TX_McCulloch", "TX_McLennan", "TX_McMullen", "TX_Medina", "TX_Menard", "TX_Midland", "TX_Milam", "TX_Mills", "TX_Mitchell", "TX_Montague", "TX_Montgomery", "TX_Moore", "TX_Morris", "TX_Motley", "TX_Nacogdoches", "TX_Navarro", "TX_Newton", "TX_Nolan", "TX_Nueces", "TX_Ochiltree", "TX_Oldham", "TX_Orange", "TX_Palo_Pinto", "TX_Panola", "TX_Parker", "TX_Parmer", "TX_Pecos", "TX_Polk", "TX_Potter", "TX_Presidio", "TX_Rains", "TX_Randall", "TX_Reagan", "TX_Real", "TX_Red_River", "TX_Reeves", "TX_Refugio", "TX_Roberts", "TX_Robertson", "TX_Rockwall", "TX_Runnels", "TX_Rusk", "TX_Sabine", "TX_San_Augustine", "TX_San_Jacinto", "TX_San_Patricio", "TX_San_Saba", "TX_Schleicher", "TX_Scurry", "TX_Shackelford", "TX_Shelby", "TX_Sherman", "TX_Smith", "TX_Somervell", "TX_Starr", "TX_Stephens", "TX_Sterling", "TX_Stonewall", "TX_Sutton", "TX_Swisher", "TX_Tarrant", "TX_Taylor", "TX_Terrell", "TX_Terry", "TX_Throckmorton", "TX_Titus", "TX_Tom_Green", "TX_Travis", "TX_Trinity", "TX_Tyler", "TX_Upshur", "TX_Upton", "TX_Uvalade", "TX_Val_Verde", "TX_Van_Zandt", "TX_Victoria", "TX_Walker", "TX_Waller", "TX_Ward", "TX_Washington", "TX_Webb", "TX_Wharton", "TX_Wheeler", "TX_Wichita", "TX_Wilbarger", "TX_Willacy", "TX_Williamson", "TX_Wilson", "TX_Winkler", "TX_Wise", "TX_Wood", "TX_Yoakum", "TX_Young", "TX_Zapata", "TX_Zavala" }; #endregion CollectionAssert.AreEqual(expected, allIdsByColumnName); }