public static void Test(String tempFolderName, String sourceSubfolderPath) { String subfolderName = Path.GetFileName(sourceSubfolderPath); String tempFolder = Path.GetFullPath(Path.Combine(TestContext.CurrentContext.WorkDirectory, @"Temp\XlsxConverterTesting")); String tempFolderPath = Path.Combine(tempFolder, subfolderName); String xlsxFilePath = GetFilePath(Path.Combine(sourceSubfolderPath, "source.xlsx")); String templateFilePath = GetFilePath(Path.Combine(sourceSubfolderPath, "template.csv")); String csvFilePath = PrepareCsvFile(Path.Combine(tempFolder, tempFolderName, subfolderName, "result.csv")); using (StreamWriter streamWriter = new StreamWriter(csvFilePath)) { CsvWriter csvWriter = new CsvWriter(streamWriter); MoqDelimitedTextWriter delimitedTextWriter = new MoqDelimitedTextWriter(csvWriter); XlsxConverter.Convert(xlsxFilePath, delimitedTextWriter); delimitedTextWriter.Flush(); streamWriter.Flush(); } FileAssert.AreEqual(csvFilePath, templateFilePath); }
public void Test_001() { Assert.Catch <ActiveWorksheetException>( () => { String xlsxFilePath = Path.GetFullPath(Path.Combine(TestContext.CurrentContext.TestDirectory, @"..\..\XlsxConverterTesting\Tester+Files\001\source.xlsx")); String csvFilePath = Path.GetTempFileName(); try { using (StreamWriter streamWriter = new StreamWriter(csvFilePath)) { CsvWriter csvWriter = new CsvWriter(streamWriter); MoqDelimitedTextWriter delimitedTextWriter = new MoqDelimitedTextWriter(csvWriter); XlsxConverter.Convert(xlsxFilePath, delimitedTextWriter); csvWriter.Flush(); streamWriter.Flush(); } } finally { File.Delete(csvFilePath); } }); }