No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
MDriven reports are created with open document text (odt) or open document spreadsheet formats (ods). | MDriven reports are created with open document text (odt) or open document spreadsheet formats (ods). | ||
If you need to convert the odt to PDF there are online services available. If you rather do this | If you need to convert the odt to PDF, there are online services available. If you would rather do this yourself, you can buy a third party library that has this ability or you can simply automate Word (for odt) and have it save your odt as a PDF. | ||
'''Please note''' that this solution with automating Microsoft Word only works well in a client that can access Word locally, like the WPF client. If you want to | '''Please note''' that this solution with automating Microsoft Word only works well in a client that can access Word locally, like the WPF client. If you want to convert to PDF server-side in Turnkey och the MDrivenServer, we recommend an online service or a .net component rather than trying to call Word. This is because Word components don't work well being called from inside IIS. | ||
Here is an example of using a [[Serverside PDF|third party component]] | Here is an example of using a [[Serverside PDF|third party component]]: | ||
Microsoft.Office.Interop.Word.Application word = new Microsoft.Office.Interop.Word.Application(); | Microsoft.Office.Interop.Word.Application word = new Microsoft.Office.Interop.Word.Application(); | ||
foreach (var file in files) | foreach (var file in files) | ||
| Line 31: | Line 31: | ||
app.Quit(); | app.Quit(); | ||
} | } | ||
To use C# code in Turnkey, look at [[CodeDress|CodeDress.]] | |||
[[Category:Reports]] | [[Category:Reports]] | ||
Revision as of 06:54, 20 March 2023
MDriven reports are created with open document text (odt) or open document spreadsheet formats (ods).
If you need to convert the odt to PDF, there are online services available. If you would rather do this yourself, you can buy a third party library that has this ability or you can simply automate Word (for odt) and have it save your odt as a PDF.
Please note that this solution with automating Microsoft Word only works well in a client that can access Word locally, like the WPF client. If you want to convert to PDF server-side in Turnkey och the MDrivenServer, we recommend an online service or a .net component rather than trying to call Word. This is because Word components don't work well being called from inside IIS.
Here is an example of using a third party component:
Microsoft.Office.Interop.Word.Application word = new Microsoft.Office.Interop.Word.Application();
foreach (var file in files)
{
if (System.IO.Path.GetExtension(file.FileName.ToLower()) == ".odt" )
{
if (File.Exists(file.FileName)) // Protect againts doublettes
{
_Document doc = word.Documents.Open(file.FileName);
doc.Activate();
string newfile;
if (pdf)
{
newfile = System.IO.Path.ChangeExtension(file.FileName, ".pdf");
doc.SaveAs2(newfile, WdSaveFormat.wdFormatPDF);
}
object oMissing = System.Reflection.Missing.Value;
doc.Close(ref oMissing, ref oMissing, ref oMissing);
File.Delete(file.FileName);
file.FileName = newfile;
}
}
Microsoft.Office.Interop.Word._Application app = word.Application;
app.Quit();
}
To use C# code in Turnkey, look at CodeDress.