int e = excelcall("invisible"); //隐式调用excel程序，不显示界面，调用成功时e值为1，否则为0。
int w = wb1("Open", "D:\test.xlsx"); //打开指定的excel文件，成功返回值为1，否则为0。

string valStr = wb1range(1,"B2","Value()"); //获取第1个sheet中单元格B2的值\
printf(valStr);
wb1range(1,"D2","SetValue(conts QVariant&)",valStr);  //设置第1个sheet中单元格D2的值
//wb1cell(1,2,3,"SetValue(conts QVariant&)",valStr);  //设置第1个sheet中第2行，第3列单元格的值

wb1("Save"); //保存
wb1("Close"); //关闭
excelquit(); //退出excel调用。


常用操作(1个单元格的区域参数都可以用行,列参数代替(wb1cell、wb1cellget、wb1cellset))：

string valStr = wb1range(1,"B2","Value()"); //获取第1个sheet中单元格B2的值

wb1range(1,"D2","SetValue(conts QVariant&)",valStr);  //设置第1个sheet中单元格D2的值
wb1cell(1,2,3,"SetValue(conts QVariant&)",valStr);  //设置第1个sheet中第2行，第3列单元格的值

wb1range(1,"C2","SetForMula(conts QVariant&)","=A2+B2");  //设置第1个sheet中单元格C2的公式

wb1range(1,"B:B","Insert()"); //在B列前参入1空列
wb1range(1,"5:5","Insert()"); //在第5行前参入1空行
wb1range(1,"B:B","Delete()"); //删除B列
wb1range(1,"5:5","Delete()"); //删除第5行
wb1range(1,"UsedRange","Replace(const QString&,const QString&)","营业收入","收入"); //对工作表中已经使用了的单元格区域进行查找替换

wb1rangeget(1,"A1","Value"); //获取A1单元格值
wb1rangeget(1,"C2","Formula"); //获取C1单元格公式
wb1rangeget(1,"A2:E5","Row"); //获取A2:E5区域的起始行
wb1rangeget(1,"A2:E5","Column"); //获取A2:E5区域的起始列
wb1rangeget(1,"A2:E5","Rows"); //获取A2:E5区域的行数
wb1rangeget(1,"A2:E5","Columns"); //获取A2:E5区域的列数
wb1rangeget(1,"UsedRange","Rows"); //获取工作表中已经使用了的单元格区域行数
wb1rangeget(1,"UsedRange","Columns"); //获取工作表中已经使用了的单元格区域列数

wb1rangeset(1,"A1","RowHeight",50); //设置单元格行高
wb1rangeset(1,"A1","ColumnWidth",30);  //设置单元格列宽

wb1rangeset(1,"A3","HorizontalAlignment",-4131); //左对齐
wb1rangeset(1,"A3","HorizontalAlignment",-4108); //居中
wb1rangeset(1,"A3","HorizontalAlignment",-4152); //右对齐
wb1rangeset(1,"A3","VerticalAlignment",-4160); //上对齐
wb1rangeset(1,"A3","VerticalAlignment",-4108); //居中
wb1rangeset(1,"A3","VerticalAlignment",-4107); //下对齐

wb1rangeset(1,"A5","Interior","Color","0,0,255"); //设置单元格rgb背景色

wb1rangeset(1,"A7","Font","Name","华文彩云"); //设置字体
wb1rangeset(1,"D2","Font","Bold",1); //设置字体加粗
wb1rangeset(1,"D2","Font","Bold",0); //取消字体加粗
wb1rangeset(1,"D2","Font","Size",20); //设置字体大小
wb1rangeset(1,"D2","Font","Italic",1); //设置字体斜体
wb1rangeset(1,"D2","Font","Italic",0); //取消字体斜体
wb1rangeset(1,"A8","Font","Underline",2); //设置下划线
wb1rangeset(1,"A8","Font","Underline",1); //取消下划线
wb1rangeset(1,"A8","Font","Color","0,0,255"); //设置字体rgb颜色

wb1rangeset(1,"A3:A4","MergeCells",1); //合并单元格
wb1rangeset(1,"A3:A4","MergeCells",0); //拆分单元格

