C派生matlab读取excel脚本

Matlab读取Excel数据

最新推荐文章于 2023-01-18 00:30:00 发布

最新推荐文章于 2023-01-18 00:30:00 发布 · 131 阅读

文章标签：

#matlab

本文提供了一个使用C语言编写的脚本，该脚本用于生成Matlab代码，以便从Excel文件中读取特定的数据范围。通过定义起始和结束字符及数字，脚本能够自动创建一系列针对不同数据质量指标的Matlab变量。

matlab那个代码有点长，而且数据多。。。。一个个打不方便。。。不如直接用个脚本派生，或者matlab oop，现在没网上，oop没资料，故直接写个C的脚本派生了，matlab读取execl的代码在这http://blog.youkuaiyun.com/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;

}