Clear Table

[Maddis]

Hi, I am trying to clear the Table in ZennoPoster rather than use the ZennoPoster action.

I try:

project.Tables['leadTable'].Clear();

But this does not work. Can someone help?

Thanks

 

[BAZAg]

Hi, I am trying to clear the Table in ZennoPoster rather than use the ZennoPoster action.

I try:

project.Tables['leadTable'].Clear();

But this does not work. Can someone help?

Thanks

project.Tables["leadTable"].AddRow(new[]{"123"}); // add demo
project.Tables["leadTable"].GetItems("0-end",true);

 

[Maddis]

project. Tables["leadTable"]. AddRow(new[]{"123"}); add demo
project. Tables["leadTable"]. GetItems("0-end",true);

Посмотреть вложение 107067

Yes that did the trick. Thank You

 

[Maddis]

project. Tables["leadTable"]. AddRow(new[]{"123"});  add demo
project. Tables["leadTable"]. GetItems("0-end",true);

Посмотреть вложение 107067

Thanks again. All I need to do now is save the table once I have data written to it. Is there a method to get the table contents to string value?

I have tried this but I get an error.

string CSVFile = @"C:\Test.csv"
string stream = project.Tables["leadTable"].ToString();

System.IO.File.WriteAllText(CSVFile,stream);

 

[BAZAg]

Thanks again. All I need to do now is save the table once I have data written to it. Is there a method to get the table contents to string value?

I have tried this but I get an error.

string CSVFile = @"C:\Test.csv"
string stream = project.Tables["leadTable"].ToString();

System.IO.File.WriteAllText(CSVFile,stream);

var tb = project.Tables["leadTable"];
tb.AddRow(new[]{"123", "321"});  // add demo
tb.AddRow(new[]{"123","654", "987"});  // add demo

var list = tb.GetItems("0-end",true).Select(x=>string.Join(";", x.ToArray())).ToList();
string stream = string.Join(Environment.NewLine, list);
return stream;