I am trying to create a new excel with my results and then replace it using this code for macro ImageJ:
run("Clear Results"); path = saveDir +"Results.xls"; saveAs("Results" , path); setResult("my name", i, ct2);
my name: place holder for another column name
i : a for loop used to change the row
ct2: a number changing as the for loop progresses
However it keeps returning an error stating there is not enough Rows or row(1) out of range, and I was wondering how exactly to fix it.
If there is an alternative method to create new excel spread sheet and constantly add new data using my same variable please let me know.