How to read and write ODF/ODS files (OpenDocument Spreadsheets): ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
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): 37591/ 44

Article Contents:

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

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).

« (Page 2)

View Entire Article

(Page 4) »

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