C语言编程将EXCEL里的数据导出来修改
如何用C语言编程将EXCEL里的数据导出修改,然后再导回EXCEL文件里
以下是我的程序,导出来后总是乱码
#include"stdio.h"
#include<stdlib.h>
#define N 1
struct hang
{
long id;
double mianji;
double zhouchang;
char FEATUREID[26];
char CHFCAC[6];
char HXDD[6];
long double HXGAKA;
long double HXGAKB;
char neixing[10];
char xingtai[16];
char chuangzhuang[8];
double chang;
double kuan;
double jiamian;
double jiazhou;
long RegNo;
long id0;
double mianji0;
double zhouchang0;
char FEATUREID0[26];
char CHFCAC0[6];
char neixing0[8];
char xingtai0[16];
char chuangzhuang0[8];
double chang0;
double kuan0;
float WTCEBQ;
float WTCEBR;
};
void main()
{
FILE*fp,*op;
struct hang ha[N];
int i;long j;
fp=fopen("C://Documents and Settings//Administrator//桌面//1.xls","r");
op=fopen("C://Documents and Settings//Administrator//桌面//out.xls","w");
if(fp==NULL)
{
printf("can't open file\n");
exit(0);
}
if(op==NULL)
{
printf("can't write file\n");
exit(0);
}for(i=0;i<N;i++){fscanf(fp+4*i,"%ld",&j);if(j==5)printf("%d\t成功",i);}
for(i=0;i<N;i++)
{
fscanf(fp,"%ld%lf%lf%s%s%s%lf%lf\t%lf\t",&ha[i].id,&ha[i].mianji,&ha[i].zhouchang,ha[i].FEATUREID,ha[i].CHFCAC,ha[i].HXDD,&ha[i].HXGAKA,&ha[i].HXGAKB);
fscanf(fp,"%s\t%s\t%s\t%lf\t%lf\t%lf\t%lf\t%ld\t%ld\t%lf\t",ha[i].neixing,ha[i].xingtai,ha[i].chuangzhuang,&ha[i].chang,&ha[i].kuan,&ha[i].jiamian,&ha[i].jiazhou,&ha[i].RegNo,&ha[i].id0,&ha[i].mianji0);
fscanf(fp,"%lf\t%s\t%s\t%s\t%s\t%s\t",&ha[i].zhouchang0,ha[i].FEATUREID0,ha[i].CHFCAC0,ha[i].neixing0,ha[i].xingtai0,ha[i].chuangzhuang0);
fscanf(fp,"%lf\t%lf\t%f\t%f\n",&ha[i].chang0,&ha[i].kuan0,&ha[i].WTCEBQ,&ha[i].WTCEBR);
printf("%ld,%lf,%lf,%s,%s,%s",ha[i].id,ha[i].mianji,ha[i].zhouchang,ha[i].FEATUREID,ha[i].CHFCAC,ha[i].HXDD);
printf("%lf,%lf",ha[i].HXGAKA,ha[i].HXGAKB);
printf("%s,%s,%s,%lf,%lf,%lf,%lf,%ld,%ld,%lf",ha[i].neixing,ha[i].xingtai,ha[i].chuangzhuang,ha[i].chang,ha[i].kuan,ha[i].jiamian,ha[i].jiazhou,ha[i].RegNo,ha[i].id0,ha[i].mianji0);
printf("%lf,%s,%s,%s,%s,%s,%lf",ha[i].zhouchang0,ha[i].FEATUREID0,ha[i].CHFCAC0,ha[i].neixing0,ha[i].xingtai0,ha[i].chuangzhuang0,ha[i].chang0);
printf("%lf,%f,%f\n",ha[i].kuan0,ha[i].WTCEBQ,ha[i].WTCEBR);printf("%d",i);
}
fclose(fp);
for(i=0;i<N;i++)
{
fprintf(op,"%ld\t%lf\t%lf\t%s\t%s\t%s\t",ha[i].id,ha[i].mianji,ha[i].zhouchang,ha[i].FEATUREID,ha[i].CHFCAC,ha[i].HXDD);
fprintf(op,"%\tlf\t%lf\t",ha[i].HXGAKA,ha[i].HXGAKB);
fprintf(op,"%s\t%s\t%s\t%lf\t%lf\t%lf\t%lf\t%ld\t%ld\t%lf\t",ha[i].neixing,ha[i].xingtai,ha[i].chuangzhuang,ha[i].chang,ha[i].kuan,ha[i].jiamian,ha[i].jiazhou,ha[i].RegNo,ha[i].id0,ha[i].mianji0);
fprintf(op,"%lf\t%s\t%s\t%s\t%s\t%s\t%lf\t",ha[i].zhouchang0,ha[i].FEATUREID0,ha[i].CHFCAC0,ha[i].neixing0,ha[i].xingtai0,ha[i].chuangzhuang0,ha[i].chang0);
fprintf(op,"%lf\t%f\t%f\n",ha[i].kuan0,ha[i].WTCEBQ,ha[i].WTCEBR);
fclose(op);
}
return;
}
请问正确的的步骤是怎么的,具体要调用哪些API函数。