For those who may be unfamiliar with how to export data to a CSV file, here is some code that will export the name of the objects located directly beneath model() in the tree:
string filepath = filebrowse("*.csv","Excel Files",concat(cdir(),"userprojects")); // get the name of the file to open
if (stringlen(filepath) == 0) // This is true when the user presses Cancel on the file browse window
{
return 0;
}
fileopen(filepath); // open a link with an Excel workbook
for(int i = 1; i <= content(model()); i++)
{
fpt(getname(rank(model(),i)));fpr();
}
fileclose(0);
The basic steps are as follows:
-call fileopen(filepath) on a file
-call your ftp();,fpf();,fpd();, and fpr(); commands
-call fileclose(0);
Here is a quick rundown of the file print commands:
fpt() will export a string value to the open file
fpf() will export a float value to the open file
fpd() will export a integer value to the open file
fpc() will export a ASCII value to the open file
fpr() will tell the file you are moving to a new line (row)
*Some important things to remember are that you must print a comma inbetween each value that is exported. When you print a comma, that is just like moving to the next cell when working in excel.
If you need to move to a new line you must print a fpr(); to return to the next line.
For instance:
fileopen(filepath);
fpt("NAME");fpt(",");fpt("Processor4");fpt(",");fpt("RANK");fpt(",");fpd(10);fpr();
fpt("NAME");fpt(",");fpt("Combiner24");fpt(",");fpt("RANK");fpt(",");fpd(15);
fileclose(0);
Would write:
NAME,Processor4,RANK,10
NAME,Combiner24,RANK,15
to the csv file specified as 'filepath'
When this csv file is opened in excel it would have:
NAME in Row1 Col A, Processor4 in Row 1 Col B, RANK in Row 1 Col C, and 10 in Row 1 Col D.
NAME in Row2 Col A, Combiner24 in Row 2 Col B, RANK in Row 2 Col C, and 15 in Row 2 Col D.
|
thats not normal.
