Difference between revisions of "AODL example 1"
From Apache OpenOffice Wiki
m |
|||
(2 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | <b>Create a Spreadsheet document and add a table with | + | <b>Create a Spreadsheet document and add a table with formatted cells.</b> |
− | + | <syntaxhighlight lang="c"> | |
− | < | ||
//Create new spreadsheet document | //Create new spreadsheet document | ||
SpreadsheetDocument spreadsheetDocument = new SpreadsheetDocument(); | SpreadsheetDocument spreadsheetDocument = new SpreadsheetDocument(); | ||
Line 25: | Line 24: | ||
//Insert table into the spreadsheet document | //Insert table into the spreadsheet document | ||
spreadsheetDocument.TableCollection.Add(table); | spreadsheetDocument.TableCollection.Add(table); | ||
− | spreadsheetDocument.SaveTo(" | + | spreadsheetDocument.SaveTo("formatted.ods"); |
− | </ | + | </syntaxhighlight> |
Back to the [[AODL_examples|AODL examples]] overview. | Back to the [[AODL_examples|AODL examples]] overview. | ||
+ | |||
+ | [[category:Summer of Code 2007]][[category:AODL]] |
Latest revision as of 12:33, 22 May 2022
Create a Spreadsheet document and add a table with formatted 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("formatted.ods");
Back to the AODL examples overview.