/// <summary>
/// Initialize Word Report --> Support Method
/// </summary>
public static void InsertSummaryResults()
{
try
{
Table table = resultSummarydocument.AddTable(1, 4);
// Specify some properties for this Table.
table.Alignment = Alignment.left;
table.AutoFit = AutoFit.Contents;
table.Design = TableDesign.TableGrid;
table.SetColumnWidth(0, 667.87);
table.SetColumnWidth(1, 5347.87);
table.SetColumnWidth(2, 1255.87);
table.SetColumnWidth(3, 1825.82);
table.Rows[0].Cells[0].Paragraphs.First().Append(smrw.ToString() + ".");
smrw += 1;
table.Rows[0].Cells[1].Paragraphs.First().Append(BaseUtilities.scenarioName);
switch (BaseUtilities.scenarioStatus.ToLower())
{
case "pass":
table.Rows[0].Cells[2].Paragraphs.First().Append("Pass").Color(System.Drawing.Color.FromArgb(52, 168, 83));
break;
case "fail":
table.Rows[0].Cells[2].Paragraphs.First().Append("Fail").Color(System.Drawing.Color.FromArgb(234, 67, 53));
break;
case "skip":
table.Rows[0].Cells[2].Paragraphs.First().Append("Skip").Color(System.Drawing.Color.FromArgb(234, 67, 53));
break;
}
Hyperlink link = resultSummarydocument.AddHyperlink("Click here", new Uri(reportpath));
table.Rows[0].Cells[3].Paragraphs.First().AppendHyperlink(link).Color(System.Drawing.Color.FromArgb(1, 91, 168));
resultSummarydocument.InsertTable(table);
resultSummarydocument.Save();
}
catch (Exception e)
{
Reports.SetupErrorLog(e);
}
}
public void CopyFromFileTextOnly_Test_CopiesNoStyle()
{
_tmpFile = GetNewRandomFilePath(GetOrCreateTmpDirectory());
using (DocX doc = DocX.Create(_tmpFile)) {
doc.InsertParagraph()
.Append("text")
.Bold()
.Italic()
.Color(Color.Green)
.FontSize(20);
doc.Save();
}
Range targetRange = _application.Documents.Add().Range();
targetRange.Text = "unexpected";
new OpenXmlHelper().CopyFromFileTextOnly(_tmpFile, targetRange);
Range result = targetRange.Document.Range(1, 2);
Assert.Zero(result.Bold);
Assert.Zero(result.Italic);
Assert.That(result.Font.Size, Is.Not.EqualTo(20).Within(0.001));
Assert.That(result.Font.Color, Is.Not.EqualTo(WdColor.wdColorGreen));
}
private DocX outputDoc(string nowBalance, string nowSum, string nowBalanceAfterBuy, string nowBonus)
{
string pathDocument = "C:\\Users\\oobit\\Desktop\\first.docx";
DocX document = DocX.Create(pathDocument);
document.MarginLeft = 60.0f;
document.MarginRight = 60.0f;
document.MarginTop = 60.0f;
document.MarginBottom = 60.0f;
document.InsertParagraph("Чек покупки").Bold().Font("Times New Roman").FontSize(14);
Table table = document.AddTable(4, 2);
table.Alignment = Alignment.center;
table.Design = TableDesign.TableGrid;
table.SetWidths(new float[] { 180.0f, 600.0f });
table.Rows[0].Cells[0].Paragraphs[0].Append("Баланс до покупки").Font("Times New Roman").FontSize(12).Bold();
table.Rows[0].Cells[1].Paragraphs[0].Append(nowBalance).Font("Times New Roman").FontSize(12);
table.Rows[1].Cells[0].Paragraphs[0].Append("Сумма").Font("Times New Roman").FontSize(12).Bold();
table.Rows[1].Cells[1].Paragraphs[0].Append(nowSum).Font("Times New Roman").FontSize(12);
table.Rows[2].Cells[0].Paragraphs[0].Append("Баланс после покупки").Font("Times New Roman").FontSize(12).Bold();
table.Rows[2].Cells[1].Paragraphs[0].Append(nowBalanceAfterBuy).Font("Times New Roman").FontSize(12);
table.Rows[3].Cells[0].Paragraphs[0].Append("Текущее количество бонусов").Font("Times New Roman").FontSize(12).Bold();
table.Rows[3].Cells[1].Paragraphs[0].Append(nowBonus).Font("Times New Roman").FontSize(12);
document.InsertParagraph().InsertTableAfterSelf(table);
document.Save();
return(document);
}
/// <summary>
/// Modify the direction of text in a paragraph or document.
/// </summary>
public static void SetDirection()
{
Console.WriteLine("\tSetDirection()");
// Create a document.
using (DocX document = DocX.Create(MarginSample.MarginSampleOutputDirectory + @"SetDirection.docx"))
{
// Add a title.
document.InsertParagraph("Modify direction of paragraphs").FontSize(15d).SpacingAfter(50d).Alignment = Alignment.center;
// Add first paragraph.
var p = document.InsertParagraph("This is the first paragraph.");
p.SpacingAfter(30);
// Add second paragraph.
var p2 = document.InsertParagraph("This is the second paragraph.");
p2.SpacingAfter(30);
// Make this Paragraph flow right to left. Default is left to right.
p2.Direction = Direction.RightToLeft;
// Add third paragraph.
var p3 = document.InsertParagraph("This is the third paragraph.");
p3.SpacingAfter(30);
// Add fourth paragraph.
var p4 = document.InsertParagraph("This is the fourth paragraph.");
p4.SpacingAfter(30);
// To modify the direction of each paragraph in a document, just set the direction on the document.
document.SetDirection(Direction.RightToLeft);
document.Save();
Console.WriteLine("\tCreated: SetDirection.docx\n");
}
}
/// <summary>
/// Create a read only document that can be edited by stopping the protection.
/// </summary>
public static void AddProtection()
{
Console.WriteLine("\tAddProtection()");
// Create a new document.
using (DocX document = DocX.Create(ProtectionSample.ProtectionSampleOutputDirectory + @"AddProtection.docx"))
{
// Add a title.
document.InsertParagraph("Document protection not using password").FontSize(15d).SpacingAfter(50d).Alignment = Alignment.center;
// Insert a Paragraph into this document.
var p = document.InsertParagraph();
// Append some text and add formatting.
p.Append("This document is protected and can only be edited by stopping its protection.")
.Font(new Font("Arial"))
.FontSize(25)
.Color(Color.Red)
.Bold();
document.AddProtection(EditRestrictions.readOnly);
// Save this document to disk.
document.Save();
Console.WriteLine("\tCreated: AddProtection.docx\n");
}
}
/// <summary>
/// Add a Table of content to a document by inserting it just before a reference paragraph.
/// </summary>
public static void InsertTableOfContentWithReference()
{
Console.WriteLine("\tInsertTableOfContentWithReference()");
// Create a document.
using (DocX document = DocX.Create(TableOfContentSample.TableOfContentSampleOutputDirectory + @"InsertTableOfContentWithReference.docx"))
{
// Add a title.
document.InsertParagraph("Insert Table of content with reference").FontSize(15d).SpacingAfter(50d).Alignment = Alignment.center;
// Add an intro paragraph.
var intro = document.InsertParagraph("This page will show the team rosters of the American League East Division.");
intro.SpacingAfter(150d);
// Create a paragraph and fill it in method AddTeams().
var p = document.InsertParagraph();
var rosters = TableOfContentSample.AddTeams(p);
document.InsertParagraph(rosters);
// Insert a table of content with a page break just before the paragraph p.
document.InsertTableOfContents(p,
"Teams",
TableOfContentsSwitches.O | TableOfContentsSwitches.U | TableOfContentsSwitches.Z | TableOfContentsSwitches.H,
"Heading4");
document.Save();
Console.WriteLine("\tCreated: InsertTableOfContentWithReference.docx\n");
}
}
public void crearwordRegistroproyecto()
{
string destinipath = "Formatos\\" + solicitante.NoControl;
if (!Directory.Exists(destinipath))
{
Directory.CreateDirectory(destinipath);
}
DocX testTemplate = DocX.Load(@"Templatesformatos\Registrodeproyecto.docx");
//Paragraph p = testTemplate.InsertParagraph("Hello World.");
DocX testDoc = testTemplate;
//Paragraph pa = testDoc.InsertParagraph("Foo.");
try
{
testDoc.ReplaceText("{fecha}", DateTime.Now.Date.ToString());
testDoc.ReplaceText("{correoelectronico}", solicitante.Correo);
testDoc.ReplaceText("{numtelefono}", solicitante.Telefono);
testDoc.ReplaceText("{nombreproyecto}", solicitante.Proyecto_Residencia.Nombre_Proyecto);
testDoc.ReplaceText("{nombreestudiante}", solicitante.Nombre + " " + solicitante.Apellido_Paterno + " " + solicitante.Apellido_Materno);
testDoc.ReplaceText("{numestudiantes}", "1");
testDoc.ReplaceText("{asesorinterno}", solicitante.Proyecto_Residencia.Asesor_Interno.Nombre);
testDoc.ReplaceText("{nombreempresa}", solicitante.Proyecto_Residencia.Nombre_de_la_Empresa);
testDoc.ReplaceText("{nocontrol}", solicitante.NoControl.ToString());
}
catch { }
testDoc.SaveAs(destinipath + @"\Registrodeproyecto" + solicitante.NoControl + ".docx");
testTemplate.Save();
}
public void crearwordconstanciarevisores()
{
string destinipath = "Formatos\\" + solicitante.NoControl;
if (!Directory.Exists(destinipath))
{
Directory.CreateDirectory(destinipath);
}
DocX testTemplate = DocX.Load(@"Templatesformatos\constanciarevisores.docx");
//Paragraph p = testTemplate.InsertParagraph("Hello World.");
DocX testDoc = testTemplate;
//Paragraph pa = testDoc.InsertParagraph("Foo.");
try
{
testDoc.ReplaceText("{nombrealumno}", solicitante.Nombre + " " + solicitante.Apellido_Paterno + " " + solicitante.Apellido_Materno);
testDoc.ReplaceText("{nocontrol}", solicitante.NoControl.ToString());
testDoc.ReplaceText("{nombreproyecto}", solicitante.Proyecto_Residencia.Nombre_Proyecto);
testDoc.ReplaceText("{nombreempresa}", solicitante.Proyecto_Residencia.Nombre_de_la_Empresa);
testDoc.ReplaceText("{nombreasesorinterno}", solicitante.Proyecto_Residencia.Asesor_Interno.Nombre);
testDoc.ReplaceText("{nombreasesorexterno}", solicitante.Proyecto_Residencia.Nombre_Asesor_Externo);
}
catch { }
testDoc.SaveAs(destinipath + @"\constanciarevisores" + solicitante.NoControl + ".docx");
testTemplate.Save();
}
private static void LineChart()
{
// Create new document.
using (DocX document = DocX.Create(@"docs\LineChart.docx"))
{
// Create chart.
LineChart c = new LineChart();
c.AddLegend(ChartLegendPosition.Bottom, false);
// Create data.
List <ChartData> company1 = ChartData.CreateCompanyList1();
List <ChartData> company2 = ChartData.CreateCompanyList2();
// Create and add series
Series s1 = new Series("Microsoft");
s1.Color = Color.GreenYellow;
s1.Bind(company1, "Mounth", "Money");
c.AddSeries(s1);
Series s2 = new Series("Apple");
s2.Bind(company2, "Mounth", "Money");
c.AddSeries(s2);
// Insert chart into document
document.InsertParagraph("Diagram").FontSize(20);
document.InsertChart(c);
document.Save();
}
}
private void MyFunc()
{
var list = new OpstiUsloviDa().Prep();
foreach (var item in list)
{
if (item.Length > 3)
{
var downloadDirectory = HttpRuntime.AppDomainAppPath + "Uslovi\\";
if (!Directory.Exists(downloadDirectory))
{
Directory.CreateDirectory(downloadDirectory);
}
var outFileName = string.Format("pu_{0}.docx", item);
string docTemplatePath = HttpRuntime.AppDomainAppPath + "Templates\\blank_0.docx";
string docOutputPath = downloadDirectory + outFileName;
////create copy of template so that we don't overwrite it
File.Copy(docTemplatePath, docOutputPath);
// Load a .docx file
using (DocX document = DocX.Load(docOutputPath))
{
var imetabela = item.Split('_')[0];
var stranici = item.Split('_')[1];
foreach (var grupa in stranici.Split(';'))
{
int start = 0;
int stop = 0;
if (grupa.Contains('-'))
{
start = int.Parse(grupa.Split('-')[0]);
stop = int.Parse(grupa.Split('-')[1]);
}
else
{
start = stop = int.Parse(grupa);
}
for (int i = start; i <= stop; i++)
{
try
{
Image image =
document.AddImage(downloadDirectory + "izvod\\" + imetabela + "\\" + "uslovi_" +
i +
".jpg");
var picture = image.CreatePicture(1100, 778);
var paragraph = document.InsertParagraph("", false);
paragraph.InsertPicture(picture);
paragraph.Alignment = Alignment.center;
}
catch (Exception ex)
{
Logger.Error(ex);
}
}
}
document.Save();
}
}
}
}
private void UpdateDoc(DocX doc, FileContent fileCnt)
{
//1、页眉
//logo
if (fileCnt.logo.IsNotEmpty() && File.Exists(fileCnt.logo))
{
Novacode.Image img = doc.AddImage(fileCnt.logo);
AddLogoToHeader(doc.Headers.odd, img);
AddLogoToHeader(doc.Headers.first, img, 100, 100);
}
doc.ReplaceText("A2", fileCnt.filename);
doc.ReplaceText("A3", fileCnt.filecode);
doc.ReplaceText("A4", fileCnt.versioncode);
doc.ReplaceText("A5", fileCnt.efdate);
//2、表格
doc.ReplaceText("A6", fileCnt.draftdept);
doc.ReplaceText("A7", fileCnt.checkdept1);
doc.ReplaceText("A8", fileCnt.checkdept2);
doc.ReplaceText("A9", fileCnt.checkdept3);
doc.ReplaceText("A10", fileCnt.approver);
doc.ReplaceText("A11", "1");
doc.ReplaceText("A12", fileCnt.remark);
doc.ReplaceText("A13", fileCnt.writer);
doc.Save();
}
//added by LIUJIE 2017-09-18
/// <summary>
/// 插入图片及图片注释（对图片尺寸没有要求）
/// </summary>
/// <param name="oldPath">添加的doc路径</param>
/// <param name="oPath">添加图片的数组</param>
/// <param name="replaceFlag">替换符</param>
/// <param name="oRemark">图片备注数组</param>
public void AddWordPic(string oldPath, object[] oPath, string replaceFlag, object[] oRemark)
{
DocX oldDocument = DocX.Load(oldPath);
Paragraph ss = null;
Novacode.Image img = null;
ss = GetParagraphByReplaceFlag(oldDocument, replaceFlag, "CENTER");
ss.ReplaceText(replaceFlag, "");
if (!(oPath == null || oRemark == null))
{
try
{
string[] imagePath = classLims_NPOI.dArray2String1(oPath);
string[] remark = classLims_NPOI.dArray2String1(oRemark);
for (int i = 0; i < imagePath.Length; i++)
{
img = oldDocument.AddImage(imagePath[i]);
Picture pic = img.CreatePicture();
ss.AppendPicture(pic);
pic.Height = Convert.ToInt32(Convert.ToDouble(pic.Height) / Convert.ToDouble(pic.Width) * Convert.ToDouble(oldDocument.PageWidth));
pic.Width = Convert.ToInt32(Convert.ToDouble(oldDocument.PageWidth));
ss.AppendLine(remark[i] + "\n");
//ss.AppendLine("\n");
ss.Alignment = Alignment.center;
}
}
catch (System.InvalidOperationException e)
{
classLims_NPOI.WriteLog(e, "");
return;
}
}
oldDocument.Save();
return;
}
public ActionResult Generate(JIUViewModel model)
{
//get temp name from reg expression plus lang plus symb
string fname = model.tempname.ToString();
g_assembly = Assembly.GetExecutingAssembly();
// string source = Server.MapPath(Path.Combine("/", "IN/" + fname + ".docx"));
// string Dest = Server.MapPath(Path.Combine("/", "OUT/" + fname + ".docx"));
string source = Server.MapPath(Path.Combine("/", "GDGS/IN/" + fname + ".docx"));
string Dest = Server.MapPath(Path.Combine("/", "GDGS/OUT/" + fname + ".docx"));
string tempname = fname.Remove(fname.Length - 1);
model.tempname = tempname;
g_document = DocX.Load(source);
g_document = CreateDocA(DocX.Load(source), model, source);
g_document.SaveAs(Dest);
g_document.AddCoreProperty("dc:title", model.Sym.ToString());
// g_document.AddCoreProperty("dc:author", model.Sym.ToString());
g_document.Save();
// Changegdoc(source);
return(RedirectToAction("download", "JIU", new { name = fname }));
}
/// <summary>
/// Set different Heading type for a Paragraph.
/// </summary>
public static void Heading()
{
Console.WriteLine("\tHeading()");
// Create a document.
using (DocX document = DocX.Create(ParagraphSample.ParagraphSampleOutputDirectory + @"Heading.docx"))
{
// Add a title.
document.InsertParagraph("Heading types").FontSize(15d).SpacingAfter(50d).Alignment = Alignment.center;
var headingTypes = Enum.GetValues(typeof(HeadingType));
foreach (HeadingType heading in headingTypes)
{
// Set a text containing the current Heading type.
var text = string.Format("This Paragraph is using \"{0}\" heading type.", heading.EnumDescription());
// Add a paragraph.
var p = document.InsertParagraph().AppendLine(text);
// Set the paragraph's heading type.
p.Heading(heading);
}
document.Save();
Console.WriteLine("\tCreated: Heading.docx\n");
}
}
/// <summary>
/// Create a document and add a paragraph with all its lines on the same page as the next paragraph.
/// </summary>
public static void ForceMultiParagraphsOnSinglePage()
{
Console.WriteLine("\tForceMultiParagraphsOnSinglePage()");
// Create a new document.
using (DocX document = DocX.Create(ParagraphSample.ParagraphSampleOutputDirectory + @"ForceMultiParagraphsOnSinglePage.docx"))
{
// Add a title.
document.InsertParagraph("Keeps Paragraphs on same page").FontSize(15d).SpacingAfter(50d).Alignment = Alignment.center;
// Create a Paragraph that will appear on 1st page.
var p = document.InsertParagraph("This is a paragraph on first page.\nLine2\nLine3\nLine4\nLine5\nLine6\nLine7\nLine8\nLine9\nLine10\nLine11\nLine12\nLine13\nLine14\nLine15\nLine16\nLine17\nLine18\nLine19\nLine20\nLine21\nLine22\n");
p.FontSize(15).SpacingAfter(30);
// Create a Paragraph where all its lines will appear on a same page as the next paragraph.
var p2 = document.InsertParagraph("This is a paragraph where all its lines are on the same page as the next paragraph.\nLine2\nLine3\nLine4\nLine5\nLine6\nLine7\nLine8\nLine9\nLine10");
p2.SpacingAfter(30);
// Indicate that this paragraph will be on the same page as the next paragraph.
p2.KeepWithNextParagraph();
// Create a Paragraph that will appear on 2nd page.
var p3 = document.InsertParagraph("This is a paragraph on second page.\nLine2\nLine3\nLine4\nLine5\nLine6\nLine7\nLine8\nLine9\nLine10");
// Indicate that all this paragraph's lines will be on the same page.
p3.KeepLinesTogether();
// Save this document to disk.
document.Save();
Console.WriteLine("\tCreated: ForceMultiParagraphsOnSinglePage.docx\n");
}
}
static void Main(string[] args)
{
var imageFolderPath = @"c:\temp\image\z1";
var imageFiles = new List <string>();
string[] filePaths = Directory.GetFiles(imageFolderPath, "*.*", SearchOption.AllDirectories);
foreach (var fp in filePaths)
{
if (Regex.IsMatch(fp.ToLower(), @".jpg|.png|.gif$"))
{
imageFiles.Add(fp);
}
}
using (DocX document = DocX.Create(@"c:\temp\image\test.docx"))
{
document.SetTitle("tytuł");
document.SetPageMargins();
int imageIndex = 1;
int imageCount = imageFiles.Count;
foreach (var fp in imageFiles.OrderBy(fp => fp))
{
//document.AddPicture(fp, title: $"{fp}\r\n");
document.AddPicture(fp);
Console.WriteLine($"Added image {imageIndex++} / {imageCount} ({fp}).");
}
document.Save();
}
}
public void crearwordasignarrevisor()
{
string destinipath = "Formatos\\" + solicitante.NoControl;
if (!Directory.Exists(destinipath))
{
Directory.CreateDirectory(destinipath);
}
DocX testTemplate = DocX.Load(@"Templatesformatos\asignarevisor.docx");
//Paragraph p = testTemplate.InsertParagraph("Hello World.");
DocX testDoc = testTemplate;
//Paragraph pa = testDoc.InsertParagraph("Foo.");
testDoc.ReplaceText("{nombreproyecto}", solicitante.Proyecto_Residencia.Nombre_Proyecto);
testDoc.ReplaceText("{Nombrealumno}", solicitante.Nombre + " " + solicitante.Apellido_Paterno + " " + solicitante.Apellido_Materno);
testDoc.SaveAs(destinipath + @"\asignarevisor" + solicitante.NoControl + ".docx");
testTemplate.Save();
}
/// <summary>
/// For each of the documents in the folder 'docs\',
/// Replace the string a with the string b,
/// Do this in Parrallel accross many CPU cores.
/// </summary>
static void ReplaceTextParallel()
{
Console.WriteLine("\tReplaceTextParallel()\n");
const string a = "apple";
const string b = "pear";
// Directory containing many .docx documents.
DirectoryInfo di = new DirectoryInfo(@"docs\");
// Loop through each document in this specified direction.
Parallel.ForEach
(
di.GetFiles(),
currentFile =>
{
// Load the document.
using (DocX document = DocX.Load(currentFile.FullName))
{
// Replace text in this document.
document.ReplaceText(a, b);
// Save changes made to this document.
document.Save();
} // Release this document from memory.
}
);
Console.WriteLine("\tCreated: None\n");
}
public void crearwordasignacionasesorinterno()
{
string destinipath = "Formatos\\" + solicitante.NoControl;
if (!Directory.Exists(destinipath))
{
Directory.CreateDirectory(destinipath);
}
DocX testTemplate = DocX.Load(@"Templatesformatos\Asignacionasesorinterno.docx");
//Paragraph p = testTemplate.InsertParagraph("Hello World.");
DocX testDoc = testTemplate;
//Paragraph pa = testDoc.InsertParagraph("Foo.");
try
{
testDoc.ReplaceText("{nombrealumno}", solicitante.Nombre + " " + solicitante.Apellido_Paterno + " " + solicitante.Apellido_Materno);
testDoc.ReplaceText("{correoalumno}", solicitante.Correo);
testDoc.ReplaceText("{telefonoalumno}", solicitante.Telefono);
testDoc.ReplaceText("{nombreproyecto}", solicitante.Proyecto_Residencia.Nombre_Proyecto);
testDoc.ReplaceText("{nombreempresa}", solicitante.Proyecto_Residencia.Nombre_de_la_Empresa);
testDoc.ReplaceText("{telefonoasesor}", solicitante.Proyecto_Residencia.Telefono_Asesor_Externo);
testDoc.ReplaceText("{nombreasesor}", solicitante.Proyecto_Residencia.Nombre_Asesor_Externo);
testDoc.ReplaceText("{cargoasesor}", solicitante.Proyecto_Residencia.Cargo_Asesor_Externo);
}
catch { }
testDoc.SaveAs(destinipath + @"\Asignacionasesorinterno" + solicitante.NoControl + ".docx");
testTemplate.Save();
}
public async Task <Result> Handle(Command request, CancellationToken cancellationToken)
{
var extactor = ExtractorFactory.GetExtraactor(request.Url);
var chordsheet = await extactor.GetChordSheetText(request.Url);
if (!string.IsNullOrEmpty(request.NewKey))
{
var transposer = new Transposer();
chordsheet = await transposer.ChangeKey(chordsheet, request.NewKey, request.OriginalKey);
}
using (DocX document = DocX.Create(request.DestinationFilename))
{
document.MarginTop = 36f;
document.MarginBottom = 36f;
document.MarginLeft = 36f;
document.MarginRight = 36f;
// Add a new Paragraph to the document.
var p = document.InsertParagraph();
// Append some text.
p.Append(chordsheet).Font("Courier New");
// Save the document.
document.Save();
}
return(new Result {
OutputFilename = request.DestinationFilename
});
}
public void crearwordsolicitudresidencia()
{
string destinipath = "Formatos\\" + solicitante.NoControl;
if (!Directory.Exists(destinipath))
{
Directory.CreateDirectory(destinipath);
}
DocX testTemplate = DocX.Load(@"Templatesformatos\solicitudresidencia.docx");
//Paragraph p = testTemplate.InsertParagraph("Hello World.");
DocX testDoc = testTemplate;
//Paragraph pa = testDoc.InsertParagraph("Foo.");
testDoc.ReplaceText("{Fecha}", DateTime.Now.Date.ToString());
testDoc.ReplaceText("{Nombreproyecto}", solicitante.Proyecto_Residencia.Nombre_Proyecto);
testDoc.ReplaceText("{nombreempresa}", solicitante.Proyecto_Residencia.Nombre_de_la_Empresa);
testDoc.ReplaceText("{Asesorexterno}", solicitante.Proyecto_Residencia.Nombre_Asesor_Externo);
testDoc.ReplaceText("{cargoasesor}", solicitante.Proyecto_Residencia.Cargo_Asesor_Externo);
testDoc.ReplaceText("{asesorexterno}", solicitante.Proyecto_Residencia.Nombre_Asesor_Externo);
testDoc.ReplaceText("{cargoasesorexterno}", solicitante.Proyecto_Residencia.Cargo_Asesor_Externo);
testDoc.ReplaceText("{nombrealumno}", solicitante.Nombre + " " + solicitante.Apellido_Paterno + " " + solicitante.Apellido_Materno);
testDoc.ReplaceText("{Nocontrol}", solicitante.NoControl.ToString());
testDoc.ReplaceText("{Correoalumno}", solicitante.Correo);
testDoc.ReplaceText("{telefonoalumno}", solicitante.Telefono);
testDoc.SaveAs(destinipath + @"\Solicitudresidencia" + solicitante.NoControl + ".docx");
testTemplate.Save();
}
/// <summary>
/// Add a Pie chart to a document.
/// </summary>
public static void PieChart()
{
Console.WriteLine("\tPieChart()");
// Creates a document
using (DocX document = DocX.Create(ChartSample.ChartSampleOutputDirectory + @"PieChart.docx"))
{
// Add a title
document.InsertParagraph("Pie Chart").FontSize(15d).SpacingAfter(50d).Alignment = Alignment.center;
// Create a pie chart.
var c = new PieChart();
c.AddLegend(ChartLegendPosition.Left, false);
// Create the data.
var brazil = ChartData.CreateBrazilExpenses();
// Create and add series
var s1 = new Series("Canada");
s1.Bind(brazil, "Category", "Expenses");
c.AddSeries(s1);
// Insert chart into document
document.InsertParagraph("Expenses(M$) for selected categories in Canada").FontSize(15).SpacingAfter(10d);
document.InsertChart(c);
document.Save();
Console.WriteLine("\tCreated: PieChart.docx\n");
}
}
public void CopyFromFile_Test_CopiesCorrectHyperlinksToBookmarks()
{
_tmpFile = GetNewRandomFilePath(GetOrCreateTmpDirectory());
using (DocX doc = DocX.Create(_tmpFile)) {
Hyperlink hyperlink = doc.AddHyperlink("hypelink text", "bookmark");
doc.InsertParagraph()
.AppendBookmark("bookmark")
.Append("bookmark text");
doc.InsertParagraph()
.AppendHyperlink(hyperlink);
doc.Save();
}
Range targetRange = _application.Documents.Add().Range();
targetRange.Text = "unexpected";
new OpenXmlHelper().CopyFromFile(_tmpFile, targetRange);
Bookmarks bookmarks = targetRange.Document.Bookmarks;
Hyperlinks hyperlinks = targetRange.Document.Hyperlinks;
Assert.NotZero(bookmarks.Count);
Assert.NotZero(hyperlinks.Count);
Assert.That(hyperlinks[1].SubAddress, Is.EqualTo(bookmarks[1].Name));
}
/// <summary>
/// Add a 3D bar chart to a document.
/// </summary>
///
public static void Chart3D()
{
Console.WriteLine("\tChart3D)");
// Creates a document
using (DocX document = DocX.Create(ChartSample.ChartSampleOutputDirectory + @"3DChart.docx"))
{
// Add a title
document.InsertParagraph("3D Chart").FontSize(15d).SpacingAfter(50d).Alignment = Alignment.center;
// Create a 3D Bar chart.
var c = new BarChart();
c.View3D = true;
// Create the data.
var brazil = ChartData.CreateBrazilExpenses();
// Create and add series
var s1 = new Series("Brazil");
s1.Color = Color.GreenYellow;
s1.Bind(brazil, "Category", "Expenses");
c.AddSeries(s1);
// Insert chart into document
document.InsertParagraph("Expenses(M$) for selected categories in Brazil").FontSize(15).SpacingAfter(10d);
document.InsertChart(c);
document.Save();
Console.WriteLine("\tCreated: 3DChart.docx\n");
}
}
/// <summary>
/// Add margins for a document.
/// </summary>
public static void Margins()
{
Console.WriteLine("\tMargins()");
// Create a document.
using (DocX document = DocX.Create(MarginSample.MarginSampleOutputDirectory + @"Margins.docx"))
{
// Add a title.
document.InsertParagraph("Document margins").FontSize(15d).SpacingAfter(50d).Alignment = Alignment.center;
// Set the page width to be smaller.
document.PageWidth = 350f;
// Set the document margins.
document.MarginLeft = 85f;
document.MarginRight = 85f;
document.MarginTop = 0f;
document.MarginBottom = 50f;
// Add a paragraph. It will be affected by the document margins.
var p = document.InsertParagraph("This is a paragraph from a document with a left margin of 85, a right margin of 85, a top margin of 0 and a bottom margin of 50.");
document.Save();
Console.WriteLine("\tCreated: Margins.docx\n");
}
}
private void reportItem_Click(object sender, EventArgs e)
{
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
DocX document = DocX.Create(saveFileDialog.FileName);
Paragraph paragraph = document.InsertParagraph();
paragraph.FontSize(14);
paragraph.Append(DateTime.Now.ToString("dd.MM.yyyy HH:mm:ss"));
paragraph.AppendLine("Отчет за месяц").Alignment = Alignment.center;
Paragraph content = document.InsertParagraph();
using (MySqlApplicationContext db = new MySqlApplicationContext())
{
content.Append("Количество выполненных проектов:");
foreach (ProjectType item in db.ProjectTypes.Include(item => item.Projects)
.ThenInclude(item => item.ProjectStatus).ToList())
{
content.AppendLine(item.Name + ": " + item.Projects.Count(project =>
project.ProjectStatus.Name == "Готово" &&
project.FinishDate.Month == DateTime.Now.Month));
}
content.AppendLine("Заработано денег: " + db.Projects.Include(item => item.ProjectType)
.Include(item => item.ProjectStatus)
.Where(item =>
item.FinishDate.Month == DateTime.Now.Month &&
item.ProjectStatus.Name == "Готово")
.Sum(item => item.ProjectType.Price));
}
document.Save();
}
}
/// <summary>
/// Add indentations on paragraphs.
/// </summary>
public static void Indentation()
{
Console.WriteLine("\tIndentation()");
// Create a document.
using (DocX document = DocX.Create(MarginSample.MarginSampleOutputDirectory + @"Indentation.docx"))
{
// Add a title.
document.InsertParagraph("Paragraph indentation").FontSize(15d).SpacingAfter(50d).Alignment = Alignment.center;
// Set a smaller page width.
document.PageWidth = 250f;
// Add the first paragraph.
var p = document.InsertParagraph("This is the first paragraph. It doesn't contain any indentation.");
p.SpacingAfter(30);
// Add the second paragraph.
var p2 = document.InsertParagraph("This is the second paragraph. It contains an indentation on the first line.");
// Indent only the first line of the Paragraph.
p2.IndentationFirstLine = 1.0f;
p2.SpacingAfter(30);
// Add the third paragraph.
var p3 = document.InsertParagraph("This is the third paragraph. It contains an indentation on all the lines except the first one.");
// Indent all the lines of the Paragraph, except the first.
p3.IndentationHanging = 1.0f;
document.Save();
Console.WriteLine("\tCreated: Indentation.docx\n");
}
}
protected void SaveDOCX_Click(object sender, EventArgs e)
{
try
{
if (File.Exists(Server.MapPath("Deciper\\Program\\") + "AppDataDocx.docx"))
{
File.Delete(Server.MapPath("Deciper\\Program\\") + "AppDataDocx.docx");
}
string pathDocument = Server.MapPath("Deciper\\Program\\") + "AppDataDocx.docx";
// создаём документ
DocX document = DocX.Create(pathDocument);
// вставляем параграф и передаём текст
document.InsertParagraph(data.DeciperData).
// устанавливаем шрифт
Font("Calibri").
// устанавливаем размер шрифта
FontSize(36);
// сохраняем документ
document.Save();
Response.Redirect(@"/Deciper/Program/" + "AppDataDocx.docx");
}
finally
{
}
}
static void Main(string[] args)
{
//EPPlus (excel lib)
DocX report = DocX.Create("Report.docx", DocumentTypes.Document);
var paragraph = report.InsertParagraph("YoY Value Report", false,
new Formatting()
{
Bold = true
});
report.InsertParagraph();
report.InsertParagraph();
var table = report.InsertTable(2, 3);
table.Rows[0].Cells[0].InsertParagraph("Year");
table.Rows[0].Cells[1].InsertParagraph("Value");
table.Rows[0].Cells[2].InsertParagraph("Remarks");
table.Design = TableDesign.ColorfulList;
report.Save();
report.Dispose();
}
public void ToReport(string filePath, int language)
{
List <string> tableString = new List <string>();
tableString.Add("Table: ");
tableString.Add("Таблиця: ");
tableString.Add("Таблица: ");
List <string> databaseString = new List <string>();
databaseString.Add("Database: ");
databaseString.Add("База даних: ");
databaseString.Add("База данных: ");
List <string> tablesString = new List <string>();
tablesString.Add("Tables: ");
tablesString.Add("Таблиць: ");
tablesString.Add("Таблиц: ");
List <string> dateString = new List <string>();
dateString.Add("Creation date: ");
dateString.Add("Дата створення: ");
dateString.Add("Дата создания: ");
DocX doc = DocX.Create(filePath);
doc.InsertParagraph(databaseString[language] + name + " " + tablesString[language] + tables.Count + " " + dateString[language] + DateTime.Now + "\r\n");
foreach (Table tbl in tables)
{
doc.InsertParagraph(tableString[language] + tbl.ToString() + "\r\n");
tbl.ToReport(filePath, ref doc, language);
}
doc.Save();
}
