private static void ModifyWordCellTextContent(OXW.TableCell cell, string txt)
{
if (null != cell)
{
OXW.Paragraph paragraph = cell.Descendants <OXW.Paragraph>().FirstOrDefault();
if (null != paragraph)
{
paragraph = paragraph.CloneNode(true) as OXW.Paragraph;
ModifyWordParagraphTextContent(paragraph, txt);
cell.RemoveAllChildren <OXW.Paragraph>();
cell.Append(paragraph);
}
}
}
public void FillTable(OpenXmlElement element, QResult query)
{
var row = FindParent <Word.TableRow>(element);
var prg = row.Descendants <Word.Paragraph>().FirstOrDefault();
//element.Remove();
Word.TableRow prow = null;
foreach (object[] data in query.Values)
{
Word.TableCell cell = row.GetFirstChild <Word.TableCell>();
foreach (object value in data)
{
if (cell != null)
{
var paragraph = cell.Descendants <Word.Paragraph>().FirstOrDefault();
if (paragraph == null)
{
paragraph = (Word.Paragraph)prg.Clone();
cell.Append(paragraph);
}
Word.Run run = paragraph.Descendants <Word.Run>().FirstOrDefault();
if (run != null)
{
ReplaceString(run, value.ToString());
}
else
{
Word.Text text = new Word.Text()
{
Text = value.ToString(), Space = SpaceProcessingModeValues.Preserve
};
run = new Word.Run();
run.Append(text);
paragraph.Append(run);
}
cell = cell.NextSibling <Word.TableCell>();
}
}
if (row.Parent == null)
{
prow.InsertAfterSelf <Word.TableRow>(row);
}
prow = row;
row = (Word.TableRow)row.Clone();
}
}
/// <summary>
/// Adds a new table before the last paragraph in the cell
/// </summary>
/// <returns></returns>
protected override DocumentFormat.OpenXml.Wordprocessing.Table NewTable()
{
var paragraph = tableCell.Descendants <DocumentFormat.OpenXml.Wordprocessing.Paragraph>().Last();
return(paragraph.InsertBeforeSelf(new DocumentFormat.OpenXml.Wordprocessing.Table()));
}
public static MemoryStream BuildReport(IConfigurationRoot config)
{
//Read the template from disk
byte[] byteArray = File.ReadAllBytes(config["ReportConfiguration:TemplateFile"]);
//Load it into memory
MemoryStream mem = new MemoryStream();
mem.Write(byteArray, 0, byteArray.Length);
//Open the word document from memory
using (WordprocessingDocument output = WordprocessingDocument.Open(mem, true))
{
var doc = output.MainDocumentPart.Document;
var contentControls = output.ContentControls().ToList();
foreach (var cc in contentControls)
{
wp.SdtProperties props = cc.Elements <wp.SdtProperties>().FirstOrDefault();
string controlTitle = props.Elements <wp.SdtAlias>().FirstOrDefault().Val;
string controlTag = props.Elements <wp.Tag>().FirstOrDefault().Val;
string configKeyResult = String.Format("{0}:Result", controlTitle);
string queryResult = config[configKeyResult];
Type sdtType = ((wp.SdtElement)cc).GetType();
OpenXmlElement targetContent = null;
//Determine if the content control is actually a docpart (Table of Contents, etc.), so we can ignore it.
bool isDocPart = false;
//If the content control document tag is a block tag and has docpart object children, it's a docpart.
if (sdtType == typeof(wp.SdtBlock) && (((wp.SdtBlock)cc).Descendants <wp.SdtContentDocPartObject>().Count() > 0))
{
isDocPart = true;
}
if (!isDocPart)
{
//Replace our ReportParameter placeholders.
if (controlTag.Equals("ReportParameter"))
{
if (config[controlTitle] != null)
{
targetContent = new wp.Text(config[controlTitle]);
}
else
{
targetContent = new wp.Text("No Result");
}
}
//Replace our SingleValue placeholders with tables containing the query results.
if (controlTag.Equals("SingleValue"))
{
if (queryResult != null)
{
dynamic svData = JsonConvert.DeserializeObject <dynamic>(queryResult);
if (svData.rows.Count == 1)
{
targetContent = new wp.Text(svData.rows[0][0].ToString());
}
else
{
throw new IndexOutOfRangeException(String.Format("The QueryResult for {0} contained {1} row/s but a single row was expected.", controlTitle, svData.rows.Count));
}
}
else
{
targetContent = new wp.Text("No Result");
}
}
//Special handling is needed if a SingleValue or ReportParameter content control is actually configured as a SdtBlock instead of SdtRun.
if (controlTag.Equals("ReportParameter") || controlTag.Equals("SingleValue"))
{
if (sdtType == typeof(wp.SdtBlock))
{
var targetContentParent = cc.GetFirstChild <wp.SdtContentBlock>().GetFirstChild <wp.Paragraph>().CloneNode(true);
targetContentParent.GetFirstChild <wp.Run>().InsertAfterSelf(new wp.Run(targetContent));
targetContentParent.GetFirstChild <wp.Run>().Remove();
targetContent = targetContentParent;
}
}
//Replace our Table placeholders with tables containing the query results.
if (controlTag.Equals("Table"))
{
targetContent = BuildTable(queryResult, config["ReportConfiguration:TableStyle"]);
}
//Update the charts in our Chart placeholders with the data from the query results.
if (controlTag.Equals("Chart"))
{
UpdateChart(
cc.Descendants <drc.ChartReference>().FirstOrDefault(),
output,
controlTitle.Split(':').Last(),
queryResult);
targetContent = cc.GetFirstChild <wp.SdtContentBlock>().GetFirstChild <wp.Paragraph>().CloneNode(true);
}
//Remove PlaceholderText styles from all Run elements
foreach (var item in cc.Descendants <wp.Run>())
{
var rPr = item.GetFirstChild <wp.RunProperties>();
if (rPr != null && rPr.RunStyle != null)
{
if (rPr.RunStyle.Val == "PlaceholderText")
{
rPr.RunStyle.Remove();
}
}
}
if (targetContent != null)
{
//The content control is inline
if (sdtType == typeof(wp.SdtRun))
{
cc.InsertAfterSelf(new wp.Run(targetContent));
cc.Remove();
}
//The content control is a table cell
else if (sdtType == typeof(wp.SdtCell))
{
wp.TableCell tc = (wp.TableCell)((cc.Descendants <wp.TableCell>().FirstOrDefault()).CloneNode(true));
if (targetContent.GetType() == typeof(wp.Text))
{
wp.Run targetRun = tc.Descendants <wp.Run>().FirstOrDefault();
targetRun.RemoveAllChildren();
targetRun.Append(targetContent);
}
else
{
tc.Append(targetContent);
}
cc.InsertAfterSelf(tc);
cc.Remove();
}
//The content control is multi-line
else if (sdtType == typeof(wp.SdtBlock))
{
cc.InsertAfterSelf(targetContent);
cc.Remove();
}
}
}
}
foreach (var footer in output.MainDocumentPart.FooterParts)
{
footer.Footer.Save();
}
doc.Save();
output.Close();
return(mem);
}
}
