how to use openoffice database in visual basic

HOW TO USE OPENOFFICE DATABASE IN VISUAL BASIC ZIP FILE
HOW TO USE OPENOFFICE DATABASE IN VISUAL BASIC FULL
HOW TO USE OPENOFFICE DATABASE IN VISUAL BASIC SOFTWARE
HOW TO USE OPENOFFICE DATABASE IN VISUAL BASIC ZIP

HOW TO USE OPENOFFICE DATABASE IN VISUAL BASIC ZIP

ods file (which is ZIP file).įor processing documents we have used XmlDocument because it offers easy way to reach part that we want. Using ZIP component we can extract files, get subdocument, replace (or add) subdocuments that we want and save that file as. Because of that, our demo uses open source component called DotNetZip. Zip component and XML parserĪlthough classes from System.IO.Packaging namespace (.NET 3.0) provides way to read and write ZIP files, they require different format of ZIP file. Through interface, user can read, write, edit data and add new rows to Spreadsheet document. To show data from our DataSet (and to allow editing that data) application dynamically creates tabs with DataGridViews (that are connected to our DataTables). Each DataTable has number of rows and columns that conforms to our needs. So, to create a new document we have to create new DataSet, with DataTables. Each sheet is represented with DataTable, sheet’s row with DataRow, and sheet’s column with DataColumn. Internal, Spreadsheet document is stored as DataSet. Our demo is Windows Forms application (Picture 2), written in C# using Visual Studio 2008.Ĭreating new document and underlying model of application

HOW TO USE OPENOFFICE DATABASE IN VISUAL BASIC FULL

They contain column and row definitions, rows contain cells and so on… On picture is data from one specific document, but from this we can see basic structure of content.xml file (you can also download full ODF specification). The content (sheets) is stored in content.xml subdocument.Īs we can see on Picture 1, sheets are stored as xml elements. Spreadsheet document files are the subset of ODF files.

HOW TO USE OPENOFFICE DATABASE IN VISUAL BASIC ZIP FILE

Package everything into a ZIP file with appropriate extension.On the other side, if you want to create a new ODF file, you need to: Find parts that contain data you want to read.In order to read the data from an ODF file you need to: settings.xml – Application-specific settings, such as the window size or printer information.īesides them, in package can be many other subdocuments like document thumbnail, images, etc.meta.xml – Document meta information, such as the author or the time of the last save action.styles.xml – Styles used in the document content and automatic styles used in the styles themselves.content.xml – Document content and automatic styles used in the content.There are four subdocuments in the package that contains file’s data: Files are smaller as a result of compression and native multimedia storage.Images and multimedia are now encoded in native format, not as text streams.You don’t need to process entire file in order to extract specific data.For example, one subdocument contains the style information and another subdocument contains the content of the document. Each subdocument stores a particular aspect of the document. Office applications use second approach so we will explain it detail.Įvery ODF file is a collection of several subdocuments within a package (ZIP file), each of which stores part of the complete document. As a collection of several subdocuments within a package.

OpenDocument format supports document representation: ods files can be opened using Excel 2007 SP2 and Calc. Application is written in C# using Visual Studio 2008. Presented is a demo application which writes/reads tabular data to/from. This article will explain basics of ODF format, and specifically its implementation in spreadsheet applications ( Calc and Microsoft Office Excel 2007 SP2). Originally, format was implemented by the office suite and, with Office 2007 SP2, Microsoft also supports ODF subset.

HOW TO USE OPENOFFICE DATABASE IN VISUAL BASIC SOFTWARE

The OpenDocument format is used in free software and in proprietary software. The standard was developed by the OASIS (Organization for the Advancement of Structured Information Standards), and it is free and open format. The OpenDocument Format (ODF) is an XML-based file format for representing electronic documents such as spreadsheets, charts, presentations and word processing documents.

How to use openoffice database in visual basic