EBDN - Community - Question & Answers

  Tuesday, 21 November 2017
  12 Replies
  6.2K Visits
0
Votes
Undo
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..)
}
};
}