In the life science domain, experts are usually familiar with spreadsheet software and often use it in their daily work to collect and structure required domain knowledge. The processing and analysis of spreadsheet data is an important task that must be supported by efficient software solutions. A typical application scenario is for example an integration of spreadsheet data (specified or derived) in an ontology to provide reasoning or search. Different converter tools were developed to support a spreadsheet-to-ontology transformation. Such tools allow often only a relatively simple structure of the spreadsheet template or they require complex mapping processes to map the spreadsheet and ontological entities. In many cases, it is impossible to use the existing converter tools because the spreadsheet data must be processed first before the derived data can be integrated into the ontology. In such cases, an efficient and fast development of customized software solutions is of great importance. In this paper, we present a general spreadsheet processing framework to efficiently read and write spreadsheet data. The Spreadsheet Model Generator (SMOG) provides a simple mechanism to automatically generate the Java object model and mappings between object code and spreadsheet entities. Our solution greatly simplifies the implementation of spreadsheet access methods and enables an efficient development of spreadsheet-based applications. The SMOG has already been used successfully in several biomedical projects under real world conditions.
IOS Press, Inc.
6751 Tepper Drive
Clifton, VA 20124
Tel.: +1 703 830 6300
Fax: +1 703 830 2300 firstname.lastname@example.org
(Corporate matters and books only) IOS Press c/o Accucoms US, Inc.
For North America Sales and Customer Service
West Point Commons
Lansdale PA 19446
Tel.: +1 866 855 8967
Fax: +1 215 660 5042 email@example.com