Denise's IT Story

FUNCTION zdk_rgb_to_ole_color. *"---------------------------------------------------------------------- *"*"Local Interface: *" IMPORTING *" REFERENCE(IV_RGB) TYPE CSEQUENCE *" EXPORTING *" REFERENCE(EV_COLOR) TYPE CSEQUENCE *" EXCEPTIONS *" INVALID_COLOR *"---------------------------------------------------------------------- CONSTANTS: lc_rgb TYPE i VALUE 256. DATA: lv_color TYPE c LENGTH 6. D..

1. 엑셀 upload시 셀서식에 의해 데이터가 변형되는것을 방지 할때 사용. 2. 용도 : 엑셀의 날짜값을 raw data로 받아 날짜로 변환.FUNCTION zcp_excel_date_from_serial. *"---------------------------------------------------------------------- *"*"Local interface: *" IMPORTING *" REFERENCE(IV_DAYS) TYPE CHAR08 *" EXPORTING *" REFERENCE(EV_DATE) TYPE DATS *"---------------------------------------------------------------------- DATA : lv_years TYPE ..

ZEXCEL_T_HEADER ZEXCEL_S_HEADER ROW 1 Types ZDK_SEQ NUMC 3 TEXT 1 Types CHAR255 CHAR 255 ZEXCEL_T_COLOR ZEXCEL_S_COLOR FIELDNAME 1 Types FIELDNAME COLOR 1 Types UAC_COLOR FUNCTION zdk_download_excel . *"---------------------------------------------------------------------- *"*"Local Interface: *" IMPORTING *" REFERENCE(IV_TITLE) TYPE CHAR255 *" VALUE(IT_HEADER) TYPE ZEXCEL_T_HEADER *" REFERENCE(..

XlHAlign EnumerationNameValueDescriptionxlHAlignCenter-4108Center.xlHAlignCenterAcrossSelection7Center across selection.xlHAlignDistributed-4117Distribute.xlHAlignFill5Fill.xlHAlignGeneral1Align according to data type.xlHAlignJustify-4130Justify.xlHAlignLeft-4131Left.xlHAlignRight-4152Right. http://msdn.microsoft.com/en-us/library/bb241313(v=office.12).aspx XlVAlign Enumeration NameValueDescript..

*---- 엑셀 Structure______________________________ZEXCEL_T_HEADER______________________________ZEXCEL_S_HEADER______________________________ROWTypesZESEQ3 NUMC3TEXTTypesCHAR255 CHAR255______________________________ *---- 엑셀 헤더 FUNCTION zcp_excel_header. *"---------------------------------------------------------------------- *"*"Local interface: *" IMPORTING *" VALUE(IT_EXCEL) TYPE STANDARD TABLE ..