Difference between revisions of "AODL example 1"
From Apache OpenOffice Wiki
Line 27: | Line 27: | ||
spreadsheetDocument.SaveTo("formated.ods"); | spreadsheetDocument.SaveTo("formated.ods"); | ||
</pre> | </pre> | ||
+ | |||
+ | Back to the [[AODL_examples|AODL examples]] overview. |
Revision as of 18:22, 4 March 2007
Create a Spreadsheet document and add a table with formated cells.
//Create new spreadsheet document SpreadsheetDocument spreadsheetDocument = new SpreadsheetDocument(); spreadsheetDocument.New(); //Create a new table Table table = new Table(spreadsheetDocument, "First", "tablefirst"); //Create a new cell, without any extra styles Cell cell = table.CreateCell(); //Add a paragraph to this cell Paragraph paragraph = ParagraphBuilder.CreateSpreadsheetParagraph(spreadsheetDocument); //Create some Formated text FormatedText fText = new FormatedText(spreadsheetDocument, "T1", "Some Text"); //fText.TextStyle.TextProperties.Bold = "bold"; fText.TextStyle.TextProperties.Underline = LineStyles.dotted; //Add formated text paragraph.TextContent.Add(fText); //Add paragraph to the cell cell.Content.Add(paragraph); //Insert the cell at row index 2 and column index 3 //All need rows, columns and cells below the given //indexes will be build automatically. table.InsertCellAt(2, 3, cell); //Insert table into the spreadsheet document spreadsheetDocument.TableCollection.Add(table); spreadsheetDocument.SaveTo("formated.ods");
Back to the AODL examples overview.