How to read and write ODF/ODS files (OpenDocument Spreadsheets)
page 3 of 6
by Josip Kremenic
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 38118/ 127

Spreadsheet Documents

Spreadsheet document files are the subset of ODF files. Spreadsheet files have .ods file extensions.

The content (sheets) is stored in content.xml subdocument.

Picture 1: content.xml subdocument

ContentXml.png

As we can see on Picture 1, sheets are stored as xml elements. 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).


View Entire Article

User Comments

Title: Read from .ods   
Name: .ods
Date: 2011-06-14 9:48:22 AM
Comment:
in asp.net i cannot view data from .ods file.
but i can view from .xls
Title: Read ODS Data   
Name: Cuong
Date: 2010-07-22 4:52:40 PM
Comment:
\
Title: Read ODS Data   
Name: pdvbalaji
Date: 2010-06-24 10:30:52 AM
Comment:
Hi,
Thank you I am searching for this for a long time ,but I am getting on issue ,when I am reading from .ods file in dataset I am getting some cells are empty plz tell me how to solve this problem. I am using .net2.0 and open office 3.1. I am waiting for your replay .my email id pdvbalaji@gmail.com
Title: Read ODS Data   
Name: pdvbalaji
Date: 2010-06-24 9:39:37 AM
Comment:
Hi,
Thank you I am searching for this for a long time ,but I am getting on issue ,when I am reading from .ods file in dataset I am getting some cells are empty plz tell me how to solve this problem. I am using .net2.0 and open office 3.1. I am waiting for your replay

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2021 ASPAlliance.com  |  Page Processed at 2021-04-16 11:08:32 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search