static void Main(string[] args) { try { SheetRow[] rows = null; if (usingExcel) { Console.WriteLine("Using .xlsx Excel sheet for data...."); rows = new XLSXDataSource(EXCEL_SHEET_PATH).GetRows(); } else { Console.WriteLine("Using Google sheet (on Google Drive) for data...."); rows = new GoogleDataSource().GetRows(); } Script script = new Script(rows); Console.WriteLine("Saving xml data file..."); script.GetXML().Save("SceneBreakdown.xml"); Console.WriteLine("Application finished."); Console.WriteLine("press any key to terminate..."); Console.ReadKey(); } catch (Exception e) { Console.WriteLine("Catastrophic failure occured:"); Console.WriteLine("If this continues contact [email protected]"); Console.WriteLine("press any key to terminate..."); Console.ReadKey(); return; } }
public void GetXML() { XLSXDataSource data = new XLSXDataSource(TEST_DATA_PATH_1); SheetRow[] rows = data.GetRows(); Script script = new Script(rows); XmlDocument doc = script.GetXML(); Assert.AreEqual(2, doc.SelectNodes("script/act").Count); Assert.AreEqual(3, doc.SelectNodes("script/act[@number='1']/scene").Count); Assert.AreEqual(4, doc.SelectNodes("script/act[@number='2']/scene[@number='3']/moment").Count); Assert.AreEqual("We will need to shut down her ", doc.SelectSingleNode("script /act[@number='2']/scene[@number='3']/moment[@title='Planning Dialogue, Leo joins']/@line").Value); }
static void Main(string[] args) { string tableName = "LarData"; string[] mappingColumnNames = new string[] { "ent", "rec_no", "msa", "perc_min", "trct_incm", "app_incm", "ltv", "purpose", "fed_grn", "race", "co_race", "sex", "co_sex", "no_unit", "aff_catg" }; IFileDataSource dataSource = new XLSXDataSource(); dataSource.FileName = @"D:\tmp\Book2.xlsx"; dataSource.sheetName = "sheet1$"; using (var import = new Import(dataSource)) { import.DoImport(tableName, mappingColumnNames); } }
public void ScriptTest2() { XLSXDataSource data = new XLSXDataSource(TEST_DATA_PATH_1); SheetRow[] rows = data.GetRows(); Script script = new Script(rows); Assert.AreEqual("01:30:00", script.TotalTime); Assert.AreEqual(2, script.Acts.Length); Assert.AreEqual(3, script.Acts[0].Scenes.Length); Assert.AreEqual(3, script.Acts[1].Scenes.Length); Assert.AreEqual(12, script.Acts[0].Scenes[0].Moments.Length); Assert.AreEqual("FIRST SET : INTRO", script.Acts[0].Scenes[0].Moments[0].Title); Assert.AreEqual("", script.Acts[0].Scenes[0].Moments[0].Duration); Moment momentUnderTest = script.Acts[1].Scenes[1].Moments[6]; Assert.AreEqual("Out of sex scene", momentUnderTest.Title); Assert.AreEqual("Guess you're not in Kansas any more", momentUnderTest.Line); Assert.AreEqual("", momentUnderTest.Duration); Assert.AreEqual("", momentUnderTest.Location); Assert.AreEqual("", momentUnderTest.SFX); }
public void TestInit() { _dataSource = new XLSXDataSource(TEST_DATA_PATH_1); _privateDataSource = new PrivateObject(_dataSource); }