Spreadsheet Data Manipulation Using Examples.
Millions of computer end users need to perform tasks over large spreadsheet data, yet lack the programming knowledge to do such tasks automatically. We present a programming by example methodology that allows end users to automate such repetitive tasks. Our methodology involves designing a domain-sp...
| Publicado en: | Communications of the ACM Vol. 55; no. 8; pp. 97 - 106 |
|---|---|
| Formato: | Artículo |
| Publicado: |
Association for Computing Machinery
Aug2012
|
| Materias: | |
| Acceso en línea: | Ver este registro en EBSCOhost |
| fields | @attributes: recordID: 1 pdfLink: plink: https://search.ebscohost.com/login.aspx?direct=true&db=hlh&AN=78357200&site=ehost-live header: @attributes: shortDbName: hlh uiTerm: 78357200 longDbName: Humanities International Complete uiTag: AN controlInfo: bkinfo: jinfo: jid: 00010782 ACM jtl: Communications of the ACM issn: 00010782 maglogo: N pubinfo: dt: Aug2012 vid: 55 iid: 8 pid: 68 pub: Association for Computing Machinery artinfo: ui: 78357200 10.1145/2240236.2240260 ppf: 97 ppct: 9 formats: tig: atl: Spreadsheet Data Manipulation Using Examples. aug: su: Electronic spreadsheets Computer programming Microsoft Excel (Computer software) Domain-specific programming languages Information technology Electronic data processing sug: subj: Electronic spreadsheets Computer programming Microsoft Excel (Computer software) Domain-specific programming languages Information technology Electronic data processing ab: Millions of computer end users need to perform tasks over large spreadsheet data, yet lack the programming knowledge to do such tasks automatically. We present a programming by example methodology that allows end users to automate such repetitive tasks. Our methodology involves designing a domain-specific language and developing a synthesis algorithm that can learn programs in that language from user-provided examples. We present instantiations of this methodology for particular domains of tasks: (a) syntactic transformations of strings using restricted forms of regular expressions, conditionals, and loops, (b) semantic transformations of strings involving lookup in relational tables, and (c) layout transformations on spreadsheet tables. We have implemented this technology as an add-in for the Microsoft Excel Spreadsheet system and have evaluated it successfully over several benchmarks picked from various Excel help forums. pubtype: Periodical doctype: Article src: R language: English refInfo: copyright: @attributes: flag: Y dt: @attributes: year: 2012 holdings: @attributes: islocal: N |
|---|