76 results about "Spread sheet" patented technology

A system for extracting a number of data elements from one or more data sources. A text representing tables using a markdown language is extracted from spreadsheets and or other grid-based documents. The text is provided to a language model with a prompt. The prompt may be a chain-of-thoughts prompt. The prompt includes several requests and / or steps that cause the language model to extract one or more tables from the spreadsheet and output the tables using the markdown language or a different markdown language. The tables extracted from the spreadsheet are converted into table chunks and indexed for retrieval by a retrieval augmented architecture. When a prompt to extract particular information from the spreadsheet is provided, one or more relevant table chunks are identified and provided to a language model for extraction. Using the language model to separate tables improves information extraction accuracy while maintaining downstream instructions.

The invention discloses a multi-dimensional data management method and system based on a spreadsheet, and the method comprises the steps: responding to an editing operation instruction of the spreadsheet displayed by a client, and updating the table structure and table data of the spreadsheet; the editing operation instruction at least comprises one of a dragging instruction for dragging rows and columns of the spreadsheet to carry out free combination, a hiding and screening instruction for hiding and screening the rows and the columns and a sorting instruction for sorting data of the rows and the columns; capturing a timestamp corresponding to the editing operation instruction, taking the timestamp as an index, taking the updated table structure and table data as historical data modification records, and storing a mapping relation between the index and the historical data modification records; and tracing the historical data modification record through the mapping relationship. Therefore, by adopting the embodiment of the invention, multi-dimensional operation can meet the requirements of enterprises on refinement and individuation of inventory management, meanwhile, operators and modification history can be tracked, and the security and reliability of data are improved.

The invention provides an automatic spreadsheet operation and reasoning method and system based on a large language model, and the method comprises the steps: S1, uploading a spreadsheet file, and extracting related information; s2, the table state, the table description and the system prompt of the information provider module are provided for the information provider module; s3, generating an SQL query statement, executing the SQL query statement, and generating a sub-table corresponding to the spreadsheet; s4, extracting forward data from the sub-table, and providing the forward data to the planner module in combination with a table state, table description and a system prompt of the planner module; s5, generating a Python code through a planner module, and executing the Python code in an interpreter to obtain an execution result; s6, judging and skipping according to an execution result until the code is successfully executed; and S7, repeating the steps S1 to S6 until the task is completed. The method can effectively improve the capability and efficiency of automatically solving spreadsheet operation and reasoning tasks.

Disclosed is a method giving an alternative to typing, cell selecting, single list selecting and pasting in arguments for a built-in spreadsheet function and flex copy paste capabilities through the use of a broad spectrum of selection list panels supporting multiple selections from multiple lists with fixed and / or situationally specific specification options. Those and other arguments can be invisible in the spreadsheet formula text while more understandably visible in UIs. Also disclosed is function and flex copy-paste control of cell formatting overriding any cell formatting otherwise applied to those cells employing a broad spectrum of specification types and selection list panels not previously utilized for spreadsheet functions or copy paste.

The invention discloses a character rotation method and device for a front-end component. The method comprises the steps that the position of a target cell is identified, and text content and style information are obtained; dynamically adjusting the text size according to the cell size and the rotation angle, and trying different font sizes by using a loop structure. And according to the width and font size of the target cell, carrying out line feed processing on the text exceeding the effective size of the target cell. And calculating the position of the text center in nine combined alignment modes according to the horizontal and vertical alignment modes of the target cells, the virtual rectangular space occupied by the text and the set rotation angle. And repeatedly executing the position determination step for multiple lines of texts until the positions of the centers of all the lines of texts are determined. And converting and filling the text by utilizing a canvas interface in combination with the rotation angle and the text center position. The problem of how to realize an accurate character rotation function in the spreadsheet front-end component and fully consider all factors influencing the character positions of the cells is solved.

The present disclosure relates to adding machine understanding to spreadsheet data. A method for generating chart recommendations based on machine understanding of spreadsheet data includes determining a data set, each piece of data including the content of a cell in one or more cells of a column of a spreadsheet presented to a user. The method also determines an entity type associated with the column based on the data set. The entity type represents the semantic meaning of the data set in the column of the spreadsheet. The method also identifies at least one icon in a plurality of charts that is related to the entity type associated with the column. The method then provides the identified chart for presentation to the user.

A client device for managing a distributed document is described. The client device comprises a transfer processor configured to exchange content data with a database, a spreadsheet processor configured to execute a file-based spreadsheet application, and a target processor configured to monitor content locations within a user interface. The transfer processor is configured to receive first content data that includes pre-existing data for a spreadsheet displayed by the application. The target processor is configured to populate first content locations with the first content data according to the identified content locations and capture second content data that is not included in the pre-existing data using content locations identified by a content profile. The content profile identifies content locations for the spreadsheet as displaying static content or user-based content. The transfer processor is configured to store the second content data in the database.

The embodiment of the invention discloses a data processing method and device based on a generative large language model. The method comprises the steps that a spreadsheet area and an assistant bar area are displayed on a target display interface; acquiring a spreadsheet operation description input by a user from the assistant bar area, and calling the target generative large language model to perform operation analysis processing on the spreadsheet operation description to obtain target table operation information; and determining a target editing script based on the target table operation information, and calling the target editing script to perform target table operation processing on the spreadsheet region. The steps of executing operation processing on the spreadsheet area by the user are simplified, the spreadsheet operation description is obtained through the assistant column area so as to identify the operation expected by the user, the operation is autonomously executed on the spreadsheet area, additional intervention of the user is not needed, continuous iteration updating of a spreadsheet software version is solved, and the user experience is improved. And the learning cost of the user is high.

Technology is disclosed herein for the integration of spreadsheet environments with LLM services. In an implementation, an application receives a natural language input from a user associated with a spreadsheet hosted by the application. The application generates a prompt that includes metadata about the spreadsheet and identifies a required format for descriptions of pivot tables. The application sends a prompt to a large language model (LLM) service to elicit a reply that includes a description of the pivot table having the required format. The application receives a reply to the prompt from the LLM service that includes the description of the pivot table in the required format. The application generates pivot table according to the reply from the LLM service.

The invention relates to the technical field of data processing, discloses a processing method and device for importing spreadsheet data into a database based on a Java persistent layer framework, equipment and a medium, and aims to solve the problem of low automation degree of importing the spreadsheet data into the database in the prior art. The method comprises the following steps: analyzing spreadsheet data needing to be read, putting the spreadsheet data of each row into a row object, setting an attribute format of each row object as a uniform character string format, obtaining a column value from the row object, and mapping the column value through an object relation configured by a Java-based persistent layer framework, so as to obtain the data of the spreadsheet; according to the method, the spreadsheet data is mapped into the field object of the corresponding table, and the data in the field object is written into the database table, so that the expandability and the automation degree of importing the spreadsheet data into the database are improved, and the method can be applied to but not limited to the medical health field, the financial field and the insurance field.

In a case where query information is stored in a cache sheet when recalculation is performed on a cell, a spreadsheet device (100) acquires an answer stored in the cache sheet in association with the query information, as a value to be stored in the cell in place of transmitting a query to an external server and acquiring an answer.

Aspects described herein may be used with local spreadsheet applications, web, and / or cloud-based spreadsheet solutions, to create complex custom software applications. Spreadsheets themselves lack the conceptual framework to be used as a platform tool to build custom or complex software applications. Using the methods and systems described herein using low-code / no-code techniques, a designer can create custom and / or complex software applications using one or more spreadsheets as the underlying blueprints for the software application. The resultant software application may be static / read-only, or may be interactive to allow users to dynamically add, delete, edit, or otherwise amend application data, e.g., via one or more online web pages or via a mobile application. Data transfer may be one-way or bi-directional between the blueprint spreadsheets and the resultant software application, thereby allowing amended data to be transferred from the software application back into spreadsheet form.

To enable a sheet to be safely, easily, quickly, and reliably spread over a vehicle cargo bed.SOLUTION: A device A includes a pair of support posts 1 erected on both rear sides of a work area and used as a mounting base B. From a position on the mounting base B that is reachable by a worker in the work area P, a sheet guide 2 extends obliquely via a curved section 20 toward the work area to a position above the far end of a vehicle cargo bed in the work area. A sheet hanger 3 to transfer a sheet is movably arranged on the sheet guide 2 and is driven by a sheet hanger drive device 4.SELECTED DRAWING: Figure 1

Aspects described herein may be used with local spreadsheet applications, web, and / or cloud-based spreadsheet solutions, to create complex custom software applications. Spreadsheets themselves lack the conceptual framework to be used as a platform tool to build custom or complex software applications. Using the methods and systems described herein using low-code / no-code techniques, a designer can create custom and / or complex software applications using one or more spreadsheets as the underlying blueprints for the software application. The resultant software application may be static / read-only, or may be interactive to allow users to dynamically add, delete, edit, or otherwise amend application data, e.g., via one or more online web pages or via a mobile application. Data transfer may be one-way or bi-directional between the blueprint spreadsheets and the resultant software application, thereby allowing amended data to be transferred from the software application back into spreadsheet form.

The invention provides an Excel multi-table continuous repeating data processing system and method, and belongs to the technical field of spreadsheet automation. According to the method, background colors of original table cells are removed through preprocessing; traversing the same Sheet in multiple tables by adopting a sliding window algorithm (the window length N is greater than or equal to 5), and detecting continuously repeated numerical values, texts or formulas in the row or column direction; color marking is carried out based on repeated source differentiation (the same as Sheet marking yellow, cross-Sheet marking red, and RGB self-definition is supported); through picture zooming, gray scale conversion and Hash value comparison, duplicate picture deduplication is realized, and a new table is positioned according to original coordinate parameters; and finally generating a new Excel file which retains original table merging cells, frame styles, font formats and formula structures. According to the method, the three technical problems of continuous repeated region detection missing, picture redundant storage and structure migration distortion are solved, the data processing efficiency and precision are remarkably improved, and the method is suitable for complex scenes in multiple fields such as financial audit, supply chain management and scientific research.

To provide a 3D CAD and spreadsheet software which allow for understanding a phenomenon by quantizing the phenomenon and making the phenomenon three-dimensional and allow for deepening understanding of a more abstruse and complicated phenomenon.SOLUTION: A method for displaying a three-dimensional graph includes drawing a circle with a radius R with an origin O as a center in a plane including an X axis and a Y axis of Cartesian coordinates, setting a point Op (0, 0, p) and equally dividing the circle and a segment from the origin O to the point Op by N, and properly setting N, p, and r. When an n-th measured value is denoted as Kn, coordinates (r.Kn.cos(2π.n / N), r.Kn.sin(2π.n / N), p.n / N) of arbitrary data Dn to be inputted are calculated by spreadsheet software, and the data is read in. When a point adjacent to the point Dn is denoted as a point D(n+1) and an N-th point from the point Dn is denoted as D(n+N) and a point having coordinates (0,0,p.n / N) is denoted as On, a segment from On to Dn, a segment from Dn to D(n+1), and a segment from Dn to D(n+N) are automatically plotted.SELECTED DRAWING: Figure 7

The present application discloses a method, device, equipment and storage medium for preventing spreadsheet formula calculation from being stuck, and relates to the field of computer technology. Specifically, it includes: determining a formula to be calculated according to a spreadsheet; determining the number of formula references of the formula to be calculated according to the formula to be calculated; determining a first formula according to the number of formula references, calculating the first formula, obtaining and storing the calculation result, and updating the first formula and the second formula; determining to respond to user operations according to a first preset rule, and executing a first preset action according to the user's operation type; determining that there is a circular reference formula and the preset number of iterations has not been reached, iteratively calculating the circular reference formula, determining to respond to user operations according to a second preset rule, and executing a second preset action according to the user's operation type. The present disclosure can realize responding to user operations during the calculation process of a spreadsheet, improving user experience, and avoiding invalid calculations and improving calculation efficiency after the spreadsheet is re-edited.

The present disclosure provides an information processing method and apparatus, a terminal, and a storage medium. The information processing method includes: receiving a first condition in an input box of a filter function of a spreadsheet, where the first condition corresponds to a corresponding column of the spreadsheet; obtaining data of each cell of the column corresponding to the first condition, and filtering the data based on the first condition to obtain a filtering result of the data; and outputting result data based on the filter function and the filtering result of the data. By using the filter function of the spreadsheet, multi-condition data filtering and statistics can be achieved, and the statistical requirements of users for table data can be met.

A shielding member (1) that suppresses penetration of noise into a vehicle interior both in a spread sheet state as a single sheet and in a folded state. The shielding member (1) comprises a flexible sheet member (2) that has a plurality of plate parts (3a, 3b) and an intermediate part (4) located between adjacent plate parts (3a, 3b). The sheet member (2) is foldable around the intermediate part (4) and can selectively assume a state in which the sheet member (2) is spread as a single plate and a state in which the plurality of plate parts (3a, 3b) are folded over each other. The plate parts (3a, 3b), with the exception of the intermediate part (4), contain a sound-absorbing layer (6a).

The invention discloses a method for performing object-oriented programming on a spreadsheet, which is characterized by comprising the following steps of: creating a definition of an object, and storing a definition file in a medium; the definition file of the object contains the definition of one or more objects; the definition file of the object is used for storing the object according to a preset storage format; a method function is created for the object, the method function is used for operating the object, the method function comprises at least one of a first method function, a second method function, a third method function, a fourth method function and a fifth method function, and the first method function is used for reading the object from a definition file to a memory data structure; a second method function to save the object from the memory data structure to a definition file; the third method function is used for returning the object; the fourth method function is used for transforming the input object; and the fifth method function is used for displaying the object in the memory on the interface. According to the method, object-oriented programming is realized on the spreadsheet, and related objects can be operated through the method function, so that the bottom logic complexity is hidden, and the programming efficiency is improved.

The application discloses a kind of multi-dimension data management method and system based on spreadsheet, method includes: in response to the editing operation instruction of the spreadsheet displayed to client, update the table structure and table data of spreadsheet;Editing operation instruction at least includes one of the drag instruction for dragging the row, column of spreadsheet to freely combine, the hidden filter instruction for hiding filter row, column and the sorting instruction for sorting the data of row, column;Capture the timestamp corresponding to editing operation instruction, with timestamp as index, updated table structure and table data as history data modification record, store the mapping relationship between index and history data modification record;Through mapping relationship, trace history data modification record.Therefore, by using the embodiment of the application, multi-dimension operation can meet the needs of enterprise to inventory management refinement, individualization, while can track to operator and modification history, improve the security and reliability of data.

The invention belongs to the technical field of charging piles, and discloses a charging pile communication message analysis method, which comprises the following steps: selecting a target spreadsheet file corresponding to a charging pile communication message from a plurality of preset spreadsheet files, and inputting the charging pile communication message into the target spreadsheet file; the method comprises the steps of determining an initial byte position and a byte length of each field in a communication message, presetting a field interception function taking the initial byte position and the byte length as parameters for each field, performing field-by-field interception on the communication message by calling the field interception function, and performing field-by-field interception on the communication message. Each field obtained by interception is output; carrying out system conversion on the intercepted field to obtain starting time and ending time; and determining a corresponding rate time period according to the starting time and the ending time, calculating and generating a rate amount according to the rate time period and a preset charging rule, and outputting the rate amount. The problems of low efficiency and poor accuracy during manual analysis are solved.

The present application relates to a key structure and a keyboard. The key structure comprises a key cap, a light emitting unit, and a light spreading sheet. The light spreading sheet is arranged between the light emitting unit and the key cap. Light emitted by the light emitting unit forms a light pattern on a first surface of the light spreading sheet after passing through the light spreading sheet. The light pattern comprises a first light spot, and a position of a normal projection of the first light spot on a projection plane parallel to the light spreading sheet is different from a position of a normal projection of the light emitting unit on the projection plane.

The invention provides an intelligent integration method, device and equipment for a flying book spreadsheet and a system data table, and the method comprises the steps: responding to the triggering of reading the spreadsheet, and loading pre-configured reading task parameters which comprise a flying book access token, a sheet name of the spreadsheet and a parameter configuration table preset for a reading task, the parameter configuration table is used for recording a first mapping relation between a spreadsheet column header and a system data table field; acquiring spreadsheet data based on the fly book access token and a sheet name of the spreadsheet, and extracting a column header field from the spreadsheet data; through at least one matching operation of annotation matching, synonym matching and parameter configuration table matching, constructing a second mapping relationship between the column header field and the system data table field; and writing the spreadsheet data into the system data table based on the second mapping relation. Through the method disclosed by the invention, automatic integration between the spreadsheet and the system data table can be realized.

According to an embodiment, the present invention provides a method for converting spreadsheet files into structured workbooks. The method includes receiving a spreadsheet file and identifying tables within it. Metadata associated with the tables is extracted and matched using fuzzy matching to identify standard objects and reports. The method further includes extracting formulas, selecting templates based on identified objects and reports, and creating a dependency graph. A topological sort is performed on the dependency graph to resolve dependencies. A workbook is generated, including sheets based on the processed tables and dependency graphs, and stored in non-volatile memory. A detailed report is also generated, documenting the conversion process. There are other embodiments as well.

The invention relates to the technical field of ultra-thin aluminum profile extrusion dies, in particular to a uniform heat treatment system and method for a one-die multi-output ultra-thin aluminum profile extrusion die, the uniform heat treatment system comprises a die assembly, a soaking assembly is arranged on the outer side of the die assembly, the soaking assembly comprises soaking boxes which are symmetrically arranged up and down, and the die assembly is arranged in the two soaking boxes; the rear sides of the two soaking boxes are rotationally connected through a hinge, the front sides of the two soaking boxes are connected through a buckle in a clamped mode, a plurality of arc-shaped soaking grooves are formed in the inner walls of the soaking boxes at equal intervals, and the multiple soaking grooves correspond to the mold assemblies in position. A uniform heat conduction layer is formed through thermal expansion of the metal soaking piece to guarantee heating uniformity of the mold, sealing of the heating cavity and uniform introduction of cooling airflow are achieved through linkage of thermal expansion and cold contraction of the metal soaking piece and the cooling holes, thermal stress is reduced fundamentally, mold defects are avoided, the service life of the mold is prolonged, and the qualified rate of aluminum profile products is increased.

To improve efficiency and accuracy of bill processing by a system including photographing of a bill, confirmation of information, automatic reflection, and transmission of an original.SOLUTION: A system includes: means for photographing a bill and confirming whether or not necessary information is prepared; means for automatically reflecting it on a spread sheet; and means for sending only an original to a person in charge.SELECTED DRAWING: Figure 1

To describe techniques for automatically synthesizing programs that include one or more functions in a spreadsheet programming language.SOLUTION: A method includes the steps of: receiving a first example including input provided in a first cell in a spreadsheet; automatically synthesizing a plurality of candidate programs including a first set of candidate programs consistent with the first example, each candidate program in the first set of candidate programs comprising at least one function in a spreadsheet programming language and, when the candidate program is executed, the candidate program generating output that matches the first example; ranking the plurality of candidate programs; and storing a highest-ranked program of the plurality of candidate programs in association with the first cell in the spreadsheet.SELECTED DRAWING: Figure 2

The utility model discloses a broadband omnidirectional ceiling antenna, and belongs to the field of antennas. The broadband omnidirectional ceiling antenna provided by the utility model comprises a reflection bottom plate, an oscillator assembly and a feed assembly, the oscillator assembly is installed above the reflection bottom plate, the oscillator assembly comprises a cup-shaped oscillator and a spectrum spreading sheet, the cup-shaped oscillator encloses an accommodating space with a top opening, and the spectrum spreading sheet is connected with the cup-shaped oscillator and is arranged at the opening position of the accommodating space; the feed assembly comprises a connecting seat, an insulating pad and a coaxial cable, the connecting seat is fixed with the reflection bottom plate, the connecting seat is of a hollow structure, the coaxial cable penetrates through a hollow area of the connecting seat to be connected with the cup-shaped vibrator, and the insulating pad is arranged on the periphery of the coaxial cable in a sleeving mode and clamped between the cup-shaped vibrator and the connecting seat. According to the utility model, the oscillator is designed to be of a cup-shaped structure with an opening at the top, and the spread spectrum sheet is arranged at the opening at the top of the oscillator to carry out spread spectrum processing on signals, so that the oscillator can cover frequency bands of 698-806 MHz and 3700-4200 MHz, and spread spectrum capacity expansion of indoor distributed communication network coverage is realized.