C派生matlab读取excel脚本-CSDN博客

matlab那个代码有点长，而且数据多。。。。一个个打不方便。。。不如直接用个脚本派生，或者matlab oop，现在没网上，oop没资料，故直接写个C的脚本派生了，matlab读取execl的代码在这http://blog.csdn.net/fzxy002763/article/details/7983534

// create by Edward.xu
// must
// 16.9.2012

#include "stdio.h"
#include "stdlib.h"

#define QUALITY_SIZE 10

int main()
{

  FILE *fp; 
  int  class = 0;
  int  test = 0;	
  int  start_number = 0;
  int  end_number = 0;
  char start_char = 0;
  char end_char = 0;
  char file_name[] = "附件1-葡萄酒品尝评分表.xls";
  char label_name[] = "第一组红葡萄酒品尝评分";
  int  i = 0;
  char var_name[][QUALITY_SIZE]  = {"WGCQD","WGSD","XQCZD","XQND","XQZL","KGCZD","KGND","KGCJX","KGZL","AVG"}; 

  //init
  start_char   = 'C';
  end_char     = 'L';
  start_number = 5;
  end_number   = 5;
  class        = 1;
  test         = 25;  

  
  //direct overwrite
  if((fp=fopen("print.m","w+"))==NULL)
  {
    printf("File cannot be opened\n");
    exit(0);
  }

  fprintf(fp,"\% 16,9,2012 at must,Edward.xu\r\n");

  for(i = 0; i < QUALITY_SIZE ; i++)
    {
       fprintf(fp,"%s_%d_%d = xlsread(\'%s\',\'%s\',\'%c%d:%c%d\');  \r\n",var_name

[i],class,test,file_name,label_name,start_char,start_number,end_char,end_number);
       start_number++;
       end_number++;
     }

  fclose(fp);
  return 0;

}