public void MergeFilesTest()
{
//DateTime date = DateTime.Now.Date.AddDays(0 - (int)DateTime.Now.DayOfWeek);
int weekOfYear = weekofyear(DateTime.Now);
weekOfYear = weekofyear(DateTime.Parse("2009/12/31"));
weekOfYear = weekofyear(DateTime.Parse("2010/01/01"));
weekOfYear = weekofyear(DateTime.Parse("2010/12/31"));
int m = ExcelUtilies.ExcelColumnNameToIndex("AN");
string c = ExcelUtilies.ExcelColumnIndexToName(m);
//ExecelAdapter target = new ExecelAdapter(); // TODO: Initialize to an appropriate value
//Dictionary<string, string> MergedFiles = new Dictionary<string,string>(); // TODO: Initialize to an appropriate value
//MergedFiles.Add("China", @"C:\ReportExport\Etag_20110922_160228.xls");
//MergedFiles.Add("Jan", @"C:\ReportExport\Etag_20110927_142140.xls");
//MergedFiles.Add("USA", @"C:\ReportExport\Etag_20111009_163730.xls");
//MergedFiles.Add("French", @"C:\ReportExport\Etag_20111011_140943.xls");
//string outputFile = @"C:\ReportExport\MergedReport" + DateTime.Now.Second + ".xls"; // TODO: Initialize to an appropriate value
//bool expected = true; // TODO: Initialize to an appropriate value
//bool actual;
//actual = target.MergeFiles(MergedFiles, outputFile);
//Assert.AreEqual(expected, actual);
//Assert.Inconclusive("Verify the correctness of this test method.");
}
public void ExcelColumnNameToIndexTest()
{
string name = "AB"; // TODO: Initialize to an appropriate value
int expected = 28; // TODO: Initialize to an appropriate value
int actual;
actual = ExcelUtilies.ExcelColumnNameToIndex(name);
Assert.AreEqual(expected, actual);
//Assert.Inconclusive("Verify the correctness of this test method.");
}
public void ExcelColumnIndexToNameTest()
{
DateTime date = DateTime.Now.Date.AddDays(0 - DateTime.Now.Day);
int Index = 28; // TODO: Initialize to an appropriate value
string expected = "AB"; // TODO: Initialize to an appropriate value
string actual;
actual = ExcelUtilies.ExcelColumnIndexToName(Index);
Assert.AreEqual(expected, actual);
//Assert.Inconclusive("Verify the correctness of this test method.");
}
