CN104285209B - 适用于报告生成的基于电子表格的编程语言 - Google Patents

适用于报告生成的基于电子表格的编程语言 Download PDF

Info

Publication number
CN104285209B
CN104285209B CN201280069713.2A CN201280069713A CN104285209B CN 104285209 B CN104285209 B CN 104285209B CN 201280069713 A CN201280069713 A CN 201280069713A CN 104285209 B CN104285209 B CN 104285209B
Authority
CN
China
Prior art keywords
report
spreadsheet
template
software module
datasets
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201280069713.2A
Other languages
English (en)
Chinese (zh)
Other versions
CN104285209A (zh
Inventor
迈克尔·J·陈
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Bibo Labs Inc
Original Assignee
Bibo Labs Inc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Bibo Labs Inc filed Critical Bibo Labs Inc
Publication of CN104285209A publication Critical patent/CN104285209A/zh
Application granted granted Critical
Publication of CN104285209B publication Critical patent/CN104285209B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44—Arrangements for executing specific programs
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44—Arrangements for executing specific programs
    • G06F9/448—Execution paradigms, e.g. implementations of programming paradigms
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/103—Formatting, i.e. changing of presentation of documents
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/103—Formatting, i.e. changing of presentation of documents
    • G06F40/117—Tagging; Marking up; Designating a block; Setting of attributes
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/174—Form filling; Merging
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/183—Tabulation, i.e. one-dimensional positioning
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/186—Templates

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Artificial Intelligence (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Stored Programmes (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Devices For Executing Special Programs (AREA)
CN201280069713.2A 2011-12-29 2012-12-27 适用于报告生成的基于电子表格的编程语言 Active CN104285209B (zh)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US201161581515P 2011-12-29 2011-12-29
US61/581,515 2011-12-29
PCT/US2012/071788 WO2013101914A1 (en) 2011-12-29 2012-12-27 Spreadsheet-based programming language adapted for report generation

Publications (2)

Publication Number Publication Date
CN104285209A CN104285209A (zh) 2015-01-14
CN104285209B true CN104285209B (zh) 2018-01-30

Family

ID=48698608

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201280069713.2A Active CN104285209B (zh) 2011-12-29 2012-12-27 适用于报告生成的基于电子表格的编程语言

Country Status (14)

Country Link
US (1) US10824802B2 (enExample)
EP (2) EP4571566A3 (enExample)
JP (1) JP6134737B2 (enExample)
KR (1) KR101977972B1 (enExample)
CN (1) CN104285209B (enExample)
AU (1) AU2012362383B2 (enExample)
CA (1) CA2862387C (enExample)
ES (1) ES3032661T3 (enExample)
HR (1) HRP20250753T1 (enExample)
HU (1) HUE072416T2 (enExample)
PL (1) PL2798487T3 (enExample)
RS (1) RS67042B1 (enExample)
SM (1) SMT202500242T1 (enExample)
WO (1) WO2013101914A1 (enExample)

Families Citing this family (54)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9483456B2 (en) 2011-09-19 2016-11-01 Jeffrey Dean Honsowetz Grid data management
US9292571B1 (en) * 2013-01-18 2016-03-22 Microstrategy Incorporated Joining database tables
US9244971B1 (en) 2013-03-07 2016-01-26 Amazon Technologies, Inc. Data retrieval from heterogeneous storage systems
US9189515B1 (en) * 2013-03-08 2015-11-17 Amazon Technologies, Inc. Data retrieval from heterogeneous storage systems
US9164977B2 (en) * 2013-06-24 2015-10-20 International Business Machines Corporation Error correction in tables using discovered functional dependencies
US9600461B2 (en) * 2013-07-01 2017-03-21 International Business Machines Corporation Discovering relationships in tabular data
USD748664S1 (en) * 2013-07-19 2016-02-02 Robert Bosch Gmbh Display screen with a graphical user interface
US9830314B2 (en) 2013-11-18 2017-11-28 International Business Machines Corporation Error correction in tables using a question and answer system
US10013396B2 (en) * 2015-01-29 2018-07-03 Dropbox, Inc. Modifying native documents with formulas in a preview
US10095740B2 (en) 2015-08-25 2018-10-09 International Business Machines Corporation Selective fact generation from table data in a cognitive system
JP1553723S (enExample) * 2015-10-30 2016-07-11
JP1553722S (enExample) * 2015-10-30 2016-07-11
CN105488019B (zh) * 2015-11-30 2018-05-29 云南电网有限责任公司电力科学研究院 一种电能质量监测装置检测报告自动生成方法
CN106021303B (zh) * 2016-05-05 2019-12-17 北京轻元科技有限公司 一种用于持续集成报告发布的系统和方法
US10303757B2 (en) * 2016-08-19 2019-05-28 Cognex Corporation Apparatuses, systems, and methods for providing a visual program for machine vision systems
KR102035277B1 (ko) * 2016-10-28 2019-10-22 단국대학교 천안캠퍼스 산학협력단 화장품 노출인자 분석 장치 및 방법
CN106446598A (zh) * 2016-11-15 2017-02-22 上海派森诺生物科技股份有限公司 项目报告自动生成方法
US10216494B2 (en) 2016-12-03 2019-02-26 Thomas STACHURA Spreadsheet-based software application development
US10540153B2 (en) 2016-12-03 2020-01-21 Thomas STACHURA Spreadsheet-based software application development
US11726753B2 (en) 2016-12-03 2023-08-15 Thomas STACHURA Spreadsheet-based software application development
JP1606618S (enExample) * 2017-09-21 2018-06-11
US10877735B1 (en) 2017-09-25 2020-12-29 Amazon Technologies, Inc. Automated generation of software applications using analysis of submitted content items
CN107845033A (zh) * 2017-11-08 2018-03-27 上海壹账通金融科技有限公司 风控报告生成方法、装置、设备及计算机可读存储介质
US10740550B1 (en) 2017-11-20 2020-08-11 Amazon Technologies, Inc. Network-accessible data management service with web-of-sheets data model
EP4231137A1 (en) * 2017-12-03 2023-08-23 Thomas Stachura Spreadsheet-based software application development
US10705805B1 (en) 2017-12-12 2020-07-07 Amazon Technologies, Inc. Application authoring using web-of-sheets data model
CN110083339A (zh) * 2018-01-26 2019-08-02 拜椰特（上海）软件技术有限公司 一种新型计算机编程语言
US11216706B2 (en) * 2018-03-15 2022-01-04 Datorama Technologies Ltd. System and method for visually presenting interesting plots of tabular data
CN108647196B (zh) * 2018-04-16 2022-10-25 北京航空航天大学 数字飞行器仿真报告中表格的人工智能生成方法和装置
US11586603B1 (en) 2018-05-23 2023-02-21 Amazon Technologies, Inc. Index sheets for robust spreadsheet-based applications
CN109241514A (zh) * 2018-09-10 2019-01-18 深圳市泰洲科技有限公司 数据自动导入方法、装置、计算机设备及存储介质
US11429558B2 (en) * 2018-10-11 2022-08-30 Dealvector, Inc. Mapping tests of spreadsheets in server-browser environments
US12223262B1 (en) * 2019-03-27 2025-02-11 Amazon Technologies, Inc. Expressions management service for data sheet-based applications
CN110427599A (zh) * 2019-06-06 2019-11-08 北京辰森世纪科技股份有限公司 报表小计的统计方法及装置、存储介质、电子装置
WO2021013871A1 (en) * 2019-07-22 2021-01-28 Ming Zou Computer implemented method, computer program and physical computing environment
CN111126019B (zh) * 2019-11-28 2024-01-05 泰康保险集团股份有限公司 基于模式定制的报表生成方法、装置和电子设备
CN111178027B (zh) * 2019-12-09 2023-03-31 北京尊冠科技有限公司 基于在线创建模板和在线指定数据的报告生成系统和方法
CN111144082B (zh) * 2019-12-23 2023-05-12 中国建设银行股份有限公司 多表格迭代计算方法、装置、电子设备及存储介质
CN111158650B (zh) * 2019-12-25 2023-06-27 中国建设银行股份有限公司 报表模板、报表的生成方法、装置
CN111241091B (zh) * 2019-12-29 2023-05-16 云帐房网络科技有限公司 一种商业报表数据的分布式列式数据存储转换方法及系统
TWI796545B (zh) * 2020-01-15 2023-03-21 訊光科技系統股份有限公司 文件式智能程式產生方法及其電子裝置
USD974370S1 (en) * 2020-04-03 2023-01-03 Markup Llc Display screen portion with graphical user interface
CN111680478B (zh) * 2020-06-17 2024-04-16 华自科技股份有限公司 基于组态软件的报表生成方法、装置、设备和存储介质
CN111723129B (zh) * 2020-06-24 2024-03-29 中国工商银行股份有限公司 报表生成方法、报表生成装置和电子设备
KR102230729B1 (ko) * 2020-08-31 2021-03-23 (주)비아이매트릭스 템플릿 기반 엑셀 문서 온라인 작업 시스템
CN112233498B (zh) * 2020-10-14 2023-01-06 烟台鼎钰电子科技有限公司 一种表格式可编程显示控制器
USD957452S1 (en) * 2020-11-19 2022-07-12 Autel Intelligent Technology Corp., Ltd. Display screen or portion thereof of a device with transitional graphical user interface
CN112541033B (zh) * 2020-12-01 2023-05-05 山东师范大学 Vba栈结构的演示方法、系统、存储介质及计算机设备
KR102499832B1 (ko) * 2020-12-18 2023-02-15 (주)비아이매트릭스 쿼리 바인딩 기능을 구비한 온라인 보고서 작성 시스템
US12450426B1 (en) * 2020-12-21 2025-10-21 Mehrdad Samadani Method and system for cellular computation and display
EP4050500A1 (en) * 2021-02-24 2022-08-31 Think Research Corporation Systems, methods and devices for structured dynamic electronic forms
US11797430B2 (en) 2021-12-03 2023-10-24 T-Mobile Usa, Inc. Configuration-driven data conversion and hosting for software development systems and methods
US11599718B1 (en) 2022-03-23 2023-03-07 Acuitive Solutions, Inc. Database system for storing electronic spreadsheets
CN117454862A (zh) * 2023-12-25 2024-01-26 青岛民航凯亚系统集成有限公司 一种基于引擎模式的报表生成方法及自助bi系统

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7197696B1 (en) * 2003-06-05 2007-03-27 Pavan Vidyadhar Muzumdar System, method and computer program product to populate data into spreadsheets and execute functions and programs within the same
CN101038584A (zh) * 2006-03-14 2007-09-19 国际商业机器公司 用于执行计算处理的系统和方法

Family Cites Families (33)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH11161656A (ja) * 1997-11-27 1999-06-18 Asahi Chem Ind Co Ltd データベース検索・抽出システムおよびデータベース検索・抽出用制御プログラムを記録した記録媒体
US6078924A (en) * 1998-01-30 2000-06-20 Aeneid Corporation Method and apparatus for performing data collection, interpretation and analysis, in an information platform
US6631497B1 (en) * 1999-07-19 2003-10-07 International Business Machines Corporation Binding data from data source to cells in a spreadsheet
US6816630B1 (en) * 2000-05-22 2004-11-09 Electro-Sensors, Inc. System and method for creating and processing data forms
US7251776B2 (en) 2001-07-13 2007-07-31 Netview Technologies, Inc. System and method for efficiently and flexibly utilizing spreadsheet information
WO2003098500A1 (en) 2002-05-16 2003-11-27 Decision Curve Limited Method and apparatus for automatically producing spreadsheet-based models
US20040111666A1 (en) * 2002-12-05 2004-06-10 Hollcraft James G. Software replicator functions for generating reports
US20040221233A1 (en) 2003-04-29 2004-11-04 David Thielen Systems and methods for report design and generation
US6965978B2 (en) * 2003-05-15 2005-11-15 Microsoft Corporation Memory tracking tool
US7694315B2 (en) * 2004-02-13 2010-04-06 Microsoft Corporation Schema-based machine generated programming models
US20060085444A1 (en) * 2004-10-19 2006-04-20 Microsoft Corporation Query consolidation for retrieving data from an OLAP cube
US7426688B2 (en) * 2004-11-02 2008-09-16 Hewlett-Packard Development Company, L.P. Embedded spreadsheet commands
US7487446B2 (en) 2004-11-10 2009-02-03 Microsoft Corporation Using a word processor with accounting data
US20060107196A1 (en) * 2004-11-12 2006-05-18 Microsoft Corporation Method for expanding and collapsing data cells in a spreadsheet report
US7647551B2 (en) * 2004-12-15 2010-01-12 Microsoft Corporation System and method for formatting a cell in response to data stored in a separate location
US20060136436A1 (en) * 2004-12-22 2006-06-22 At&T Corp. Arrangement enabling thin client to access and present data in custom defined reports
US7792847B2 (en) * 2005-09-09 2010-09-07 Microsoft Corporation Converting structured reports to formulas
US7805433B2 (en) * 2005-10-14 2010-09-28 Microsoft Corporation Multidimensional cube functions
US20080104542A1 (en) * 2006-10-27 2008-05-01 Information Builders, Inc. Apparatus and Method for Conducting Searches with a Search Engine for Unstructured Data to Retrieve Records Enriched with Structured Data and Generate Reports Based Thereon
JP2008234370A (ja) * 2007-03-21 2008-10-02 Just Syst Corp 文書処理装置及び文書処理方法
US8095870B2 (en) * 2007-06-06 2012-01-10 Oracle International Corporation Extensible document transformation language: an innovative way of generating business document and report
US20090055341A1 (en) * 2007-08-22 2009-02-26 American Express Travel Related Services Company, Inc. Regulatory Survey Automation System (RSAS)
US8407668B2 (en) * 2007-10-26 2013-03-26 Microsoft Corporation Model based spreadsheet scripting language
US8341512B2 (en) * 2007-10-31 2012-12-25 Microsoft Corporation Method for capturing design-time and run-time formulas associated with a cell
US8856182B2 (en) * 2008-01-25 2014-10-07 Avaya Inc. Report database dependency tracing through business intelligence metadata
US9104738B2 (en) * 2008-06-19 2015-08-11 Tropare, Inc. Leveraging collaborative cloud services to build and share apps
US8788928B2 (en) * 2009-07-15 2014-07-22 Clandscale, Inc. System and methodology for development of stream processing applications utilizing spreadsheet interface
AU2010201974A1 (en) * 2009-10-23 2011-05-12 Iconstruct (Aus) Pty Ltd System and Method for Managing Information
CN102053975A (zh) * 2009-10-30 2011-05-11 国际商业机器公司 数据库系统和跨数据库查询优化方法
US20110173529A1 (en) * 2010-01-11 2011-07-14 Microsoft Corporation Template processing engine for business systems
JP2011227631A (ja) * 2010-04-16 2011-11-10 Wincube Co Ltd 業務管理用システム
US8843814B2 (en) * 2010-05-26 2014-09-23 Content Catalyst Limited Automated report service tracking system and method
US8677230B2 (en) * 2011-09-15 2014-03-18 Morgan Stanley Network-based data consolidation, calculation and reporting engine

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7197696B1 (en) * 2003-06-05 2007-03-27 Pavan Vidyadhar Muzumdar System, method and computer program product to populate data into spreadsheets and execute functions and programs within the same
CN101038584A (zh) * 2006-03-14 2007-09-19 国际商业机器公司 用于执行计算处理的系统和方法

Also Published As

Publication number Publication date
HUE072416T2 (hu) 2025-11-28
EP4571566A3 (en) 2025-09-03
KR20140126311A (ko) 2014-10-30
EP2798487C0 (en) 2025-05-07
JP2015504213A (ja) 2015-02-05
HRP20250753T1 (hr) 2025-11-07
AU2012362383B2 (en) 2018-05-10
CA2862387A1 (en) 2013-07-04
CN104285209A (zh) 2015-01-14
EP2798487A4 (en) 2015-09-09
PL2798487T3 (pl) 2025-09-08
US10824802B2 (en) 2020-11-03
EP2798487A1 (en) 2014-11-05
WO2013101914A1 (en) 2013-07-04
KR101977972B1 (ko) 2019-05-14
CA2862387C (en) 2023-03-14
EP2798487B1 (en) 2025-05-07
US20130290822A1 (en) 2013-10-31
RS67042B1 (sr) 2025-08-29
EP4571566A2 (en) 2025-06-18
SMT202500242T1 (it) 2025-09-12
AU2012362383A1 (en) 2014-07-24
ES3032661T3 (en) 2025-07-23
JP6134737B2 (ja) 2017-05-24
HK1205303A1 (en) 2015-12-11

Similar Documents

Publication Publication Date Title
CN104285209B (zh) 适用于报告生成的基于电子表格的编程语言
US9201558B1 (en) Data transformation system, graphical mapping tool, and method for creating a schema map
US10127250B2 (en) Data transformation system, graphical mapping tool and method for creating a schema map
US9811604B2 (en) Method and system for defining an extension taxonomy
Bernstein et al. Information integration in the enterprise
US8024701B2 (en) Visual creation of object/relational constructs
US20130166550A1 (en) Integration of Tags and Object Data
US20110087708A1 (en) Business object based operational reporting and analysis
US20120023130A1 (en) Facilitation of extension field usage based on reference field usage
US8527867B2 (en) Enabling users to edit very large XML data
JP2015504213A5 (enExample)
US9779135B2 (en) Semantic related objects
CN115004171B (zh) 用于与模式无关的查询模板的生成和应用的系统和方法
US20120143867A1 (en) Facilitating Extraction and Discovery of Enterprise Services
US9208195B2 (en) Retrieving information from a relational database using user defined facets in a faceted query
Sattar et al. Incorporating nosql into a database course
US11644949B2 (en) Autotagging a template of a reporting workbook
He et al. Application of the indent conversion based on XML and DOM
HK1205303B (en) Spreadsheet-based programming language adapted for report generation
US20130086128A1 (en) Business content hierarchy
Poznanović et al. An Approach to Generating Specifications of a Database Schema for DBMSs based on XML Data Model
Choo et al. Data Warehouse Design and Implementation for Research Literature Mining
Ristic et al. Form-driven Application Development
Sattar et al. Bits& Bytes
Velinska et al. Performance of an XML DBMS as a Model Repository in Model-Driven Software Development

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
REG Reference to a national code

Ref country code: HK

Ref legal event code: DE

Ref document number: 1205303

Country of ref document: HK

GR01 Patent grant
GR01 Patent grant
REG Reference to a national code

Ref country code: HK

Ref legal event code: GR

Ref document number: 1205303

Country of ref document: HK