Excel-based LCD display method, system, tool and memory

Abstract

The present invention provides an Excel-based LCD display method, system, tool, and memory. The method utilizes an Excel spreadsheet for LCD display development, sets a field operation table based on target segments displayed in a segment position comparison chart, summarizes all segment states in the field operation table into a segment state summary table, converts HCOM0 and HCOM1 data columns from COM0 and COM1 data columns in a segment code table to construct a segment code operation table, constructs the segment code operation table, converts segment values ​​in the segment code operation table from binary to hexadecimal to generate a corresponding array, converts the data into a code format using an array output table, and forms a two-dimensional array, which is then output to a selected software code for burning into a corresponding device to display the target segment. The LCD development tool of the present invention has strong compatibility, and a user only needs to select the corresponding segment state in the field operation table to quickly obtain the corresponding array, thereby improving work efficiency.

Description

Technical Field

[0001] The present invention belongs to the field of display screen development, and in particular relates to an Excel-based LCD display method, system, tool and memory. Background Art

[0002] LCD is widely used in various industries due to its small size, light weight, low power consumption, ability to display graphics and images, and ease of direct drive by integrated circuits. It has three types: segment type, character type, and dot matrix type. Among them, the segment type LCD has two pins: segment electrode SEG and common electrode COM.

[0003] Currently, LCD display drivers typically control the LCD IC via IIC or SPI, with the LCD IC controlling the panel's SEG and COM pins to control the corresponding segments. Commonly used software calls functions with SEG and COM parameters, displaying only one segment each time. However, to compress data, users often call data compression functions to display the corresponding content. However, when calling these functions to display the corresponding content, users are required to calculate the corresponding data based on the desired segments. This process is time-consuming and error-prone. Furthermore, identifying the erroneous data can be difficult after an error occurs, and subsequent changes to the displayed content require recalculation, hindering code maintenance. Summary of the Invention

[0004] In response to the above technical problems, the present invention aims to propose an Excel-based LCD display method, system, tool and memory, which can intuitively show which segments are displayed, and is not prone to errors when calculating segment data. Even if an error occurs, the erroneous data can be intuitively found. When subsequent content needs to be modified, only the segment status needs to be modified, which is conducive to code maintenance. The tool has strong compatibility and can adapt to a variety of LCD segment code screens.

[0005] The present invention provides an Excel-based LCD display method, which performs LCD display development in an Excel table, specifically comprising the following steps:

[0006] A field operation table is set according to the target segment displayed in the segment position comparison diagram; all segment states of the field operation table are summarized in a segment state summary table; HCOM0 data column and HCOM1 data column are converted from COM0 data column and COM1 data column in the segment code table to construct a segment code operation table; construct the segment code operation table: first arrange the segment code table according to the SEG serial number, divide every 8 SEGs into a group and sort them in RamNum sequence in turn, and obtain the data corresponding to each SEG from the segment state summary table, HCOM0 data column and HCOM1 data column respectively; then add a segment value column, and the segment value column is calculated according to the segment state; convert the segment values ​​belonging to the same RamNum sequence in the segment code operation table from binary to hexadecimal, generate a corresponding array, and convert it into code format through the array output table to form a two-dimensional array, output it to the selected software code for burning into the corresponding device to display the target segment.

[0007] Among them, the code format content writes out the cell number corresponding to the data in the hexadecimal conversion table, and the line break statement after the nth data. The composition of the array can be intuitively derived from the code content. The array corresponds one-to-one to the data in the hexadecimal conversion table.

[0008] The field operation table sets the segment state of the corresponding cell according to the target segment position, and the segment state includes a bright state and a dark state.

[0009] Among them, setting the state parameters of the pen segment to bright state and dark state can intuitively show the meaning of the target pen segment.

[0010] The conversion of the COM0 data column and the COM1 data column in the segment code table to obtain the HCOM0 data column and the HCOM1 data column is specifically as follows: whether the number of characters in each cell of the COM0 data column and the COM1 data column is greater than or equal to 2, and if so, adding #0 after the corresponding cell data to obtain the HCOM0 data column and the HCOM1 data column respectively; otherwise, adding *0 after the corresponding cell data to obtain the HCOM0 data column and the HCOM1 data column respectively; the HCOM0 data column corresponds one-to-one to the cells in the COM0 data column, and the HCOM1 data column corresponds one-to-one to the cells in the COM1 data column.

[0011] The HCOM0 data column and HCOM1 data column converted from the COM0 data column and COM1 data column in the segment code table clearly indicate the number of characters in the field, thereby distinguishing double letters from single letters, and preventing the segment code operation module from being unable to find errors.

[0012] The method of obtaining the data corresponding to each SEG from the segment status summary table is as follows: matching the data of each cell of the HCOM0 data column and the HCOM1 data column in the segment status summary table; if the match is successful, the segment status maintains the data corresponding to the HCOM0 data column and the HCOM1 data column; otherwise, the segment status replaces the 0 in the HCOM0 data column and the HCOM1 data column with 1.

[0013] The segment value column is calculated based on the segment status, specifically: the corresponding segment value is calculated based on the matched segment status. When the suffix of the segment status is #1 or *1, the segment value is 1; when the suffix of the segment status is #0 or *0, the segment value is 0.

[0014] As another preferred embodiment, the present invention further provides a system for an Excel-based LCD display method, wherein an LCD display development system design is performed in an Excel spreadsheet, and the system at least comprises:

[0015] A segment position comparison chart is used to display target segments, allowing users to set the field operation table by comparing them with the target segments; each cell in the field operation table corresponds to a segment code, and the position of each cell matches the segment position in the segment position comparison chart; a segment status summary table is used to summarize all segment states in the field operation table for matching operations in the segment code operation table; the segment code operation table includes a RamNum sequence, matching area and segment state, and corresponding segment values ​​calculated based on the segment state; the RamNum sequence is the arrangement number of each group of SEGs; The matching area includes HCOM0 data column and HCOM1 data column, and the HCOM0 data column and HCOM1 data column are respectively converted according to the COM0 data column and COM1 data column in the segment code table; the segment status is obtained from the segment status summary table; the hexadecimal conversion table is used to convert the segment values ​​belonging to the same RamNum sequence from binary to hexadecimal, generate the corresponding array, and convert it into code format through the array output table to form a two-dimensional array for output to the selected software code for burning into the corresponding device to display the target segment.

[0016] The matching area is the HCOM0 data column and HCOM1 data column converted according to the COM0 data column and COM1 data column in the segment code table; the HCOM0 data column corresponds one-to-one to the cells in the COM0 data column, and the HCOM1 data column corresponds one-to-one to the cells in the COM1 data column; the HCOM0 data column and HCOM1 data column are obtained according to the following IF function: HCOMn column cell = IF (if the number of characters in the COMn column is greater than or equal to 2, remove the field number and add #0, otherwise remove the field number and add *0), n takes the value of 0 or 1.

[0017] The above system also includes: a select all button, when selected, the field operation table of the corresponding field is all set to a bright state; when unselected, the field operation table of the corresponding field is in the corresponding state of the target segment selected; and a clear button, when selected, the field operation table of the corresponding field is all set to a dark state, when unselected, the field operation table of the corresponding field is in the corresponding state of the target segment selected.

[0018] As another preferred embodiment, the present invention further provides a tool, which is an LCD development tool, and the LCD development tool is used to implement any of the methods described above.

[0019] As another preferred embodiment, the present invention further provides a memory, wherein a computer program is stored in the memory, and when the computer program is run on a computer, the computer is enabled to execute any one of the above methods.

[0020] In summary, the present invention provides an Excel-based LCD display method, system, tool and memory. By using Excel tables for LCD display development, a field operation table is set according to the target pen segment displayed in the pen segment position comparison diagram; all pen segment states in the field operation table are summarized in a pen segment state summary table; HCOM0 data column and HCOM1 data column are converted according to the COM0 data column and COM1 data column in the segment code table to construct a segment code operation table; then the segment code operation table is constructed; the pen segment value in the segment code operation table is converted from binary to hexadecimal to generate a corresponding array, and after converting it into a code format through an array output table, it forms a two-dimensional array, which is output to the selected software code for burning into the corresponding device to display the target pen segment.

[0021] The beneficial effect of the present invention is that it is applicable to a variety of segment code screens. The user only needs to replace the segment code table with the COM0 data column and COM1 data column in the segment code processing module and then quickly develop the LCD segment code screen through the above steps. In addition, the user only needs to select the corresponding pen segment state in the field operation table to quickly obtain the corresponding array, thereby improving work efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] Figure 1 This is a flow chart of the LCD display method.

[0023] Figure 2 This is a schematic diagram of the segment code operation module.

[0024] Figure 3 Expresses intent for field operations.

[0025] Figure 4 This is a schematic diagram of the segment code processing module.

[0026] Figure 5 This is a schematic diagram of segment code operation.

[0027] Figure 6 Intended for hexadecimal conversion.

[0028] Figure 7 Outputs a representation for an array.

[0029] Figure 8 This is the LCD display system framework diagram.

[0030] Among them, 21-segment position comparison chart; 22-field operation table; 23-segment status summary table; 24-segment code operation table; 25-hexadecimal conversion table; 26-array output table; 27-select all button; 28-clear button. DETAILED DESCRIPTION

[0031] The following is a further detailed description of an Excel-based LCD display method, system, tool and memory of the present invention in conjunction with specific embodiments and drawings.

[0032] like Figure 1 As shown in the flowchart of the LCD display method of the present invention, LCD display development is performed in Excel, such as Figure 2 FIG. 1 is a schematic diagram of a segment code operation module of the present invention. Specifically, the Excel-based LCD display method of the present invention includes the following steps:

[0033] Step 1: Set the field operation table according to the target segment shown in the segment position comparison chart.

[0034] The field operation table sets the segment state of the corresponding cell according to the target segment position, and the segment state includes a bright state and a dark state.

[0035] Preferably, Figure 3As shown, for the target segment AA, AA#0 corresponds to the dark state of the segment, and AA#1 corresponds to the bright state of the segment. This cell only allows selection of AA#0 or AA#1. Cells in the field operation table can be filled with different background colors based on their content. AA#1 corresponds to light red, while AA#0 corresponds to white, allowing users to intuitively observe the displayed content of the field operation table.

[0036] Step 2: Summarize all the segment statuses in the field operation table into the segment status summary table.

[0037] Step 3: HCOM0 data column and HCOM1 data column are converted according to COM0 data column and COM1 data column in the segment code table to construct a segment code operation table, specifically: determine whether the number of characters in each cell of COM0 data column and COM1 data column is greater than or equal to 2, if so, add #0 after the corresponding cell data to obtain HCOM0 data column and HCOM1 data column respectively; otherwise, add *0 after the corresponding cell data to obtain HCOM0 data column and HCOM1 data column respectively; the HCOM0 data column corresponds one-to-one to the cells in COM0 data column, and the HCOM1 data column corresponds one-to-one to the cells in COM1 data column.

[0038] Since the LCD display driver generally controls the LCD IC through IIC or SPI, and the LCD IC controls the SEG pin and COM pin of the panel to control the corresponding pen segments, a segment code table is used to record the pen segments controlled by the SEG pin and the COM pin. The user only needs to transmit the display data to the LCD through IIC or SPI according to the segment code table to display the corresponding content. A general segment code table consists of multiple SEGs in rows and several COMs in columns. Preferably, the segment code table described in the present invention consists of 120 rows of SEGs and 2 columns of COMs.

[0039] like Figure 4 As shown, the cell in the HCOM1 column =IF(LEN(C11)>2,MID(C11,2,2)&"#0",MID(C11,2,2)&"*0"). The meaning of this function is: determine whether the number of characters in the segment in the cell in the COM1 column is greater than or equal to 2. If so, remove the field number of the segment and add #0. Otherwise, remove the field number of the segment and add *0. For segment 1HH, the processed value is HH#0.

[0040] Here, C11 is the cell number, the IF() function is a conditional function that determines the result based on the condition in the parentheses; the LEN() function calculates the length; and the MID() function is a string function used to extract a specified number of characters from a string. Specifically, the IF function distinguishes between double-letter and single-letter segments, preventing mismatches when matching against the segment status summary table.

[0041] Step 4: Construct a segment code operation table: first arrange the segment code table according to the SEG serial number, divide every 8 SEGs into a group and sort them in RamNum sequence in turn, and obtain the data corresponding to each SEG from the segment status summary table, HCOM0 data column and HCOM1 data column respectively; then add a new segment value column, and the segment value column is calculated according to the segment status.

[0042] The segment status is obtained from the segment status summary table, as follows:

[0043] Preferably, the segment status is the COM0 data column and COM1 data column in the segment code operation table, which is obtained from the segment status summary table according to the data in the matching area. Obtaining the segment status is beneficial to the calculation of the subsequent segment value. Let the COM0 cell corresponding to the segment HH in the segment code operation table be

[0044] =IF(IFERROR(FIND(D36,C$),0),D36,LEFT(D36,LEN(D36)-1)&1); The specific method is to first check whether the content of the segment status summary table exists based on the cell content corresponding to the matching area. If it exists, it is HH#0, otherwise it is HH#1; among them, D36 is the cell number of the matching area corresponding to the segment HH, and C$ is the segment status summary table.

[0045] Preferably, the segment code operation table (such as Figure 5As shown in the example, the cells in the COM0 and COM1 columns can be filled with different background colors depending on their contents. HH#1 is filled with light red, and HH#0 is filled with white. This allows users to visually observe the status of the segment code table and facilitates troubleshooting. The COM0_DATA column corresponds to the data in the COM0 column, and the COM1_DATA column corresponds to the data in the COM1 column. If the content of the COM0 cell corresponding to segment HH is HH#0, the content of the COM0_DATA cell corresponding to segment HH is 0. If the content of the COM0 cell corresponding to segment HH is HH#1, the content of the COM0_DATA cell corresponding to segment HH is 1. Furthermore, if the content of the COM0 cell corresponding to segment HH is blank, the content of the COM0_DATA cell corresponding to segment HH is 0. Specifically, the cell corresponding to COM0_DATA corresponding to segment HH is evaluated using the statement: =IF(COUNTIF(F36,"***1"),1,0), where F36 is the cell number corresponding to COM0.

[0046] Step 5: Convert the segment values ​​belonging to the same RamNum sequence in the segment code operation table from binary to hexadecimal to generate a corresponding array, and convert them into code format through the array output table to form a two-dimensional array, which is output to the selected software code for burning into the corresponding device to display the target segment.

[0047] like Figure 6 As shown, the conversion of the segment values ​​belonging to the same RamNum sequence in the segment code operation table from binary to hexadecimal is completed in the hexadecimal conversion table. The hexadecimal conversion table is used to convert the binary numbers of COM0_DATA and COM1_DATA in the segment code operation table into hexadecimal. The content of the RamNum column is the same as that of the RamNum column in the segment code operation table. For example, if RamNum is 1, the data of COM0_DATA is 0111 1100 from high to low, and the corresponding hexadecimal content is 7C. Specifically, first convert the binary data of COM0_DATA to decimal, and then convert the decimal number to hexadecimal. The specific statements are as follows:

[0048] =DEC2HEX(G$42*1+G$41*64+G$40*32+G$39*16+G$38*8+G$37*4+G$36*2+G$35*1) gets the corresponding hexadecimal number, where G$42 to G$35 are the cell numbers corresponding to COM0_DATA in the segment code operation table when RamNum is 1, and the DEC2HEX statement converts the decimal number into hexadecimal.

[0049] like Figure 7 As shown, the array output table converts the hexadecimal conversion table into code format content for output, forming a two-dimensional array. The specific statements are as follows:

[0050] ="{"&F61&"u, 0x"&G61&", 0x"&I61&"},"&CHAR(10)&"{"&F62&"u,0x"&G62&", 0x"&I62&"},"&CHAR(10)&"{"&F63&"u, 0x"&G63&", 0x"&I63&"},"

[0051] Among them, F61, F62, and F63 are the cell numbers corresponding to the data of RamNum, G61, G62, and G63 are the cell numbers of COM0_DATA, I61, I62, and I63 are the cell numbers of COM1_DATA, " " is a space and can be added or deleted as needed, and CHAR(10) is a line break statement.

[0052] As another preferred embodiment, the present invention also provides a system for LCD display method based on Excel (such as Figure 8 As shown in the figure), design an LCD display development system in an Excel spreadsheet, the system at least including:

[0053] The pen segment position comparison diagram is used to display the target pen segment for the user to set the field operation table according to the target pen segment; each cell in the field operation table corresponds to a segment code, and the position of each cell matches the pen segment position in the pen segment position comparison diagram.

[0054] The segment status summary table is used to summarize the status of all segments in the field operation table for matching operations in the segment code operation table.

[0055] The segment code operation table includes a RamNum sequence, a matching area and a segment status, and a corresponding segment value calculated according to the segment status; the RamNum sequence is the arrangement number of each group of SEGs; the matching area includes an HCOM0 data column and an HCOM1 data column, and the HCOM0 data column and the HCOM1 data column are respectively converted according to the COM0 data column and the COM1 data column in the segment code table; the segment status is obtained from the segment status summary table.

[0056] A hexadecimal conversion table is used to convert the segment values ​​belonging to the same RamNum sequence from binary to hexadecimal, generate a corresponding array, and convert it into code format through an array output table to form a two-dimensional array for output to the selected software code for burning into the corresponding device to display the target segment.

[0057] The above system also includes: a select all button, when selected, the field operation table of the corresponding field is all set to a bright state; when unselected, the field operation table of the corresponding field is in the corresponding state of the target segment selected; and a clear button, when selected, the field operation table of the corresponding field is all set to a dark state, when unselected, the field operation table of the corresponding field is in the corresponding state of the target segment selected.

[0058] Preferably, after clicking the Select All button, the field operation tables of the corresponding fields are all set to a bright state. Specifically, the Select All button of each field is designated as a macro, and the corresponding macro code is as follows:

[0059] Range("I3").Value = "AA#1"

[0060] Range("I4").Value = "BB#1"

[0061] Range("I5").Value = "Z*1"

[0062] Range("I6").Value = "Y*1"

[0063] Range("I8").Value = "S*1"

[0064] Range("I9").Value = "K*1"

[0065] Range("I11").Value = "J*1"

[0066] Range("I12").Value = "B*1"

[0067] Range("I13").Value = "A*1"

[0068] Range("J3").Value = "CC#1"

[0069] Range("J13").Value = "C*1"

[0070] Range("K3").Value = "DD#1"

[0071] Range("K6").Value = "JJ#1"

[0072] Range("K8").Value = "T*1"

[0073] Range("K10").Value = "L*1"

[0074] Range("K12").Value = "D*1"

[0075] Range("L3").Value = "EE#1"

[0076] Range("L5").Value = "KK#1"

[0077] Range("L8").Value = "U*1"

[0078] Range("L9").Value = "M*1"

[0079] Range("L12").Value = "E*1"

[0080] Range("M3").Value = "FF#1"

[0081] Range("M6").Value = "LL#1"

[0082] Range("M8").Value = "V*1"

[0083] Range("M10").Value = "N*1"

[0084] Range("M12").Value = "F*1"

[0085] Range("N3").Value = "GG#1"

[0086] Range("N4").Value = "II#1"

[0087] Range("N5").Value = "MM#1"

[0088] Range("N6").Value = "NN#1"

[0089] Range("N8").Value = "W*1"

[0090] Range("N9").Value = "Q*1"

[0091] Range("N11").Value = "P*1"

[0092] Range("N12").Value = "I*1"

[0093] Range("N13").Value = "G*1"

[0094] Range("O3").Value = "HH#1"

[0095] Range("O7").Value = "X*1"

[0096] Range("O9").Value = "R*1"

[0097] Range("O13").Value = "H*1"

[0098] Among them, I3~O13 are the cell numbers corresponding to the field operation table ().

[0099] As another preferred embodiment, the present invention further provides a tool, which is an LCD development tool, and the LCD development tool is used to implement any of the methods described above.

[0100] Preferably, the tool can also be made into a field operation table corresponding to multiple segment code operation tables and array output tables. Each segment code operation table obtains the corresponding pen segment status from the field operation table and then performs operations according to the corresponding RamNum to obtain the parameters Com0_Data and Com1_Data. The array output table obtains the corresponding RamNum, Com0_Data and Com1_Data from the segment code operation table of the corresponding field to form a corresponding array.

[0101] As another preferred embodiment, the present invention further provides a memory, wherein a computer program is stored in the memory, and when the computer program is run on a computer, the computer is enabled to execute any one of the above methods.

[0102] In summary, the present invention provides an Excel-based LCD display method, system, tool and memory. By using Excel tables for development, the user only needs to select the corresponding pen segment state in the field operation table to quickly obtain the corresponding array, thereby improving work efficiency. In addition, the LCD development tool has strong compatibility and can develop and display different LCD segment code screens according to different segment code tables.

[0103] Although example embodiments have been described herein with reference to the accompanying drawings, it should be understood that the above example embodiments are merely illustrative and are not intended to limit the scope of the present invention. Various changes and modifications may be made therein by those skilled in the art without departing from the scope and spirit of the present invention. All such changes and modifications are intended to be included within the scope of the present invention as claimed in the appended claims.

[0104] Those skilled in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professionals and technicians can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of the present invention.

[0105] In the several embodiments provided in this application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are merely illustrative. For example, the division of the units described is merely a logical function division. In actual implementation, other division methods may be used, such as combining or integrating multiple units or components into another device, or ignoring or not performing some features.

[0106] The various component embodiments of the present invention can be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. It will be appreciated by those skilled in the art that a microprocessor or digital signal processor (DSP) can be used in practice to implement some or all of the functions of some modules according to embodiments of the present invention. The present invention can also be implemented as a device program (e.g., a computer program and a computer program product) for executing a part or all of the methods described herein. Such a program implementing the present invention can be stored on a computer-readable medium, or can have the form of one or more signals. Such a signal can be downloaded from an Internet website, or provided on a carrier signal, or provided in any other form.

[0107] It should be noted that, in this document, terms such as "comprises," "includes," or any other variations thereof are intended to encompass non-exclusive inclusion, such that a process, method, article, or apparatus comprising a series of elements includes not only those elements but also other elements not explicitly listed, or elements inherent to such process, method, article, or apparatus. In the absence of further limitations, an element defined by the phrase "comprises a ..." does not exclude the presence of other identical elements in the process, method, article, or apparatus comprising the element.

[0108] The above-described embodiment merely represents one embodiment of the present invention. While the description is relatively specific and detailed, it should not be construed as limiting the scope of the present invention. It should be noted that a person skilled in the art would be able to make various modifications and improvements without departing from the scope of the present invention, and all such modifications and improvements fall within the scope of protection of the present invention.

Claims

1. An Excel-based LCD display method, characterized in that: LCD display development in Excel includes the following steps: S1: Setting a field operation table according to the target segment displayed in the segment position comparison chart; wherein the field operation table sets the segment state of the corresponding cell according to the target segment position, and the segment state includes a bright state and a dark state; S2: Summarize all the segment statuses in the field operation table into the segment status summary table; S3: converting the COM0 data column and COM1 data column in the segment code table into the HCOM0 data column and HCOM1 data column to construct a segment code operation table; Wherein, the step S3 specifically comprises: determining whether the number of characters in each cell of the COM0 data column and the COM1 data column is greater than or equal to 2; if so, adding #0 after the corresponding cell data to obtain the HCOM0 data column and the HCOM1 data column respectively; otherwise, adding *0 after the corresponding cell data to obtain the HCOM0 data column and the HCOM1 data column respectively; the HCOM0 data column corresponds one-to-one to the cells in the COM0 data column, and the HCOM1 data column corresponds one-to-one to the cells in the COM1 data column; S4: Constructing a segment code calculation table: first, the segment code table is arranged by SEG number, and every 8 SEGs are divided into a group and sorted in RamNum sequence in sequence. The data corresponding to each SEG is obtained from the segment status summary table, HCOM0 data column and HCOM1 data column respectively; then, a segment value column is added, and the segment value column is calculated according to the segment status; S5: Convert the segment values ​​belonging to the same RamNum sequence in the segment code operation table from binary to hexadecimal to generate a corresponding array, and convert them into code format through the array output table to form a two-dimensional array, which is output to the selected software code for burning into the corresponding device to display the target segment.

2. The LCD display method based on Excel according to claim 1, characterized in that: The method of obtaining the data corresponding to each SEG from the segment status summary table is as follows: matching the data of each cell of the HCOM0 data column and the HCOM1 data column in the segment status summary table; if the match is successful, the segment status maintains the data corresponding to the HCOM0 data column and the HCOM1 data column; otherwise, the segment status replaces the 0 in the HCOM0 data column and the HCOM1 data column with 1.

3. The Excel-based LCD display method according to claim 2, wherein: The segment value column is calculated based on the segment status, specifically: the corresponding segment value is calculated based on the matched segment status. When the suffix of the segment status is #1 or *1, the segment value is 1; when the suffix of the segment status is #0 or *0, the segment value is 0.

4. A system using the Excel-based LCD display method according to any one of claims 1 to 3, characterized in that: Design an LCD display development system in Excel. The system includes at least: A pen segment position comparison chart is used to display target pen segments for users to set a field operation table by referring to the target pen segments; each cell in the field operation table corresponds to a segment code, and the position of each cell matches the pen segment position in the pen segment position comparison chart; The segment status summary table is used to summarize all the segment statuses in the field operation table for matching operations in the segment code operation table; The segment code operation table includes a RamNum sequence, a matching area, and a segment status, as well as a corresponding segment value calculated according to the segment status; the RamNum sequence is the arrangement number of each group of SEGs; the matching area includes an HCOM0 data column and an HCOM1 data column, which are respectively converted from the COM0 data column and the COM1 data column in the segment code table; the segment status is obtained from the segment status summary table; A hexadecimal conversion table is used to convert the segment values ​​belonging to the same RamNum sequence from binary to hexadecimal, generate a corresponding array, and convert it into code format through an array output table to form a two-dimensional array for output to the selected software code for burning into the corresponding device to display the target segment.

5. The system according to claim 4, characterized in that The matching area is the HCOM0 data column and HCOM1 data column converted according to the COM0 data column and COM1 data column in the segment code table; the HCOM0 data column corresponds one-to-one to the cells in the COM0 data column, and the HCOM1 data column corresponds one-to-one to the cells in the COM1 data column; the HCOM0 data column and HCOM1 data column are obtained according to the following IF function: HCOMn column cell = IFCOMn column number of characters is greater than or equal to 2, then remove the field number and add #0, otherwise remove the field number and add *0, n takes the value of 0 or 1.

6. The system according to claim 5, characterized in that The system further comprises: Select All button, when selected, all the field operation tables of the corresponding fields are set to bright state; when unselected, the field operation table of the corresponding field is set to the corresponding state of the target segment selected; And the clear button, when selected, the field operation table of the corresponding field is all set to dark state, when not selected, the field operation table of the corresponding field is in the corresponding state of the selected target segment.

7. A tool, a type of LCD development tool, characterized in that: The LCD development tool is used to implement the method according to any one of claims 1 to 3.

8. A memory, characterized in that: The memory stores a computer program, which, when executed on a computer, enables the computer to execute the method according to any one of claims 1 to 3.

Images