Unlock instant, AI-driven research and patent intelligence for your innovation.

XLS data export method and system based on sap platform

A data export and platform technology, applied in the fields of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of high maintenance cost of template change, code redundancy, code duplication, etc., to improve maintainability and reduce code. volume, the effect of reducing complexity

Active Publication Date: 2018-08-10
SHANDONG LUNENG GROUP +1
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Developers need to write Excel output programs according to different output templates during the coding process, resulting in repeated coding, redundant code, and high maintenance costs for later template changes

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • XLS data export method and system based on sap platform
  • XLS data export method and system based on sap platform
  • XLS data export method and system based on sap platform

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] Below in conjunction with accompanying drawing and embodiment the present invention will be further described:

[0034] A method for exporting XLS data based on the SAP platform, such as figure 1 shown, including the following steps:

[0035] (1) Formulate basic EXCEL export templates according to business needs, and upload to SAP platform server; Described basic EXCEL export templates are the simplest templates that can realize EXCEL export basic functions; The simplest templates specifically include: output column format, such as Text, numerical value, date type, etc., the main title is XX unit salary slip, etc.

[0036] (2) create XLS derivation function on described EXCEL derivation template, the input of described XLS derivation function comprises: control parameter, data parameter, printing parameter and summary parameter;

[0037] The control parameters are used to control the form style of the EXCEL data export process, such as the assignment control font, row...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses an XLS (Microsoft Excel) data export method and system based on a SAP (System Applications and Products in Data Processing) platform. The method comprises the following steps: according to business requirements, drawing up a basic Excel export template, and uploading the basic Excel export template onto the SAP platform; creating an XLS export function on the Excel export template; inputting a set Excel control parameter to the XLS export function, identifying the input Excel control parameter by the XLS export function, matching the Excel control parameter with an internal control parameter, an internal data parameter, an internal printing parameter and an internal summary function, and regulating the format of the Excel export template; and outputting the Excel control parameter to a corresponding Excel file by the XLS export function, and storing the Excel control parameter in a corresponding file catalogue. The XLS data export method has the beneficial effects that a quick export and development work of a complex form style can be realized through simple data parameter preparation and parameter combination control, a code quantity for exporting an MS Excel file to a computer catalogue function is greatly reduced, code maintainability is improved, a use ratio of codes is improved, and the complexity of report development is lowered.

Description

technical field [0001] The invention relates to the field of data export, in particular to an XLS data export method and system based on a SAP platform. Background technique [0002] SAP (systems applications and products in data processing) is a software for enterprise resource planning (ERP) (enterprise resource planning) management. [0003] The list display tool ALV is preset in SAP. However, in the output display of SAP ALV, the display effect and the aesthetics of the display are often affected by problems such as complex format, too many fields, and subtotals. [0004] During the project report development process, after the data is displayed with the standard ALV report tool, it is usually necessary to export the data as a MSExcel format file and save it in the local directory. The normal processing process is that the business consultant collects different styles of MS Excel templates and passes the templates through the SAP transaction The code SMWO is imported in...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/22
Inventor 张岩王凯李帅邢宏伟张建辉戚鲁凤张晨玥
Owner SHANDONG LUNENG GROUP
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com