Hello Everyone
I am just beginning to learn C# Development in EBase. In past I have done lot of VBA Development. Now I want to convert my VBA Development into C# Development
In following sample Code which I downloaded from C# Sample Project from EBDN Community. This C# code is looping through
Worksheet. I have done similar thing in VBA. But I need help in C#.
Question: In For Loop.
1) How
do I capture Column Name for the
Worksheet.
2) How
do I Edit or Update value in the
Worksheet row and Store the value after the edit
foreach (WorksheetRow row in
worksheet.Rows)
{
for (int i = 0; i <
worksheet.Columns.Count; i++)
{
string val = "";
try
{
val = row.GetValue<string>(i);
Debug.Print("Val =" + val);
// Debug.Print(row.Kin);
}
catch
{
// value is not a string, (it can be a boolean..)
}
};
}