【免费】ABAPEXCEL通用类_abap中doi的导出Excel资源-CSDN文库

共447个文件

html：447个

excel

ABAP

需积分: 0 160 浏览量 2022-06-20 16:24:20 上传评论 2 收藏 3.53MB ZIP 举报

资源详情

资源评论

资源推荐

收起资源包目录

ABAP EXCEL通用类（447个子文件）

bind_alv_ole2.html 77KB

load_chart_attributes.html 56KB

class-zcl_excel_worksheet.html 40KB

loop_subtotal.html 34KB

shift_formula.html 31KB

change_cell_style.html 31KB

bind_table.html 29KB

class-zcl_excel_graph.html 29KB

set_cell.html 28KB

class-zcl_excel_sheet_setup.html 28KB

class-zcl_excel_converter.html 27KB

class-zcl_excel_common.html 26KB

convert_column2int.html 24KB

class-zcl_excel.html 24KB

zexcel_s_converter_fcat.html 24KB

class-zcl_excel_drawing.html 24KB

class-zcl_excel_style_conditional.html 24KB

loop_normal.html 23KB

class-zcl_excel_style_number_format.html 22KB

class-zcl_excel_table.html 22KB

set_title.html 22KB

class-zcl_excel_worksheet_columndime.html 22KB

class-zcl_excel_graph_bars.html 22KB

class-zcl_excel_graph_line.html 22KB

classindex-20220620-162141.html 21KB

convert_range2column_a_row.html 21KB

print_title_set_range.html 21KB

get_header_footer_string.html 21KB

class-zcl_excel_style_color.html 21KB

class-zcl_excel_data_validation.html 21KB

class-zcl_excel_style_font.html 21KB

create_ax.html 21KB

calculate_column_widths.html 21KB

class-zcl_excel_style_fill.html 21KB

class-zcl_excel_worksheet_rowdimensi.html 20KB

get_merge.html 20KB

recursive_struct_to_class.html 20KB

class-zcl_excel_graph_pie.html 20KB

get_fieldcatalog.html 20KB

get_structure.html 20KB

set_table.html 20KB

ask_option.html 20KB

create_table.html 20KB

class-zcl_excel_autofilter.html 20KB

class-zcl_excel_style_alignment.html 20KB

class-zcl_excel_drawings.html 20KB

get_color_style.html 20KB

unescape_string.html 20KB

recursive_class_to_struct.html 20KB

class-zcl_excel_style_border.html 20KB

zexcel_s_cstylex_font.html 20KB

bind_table.html 20KB

class-zcl_excel_worksheets.html 20KB

class-zcl_excel_styles.html 20KB

class-zcl_excel_styles_conditional.html 20KB

escape_string.html 19KB

class-zcl_excel_range.html 19KB

class-zcl_excel_ranges.html 19KB

zif_excel_sheet_protection~initialize.html 19KB

calculate_cell_distance.html 19KB

class-zcl_excel_autofilters.html 19KB

class-zcl_excel_data_validations.html 19KB

class-zcl_excel_style_borders.html 19KB

describe_structure.html 19KB

zif_excel_sheet_printsettings~set_print_repeat_columns.html 19KB

get_style.html 19KB

clean_fieldcatalog.html 19KB

class-zcl_excel_worksheet_pagebreaks.html 19KB

class-zcl_excel_style_protection.html 19KB

get_value_type.html 19KB

class-zcl_excel_style.html 19KB

get_media.html 19KB

create_style_total.html 19KB

create_serie.html 19KB

zexcel_s_fieldcatalog.html 19KB

zif_excel_sheet_printsettings~set_print_repeat_rows.html 19KB

zexcel_s_fieldcatalog.html 19KB

create_path.html 19KB

update_dimension_range.html 19KB

open_file.html 19KB

class-zcl_excel_security.html 19KB

process_header_footer.html 19KB

execute_converter.html 19KB

set_cell_formula.html 19KB

zexcel_s_style_font.html 19KB

zexcel_s_cstyle_font.html 19KB

get_column_dimension.html 19KB

get_reference.html 19KB

get_default_excel_time_format.html 19KB

add_static_styles.html 19KB

convert_column2alpha.html 19KB

zexcel_conditional_iconset.html 19KB

set_merge.html 19KB

assert_equals.html 19KB

convert.html 19KB

encrypt_password.html 19KB

generate_title.html 19KB

共 447 条

<!DOCTYPE> <html lang="zh-CN"> <head> <meta http-equiv="content-type" content="text/html;charset=utf-8" /> <meta name="generator" content="批量下载V1.5.5-E.G.Mellodew;EditByRevolveYao."> <title>BIND_ALV_OLE2</title> <style type="text/css"> code[class*=language-],pre[class*=language-]{color:#000;background:0 0;text-shadow:0 1px #fff;font-family:Consolas,'Microsoft YaHei';font-size:14px;text-align:left;white-space:pre;word-spacing:normal;word-break:normal;word-wrap:normal;line-height:1.3;-moz-tab-size:4;-o-tab-size:4;tab-size:4;-webkit-hyphens:none;-moz-hyphens:none;-ms-hyphens:none;hyphens:none}code[class*=language-] ::-moz-selection,code[class*=language-]::-moz-selection,pre[class*=language-] ::-moz-selection,pre[class*=language-]::-moz-selection{text-shadow:none;background:#b3d4fc}code[class*=language-] ::selection,code[class*=language-]::selection,pre[class*=language-] ::selection,pre[class*=language-]::selection{text-shadow:none;background:#b3d4fc}@media print{code[class*=language-],pre[class*=language-]{text-shadow:none}}pre[class*=language-]{padding:1em;margin:.5em 0;overflow:auto}:not(pre)>code[class*=language-],pre[class*=language-]{background:#f5f2f0}:not(pre)>code[class*=language-]{padding:.1em;border-radius:.3em;white-space:normal}.token.cdata,.token.comment,.token.doctype,.token.prolog{color:#708090}.token.punctuation{color:#999}.namespace{opacity:.7}.token.boolean,.token.constant,.token.deleted,.token.number,.token.property,.token.symbol,.token.tag{color:#905}.token.attr-name,.token.builtin,.token.char,.token.inserted,.token.selector,.token.string{color:#690}.language-css .token.string,.style .token.string,.token.entity,.token.operator,.token.url{color:#9a6e3a;background:hsla(0,0%,100%,.5)}.token.atrule,.token.attr-value,.token.keyword{color:#1E90FF}.token.class-name,.token.function{color:#dd4a68}.token.important,.token.regex,.token.variable{color:#e90}.token.bold,.token.important{font-weight:700}.token.italic{font-style:italic}.token.entity{cursor:help} </style> <style type="text/css"> footer{color:#2c3e50;font-size:12px;text-align:center;margin-top: 50px;}body{font:'Microsoft YaHei'}h2,h3{font-weight:600;line-height:1.25;color:#2c3e50}h2{font:'Microsoft YaHei';font-size:1.5rem;margin-top:-1.5rem;margin-bottom:1rem;margin-block-start:.67em;margin-block-end:.67em;margin-inline-start:0;margin-inline-end:0}h3{font:'Microsoft YaHei';font-size:1rem;margin-top:-3.1rem;margin-bottom:0;padding-bottom:.3rem;border-bottom:1px solid#eaecef;margin-block-start:.67em;margin-block-end:.67em;margin-inline-start:0;margin-inline-end:0}a {width: 410px;display: inline-block;text-decoration:none;}ul li:nth-child(2n){background-color:#f8f8f8} </style> </head> <body> <h2>程序名: BIND_ALV_OLE2</h2> <h3> 描述: Set cell value from ALV object (OLE2)</h3> <pre><code class="language-abap"> ************************************************************************** * Method attributes. * ************************************************************************** Instantiation: Public ************************************************************************** method BIND_ALV_OLE2. *--------------------------------------------------------------------* * Method description: * Method use to export a CL_GUI_ALV_GRID object to xlsx/xls file * with list header and characteristics of ALV field catalog such as: * + Total, group's subtotal * + Quantity fields, amount fields (dependent fields) * + No_out, no_zero, ... * Technique use in method: * SAP Desktop Office Integration (DOI) *--------------------------------------------------------------------* * Data for session 0: DOI constructor * ------------------------------------------ data: lo_control type ref to I_OI_CONTAINER_CONTROL. data: lo_proxy type ref to I_OI_DOCUMENT_PROXY. data: lo_spreadsheet type ref to I_OI_SPREADSHEET. data: lo_error type ref to I_OI_ERROR. data: lc_retcode type SOI_RET_STRING. data: li_has type i. "Proxy has spreadsheet interface? data: l_is_closed type i. * Data for session 1: Get LVC data from ALV object * ------------------------------------------ data: l_has_activex, l_doctype_excel_sheet(11) type c. data: wa_DOC_HANDLE Type CNTL_HANDLE. * LVC data: lt_fieldcat_lvc type LVC_T_FCAT. data: wa_fieldcat_lvc type lvc_s_fcat. data: lt_sort_lvc type LVC_T_SORT. data: lt_filter_idx_lvc type LVC_T_FIDX. data: lt_GROUPLEVELS_LVC type LVC_T_GRPL. * KKBLO DATA: LT_FIELDCAT_KKBLO Type KKBLO_T_FIELDCAT. DATA: LT_SORT_KKBLO Type KKBLO_T_SORTINFO. DATA: LT_GROUPLEVELS_KKBLO Type KKBLO_T_GROUPLEVELS. DATA: LT_FILTER_IDX_KKBLO Type KKBLO_T_SFINFO. data: wa_listheader like line of it_listheader. * Subtotal data: lt_collect00 type ref to data. data: lt_collect01 type ref to data. data: lt_collect02 type ref to data. data: lt_collect03 type ref to data. data: lt_collect04 type ref to data. data: lt_collect05 type ref to data. data: lt_collect06 type ref to data. data: lt_collect07 type ref to data. data: lt_collect08 type ref to data. data: lt_collect09 type ref to data. * data table name data: l_tabname type kkblo_tabname. * local object data: lo_grid type ref to lcl_gui_alv_grid. * data table get from ALV data: lt_alv type ref to data. * total / subtotal data field-symbols: <f_collect00> type standard table. field-symbols: <f_collect01> type standard table. field-symbols: <f_collect02> type standard table. field-symbols: <f_collect03> type standard table. field-symbols: <f_collect04> type standard table. field-symbols: <f_collect05> type standard table. field-symbols: <f_collect06> type standard table. field-symbols: <f_collect07> type standard table. field-symbols: <f_collect08> type standard table. field-symbols: <f_collect09> type standard table. * table before append subtotal lines field-symbols: <f_alv_tab> type standard table. * data for session 2: sort, filter and calculate total/subtotal * ------------------------------------------ * table to save index of subotal / total line in excel tanle * this ideal to control index of subtotal / total line later * for ex, when get subtotal / total line to format types: begin of st_subtot_indexs, index type i, end of st_subtot_indexs. data: lt_subtot_indexs type table of st_subtot_indexs. data: wa_subtot_indexs like line of lt_subtot_indexs. * data table after append subtotal data: lt_excel type ref to data. data: l_tabix type i. data: l_save_index type i. * dyn subtotal table name data: l_collect type string. * subtotal range, to format subtotal (and total) data: subranges type soi_range_list. data: subrangeitem type soi_range_item. data: l_sub_index type i. * table after append subtotal lines field-symbols: <f_excel_tab> type standard table. field-symbols: <f_excel_line> type any. * dyn subtotal tables field-symbols: <f_collect_tab> type standard table. field-symbols: <f_collect_line> type any. field-symbols: <f_filter_idx_line> like line of LT_FILTER_IDX_KKBLO. field-symbols: <f_fieldcat_line> like line of LT_FIELDCAT_KKBLO. field-symbols: <f_grouplevels_line> like line of LT_GROUPLEVELS_KKBLO. field-symbols: <f_line> type any. * Data for session 3: map data to semantic table * ------------------------------------------ types: