tailieunhanh - Excel Add-in Development in C/C++ Applications in Finance phần 10

Tham khảo tài liệu 'excel add-in development in c/c++ applications in finance phần 10', công nghệ thông tin, kỹ thuật lập trình phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Example Add-ins and Financial Applications 341 Prototype xloper stdcall compare_nchars char Atext char Btext short n_chars xloper op_is_case_sensitive Type string RCCIP Notes Any error in input is reflected with an Excel VALUE error. Return type does not need to allow for reference xlopers. This function is a wrapper for the C library functions strncmp and strincmp . xloper __stdcall compare_nchars char Atext char Btext short n_chars xloper op_is_case_sensitive static xloper ret_oper 0 xltypeNum if Atext Btext n_chars 0 n_chars 255 return p_xlErrValue Case-sensitive by default bool case_sensitive op_is_case_sensitive- xltype xltypeBool op_is_case_sensitive- 1 if case_sensitive strnicmp Atext Btext n_chars else strncmp Atext Btext n_chars return ret_oper Function name concat exported Concat registered with Excel Description Concatenate the contents of the given range row-by-row using the given separator or comma by default . Returned string length limit is 255 characters by default but can be set lower. Caller can specify the number of decimal places to use when converting numbers. Prototype xloper stdcall concat xloper inputs xloper p_delim xloper p_max_len xloper p_num_decs Type string RPPPP xloper __stdcall concat xloper inputs xloper p_delim xloper p_max_len xloper p_num_decs 342 Excel Add-in Development in C C cpp_xloper Inputs inputs if xltypeMissing xltypeNil return p_xlErrValue char delim p_delim- xltype xltypeStr p_delim- 1 long max_len p_max_len- xltype xltypeNum long p_max_len- 255l long num_decs p_num_decs- xltype xltypeNum long p_num_decs- -1 char buffer char calloc MAX_CONCAT_LENGTH sizeof char char p cpp_xloper Rounding num_decs long total_length 0 DWORD size size if size MAX_CONCAT_CELLS size MAX_CONCAT_CELLS for DWORD i 0 i size if num_decs 0 num_decs 16 i xltypeNum xloper p_op i Excel4 xlfRound p_op