private void MonthClosed()
{
Microsoft.Office.Interop.PowerPoint.Application pptApp = new Microsoft.Office.Interop.PowerPoint.Application();
Microsoft.Office.Core.MsoTriState ofalse = Microsoft.Office.Core.MsoTriState.msoFalse;
Microsoft.Office.Core.MsoTriState otrue = Microsoft.Office.Core.MsoTriState.msoTrue;
pptApp.Visible = otrue;
pptApp.Activate();
Microsoft.Office.Interop.PowerPoint.Presentations ps = pptApp.Presentations;
Microsoft.Office.Interop.PowerPoint.Presentation p = ps.Open(@"F:\Mess Managment\Mess Notice\PPTFormatNotice\MonthClosed.pptx", ofalse, ofalse, otrue);
System.Diagnostics.Debug.Print(p.Windows.Count.ToString());
}
/// <summary>
/// Reads PPT and PPTX file types and extracts the words in each file
/// Requires: The file path is in ppt or pptx format only
/// </summary>
/// <param name="filenameWithPath">path of PPT and PPTX document including filename</param>
/// <exception cref="PlatformNotSupportedException">Thrown when the file to read is not of supported
/// presentation format. </exception>
/// <returns>
/// A Dictionary where the Key contains the filename and the Value contains the entire wordlist
/// </returns>
private static Dictionary <string, List <string> > readPPTFiles(string filenameWithPath)
{
Contract.Requires <PlatformNotSupportedException>(System.IO.Path.GetExtension(filenameWithPath).Equals(".ppt") ||
System.IO.Path.GetExtension(filenameWithPath).Equals(".pptx"));
List <string> result = new List <string>();
Dictionary <string, List <string> > listresult = new Dictionary <string, List <string> >();
Microsoft.Office.Interop.PowerPoint.Application PowerPoint_App = new Microsoft.Office.Interop.PowerPoint.Application();
Microsoft.Office.Interop.PowerPoint.Presentations multi_presentations = PowerPoint_App.Presentations;
Microsoft.Office.Interop.PowerPoint.Presentation presentation = multi_presentations.Open(filenameWithPath);
for (int i = 0; i < presentation.Slides.Count; i++)
{
foreach (var item in presentation.Slides[i + 1].Shapes)
{
var shape = (Microsoft.Office.Interop.PowerPoint.Shape)item;
if (shape.HasTextFrame == MsoTriState.msoTrue)
{
if (shape.TextFrame.HasText == MsoTriState.msoTrue)
{
var textRange = shape.TextFrame.TextRange;
string text = textRange.Text.ToLower().Trim().ToString();
result.AddRange(text.Split(new char[] { ' ', '\n', '\t', '\r' }));
}
}
}
}
PowerPoint_App.Quit();
listresult.Add(filenameWithPath, result);
return(listresult);
}
private void allocPowerPoint()
{
if (avaPoawrPoint)
{
pptApp = new Microsoft.Office.Interop.PowerPoint.Application();
pptPres = pptApp.Presentations;
}
}
public void OpenPowerPoint()
{
powerpoint = new Microsoft.Office.Interop.PowerPoint.Application();
powerpoint.Visible = MsoTriState.msoTrue;
//Prevent Office Assistant from displaying alert messages:
bAssistantOn = powerpoint.Assistant.On;
powerpoint.Assistant.On = false;
presentationSet = powerpoint.Presentations;
}
private void createSlideFromTemplate()
{
//Create a new presentation based on a template.
objApp = new Microsoft.Office.Interop.PowerPoint.Application();
objApp.Visible = MsoTriState.msoTrue;
objPresSet = objApp.Presentations;
objPres = objPresSet.Open(strTemplate,
MsoTriState.msoFalse, MsoTriState.msoTrue, MsoTriState.msoTrue);
objSlides = objPres.Slides;
}
private void bunifuThinButton23_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.PowerPoint.Application pptApp = new Microsoft.Office.Interop.PowerPoint.Application();
Microsoft.Office.Core.MsoTriState ofalse = Microsoft.Office.Core.MsoTriState.msoFalse;
Microsoft.Office.Core.MsoTriState otrue = Microsoft.Office.Core.MsoTriState.msoTrue;
pptApp.Visible = otrue;
pptApp.Activate();
Microsoft.Office.Interop.PowerPoint.Presentations ps = pptApp.Presentations;
Microsoft.Office.Interop.PowerPoint.Presentation p = ps.Open(@"F:\Mess Managment\Mess Notice\PPTFormatNotice\PenaltyMeal.pptx", ofalse, ofalse, otrue);
System.Diagnostics.Debug.Print(p.Windows.Count.ToString());
}
private void freePowerPoint()
{
if (avaPoawrPoint)
{
if (pptPres != null)
{
pptPres = null;
}
pptApp.Quit();
}
}
private void button1_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.PowerPoint.Application pptApp = new Microsoft.Office.Interop.PowerPoint.Application();
Microsoft.Office.Core.MsoTriState ofalse = Microsoft.Office.Core.MsoTriState.msoFalse;
Microsoft.Office.Core.MsoTriState otrue = Microsoft.Office.Core.MsoTriState.msoTrue;
pptApp.Visible = otrue;
pptApp.Activate();
Microsoft.Office.Interop.PowerPoint.Presentations ps = pptApp.Presentations;
Microsoft.Office.Interop.PowerPoint.Presentation p = ps.Open(@"F:\Mess Managment\PersonalCostV.1.1.00V.pptx", ofalse, ofalse, otrue);
System.Diagnostics.Debug.Print(p.Windows.Count.ToString());
MessageBox.Show(pptApp.ActiveWindow.Caption);
}
public override bool PPT2HTML(string sourcePath, string targetPath, string targetRelativeDirectory)
{
Microsoft.Office.Interop.PowerPoint.PpSaveAsFileType targetFileType = Microsoft.Office.Interop.PowerPoint.PpSaveAsFileType.ppSaveAsJPG;
object missing = Type.Missing;
Microsoft.Office.Interop.PowerPoint.Application pptApp = null;
Microsoft.Office.Interop.PowerPoint.Presentation presentation = null;
try
{
if (!sourcePath.EndsWith(".ppt") && !sourcePath.EndsWith(".pptx"))
{
return(false);
}
if (File.Exists(targetPath))
{
File.Delete(targetPath);
}
object target = targetPath;
pptApp = new Microsoft.Office.Interop.PowerPoint.ApplicationClass();
Microsoft.Office.Interop.PowerPoint.Presentations presentations = pptApp.Presentations;
presentation = presentations.Open(sourcePath, MsoTriState.msoTrue, MsoTriState.msoFalse, MsoTriState.msoFalse);
presentation.SaveAs(targetPath, targetFileType, Microsoft.Office.Core.MsoTriState.msoTrue);
}
catch (Exception e)
{
Log.LogInfo("ppt转换html:", e);
return(false);
}
finally
{
if (presentation != null)
{
presentation.Close();
presentation = null;
}
if (pptApp != null)
{
pptApp.Quit();
pptApp = null;
}
GC.Collect();
GC.WaitForPendingFinalizers();
}
pptHelper(targetPath, targetRelativeDirectory);
return(true);
}
public static bool CreatePowerPoint()
{
try
{ //create powerpoint
ppPresens = ppApp.Presentations;
objPres = ppPresens.Add();
objSlides = objPres.Slides;
}
catch (Exception e)
{
Console.WriteLine("Creating PowerPoint Failed: " + fileName + "\n" + e.Message);
}
return(result);
}
public void ClosePowerPoint()
{
if (powerpoint != null)
{
// Reenable Office Assisant, if it was on:
if (bAssistantOn)
{
powerpoint.Assistant.On = true;
powerpoint.Assistant.Visible = false;
}
powerpoint.Quit();
presentationSet = null;
powerpoint = null;
}
}
protected override void OnStart(CustomForm Sender)
{
Microsoft.Office.Interop.PowerPoint.Application pptApp = new Microsoft.Office.Interop.PowerPoint.Application();
Microsoft.Office.Core.MsoTriState ofalse = Microsoft.Office.Core.MsoTriState.msoFalse;
Microsoft.Office.Core.MsoTriState otrue = Microsoft.Office.Core.MsoTriState.msoTrue;
pptApp.Visible = otrue;
pptApp.Activate();
Microsoft.Office.Interop.PowerPoint.Presentations ps = pptApp.Presentations;
opApp = new Microsoft.Office.Interop.PowerPoint.Application();
opApp.SlideShowNextSlide += OpApp_SlideShowNextSlide;
ppPresentation = ps.Open(@"c:\a.pptx", ofalse, ofalse, otrue);
settings = ppPresentation.SlideShowSettings;
settings.RangeType = Microsoft.Office.Interop.PowerPoint.PpSlideShowRangeType.ppShowSlideRange;
settings.StartingSlide = StartingSlide;
settings.Run();
}
public override void Convert(string src, string dest, out string msg)
{
msg = null;
try
{
if (string.IsNullOrEmpty(src))
{
msg = "源文件不能为空";
return;
}
var contentType = MimeTypes.GetContentType(src);
if (contentType != "application/mspowerpoint")
{
msg = "源文件应为powerpoint文件";
return;
}
if (string.IsNullOrEmpty(dest))
{
msg = "目标路径不能为空";
return;
}
if (!File.Exists(src))
{
msg = "文件不存在";
return;
}
if (IsPasswordProtected(src))
{
msg = "存在密码";
return;
}
app = new Microsoft.Office.Interop.PowerPoint.Application();
presentations = app.Presentations;
presentation = presentations.Open(src.ToString(), Microsoft.Office.Core.MsoTriState.msoTrue, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoFalse);
presentation.ExportAsFixedFormat(dest.ToString(), Microsoft.Office.Interop.PowerPoint.PpFixedFormatType.ppFixedFormatTypePDF);
// presentation.ExportAsFixedFormat(outputFile, PowerPoint.PpFixedFormatType.ppFixedFormatTypePDF, PowerPoint.PpFixedFormatIntent.ppFixedFormatIntentScreen, MsoTriState.msoFalse, PowerPoint.PpPrintHandoutOrder.ppPrintHandoutVerticalFirst, PowerPoint.PpPrintOutputType.ppPrintOutputSlides, MsoTriState.msoFalse, null, PowerPoint.PpPrintRangeType.ppPrintAll, "", false, false, false, false, false, null);
}
catch (Exception e)
{
release();
throw new ConvertException(e.Message);
}
release();
}
private static string GetPPTContent(string path)
{
string fileExtension = Path.GetExtension(path).ToLower();
if (fileExtension.Contains("pptx"))
{
StringBuilder sb = new StringBuilder();
PresentationDocument pptx = PresentationDocument.Open(path, false);
foreach (SlidePart slide in pptx.PresentationPart.SlideParts)
{
sb.Append(slide.Slide.InnerText).Append(Environment.NewLine);
}
return(sb.ToString());
}
else
{
Microsoft.Office.Interop.PowerPoint.Application PowerPoint_App = new Microsoft.Office.Interop.PowerPoint.Application();
Microsoft.Office.Interop.PowerPoint.Presentations multi_presentations = PowerPoint_App.Presentations;
Microsoft.Office.Interop.PowerPoint.Presentation presentation = multi_presentations.Open(path, Microsoft.Office.Core.MsoTriState.msoTrue, Microsoft.Office.Core.MsoTriState.msoTrue, Microsoft.Office.Core.MsoTriState.msoFalse);
string presentation_text = "";
for (int i = 0; i < presentation.Slides.Count; i++)
{
foreach (var item in presentation.Slides[i + 1].Shapes)
{
var shape = (Microsoft.Office.Interop.PowerPoint.Shape)item;
if (shape.HasTextFrame == Microsoft.Office.Core.MsoTriState.msoTrue)
{
if (shape.TextFrame.HasText == Microsoft.Office.Core.MsoTriState.msoTrue)
{
var textRange = shape.TextFrame.TextRange;
var text = textRange.Text;
presentation_text += text + " ";
}
}
}
}
PowerPoint_App.Quit();
return(presentation_text);
}
}
private void btnExport_Click(object sender, EventArgs e)
{
lblMessage.Enabled = false;
lblMessage.Text = "Parsing..";
var result = this.folderBrowser.ShowDialog(this);
if (result != DialogResult.OK)
{
return;
}
var folderPath = FileIO.GetPath(folderBrowser.SelectedPath);
var ext = new List <string> {
".ppt", ".pptx"
};
var presos = Directory.GetFiles(folderPath, "*.*", SearchOption.TopDirectoryOnly)
.Where(s => ext.Any(x => s.EndsWith(x))).ToList();
var pdfext = new List <string> {
".pdf"
};
var pdfs = Directory.GetFiles(folderPath, "*.*", SearchOption.TopDirectoryOnly)
.Where(s => pdfext.Any(x => s.EndsWith(x))).ToList();
if (presos.Count() == 0 && pdfs.Count() == 0)
{
lblMessage.Text = "no presentations or Pdfs found";
return;
}
var tempDir = Directory.CreateDirectory(folderPath + @"\_temp");
Microsoft.Office.Interop.PowerPoint.Application PowerPoint_App = null;
if (presos.Count() != 0)
{
try
{
PowerPoint_App = PowerPointEx.ConvertToPPTX(presos, tempDir.FullName);
}
catch (Exception ex)
{
MessageBox.Show("Error initializing, close Powerpoint if it is open");
return;
}
}
Microsoft.Office.Interop.PowerPoint.Presentations multi_presentations = PowerPoint_App.Presentations;
string outFile = "";
foreach (var preso in presos)
{
Microsoft.Office.Interop.PowerPoint.Presentation presentation = multi_presentations.Open(preso, MsoTriState.msoFalse, MsoTriState.msoFalse, MsoTriState.msoFalse);
var pptName = Path.GetFileName(preso);
var underscoreIndex = pptName.IndexOf('_');
var newPptName = pptName.Remove(0, underscoreIndex + 1);
if (string.IsNullOrEmpty(outFile))
{
outFile = Path.GetFileNameWithoutExtension(newPptName);
outFile += ".docx";
var outDir = Directory.CreateDirectory(folderPath + @"\_output");
_fullFilePath = Path.Combine(outDir.FullName, outFile);
WordEx.CreateDoc(_fullFilePath);
}
WordEx.AddTitle(newPptName);
foreach (Microsoft.Office.Interop.PowerPoint.Slide slide in presentation.Slides)
{
bool firstLine = true;
//ParseWithOpenXML(slideId,preso);
string pptx = Path.GetFileNameWithoutExtension(preso) + ".pptx";
string pptxFile = Path.Combine(tempDir.FullName, pptx);
_slideInfos.Add(new SlideInfo()
{
Id = slide.SlideNumber, path = pptxFile
});
var prevNoteText = "";
foreach (var item in slide.Shapes)
{
//firstLine = true;
var shape = (Microsoft.Office.Interop.PowerPoint.Shape)item;
if (shape.HasTextFrame == MsoTriState.msoTrue)
{
if (shape.TextFrame2.HasText == MsoTriState.msoTrue)
{
if (shape.TextFrame2.TextRange.ParagraphFormat.Bullet.Type != MsoBulletType.msoBulletNone)
{
List <string> bullets = new List <string>();
foreach (TextRange2 para in shape.TextFrame2.TextRange.Paragraphs)
{
bullets.Add(para.Text);
//var bulletText = "- " + para.Text;
//buffer.AppendLine(bulletText);
}
WordEx.AddBulletList(bullets);
//string text = shape.TextFrame2.TextRange.Text;
//WordEx.AddBulletList(text);
}
else
{
var text = shape.TextFrame2.TextRange.Text;
//slideText += text + " ";
//buffer.AppendLine(text);
if (firstLine)
{
WordEx.AddHeader(text);
firstLine = false;
}
else
{
WordEx.AddText(text);
}
}
}
else if (shape.TextFrame.HasText == MsoTriState.msoTrue)
{
var text = shape.TextFrame.TextRange.Text;
//slideText += text + " ";
//buffer.AppendLine(text);
if (firstLine)
{
WordEx.AddHeader(text);
firstLine = false;
}
else
{
WordEx.AddText(text);
}
}
firstLine = false;
}
if (slide.HasNotesPage == MsoTriState.msoTrue)
{
//bool processedNotes = false;
foreach (var note in slide.NotesPage.Shapes)
{
//if (processedNotes)
// break;
var noteShape = (Microsoft.Office.Interop.PowerPoint.Shape)note;
if (noteShape.HasTextFrame == MsoTriState.msoTrue)
{
if (noteShape.TextFrame2.HasText == MsoTriState.msoTrue)
{
var text1 = noteShape.TextFrame2.TextRange.Text;
if (text1 == prevNoteText || WordEx.IsNumeric(text1))
{
continue;
}
//processedNotes = true; //go to next since notes are duplicated in interop.
if (noteShape.TextFrame2.TextRange.ParagraphFormat.Bullet.Type != MsoBulletType.msoBulletNone)
{
List <string> bullets = new List <string>();
foreach (TextRange2 para in noteShape.TextFrame2.TextRange.Paragraphs)
{
bullets.Add(para.Text);
}
WordEx.AddBulletList(bullets, true);
prevNoteText = noteShape.TextFrame2.TextRange.Text;
}
else
{
var text = noteShape.TextFrame2.TextRange.Text;
WordEx.AddText(text, true);
}
}
else if (noteShape.TextFrame.HasText == MsoTriState.msoTrue)
{
var text = noteShape.TextFrame.TextRange.Text;
WordEx.AddText(text, true);
}
}
}
}
}
}
presentation.Close();
//var presoSource = Path.GetFileName(preso);
//string processedPreso = Path.Combine(processedDir.FullName, presoSource);
//if (!File.Exists(processedPreso))
// File.Copy(preso, processedPreso);
}
try
{
PowerPointEx.Close(PowerPoint_App);
AddImages();
AddPdfs(pdfs, tempDir.FullName);
WordEx.Save();
lblMessage.Text = "Created Doc: " + _fullFilePath;
lblMessage.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool LoadDocument(string filename, string typename, ListView parent)
{
this.Clear();
if (!File.Exists(filename))
{
return(false);
}
// all windows media play formats
if (typename == "WMP")
{
this.pdfViewer.Visible = false;
this.fileView.Visible = false;
this.zipView.Visible = false;
this.imgView.Visible = false;
this.docView.Visible = false;
this.webBrowser.Visible = false;
if (this.b_cfw)
{
this.axWMP.Visible = false;
this.videoPlayerCtl.URL = filename;
this.videoPlayerCtl.Location = new System.Drawing.Point(this.ClientRectangle.X, this.ClientRectangle.Y);
this.videoPlayerCtl.Size = this.Size;
this.videoPlayerCtl.Visible = true;
return(true);
}
if (this.b_wmp)
{
this.videoPlayerCtl.Visible = false;
this.axWMP.URL = filename;
this.axWMP.Visible = true;
this.axWMP.Dock = DockStyle.Fill;
return(true);
}
}
// in case something goes wrong, we allow to fallback to b_asis and show the binary content
bool asisTmp = this.b_asis;
// ext drives most of the things
string ext = System.IO.Path.GetExtension(filename).ToLower();
// all music
if ((".mp3.wav.flac".IndexOf(ext) != -1) && this.b_mp3)
{
try {
this.pdfViewer.Visible = false;
this.fileView.Visible = false;
this.zipView.Visible = false;
this.imgView.Visible = false;
this.webBrowser.Visible = false;
this.videoPlayerCtl.Visible = false;
this.docView.Visible = false;
this.axWMP.Visible = true;
this.axWMP.Dock = DockStyle.Fill;
this.axWMP.URL = filename;
asisTmp = false;
} catch (System.Exception) {
asisTmp = true;
}
}
// initially I only found a way to convert Word to html (which is done here), other MSO Files conversations were found later and appear in the HTML section
if ((".rtf.doc.docx".IndexOf(ext) != -1) && this.b_doc)
{
try {
this.pdfViewer.Visible = false;
this.fileView.Visible = false;
this.zipView.Visible = false;
this.imgView.Visible = false;
this.webBrowser.Visible = false;
this.videoPlayerCtl.Visible = false;
this.axWMP.Visible = false;
this.docView.LoadDocument(filename);
this.docView.Visible = true;
asisTmp = false;
} catch (System.Exception) {
asisTmp = true;
}
}
else
{
// images
if ((".ico.bmp.tif.jpg.jpeg.wmf.gif.png.exif.emf.tiff".IndexOf(ext) != -1) && this.b_img)
{
try {
this.pdfViewer.Visible = false;
this.fileView.Visible = false;
this.zipView.Visible = false;
this.webBrowser.Visible = false;
this.docView.Visible = false;
this.videoPlayerCtl.Visible = false;
this.axWMP.Visible = false;
this.imgView.Visible = true;
this.imgView.LoadDocument(filename, parent);
asisTmp = false;
} catch (System.Exception) {
asisTmp = true;
}
}
else
{
// PDF and PowerPoint
if ((".pdf.ppt.pptx.pptm.odp".IndexOf(ext) != -1) && (this.b_pdf || this.b_doc))
{
// powerpoint formats via powerpoint interop converted to pdf
if ((".ppt.pptx.pptm.odp".IndexOf(ext) != -1) && this.b_doc)
{
string outpath = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "temp.pdf");
if (System.IO.File.Exists(outpath))
{
System.IO.File.Delete(outpath);
}
try {
Microsoft.Office.Interop.PowerPoint.Application app = new Microsoft.Office.Interop.PowerPoint.Application();
Microsoft.Office.Interop.PowerPoint.Presentations pres = app.Presentations;
Microsoft.Office.Interop.PowerPoint.Presentation file = pres.Open(filename, Microsoft.Office.Core.MsoTriState.msoTrue, Microsoft.Office.Core.MsoTriState.msoTrue, Microsoft.Office.Core.MsoTriState.msoFalse);
file.SaveCopyAs(outpath, Microsoft.Office.Interop.PowerPoint.PpSaveAsFileType.ppSaveAsPDF, Microsoft.Office.Core.MsoTriState.msoTrue);
app.Quit();
filename = outpath;
asisTmp = false;
} catch (Exception) {
asisTmp = true;
}
}
// show pdf
try {
this.pdfViewer.ZoomMode = PdfViewerZoomMode.FitWidth;
PdfDocument pdoc = PdfDocument.Load(filename);
this.pdfViewer.Document = pdoc;
this.fileView.Visible = false;
this.zipView.Visible = false;
this.imgView.Visible = false;
this.webBrowser.Visible = false;
this.docView.Visible = false;
this.videoPlayerCtl.Visible = false;
this.axWMP.Visible = false;
this.pdfViewer.Visible = true;
asisTmp = false;
} catch (Exception) {
asisTmp = true;
}
}
else
{
// ZIP-Viewer simply shows the content of zip file
if ((".zip".IndexOf(ext) != -1) && this.b_zip)
{
try {
this.zipView.LoadZip(filename);
this.pdfViewer.Visible = false;
this.fileView.Visible = false;
this.imgView.Visible = false;
this.webBrowser.Visible = false;
this.docView.Visible = false;
this.videoPlayerCtl.Visible = false;
this.axWMP.Visible = false;
this.zipView.Visible = true;
asisTmp = false;
} catch (Exception) {
asisTmp = true;
}
}
else
{
// collector for everything, which could be converted into HTML
if ((".htm.html.msg.eml.mht.xls.xlsx.xlsb.xlsm.vsd.vsdx.vsdm" /*.mpp.mpx"*/.IndexOf(ext) != -1) && (this.b_htm || this.b_doc))
{
// visio via visio interop to html
if ((".vsd.vsdx.vsdm".IndexOf(ext) != -1) && this.b_doc)
{
string outpath = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "temp.html");
if (System.IO.File.Exists(outpath))
{
System.IO.File.Delete(outpath);
}
asisTmp = true;
try {
Microsoft.Office.Interop.Visio.IVInvisibleApp visio = null;
visio = new Microsoft.Office.Interop.Visio.InvisibleApp();
Microsoft.Office.Interop.Visio.SaveAsWeb.VisSaveAsWeb saveAsWeb = (Microsoft.Office.Interop.Visio.SaveAsWeb.VisSaveAsWeb)visio.Application.SaveAsWebObject;
saveAsWeb.AttachToVisioDoc(visio.Documents.OpenEx(filename, (short)Microsoft.Office.Interop.Visio.VisOpenSaveArgs.visOpenRO));
Microsoft.Office.Interop.Visio.SaveAsWeb.VisWebPageSettings webPageSettings = (Microsoft.Office.Interop.Visio.SaveAsWeb.VisWebPageSettings)saveAsWeb.WebPageSettings;
webPageSettings.TargetPath = outpath;
webPageSettings.PageTitle = outpath;
webPageSettings.DispScreenRes = Microsoft.Office.Interop.Visio.SaveAsWeb.VISWEB_DISP_RES.res768x1024;
webPageSettings.QuietMode = 1;
webPageSettings.SilentMode = 1;
webPageSettings.NavBar = 1;
webPageSettings.PanAndZoom = 1;
webPageSettings.Search = 1;
webPageSettings.OpenBrowser = 0;
webPageSettings.PropControl = 0;
saveAsWeb.CreatePages();
this.webBrowser.Navigate(outpath);
asisTmp = false;
} catch (Exception) {
asisTmp = true;
}
}
// MS Project formats via project interop to xls:
// - not working with 2003 Interops on a system running MS-Project 2003 (--> 2003 converter is shown)
// - not working with 2007 Interops on a system running MS-Project 2003 (--> no html support in 2003)
//if ((".mpp.mpx".IndexOf(ext) != -1) && b_doc) {
// string outpath = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "temp.xls");
// if (System.IO.File.Exists(outpath)) {
// System.IO.File.Delete(outpath);
// }
// asisTmp = true;
// try {
// var app = new Microsoft.Office.Interop.MSProject.Application();
// app.Visible = false;
// var proj = app.ActiveProject;
// app.FileOpenx(filename, true, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.MSProject.PjPoolOpen.pjPoolReadOnly, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
// //app.FileOpenEx(filename, true, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.MSProject.PjPoolOpen.pjPoolReadOnly, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
// // save MS-Project as Excel file (MS-Project interopt has no HTML exporter) and let Excel viewer do the job
// proj.SaveAs(outpath, PjFileFormat.pjXLS, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
// app.Quit(Microsoft.Office.Interop.MSProject.PjSaveType.pjDoNotSave);
// // set temporary Excel filename as "real" filename --> let Excel viewer do the work
// filename = outpath;
// // adjust extension --> let Excel viewer do the work
// ext = System.IO.Path.GetExtension(filename).ToLower();
// asisTmp = false;
// } catch (System.Reflection.TargetInvocationException x) {
// asisTmp = true;
// }
//}
// excel formats via excel interop to html
if ((".xls.xlsx.xlsb.xlsm".IndexOf(ext) != -1) && this.b_doc)
{
string outpath = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "temp.html");
if (System.IO.File.Exists(outpath))
{
System.IO.File.Delete(outpath);
}
this.Cursor = Cursors.WaitCursor;
try {
// http://www.codeproject.com/Articles/507068/Microsoft-Interop-API-to-convert-the-doc-docx-dot
Microsoft.Office.Interop.Excel.Application excel = null;
Microsoft.Office.Interop.Excel.Workbook xls = null;
excel = new Microsoft.Office.Interop.Excel.Application();
object missing = Type.Missing;
object trueObject = true;
excel.Visible = false;
excel.DisplayAlerts = false;
xls = excel.Workbooks.Open(filename, missing, trueObject, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
object format = Microsoft.Office.Interop.Excel.XlFileFormat.xlHtml;
System.Collections.IEnumerator wsEnumerator = excel.ActiveWorkbook.Worksheets.GetEnumerator();
while (wsEnumerator.MoveNext())
{
this.Cursor = Cursors.WaitCursor;
Microsoft.Office.Interop.Excel.Workbook wsCurrent = xls;
wsCurrent.SaveAs(outpath, format, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);
}
excel.Quit();
this.webBrowser.Navigate(outpath);
asisTmp = false;
} catch (Exception cex) {
GrzTools.AutoMessageBox.Show(cex.Message, "Exception", 2000);
asisTmp = true;
}
Cursor.Current = Cursors.Default;
}
// msg files are converted via MsgReader to html
if (".msg".IndexOf(ext) != -1)
{
try {
string body = "";
Reader msgReader = new Reader();
using (StreamReader streamReader = new StreamReader(filename)) {
body = msgReader.ExtractMsgEmailBody(streamReader.BaseStream, true, "text/html; charset=utf-8");
}
this.webBrowser.DocumentText = body;
asisTmp = false;
} catch (Exception) {
asisTmp = true;
}
}
// html-style formatted files
if ((".htm.html.eml.mht".IndexOf(ext) != -1) && this.b_htm)
{
this.webBrowser.Url = new Uri(filename);
asisTmp = false;
}
if (!asisTmp)
{
this.pdfViewer.Visible = false;
this.fileView.Visible = false;
this.zipView.Visible = false;
this.imgView.Visible = false;
this.docView.Visible = false;
this.axWMP.Visible = false;
this.videoPlayerCtl.Visible = false;
this.webBrowser.Visible = true;
}
}
}
}
}
}
// standard file view
if (asisTmp)
{
this.fileView.LoadDocument(null, filename, parent);
this.pdfViewer.Visible = false;
this.zipView.Visible = false;
this.imgView.Visible = false;
this.webBrowser.Visible = false;
this.docView.Visible = false;
this.videoPlayerCtl.Visible = false;
this.axWMP.Visible = false;
this.fileView.Visible = true;
}
return(true);
}
public void processFBRReport(string fbrFileLocation)
{
DataRow dr = dtFBR.NewRow();
dr["FILE_NAME"] = Path.GetFileName(fbrFileLocation);
var stringBuilder = new StringBuilder();
Microsoft.Office.Interop.PowerPoint.Application pptApp =
new Microsoft.Office.Interop.PowerPoint.Application();
Microsoft.Office.Interop.PowerPoint.Presentations pptPresentations =
pptApp.Presentations;
Microsoft.Office.Interop.PowerPoint.Presentation pptPresentation =
pptPresentations.Open(fbrFileLocation,
Microsoft.Office.Core.MsoTriState.msoTrue,
Microsoft.Office.Core.MsoTriState.msoFalse,
Microsoft.Office.Core.MsoTriState.msoFalse);
Microsoft.Office.Interop.PowerPoint.Slides pptSlides = pptPresentation.Slides;
Graphics gr = this.CreateGraphics();
var slidesCount = pptSlides.Count;
int imgCrt = 0;
for (int slideIndex = 1; slideIndex <= slidesCount; slideIndex++)
{
var slide = pptSlides[slideIndex];
foreach (Microsoft.Office.Interop.PowerPoint.Shape textShape in slide.Shapes)
{
if (textShape.Type == Microsoft.Office.Core.MsoShapeType.msoPicture)
{
listofImages.Add(textShape);
imgCrt++;
textShape.Export(sPowerPointFolderImg + textShape.ZOrderPosition.ToString()
+ "-" + ((textShape.Left * gr.DpiX) / 72).ToString("0.00")
+ "-" + ((textShape.Top * gr.DpiX) / 72).ToString("0.00")
+ "-" + ((textShape.Width * gr.DpiX) / 72).ToString("0.00")
+ "-" + ((textShape.Height * gr.DpiX) / 72).ToString("0.00")
+ ".png",
Microsoft.Office.Interop.PowerPoint.PpShapeFormat.ppShapeFormatPNG,
0,
0,
Microsoft.Office.Interop.PowerPoint.PpExportMode.ppScaleXY);
}
if (textShape.HasTextFrame == Microsoft.Office.Core.MsoTriState.msoTrue &&
textShape.TextFrame.HasText == Microsoft.Office.Core.MsoTriState.msoTrue)
{
Microsoft.Office.Interop.PowerPoint.TextRange pptTextRange = textShape.TextFrame.TextRange;
if (pptTextRange != null && pptTextRange.Length > 0)
{
stringBuilder.Append(" " + pptTextRange.Text);
if (pptTextRange.Text.StartsWith("ACTUAL CUSTOMER COMPLAINT") == true)
{
string tmpString = pptTextRange.Text;
tmpString = pptTextRange.Text.Replace("ACTUAL CUSTOMER COMPLAINT", string.Empty);
dr["ACTUAL CUSTOMER COMPLAINT"] = tmpString.Replace(",", "").Replace("\r", String.Empty);
}
else if (pptTextRange.Text.Trim().ToUpper().Equals("MARKET FEED BACK") == true)
{
}
else if (pptTextRange.Text.Trim().ToUpper().StartsWith("RANK:") == true)
{
string tmpString = pptTextRange.Text.ToUpper();
tmpString = pptTextRange.Text.Replace("RANK:", string.Empty);
var regex = new Regex(Regex.Escape("\r"));
tmpString = regex.Replace(tmpString, "", 1);
dr["RANK"] = tmpString;
}
else if (pptTextRange.Text.Trim().ToUpper().StartsWith("TRACKING #") == true)
{
string tmpString = pptTextRange.Text.ToUpper();
tmpString = tmpString.ToUpper().Replace("TRACKING #:", string.Empty);
dr["TRACKING"] = tmpString.Replace(",", "").Replace("\r", String.Empty);
}
else if (pptTextRange.Text.Trim().StartsWith("This sheet is intended for quick feed back to increase associate") == true)
{
}
else if (pptTextRange.Text.Trim().Equals("For Reference Only") == true)
{
}
else
{
if (textShape.Name.ToString().Equals("Title 1") == true)
{
dr["TITLE"] = pptTextRange.Text.Replace(",", "").Replace("\r", String.Empty);
}
}
System.Runtime.InteropServices.Marshal.ReleaseComObject(pptTextRange);
}
}
if (textShape.HasTable == Microsoft.Office.Core.MsoTriState.msoTrue)
{
if (textShape.Table.Rows.Count > 1)
{
int iNumRows = textShape.Table.Rows.Count;
int iNumCols = textShape.Table.Rows[1].Cells.Count;
string sKey = textShape.Table.Rows[1].Cells[1].Shape.TextFrame.TextRange.Text;
if ((sKey.Trim().ToUpper().Equals("VIN") == true) ||
(sKey.Trim().ToUpper().Equals("PART NAME") == true) ||
(sKey.Trim().ToUpper().Equals("CUSTOMER CONCERN:") == true) ||
(sKey.Trim().ToUpper().Equals("DEALER REPAIR:") == true) ||
(sKey.Trim().ToUpper().Equals("ADDITIONAL DETAILS:") == true) ||
(sKey.Trim().ToUpper().Equals("CLAIM COST:") == true)
)
{
//Process VIN Block
for (int iCol = 1; iCol <= iNumCols; iCol++)
{
dr[textShape.Table.Rows[1].Cells[iCol].Shape.TextFrame.TextRange.Text] =
textShape.Table.Rows[2].Cells[iCol].Shape.TextFrame.TextRange.Text.Replace(",", String.Empty).Replace("\r", String.Empty);
}
}
if ((sKey.Trim().ToUpper().Equals("MODEL:") == true) ||
(sKey.Trim().ToUpper().Equals("DEPT:") == true) ||
(sKey.Trim().ToUpper().Equals("ISSUED DATE:") == true) ||
(sKey.Trim().ToUpper().Equals("ISSUER:") == true)
)
{
//Process VIN Block
for (int iRow = 1; iRow <= iNumRows; iRow++)
{
dr[textShape.Table.Rows[iRow].Cells[1].Shape.TextFrame.TextRange.Text] =
textShape.Table.Rows[iRow].Cells[2].Shape.TextFrame.TextRange.Text.Replace(",", "");
}
}
}
}
System.Runtime.InteropServices.Marshal.ReleaseComObject(textShape);
}
System.Runtime.InteropServices.Marshal.ReleaseComObject(slide);
}
System.Runtime.InteropServices.Marshal.ReleaseComObject(pptSlides);
System.Runtime.InteropServices.Marshal.ReleaseComObject(pptPresentation);
System.Runtime.InteropServices.Marshal.ReleaseComObject(pptPresentations);
System.Runtime.InteropServices.Marshal.ReleaseComObject(pptApp);
dtFBR.Rows.Add(dr);
string[] filePaths = Directory.GetFiles(sPowerPointFolderImg);
int min_left = 10000000;
int min_top = 10000000;
int max_bottom = 0;
int max_right = 0;
foreach (string filePath in filePaths)
{
string imagefilename = Path.GetFileNameWithoutExtension(filePath);
string[] filesplit = imagefilename.Split('-');
imageInfo imgInfoObj = new imageInfo();
imgInfoObj.position = Convert.ToInt32(filesplit[0]);
imgInfoObj.left = Convert.ToInt32(filesplit[1].Substring(0, filesplit[1].IndexOf('.')));
imgInfoObj.top = Convert.ToInt32(filesplit[2].Substring(0, filesplit[2].IndexOf('.')));
imgInfoObj.width = Convert.ToInt32(filesplit[3].Substring(0, filesplit[3].IndexOf('.')));
imgInfoObj.height = Convert.ToInt32(filesplit[4].Substring(0, filesplit[4].IndexOf('.')));
imgInfoObj.filename = filePath;
dicImageFileInfo.Add(imgInfoObj.position, imgInfoObj);
if (imgInfoObj.left < min_left)
{
min_left = imgInfoObj.left;
}
if (imgInfoObj.top < min_top)
{
min_top = imgInfoObj.top;
}
if (max_bottom < (imgInfoObj.height + imgInfoObj.top))
{
max_bottom = (imgInfoObj.height + imgInfoObj.top);
}
if (max_right < (imgInfoObj.left + imgInfoObj.width))
{
max_right = imgInfoObj.left + imgInfoObj.width;
}
}
List <int> list = dicImageFileInfo.Keys.ToList();
list.Sort();
Bitmap target = new Bitmap(max_right - min_left + 50, max_bottom - min_top + 50);
using (Graphics g = Graphics.FromImage(target))
{
g.PixelOffsetMode = PixelOffsetMode.HighQuality;
g.InterpolationMode = InterpolationMode.NearestNeighbor;
foreach (var key in list)
{
imageInfo temImgInfo = (imageInfo)dicImageFileInfo[key];
Bitmap src = Image.FromFile(temImgInfo.filename) as Bitmap;
g.DrawImage(src,
(temImgInfo.left - min_left),
((temImgInfo.top - min_top)));
src.Dispose();
}
g.Dispose();
}
string sImageNameCropTemp = sPowerPointFolderImgProcessed + Path.GetFileName(fbrFileLocation) + "_MergedImages.png";
target.Save(sImageNameCropTemp);
dicImageFileInfo.Clear();
target.Dispose();
gr.Dispose();
Array.ForEach(Directory.GetFiles(sPowerPointFolderImg), File.Delete);
}
public static void PrintDiscountCoupon(string companyName, string discountProductName, string discountValueOnProduct)
{
int copiesToPrint = 1;
string printTemplateFileName = @"\Assets\Docs\PrinterReceipt.pptx";
string qrCodeImageName = @"\Assets\Images\QREncode.jpg";
string printFileName = @"\Assets\Docs\printReceipt.pptx";
string printTemplateFilePath = Helper.GetAssetURI(printTemplateFileName);
string qrCodeImagepath = Helper.GetAssetURI(qrCodeImageName);
string printReceiptFilePath = Helper.GetAssetURI(printFileName);
Microsoft.Office.Interop.PowerPoint.Presentation work = null;
Microsoft.Office.Interop.PowerPoint.Application app = new Microsoft.Office.Interop.PowerPoint.Application();
try
{
if (File.Exists(printReceiptFilePath))
{
File.Delete(printReceiptFilePath);
}
if (File.Exists(qrCodeImagepath))
{
File.Delete(qrCodeImagepath);
}
Microsoft.Office.Interop.PowerPoint.Presentations presprint = app.Presentations;
work = presprint.Open(printTemplateFilePath, Microsoft.Office.Core.MsoTriState.msoCTrue, Microsoft.Office.Core.MsoTriState.msoCTrue, Microsoft.Office.Core.MsoTriState.msoFalse);
work.PrintOptions.PrintInBackground = Microsoft.Office.Core.MsoTriState.msoFalse;
Microsoft.Office.Interop.PowerPoint.Slide slide = work.Slides[1];
foreach (var item in slide.Shapes)
{
var shape = (Microsoft.Office.Interop.PowerPoint.Shape)item;
if (shape.HasTextFrame == MsoTriState.msoTrue)
{
if (shape.TextFrame.HasText == MsoTriState.msoTrue)
{
var textRange = shape.TextFrame.TextRange;
var text = textRange.Text;
if (text.Contains("10%"))
{
text = text.Replace("10", discountValueOnProduct);
shape.TextFrame.TextRange.Text = text;
}
else if (text.Contains("Microsoft"))
{
text = text.Replace("Microsoft", companyName);
shape.TextFrame.TextRange.Text = text;
}
else if (text.Contains("Windows Phone 8"))
{
text = text.Replace("Windows Phone 8", discountProductName);
shape.TextFrame.TextRange.Text = text;
}
}
}
else
{
if (shape.Name.ToString() == "Picture 2")
{
shape.Delete();
//Add QRCode to print
RippleCommonUtilities.HelperMethods.GenerateQRCode("http://projectripple.azurewebsites.net/Ripple.aspx", qrCodeImagepath);
slide.Shapes.AddPicture(qrCodeImagepath, MsoTriState.msoFalse, MsoTriState.msoTrue, 560, 90, 80, 80);
}
}
}
work.SaveAs(printReceiptFilePath);
work.PrintOut();
work.Close();
app.Quit();
//delete the PrintReceipt File
File.Delete(printReceiptFilePath);
//Delete the QRCOde image
File.Delete(qrCodeImagepath);
}
catch (System.Exception ex)
{
work.Close();
app.Quit();
//delete the PrintReceipt File
File.Delete(printReceiptFilePath);
//Delete the QRCOde image
File.Delete(qrCodeImagepath);
RippleCommonUtilities.LoggingHelper.LogTrace(1, "Went wrong in Print Discount Coupon at Screen side: {0}", ex.Message);
}
}
private void createSlideFromTemplate()
{
//Create a new presentation based on a template.
objApp = new Microsoft.Office.Interop.PowerPoint.Application();
objApp.Visible = MsoTriState.msoTrue;
objPresSet = objApp.Presentations;
objPres = objPresSet.Open(strTemplate,
MsoTriState.msoFalse, MsoTriState.msoTrue, MsoTriState.msoTrue);
objSlides = objPres.Slides;
}
public PowerPointControl()
{
// OpenFileDialog Instanz erzeugen
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
// Dateiendungs-Filter setzen
dlg.DefaultExt = ".pptx";
dlg.Filter = "Powerpoint|*.ppt;*.pptx|All files|*.*";
// OpenFileDialog anzeigen
Nullable<bool> result = dlg.ShowDialog();
// PowerPoint Instanz erzeugen
oPPT = new Microsoft.Office.Interop.PowerPoint.Application();
// PowerPoint anzeigen
oPPT.Visible = Microsoft.Office.Core.MsoTriState.msoTrue;
objPresSet = oPPT.Presentations;
// Wenn der Benutzer im OpenFileDialog eine Datei ausgewählt + auf OK geklickt hat
if (result == true)
{
// Ausgewählte Datei (Präsentation) öffnen
objPres = objPresSet.Open(dlg.FileName, MsoTriState.msoFalse, MsoTriState.msoTrue, MsoTriState.msoTrue);
// Präsentationsansicht öffnen
objPres.SlideShowSettings.ShowPresenterView = MsoTriState.msoFalse;
System.Diagnostics.Debug.WriteLine(objPres.SlideShowSettings.ShowWithAnimation);
objPres.SlideShowSettings.Run();
oSlideShowView = objPres.SlideShowWindow.View;
}
}
private void OpenPPT()
{
//Create an instance of PowerPoint.
oPPT = new Microsoft.Office.Interop.PowerPoint.Application();
// Show PowerPoint to the user.
oPPT.Visible = Microsoft.Office.Core.MsoTriState.msoTrue;
objPresSet = oPPT.Presentations;
string pptFilePath = "C:\\Users\\bastisusewind\\Desktop\\Test.pptx";
//open the presentation
objPres = objPresSet.Open(pptFilePath, MsoTriState.msoFalse,
MsoTriState.msoTrue, MsoTriState.msoTrue);
objPres.SlideShowSettings.ShowPresenterView = MsoTriState.msoFalse;
System.Diagnostics.Debug.WriteLine(objPres.SlideShowSettings.ShowWithAnimation);
objPres.SlideShowSettings.Run();
oSlideShowView = objPres.SlideShowWindow.View;
}
