public static XlsSlangEngine CreateEngine(string filename)
{
String ConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;";
ConnStr = ConnStr + "Data Source=" + filename + ";Extended Properties=\"Excel 12.0 Xml;MaxScanRows=0;HDR=YES;IMEX=1\"";
CExcelReader rd = new CExcelReader(ConnStr, null);
XlsSlangEngine s = new XlsSlangEngine(rd);
return(s);
}
/// <summary>
/// Entry Point ...
/// </summary>
/// <param name="args"></param>
static void Main(string[] args)
{
string file_name = null;
bool _diag = false;
/////////////////////////////////////////////////
//
// if no argument or empty argument ...use
// the default worksheet
if (args == null || args.Length == 0)
{
file_name = "Federal_Rules_Final_Test.xlsx";
}
else
{
file_name = args[0];
}
if (args.Length == 2 && String.Compare(args[1], "-d") == 0)
{
_diag = true;
}
////////////////////////////////////////////////////////////
// Check whether the Excel File exists or not ...
//
if (!File.Exists(file_name))
{
Console.WriteLine("Unable to Locate file => " + file_name);
return;
}
///////////////////////////////////////////////////////////////////
//
// Create the Engine....
//
XlsSlangEngine s = Helper.CreateEngine(file_name);
if (s == null)
{
Console.WriteLine("Failed to initialize the engine ");
return;
}
if (!s.Run(_diag))
{
Console.WriteLine("Failed While processing ..............");
return;
}
}