protected override void Execute(CodeActivityContext context)
{
// Initialize Tools create for this project (Class Tools or Tools.cs)
Tools toolKit = new Tools();
// Return the Letter Representation of the ColIndex
ColLetter.Set(context, toolKit.GetColLetter(ColIndex.Get(context)));
}
public bool Equals(Token other)
{
//Check whether the compared object is null.
if (ReferenceEquals(other, null)) return false;
//Check whether the compared object references the same data.
if (ReferenceEquals(this, other)) return true;
//Check whether the products' properties are equal.
return Value.Equals(other.Value) && ColIndex.Equals(other.ColIndex) && RowIndex.Equals(other.RowIndex) && Type.Equals(other.Type);
}
public override string ToString()
{
string retVal = "";
retVal += ColIndex.ToString(CultureInfo.InvariantCulture) + ";";
retVal += ColName + ";";
retVal += ColType + ";";
retVal += ParamType + ";";
retVal += NormType + ";";
retVal += MissingValue;
return(retVal);
}
protected override void Execute(CodeActivityContext context)
{
//Load Input Fields unto local variables
string headerName = HeaderName.Get(context);
string filePath = FilePath.Get(context);
string colLetter = ColLetter.Get(context);
int colIndex = ColIndex.Get(context);
// Initialize Tools create for this project (Class Tools or Tools.cs)
Tools toolKit = new Tools();
//Validate if Column Letter is empty and Column Index is 0 to return an error or continue
if (String.IsNullOrEmpty(colLetter) && colIndex == 0)
{
//We require at least one of the two Column values to process, if not return false and throw an exception
HeaderSet.Set(context, false);
throw new ArgumentNullException();
}
else
{
//If one exists continue
//Validate that file path is not empty
if (!String.IsNullOrEmpty(filePath))
{
try
{
//Initialize Excel Interop objects;
object m = Type.Missing;
Application xlApp = new Application();
Workbooks xlWorkbooks = xlApp.Workbooks;
_Workbook xWB;
//check if file Exists if not Create the file first
if (!File.Exists(filePath))
{
xWB = xlWorkbooks.Add(XlWBATemplate.xlWBATWorksheet);
xWB.SaveAs(filePath, XlFileFormat.xlOpenXMLWorkbook, m, m, false, false, XlSaveAsAccessMode.xlShared, false, false, m, m, m);
xWB.Close();
}
Workbook xlWorkbook = xlWorkbooks.Open(filePath, m, false, m, m, m, m, m, m, m, m, m, m, m, m);
_Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Range xlRange = xlWorksheet.UsedRange;
//Validate if Column Letter is empty to determine if to use the column letter or the column index input fields
if (String.IsNullOrEmpty(colLetter))
{
//Set Header using Column Index
((Excel.Range)xlWorksheet.Cells[1, colIndex]).Value2 = headerName;
}
else
{
//Set Header using Column Letter
((Excel.Range)xlWorksheet.Cells[1, toolKit.GetColNumber(colLetter)]).Value2 = headerName;
}
//Save and Close Workbook
xlWorkbook.Save();
xlWorkbook.Close(true, m, m);
//CLOSE AND GARBAGE COLLECT
Marshal.ReleaseComObject(xlWorksheet);
xlWorksheet = null;
Marshal.ReleaseComObject(xlWorkbooks);
xlWorkbooks = null;
Marshal.ReleaseComObject(xlWorkbook);
xlWorkbook = null;
xlApp.Quit();
Marshal.ReleaseComObject(xlApp);
xlApp = null;
GC.Collect(); //Garbage Collect
GC.WaitForPendingFinalizers(); //Wait until Garbage Collect completes
HeaderSet.Set(context, true);
}
catch
{
HeaderSet.Set(context, false);
throw;
}
}
else
{
HeaderSet.Set(context, false);
throw new ArgumentNullException();
}
}
}
protected override void Execute(CodeActivityContext context)
{
//Load Input Fields unto local variables
string filePath = FilePath.Get(context);
string colLetter = ColLetter.Get(context);
int colIndex = ColIndex.Get(context);
int rowIndex = RowIndex.Get(context);
//Validate that file path is not empty
if (!String.IsNullOrEmpty(filePath))
{
//Validate that file exists
if (File.Exists(filePath))
{
try
{
//Initialize Excel Interop objects;
object m = Type.Missing;
Excel.Application xlApp = new Excel.Application();
Excel.Workbooks xlWorkbooks = xlApp.Workbooks;
Excel.Workbook xlWorkbook = xlWorkbooks.Open(filePath, m, true, m, m, m, m, m, m, m, m, m, m, m, m);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
// Initialize Tools create for this project (Class Tools or Tools.cs)
Tools toolKit = new Tools();
//Validate if Column Letter is empty and Column Index is 0 to return an error or continue
if (String.IsNullOrEmpty(colLetter) && colIndex == 0)
{
//We require at least one of the two Column values to process, if not return false and throw an exception
Status.Set(context, "Error: No Column Letter or Index provided.");
throw new ArgumentNullException();
}
else
{
//Validate if Column Letter is empty to determine if to use the column letter or the column index input fields
if (String.IsNullOrEmpty(colLetter))
{
//Get Status Value using Column Index
Status.Set(context, ((Excel.Range)xlWorksheet.Cells[rowIndex, colIndex]).Value);
}
else
{
//Get Status Value using Column Letter(s)
Status.Set(context, ((Excel.Range)xlWorksheet.Cells[rowIndex, toolKit.GetColNumber(colLetter)]).Value);
}
}
//Close Workbook no Save
xlWorkbook.Close(false, m, m);
//CLOSE AND GARBAGE COLLECT
Marshal.ReleaseComObject(xlWorksheet);
xlWorksheet = null;
Marshal.ReleaseComObject(xlWorkbooks);
xlWorkbooks = null;
Marshal.ReleaseComObject(xlWorkbook);
xlWorkbook = null;
xlApp.Quit();
Marshal.ReleaseComObject(xlApp);
xlApp = null;
GC.Collect(); //Garbage Collect
GC.WaitForPendingFinalizers(); //Wait until Garbage Collect completes
}
catch
{
throw;
}
}
else
{
throw new FileNotFoundException();
}
}
else
{
throw new ArgumentNullException();
}
}
