归档数据转化为电子表格WINCC脚本

#include "apdefap.h"
intgscAction( void )
{
#pragma code("kernel32.dll");
void GetLocalTime(SYSTEMTIME* lpst);
#pragma code();
SYSTEMTIME st;
const char param[512][30]={
"fq02_pv","cod2_pv","nh3_n2#_pv","fq01_pv","cod1_pv","nh3_n1#_ pv","DO_shc_pv","SS_shc_pv","gfj_1#gfj_A_PV","gfj_2#gfj_A_PV","LT_jsb f_PV","LT_psj_PV",
"LT_lc801_PV","LT_lc1_PV","LT_lc2_PV","LT_lc3_PV","LT_lc4_PV"};
char VarName[512][30]={
"Date","备用1","备用2","出水流量","出水COD","出水氨氮","进水流量","进水COD","进水氨氮","生化池溶解氧","生化池污泥浓度","1#鼓风机频率","2#鼓风机电流","进水房液位","配水井液位",
"滤池集水池液位","1#滤池液位","2#滤池液位","3#滤池液位","4#滤池液位"};
float fa;
int b1=0;
FILE *fp;
static char NameTemp[30];
static char temp[30];
char aatemp[3],aa1temp[5];
inti,x;
GetLocalTime(&st);
sprintf(aa1temp,"%4d",st.wYear);
sprintf(aatemp,"%02d",st.wMonth);//st.wMonth???????? strcpy(temp,"E:\\t");
strcat(temp,aa1temp);
strcat(temp,aatemp);
strcat(temp,".xls");
if(NameTemp!=temp){
SetTagBit("b1",0);//????????
}
{
if(GetTagBit("filtrate_mode_sign")==1)
SetTagChar("@mode_show","????");
else if(GetTagBit("rinse_mode_sign_1")==1)
SetTagChar("@mode_show"," ????");
else
SetTagChar("@mode_show","????"); }
if(GetTagBit("b1")==0){
if((fp=fopen(temp,"r"))==NULL){
b1=1;
SetTagBit("b1",0);
}
else{
b1=0;
SetTagBit("b1",1);
fclose(fp);
}
}
fp=fopen(temp,"a");
if(fp==NULL) return 0 ;
if(b1==1)
{
for(i=0;i<30;i++)//???VarName??????
{
fprintf(fp,"%s\t",VarName[i]);
}
fprintf(fp,"\n");
b1=0;
SetTagBit("b1",1);
}
strcpy(NameTemp,temp);
fprintf(fp,"%4d-%02d-%02d %02d:%02d:%02d\t",st.wYear,st.w Month,st.wDay,st.wHour,st.wMinute,st.wSecond);
fprintf(fp,"%s\t%s\t",GetTagChar("@CurrentUser"),GetTagChar(" @mode_show"));
for(x=0;param[x][0]!=0&&x<512;x++)
{
fprintf(fp,"%5.1f \t",GetTagFloat(param[x]));
}
fprintf(fp,"\n");
fclose (fp);
return 0;。