static void Main(string[] args) { var extractZips = new ExtractZip(); extractZips.OpenZip(); var ConvertPdftoCsv = new ConvertPdftoCsv(); ConvertPdftoCsv.OpenFiles(); var readCsv = new ReadCsv(); var filename = (@"C:\Users\dabos\Downloads\Batch Reports\NewFolder\"); var fname2 = ("*.csv"); var fullfname = filename + fname2; var table = readCsv.ReadCsvAndConvertToDataTable(filename); var excelService = new ExcelService(); excelService.CreateAndSaveExcelFileFromDataTable(table, filename); }
public void TestExtractNoOfFiles() { int expectedNoOfFilesInZip = 3; var pipeline = PipelineFactory.CreateEmptyReceivePipeline(); var component = new ExtractZip(); string zipPath = @"TestData\test.zip"; pipeline.AddComponent(component, PipelineStage.Disassemble); using (FileStream fs = new FileStream(zipPath, FileMode.Open, FileAccess.Read)) { using (StreamReader sr = new StreamReader(fs)) { var message = MessageHelper.CreateFromStream(sr.BaseStream); var outout = pipeline.Execute(message); Console.WriteLine(outout.Count.ToString()); Assert.IsTrue(outout.Count == expectedNoOfFilesInZip); } } }