public void ComplexCalcLoadTest()
{
string file = AARunMeFirstAndOnce.inPutFolder + @"HazelHours.ods";
FileInfo fInfo = new FileInfo(file);
//Load a spreadsheet document
SpreadsheetDocument document = new SpreadsheetDocument();
try
{
document.Load(file);
//Save it back again
document.SaveTo(AARunMeFirstAndOnce.outPutFolder + fInfo.Name + ".html");
}
catch (Exception ex)
{
if (ex is AODLException)
{
Console.WriteLine("Stacktrace: {0}", ((AODLException)ex).OriginalException.StackTrace);
Console.WriteLine("Msg: {0}", ((AODLException)ex).OriginalException.Message);
if (((AODLException)ex).Node != null)
{
Console.WriteLine("Stacktrace: {0}", ((AODLException)ex).Node.OuterXml);
}
}
}
}
public void CsvToOpenDocumentSpreadsheet()
{
SpreadsheetDocument document = new SpreadsheetDocument();
document.Load(AARunMeFirstAndOnce.inPutFolder + "CsvToOpenDocument.csv");
Assert.IsTrue(document.Content.Count == 1, "Must contain objects.");
document.SaveTo(AARunMeFirstAndOnce.outPutFolder + "CsvToOpenDocument.ods");
}
public void ComplexCalcLoadTest()
{
string file = AARunMeFirstAndOnce.inPutFolder + @"HazelHours.ods";
FileInfo fInfo = new FileInfo(file);
//Load a spreadsheet document
SpreadsheetDocument document = new SpreadsheetDocument();
document.Load(file);
//Save it back again
document.SaveTo(AARunMeFirstAndOnce.outPutFolder + fInfo.Name + ".html");
}
public void HTMLExportTest3()
{
string file = AARunMeFirstAndOnce.inPutFolder + @"simpleCalc.ods";
FileInfo fInfo = new FileInfo(file);
//Load a spreadsheet document
SpreadsheetDocument document = new SpreadsheetDocument();
document.Load(file);
//Save it back again
document.SaveTo(AARunMeFirstAndOnce.outPutFolder + fInfo.Name + ".html");
}
public void CsvToOpenDocumentSpreadsheet()
{
SpreadsheetDocument document = new SpreadsheetDocument();
document.Load(AARunMeFirstAndOnce.inPutFolder + "CsvToOpenDocument.csv", new CsvImporter());
Assert.IsTrue(document.Content.Count == 1, "Must contain objects.");
using (IPackageWriter writer = new OnDiskPackageWriter())
{
document.Save(AARunMeFirstAndOnce.outPutFolder + "CsvToOpenDocument.ods", new OpenDocumentTextExporter(writer));
}
}
public void LoadChartModifyTitle()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"TestChartOne.ods"));
IContent iContent = (EmbedObject)doc.EmbedObjects [0];
((Chart)iContent).ChartTitle.SetTitle("A New Title");
((Chart)iContent).ChartTitle.SvgX = "2cm";
((Chart)iContent).ChartTitle.SvgY = "0.5cm";
doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "TestTitle.ods"));
}
public void NewChartWithCellRange()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"testsheet.ods"));
Table table = doc.TableCollection[0];
Chart chart = ChartBuilder.CreateChartByCellRange(table, "A4:F8", ChartTypes.bar, null, null, "刘玉花的测试", 3, "bottom", "P14");
table.InsertChartAt("H2", chart);
doc.Content.Add(table);
doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "NewChartWithCellRange.ods"));
}
public void NewChartWithLegend()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"testsheet.ods"));
Table table = doc.TableCollection[0];
Chart chart = ChartBuilder.CreateChartByLegend(table, "A3:F8", ChartTypes.surface, "left", "0.5", "5", "year", "dollars");
table.InsertChartAt("M2", chart);
doc.Content.Add(table);
doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "NewChartWithLegend.ods"));
}
public void NewChartWithAxises()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"testsheet.ods"));
Table table = doc.TableCollection[0];
Chart chart = ChartBuilder.CreateChartByAxises(table, "A1:B2", ChartTypes.line, 2);
table.InsertChartAt("I2", chart);
doc.Content.Add(table);
doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "NewChartWithAxis.ods"));
}
public void TestLengend()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"TestChartOne.ods"));
Chart chart = (Chart)doc.EmbedObjects [0];
chart.ChartLegend.LegendPosition = "left";
chart.ChartLegend.SvgX = "5cm";
chart.ChartLegend.SvgY = "2cm";
doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "TestLegend.ods"));
}
public void SpreadSheetFormsTest()
{
//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 = new Cell(spreadsheetDocument, "cell001");
cell.OfficeValueType = "string";
//Set full border
cell.CellStyle.CellProperties.Border = Border.NormalSolid;
//Add a paragraph to this cell
Paragraph paragraph = ParagraphBuilder.CreateSpreadsheetParagraph(
spreadsheetDocument);
//Add some text content
paragraph.TextContent.Add(new SimpleText(spreadsheetDocument, "Some text"));
//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.Rows.Add(new Row(table, "Standard"));
table.Rows.Add(new Row(table, "Standard"));
table.Rows.Add(new Row(table, "Standard"));
table.InsertCellAt(3, 2, cell);
//Insert table into the spreadsheet document
ODFForm main_form = new ODFForm(spreadsheetDocument, "mainform");
main_form.Method = Method.Get;
ODFButton butt = new ODFButton(main_form, cell.Content, "butt", "0cm", "0cm", "15mm", "8mm");
butt.Label = "test :)";
main_form.Controls.Add(butt);
spreadsheetDocument.TableCollection.Add(table);
table.Forms.Add(main_form);
spreadsheetDocument.SaveTo(AARunMeFirstAndOnce.outPutFolder + "spreadsheet_forms.ods");
SpreadsheetDocument spreadsheetDocument2 = new SpreadsheetDocument();
spreadsheetDocument2.Load(AARunMeFirstAndOnce.outPutFolder + "spreadsheet_forms.ods");
ODFButton b = spreadsheetDocument2.TableCollection[0].FindControlById("butt") as ODFButton;
Assert.IsNotNull(b);
b.Label = "it works!";
spreadsheetDocument2.SaveTo(AARunMeFirstAndOnce.outPutFolder + "spreadsheet_forms2.ods");
}
public void SimpleCalcLoadTest()
{
string file = AARunMeFirstAndOnce.inPutFolder + @"simpleCalc.ods";
FileInfo fInfo = new FileInfo(file);
//Load a spreadsheet document
SpreadsheetDocument document = new SpreadsheetDocument();
document.Load(file);
Assert.IsTrue(document.CommonStyles.Count > 0, "Common Styles must be read!");
Console.WriteLine("Common styles: {0}", document.CommonStyles.Count);
//Save it back again
document.SaveTo(AARunMeFirstAndOnce.outPutFolder + fInfo.Name + ".rel.ods");
}
public void SpreadSheetImportExportTest()
{
//Create new spreadsheet document
SpreadsheetDocument spreadsheetDocument = new SpreadsheetDocument();
spreadsheetDocument.Load(AARunMeFirstAndOnce.inPutFolder + @"bigtable.ods");
ODFForm f = new ODFForm(spreadsheetDocument, "mainform");
ODFButton butt = new ODFButton(f, spreadsheetDocument.TableCollection[0].Rows[1].Cells[1].Content, "butt", "5mm", "15mm", "4cm", "1cm");
f.Controls.Add(butt);
spreadsheetDocument.TableCollection[0].Forms.Add(f);
spreadsheetDocument.SaveTo(AARunMeFirstAndOnce.outPutFolder + "bigtable2.ods");
}
public void TestPlotArea()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"TestChartOne.ods"));
Chart chart = (Chart)doc.EmbedObjects [0];
chart.ChartPlotArea.SvgX = "1.2cm";
chart.ChartPlotArea.SvgY = "2.5cm";
chart.ChartPlotArea.Width = "5cm";
chart.ChartPlotArea.Height = "5cm";
doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "TestPlotArea.ods"));
}
public void LoadChart()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"TestChartOne.ods"));
IContent iContent = (EmbedObject)doc.EmbedObjects [0];
((Chart)iContent).ChartType = ChartTypes.bar.ToString();
((Chart)iContent).XAxisName = "XAxis";
((Chart)iContent).YAxisName = "YAxis";
((Chart)iContent).SvgWidth = "20cm";
((Chart)iContent).SvgHeight = "20cm";
doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "LoadChart.ods"));
}
public void HTMLExportTest3()
{
string file = AARunMeFirstAndOnce.inPutFolder + @"simpleCalc.ods";
FileInfo fInfo = new FileInfo(file);
//Load a spreadsheet document
SpreadsheetDocument document = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
document.Load(file, new OpenDocumentImporter(reader));
//Save it back again
document.Save(AARunMeFirstAndOnce.outPutFolder + fInfo.Name + ".html", new OpenDocumentHtmlExporter());
}
}
public void NewChartWithTitle()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"testsheet.ods"));
Table table = doc.TableCollection[0];
Chart chart = ChartBuilder.CreateChartByTitle(table, "A3:E7", ChartTypes.stock, "北京红旗中文两千公司九月工资报表", "0.5cm", "0.5cm", null, null);
chart.ChartTitle.TitleStyle.TextProperties.FontSize = "3pt";
chart.EndCellAddress = table.TableName + ".P17";
table.InsertChartAt("I2", chart);
doc.Content.Add(table);
doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "NewChartWithTitle.ods"));
}
public void CellHasReferenceToRow()
{
string file = AARunMeFirstAndOnce.inPutFolder + @"bigtable.ods";
SpreadsheetDocument textDocument = new SpreadsheetDocument();
textDocument.Load(file);
Table table = textDocument.Content[1] as Table;
Row row = table.Rows[0];
Cell cell = row.Cells[0];
Assert.AreEqual(row, cell.Row);
Assert.AreEqual(table, row.Table);
}
public void NewChartWithAxises()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"testsheet.ods"), new OpenDocumentImporter(reader));
Table table = doc.TableCollection[0];
Chart chart = ChartBuilder.CreateChartByAxises(table, "A1:B2", ChartTypes.line, 2);
table.InsertChartAt("I2", chart);
doc.Content.Add(table);
using (IPackageWriter writer = new OnDiskPackageWriter())
{
doc.Save(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "NewChartWithAxis.ods"), new OpenDocumentTextExporter(writer));
}
}
}
public void LoadChartModifyTitle()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"TestChartOne.ods"), new OpenDocumentImporter(reader));
IContent iContent = doc.EmbedObjects[0];
((Chart)iContent).ChartTitle.SetTitle("A New Title");
((Chart)iContent).ChartTitle.SvgX = "2cm";
((Chart)iContent).ChartTitle.SvgY = "0.5cm";
using (IPackageWriter writer = new OnDiskPackageWriter())
{
doc.Save(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "TestTitle.ods"), new OpenDocumentTextExporter(writer));
}
}
}
public void TestLengend()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"TestChartOne.ods"), new OpenDocumentImporter(reader));
Chart chart = (Chart)doc.EmbedObjects[0];
chart.ChartLegend.LegendPosition = "left";
chart.ChartLegend.SvgX = "5cm";
chart.ChartLegend.SvgY = "2cm";
using (IPackageWriter writer = new OnDiskPackageWriter())
{
doc.Save(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "TestLegend.ods"), new OpenDocumentTextExporter(writer));
}
}
}
public void CellHasReferenceToRow()
{
string file = AARunMeFirstAndOnce.inPutFolder + @"bigtable.ods";
SpreadsheetDocument textDocument = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
textDocument.Load(file, new OpenDocumentImporter(reader));
}
Table table = textDocument.Content[1] as Table;
Row row = table.Rows[0];
Cell cell = row.Cells[0];
Assert.AreEqual(row, cell.Row);
Assert.AreEqual(table, row.Table);
}
public void NewChartWithCellRange()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"testsheet.ods"), new OpenDocumentImporter(reader));
Table table = doc.TableCollection[0];
Chart chart = ChartBuilder.CreateChartByCellRange(table, "A4:F8", ChartTypes.bar, null, null,
"刘玉花的测试", 3, "bottom", "P14");
table.InsertChartAt("H2", chart);
doc.Content.Add(table);
using (IPackageWriter writer = new OnDiskPackageWriter())
{
doc.Save(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "NewChartWithCellRange.ods"), new OpenDocumentTextExporter(writer));
}
}
}
public void TestPlotArea()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"TestChartOne.ods"), new OpenDocumentImporter(reader));
Chart chart = (Chart)doc.EmbedObjects[0];
chart.ChartPlotArea.SvgX = "1.2cm";
chart.ChartPlotArea.SvgY = "2.5cm";
chart.ChartPlotArea.Width = "5cm";
chart.ChartPlotArea.Height = "5cm";
using (IPackageWriter writer = new OnDiskPackageWriter())
{
doc.Save(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "TestPlotArea.ods"), new OpenDocumentTextExporter(writer));
}
}
}
public void NewChartWithLegend()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"testsheet.ods"), new OpenDocumentImporter(reader));
Table table = doc.TableCollection[0];
Chart chart = ChartBuilder.CreateChartByLegend(table, "A3:F8", ChartTypes.surface, "left", "0.5", "5",
"year", "dollars");
table.InsertChartAt("M2", chart);
doc.Content.Add(table);
using (IPackageWriter writer = new OnDiskPackageWriter())
{
doc.Save(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "NewChartWithLegend.ods"), new OpenDocumentTextExporter(writer));
}
}
}
public void LoadChart()
{
SpreadsheetDocument doc = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"TestChartOne.ods"), new OpenDocumentImporter(reader));
IContent iContent = doc.EmbedObjects[0];
((Chart)iContent).ChartType = ChartTypes.bar.ToString();
((Chart)iContent).XAxisName = "XAxis";
((Chart)iContent).YAxisName = "YAxis";
((Chart)iContent).SvgWidth = "20cm";
((Chart)iContent).SvgHeight = "20cm";
using (IPackageWriter writer = new OnDiskPackageWriter())
{
doc.Save(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "LoadChart.ods"), new OpenDocumentTextExporter(writer));
}
}
}
public void RowAndCellIterate()
{
string file = AARunMeFirstAndOnce.inPutFolder + @"simpleCalc.ods";
_spreadsheetDocument4 = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
_spreadsheetDocument4.Load(file, new OpenDocumentImporter(reader));
}
Assert.IsNotNull(_spreadsheetDocument4.TableCollection, "Table collection must exits.");
Assert.IsTrue(_spreadsheetDocument4.TableCollection.Count == 3, "There must be 3 tables available.");
int i = 0; // current row index
int ii = 0; // current cell index
string innerText = ""; // current inner text
try
{
Assert.IsTrue(_spreadsheetDocument4.TableCollection[0].Rows.Count == 6, "There must be 6 rows available.");
for (i = 0; i < _spreadsheetDocument4.TableCollection[0].Rows.Count; i++)
{
string contents = "Row " + i + ": ";
Assert.IsTrue(_spreadsheetDocument4.TableCollection[0].Rows[i].Cells.Count == 3, "There must be 3 cells available.");
for (ii = 0; ii < _spreadsheetDocument4.TableCollection[0].Rows[i].Cells.Count; ii++)
{
innerText = _spreadsheetDocument4.TableCollection[0].Rows[i].Cells[ii].Node.Value;
if (_spreadsheetDocument4.TableCollection[0].Rows[i].Cells[ii].OfficeValue != null)
{
contents += _spreadsheetDocument4.TableCollection[0].Rows[i].Cells[ii].OfficeValue.ToString() + " ";
}
else
{
contents += innerText + " ";
}
}
Console.WriteLine(contents);
}
}
catch (Exception ex)
{
string where = "occours in Row " + i.ToString() + " and cell " + ii.ToString() + " last cell content " + innerText + "\n\n";
Console.WriteLine(where + ex.Message + "\n\n" + ex.StackTrace);
}
}
public void CreateTableFormatedText()
{
//Create new spreadsheet document
_spreadsheetDocument3 = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
_spreadsheetDocument3.Load(AARunMeFirstAndOnce.inPutFolder + @"blank.ods", new OpenDocumentImporter(reader));
}
//Create a new table
Table table = new Table(_spreadsheetDocument3, "First", "tablefirst");
table.Rows.Add(new Row(table));
//Create a new cell, without any extra styles
Cell cell = table.CreateCell();
cell.OfficeValueType = "string";
//Set full border
//cell.CellStyle.CellProperties.Border = Border.NormalSolid;
//Add a paragraph to this cell
Paragraph paragraph = ParagraphBuilder.CreateSpreadsheetParagraph(
_spreadsheetDocument3);
//Create some Formated text
FormatedText fText = new FormatedText(_spreadsheetDocument3, "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
_spreadsheetDocument3.TableCollection.Add(table);
// Test inserted content
Object insertedText = ((Paragraph)_spreadsheetDocument3.TableCollection[0].Rows[2].Cells[3].Content[0]).TextContent[0];
Assert.AreEqual(fText, insertedText as FormatedText);
}
public void SimpleCalcLoadTest()
{
string file = AARunMeFirstAndOnce.inPutFolder + @"simpleCalc.ods";
FileInfo fInfo = new FileInfo(file);
//Load a spreadsheet document
SpreadsheetDocument document = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
document.Load(file, new OpenDocumentImporter(reader));
Assert.IsTrue(document.CommonStyles.Count > 0, "Common Styles must be read!");
Console.WriteLine("Common styles: {0}", document.CommonStyles.Count);
//Save it back again
using (IPackageWriter writer = new OnDiskPackageWriter())
{
document.Save(AARunMeFirstAndOnce.outPutFolder + fInfo.Name + ".rel.ods",
new OpenDocumentTextExporter(writer));
}
}
}
public void CreateSimpleTable()
{
//Create new spreadsheet document
_spreadsheetDocument2 = new SpreadsheetDocument();
using (IPackageReader reader = new OnDiskPackageReader())
{
_spreadsheetDocument2.Load(AARunMeFirstAndOnce.inPutFolder + @"blank.ods", new OpenDocumentImporter(reader));
}
//Create a new table
Table table = new Table(_spreadsheetDocument2, "First", "tablefirst");
table.Rows.Add(new Row(table));
//Create a new cell, without any extra styles
Cell cell = new Cell(_spreadsheetDocument2, "cell001");
cell.OfficeValueType = "string";
//Set full border
cell.CellStyle.CellProperties.Border = Border.NormalSolid;
//Add a paragraph to this cell
Paragraph paragraph = ParagraphBuilder.CreateSpreadsheetParagraph(
_spreadsheetDocument2);
//Add some text content
String cellText = "Some text";
paragraph.TextContent.Add(new SimpleText(_spreadsheetDocument2, cellText));
//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(1, 1, cell);
//Insert table into the spreadsheet document
_spreadsheetDocument2.TableCollection.Add(table);
// Test inserted content
Assert.AreEqual(_spreadsheetDocument2.TableCollection[0], table);
String text = _spreadsheetDocument2.TableCollection[0].Rows[1].Cells[1].Node.Value;
Assert.AreEqual(text, cellText);
}
