public void CloneTable()
{
// with 100 columns and 5000 rows should execute in less than 29 sec
// with 100 columns and 1000 rows should execute in less than 6.5 sec
TextDocument docuemnt = new TextDocument();
docuemnt.New();
Table table = new Table(docuemnt, "table name", "table style");
int numberOfColumns = 100;
int numberOfRows = 1000;
// prepare data
// add columns
for (int i = 0; i < numberOfColumns; i++)
{
table.ColumnCollection.Add(new Column(table, "style name " + i));
}
Row row = null;
// Add rows
for (int i = 0; i < 2; i++)
{
row = new Row(table);
for (int i1 = 0; i1 < numberOfColumns; i1++)
{
Paragraph par = ParagraphBuilder.CreateStandardTextParagraph(docuemnt);
par.TextContent.AddRange(TextBuilder.BuildTextCollection(docuemnt, (i * numberOfColumns).ToString() + i1));
row.Cells.Add(new Cell(table.Document, "cell style " + i));
//row.Cells.Add(new Cell(table.Document));
row.Cells[i1].Content.Add(par);
}
table.Rows.Insert(0, row);
}
// clone many rows
row = table.Rows[0];
using (IPerformanceCounter counter = new PerformanceCounter())
{
for (int i = 0; i < numberOfRows; i++)
{
Row newRow = new Row(table, row.StyleName);
foreach (Cell rowCell in row.Cells)
{
Cell cell = new ContentMocker().CloneAny(rowCell) as Cell;
newRow.Cells.Add(cell);
}
}
Console.WriteLine(string.Format(
"Test executed in {0} seconds", counter.GetSeconds()));
}
}
public void HeadingFilledWithTextBuilder()
{
string headingText = "Some Heading with\n styles\t and more";
//Create a new text document
TextDocument document = new TextDocument();
document.New();
//Create a new Heading
Header header = new Header(document, Headings.Heading);
//Create a TextCollection from headingText using the TextBuilder
ITextCollection textCol = TextBuilder.BuildTextCollection(document, headingText);
//Add text collection
header.TextContent = textCol;
//Add header
document.Content.Add(header);
document.SaveTo(AARunMeFirstAndOnce.outPutFolder + "HeadingWithControlCharacter.odt");
}
void Supl(int id) //бланк в разрезе по поставщикам, поэтому функция для фильтрации объектов того или иного поставщика
{
SpreadsheetDocument spreadsheetDocument = new SpreadsheetDocument();
spreadsheetDocument.New();
Table table = new Table(spreadsheetDocument, "First", "tablefirst");
for (int j = 0; j < countsup; j++)
{
Paragraph parag = ParagraphBuilder.CreateSpreadsheetParagraph(spreadsheetDocument);
var text = TextBuilder.BuildTextCollection(spreadsheetDocument, " ");
Cell cell = table.CreateCell();
parag.TextContent.Add(new SimpleText(spreadsheetDocument, "элемент бд, где поставщик ид=ид"));//И за это тоже выебу и в прямом, и в переносном смысле за такие фразы
cell.Content.Add(parag);
table.InsertCellAt(0, 0, cell);
spreadsheetDocument.TableCollection.Add(table);
spreadsheetDocument.SaveTo("Matr.ods");
}
}
