The ODF Toolkit Project

» License

odftoolkit was started in October 2008, is owned by DieterLoeschky, and has 82 members.

» Bookmark This Project

Need example of odf spreadsheet

101 topics, 268 posts

Replies: 4 - Last Post: July 26, 2009 08:31
by: toecutter

« Older Topic » Newer Topic

showing 1 - 5 of 5

raju

Posted: July 21, 2009 08:26 by raju

» Permalink

Friends

I need basic example of loading spreadsheet doc/creating spreadsheet,manipulating spreadsheet table/sheet, row, col and set data type in column.

I looked into the odf source repository, there is not any useful test case for spreadsheet.
I think it would be great for us(beginner) to have test case for spreadsheet document.Test would include following

1.create/load spreadsheet
2.create sheet/table
3.create /update/delete row
4.create/update/delete col
6.setting data type in col
7.create spreadsheet header.

I think Junit test case would be great for us.

huijzer	Posted: July 21, 2009 17:05 by huijzer » Permalink
	There are some tutorials available, including one about spreadsheets: http://langintro.com/odfdom_tutorials/create_ods.html Gr. Arjan

raju	Posted: July 26, 2009 05:31 by raju » Permalink
	Thank you very much for your information. It seems those examples can help me

raju	Posted: July 26, 2009 05:58 by raju » Permalink
	those also reflecting old odf jar

toecutter

Posted: July 26, 2009 08:31 by toecutter

» Permalink

I am also interested in doing this using vb.net

I can currently do it with excel and VB.net.

I found this code that is supposed to populate a .ods sheet but i get heaps of errors.

Imports System
Imports Independentsoft.Odf

Module Module1
Sub Main(ByVal args() As String)
Dim spreadsheet As New Spreadsheet()

Dim annotation1 As New Annotation()
annotation1.Creator = "John"
annotation1.CreationDate = DateTime.Now

Dim commentParagraph As New Paragraph()
commentParagraph.Add("My comment text.")

annotation1.Content.Add(commentParagraph)

Dim a1 As New Cell(100)
a1.Content.Add(annotation1)

Dim sheet1 As New Table()
sheet1("A1") = a1

spreadsheet.Tables.Add(sheet1)

spreadsheet.Save("c:\test.ods")
End Sub
End Module

ERRORS:
Warning 1 Namespace or type specified in the Imports 'Independentsoft.Odf' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases. C:\Documents and Settings\XXX\My Documents\Visual Studio 2005\Projects\Excel To Open Office\Excel To Open Office\Module1.vb 3 9 Excel To Open Office

I think i need to add a reference to OpenOffice but i can not find it in the COM listbox and i can not find any information on how to reference it.

Or am i completely heading down the wrong path?

regards
toe

Replies: 4 - Last Post: July 26, 2009 08:31
by: toecutter

« Older Topic » Newer Topic