arrow
返回

Spreadsheet Data Manipulation Using Examples

delete2012-08-01
delete172
PRE
AI
S
Sumit Gulwani *
W
William R. Harris
R
Rishabh Singh
DOI:10.1145/2240236.2240260delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
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.

期刊

Communications of the ACM 封面图
Communications of the ACM
IF:
12.2
论文数:
1.2W
被引数:
3.7W

机构

U
university of wisconsin madison
学者数:
3.8W
论文数: 2.9W
被引数: 53
University of Wisconsin System 封面图
University of Wisconsin System
学者数:
6.7W
论文数: 5.8W
被引数: 382
M
Microsoft
学者数:
3.0K
论文数: 2.7K
被引数: 7
学者 查看更多机构
引用论文

引用论文

Measurement of Mechanical Forces Generated by Skin Fibroblasts Embedded in a Three-Dimensional Collagen Gel
err1991-11-01
err0
PREAI
errPierre. Delvoye; Philippe. Wiliquet; Jean-Luc. Levêque; Betty V. Nusgens; Charles M. Lapière
err分享
err收藏
err2003-01-01
err0
PREAI
errZ Cui; J W Shepherdson; Y Li
err分享
err收藏
Coastline retreat via progressive failure of rocky coastal cliffs
err2013-08-01
err0
errOAAI
errNick J. Rosser; Matthew J. Brain; David N. Petley; Michael Lim; Emma C. Norman
err分享
err收藏
Aromaticity Driven Electrocatalytic Water Oxidation by a Phosphorus-Nitrogen PN3-Pincer Cobalt Complex
err
IF0
err2019-08-27
err0
errOAAI
errPradip K. Das; Sarmistha Bhunia; Priyanka Chakraborty; Atanu Rana; Abhishek Dey; Kuo-Wei Huang
err分享
err收藏
err分享
err收藏
err分享
err收藏
学者 查看更多内容