public void SaveSheetAsTextWithRange()
{
ExcelFile file = new ExcelFile();
file.FileName = System.IO.Path.Combine(m_ApplicationDirectory, "DateTimeCombineExcel.xlsx");
file.SheetName = "Combinations";
file.SheetRange = "A12:D24";
file.ShowProgress = false;
using (ExcelFileReaderInterop reader = new ExcelFileReaderInterop())
{
reader.Open(file, System.Threading.CancellationToken.None, false);
reader.SaveSheetAsText(null, null, m_Output);
}
Assert.IsTrue(File.Exists(m_Output));
}
public void SaveSheetAsTextWithRangeAndProcess()
{
ExcelFile file = new ExcelFile();
file.FileName = System.IO.Path.Combine(m_ApplicationDirectory, "DateTimeCombineExcel.xlsx");
file.SheetName = "Combinations";
file.SheetRange = "B1:B5";
file.ShowProgress = false;
using (ExcelFileReaderInterop reader = new ExcelFileReaderInterop())
{
using (FormProcessDisplay disp = new FormProcessDisplay("Test", null, null))
{
reader.ProcessDisplay = disp;
reader.Open(file, System.Threading.CancellationToken.None, true);
reader.SaveSheetAsText(disp, null, m_Output);
}
}
Assert.IsTrue(File.Exists(m_Output));
}
public void ExcelFileReaderOpenWrongSheetName()
{
try
{
ExcelFile file = new ExcelFile();
file.FileName = System.IO.Path.Combine(m_ApplicationDirectory, "DateTimeCombineExcel.xlsx");
file.SheetName = "Combin ations";
file.SheetRange = null;
file.ShowProgress = false;
using (ExcelFileReaderInterop reader = new ExcelFileReaderInterop())
{
reader.Open(file, System.Threading.CancellationToken.None, false);
reader.SaveSheetAsText(null, null, m_Output);
}
}
catch (Exception)
{
return;
}
Assert.Fail("Expected Exception");
}
