对excel文件数据的操作

运行程序后...



首先点击Creat File按钮创建标准EXCEL文件（非标准excel文件笨程序无法操作）



打开程序目录下的name.xls,

excel文件下有3件工作簿分别为TestSheet1，TestSheet2，TestSheet3



//////////一定要注意任何数据不能只是数字!!!!!









将第一组数据复制到TestSheet1里"数据A1"列中

将第二组数据复制到TestSheet2里"数据B1"列中



保存关闭文件，打开程序



下列4个选项

"A并且B"　　刷第一组和第二组共同存在的数据。

"A或B"　　　　刷第一组或第二组存在的数据。

"A非B"　　　　刷第一组而不再第二组的数据。

"B非A"　　　　刷第而组而不再第一组的数据。



不用的选项不要选，节省时间，对excel写操作比较慢，需耐心等待（程序运行卡住时等待即可）。-After running the program ... First Click Creat File button to create a standard EXCEL file the (nonstandard excel file stupid program can not operate) open the program directory name.xls excel file 3 workbook the for TestSheet1 TestSheet2 TestSheet3////////// Be sure to pay attention to any data not just numbers!!!!! where the first set of data is copied to the TestSheet1 " the data A1"　column in the second set of data replication to TestSheet2 where data B1 close the file is stored in the column, open procedures following four option " A and B"　authorize the first and second group of co-existence of data. " A or B"　authorize the existing data in the first or second group. " A non-B"　brush rather than the second group of data in the first group. B non-A " the brush first group rather than the first group of data. Do not have the option not to vote, to save time, slower writes to excel, to be patient (program run stuck waiting for it).