Automatic translation of spreadsheets into scripts
US10180934B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 24, 2017 |
| Grant date | Jan 15, 2019 |
| Priority date | — |
| Expiry date | Jul 24, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F40/205
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Systems and methods are provided for automatically translating one or more electronic spreadsheets into scripts. One or more electronic spreadsheets containing data arrays and formula arrays may be accessed. The electronic spreadsheet(s) may implement various logic using the data arrays and the formula arrays. The range(s) of the formula arrays may be determined. The range(s) of the data arrays may be determined based on the range(s) of the formula arrays. Conversion ranges may be determined based on the range(s) of formula arrays and the range(s) of data arrays. One or more dependencies between the conversion ranges may be determined and used to generate source code modeling the logic implemented by the electronic spreadsheet(s).
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.