A method of outputting excel file data

An output method and file data technology, applied in the computer field, can solve the problems of high error rate, labor and time-consuming, low efficiency, etc., and achieve the effects of neat and beautiful arrangement, improved work efficiency, and improved accuracy.

Active Publication Date: 2018-08-14
SHANDONG HAILIANG INFORMATION TECH RES INST
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, it is necessary to convert the protocol table existing in excel format into a syntax format conforming to Verilog. The traditional conversion method is manual output line by line, but the problem caused by manual output and simple copy-paste replacement is that the There are many cells, the error rate is high, and the efficiency is not high, which is labor-intensive and time-consuming

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
  • A method of outputting excel file data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0016] A method for outputting excel file data described in this embodiment, as shown in the attached figure 1 As shown, the output method selects the column output of the excel cell table, mainly including the following steps:

[0017] 1) Insert a row in the excel cell table and set the parameter information; each cell in the inserted row is marked whether the corresponding column of the cell needs to be output, and the one that needs to be output does not need to be set, and does not need to be output to the Verilog file. Then the content of this cell is marked as 1;

[0018] 2) Calculate the length of the longest content in each column of cells, by sequentially reading the contents of each column of cells, and calculating the longest character length of the content characters in all cells in each column, to obtain the longest length of each column of cells long content-length value;

[0019] 3) Set the output file, including setting the output file path and name;

[0020...

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 output method of excel file data, which relates to the field of computers. The excel file format is output into a verilog file format by using the programming language vba language that comes with excel. If the column output of the excel unit table is selected, a row in the unit table is first set As an identification row, the value in each cell in this identification row determines whether the column in which the cell is located is output; then calculate the longest character length in each column cell, and cycle through all the used cells in the cell table The cells are rotated according to the column, and the longest character length of the cell in each column is calculated. The invention makes the output fast, greatly improves the work efficiency, saves manpower, and greatly improves the accuracy of data output.

Description

technical field [0001] The invention relates to the field of computers, in particular to an output method of excel file data. Background technique [0002] In the company's kanas project, when designing the protocol, for the convenience of writing and understanding, each variable used in the protocol is recorded in the excel file, each column in the excel unit table represents a variable in the protocol, and each row represents A clear combination of these variables. In this way, it is convenient to write and search the variable changes recorded in the excel unit table, and at the same time, it also improves the efficiency when modifying and reading. When the protocol is to be input into the design tool, the input protocol required by the design tool must conform to the grammar format of the Verilog language (a hardware description language). Therefore, it is necessary to convert the protocol table existing in the form of excel into a grammatical format conforming to Veril...

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/24
CPCG06F40/18
Inventor 李灯伟刘刚赵元李仁刚童圆满
Owner SHANDONG HAILIANG INFORMATION TECH RES INST
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap