1、excel文件导入sql>http://jingyan.baidu.com/article/73c3ce28c839b7e50243d950.html
2、八个产生大数据工具:
http://www.cnblogs.com/preftest/archive/2011/01/13/1934594.html
3、在LR中生成参数化文件除了使用excel还可以尝试此段代码编辑大量数据,生成txt文本文件,导入到data wizard中。其中根据实际情况进行调整。
#define USERCOUNT 100 //定义用户数量
Action()
{
char *namecommon="people";
char *passwordcommon="22222";
char *filename= "c:\\marks.txt";
char username[20];
char password[20];
int i=0;
long file;
if((file=fopen(filename,"w+")) == NULL)
{lr_output_message("Unable to create %s",filename);
return -1;
}
for(i=0;i< USERCOUNT;i++)
{
sprintf(username,"%s%d",namecommon,i);
sprintf(password,"%s%d",passwordcommon,i);
strcat(username," ");
strcat(username,password);
strcat(username,"\r\n");
fwrite(username,strlen(username),1,file);
}
fclose(file);
return 0;
}