资讯详情

Lab Windows CVI |合并单元格

# include <stdio.h> # include <stdlib.h> #include <math.h> #include "excel2000.h" #include "excelreport.h" #include <cvirte.h> #include <userint.h> #include <utility.h> #include <ansi_c.h>  //static int panelHandle; static CAObjHandle applicationHandle = 0; static CAObjHandle workbookHandle = 0; static CAObjHandle worksheetHandle = 0; static CAObjHandle workrangeHandle = 0;   VARIANT   MyCellRangeV; ERRORINFO ErrorInfo;     void openxl() { 
         ExcelRpt_ApplicationNew(0, &applicationHandle);  ExcelRpt_WorkbookOpen(applicationHandle, "C:\\Users\\7000\\Desktop\\CVI\\offset.xlsx", &workbookHandle);  ExcelRpt_GetWorksheetFromName(workbookHandle, "Sheet1", &worksheetHandle);  }  void closexl() { 
            if (worksheetHandle)               CA_DiscardObjHandle(worksheetHandle);         if (workbookHandle)        { 
                       ExcelRpt_WorkbookClose(workbookHandle, 1);
              CA_DiscardObjHandle(workbookHandle);

       }

       if (applicationHandle)

       { 
       

              ExcelRpt_ApplicationQuit(applicationHandle);
              CA_DiscardObjHandle(applicationHandle);
       }
}


int main()
{ 
          openxl(); 
    ExcelRpt_SetCellValue(worksheetHandle,"A1",CAVT_CSTRING,"Pass");
	CA_VariantSetCString (&MyCellRangeV, "A1:A5"); 
	Excel_WorksheetRange (worksheetHandle, NULL, MyCellRangeV, CA_DEFAULT_VAL, &workrangeHandle);
	Excel_RangeMerge (workrangeHandle, NULL, CA_DEFAULT_VAL);
	closexl();
// ExcelRpt_GetCellValue(worksheetHandle, "B2", CAVT_DOUBLE, &num); 
// printf("%.2f",num);

}

标签: 贴片电感cvi1014kz05

锐单商城拥有海量元器件数据手册IC替代型号,打造 电子元器件IC百科大全!

 锐单商城 - 一站式电子元器件采购平台  

 深圳锐单电子有限公司