public void ImportOdf(string odfFileName)
{
try
{
// call the exposed add-in method for importing ODF
_application.Invoke("COMAddIns", _progIdAddin).Invoke("Object").Invoke("importOdfFile", odfFileName);
}
catch (Exception ex)
{
Trace.WriteLine(ex.ToString());
throw;
}
}
/// <summary>
/// Read an ODF file.
/// </summary>
public override bool importOdfFile(string odfFile)
{
try
{
bool isTemplate = Path.GetExtension(odfFile).ToUpper().Equals(".OTS");
// create a temporary file
string outputExtension = isTemplate ? ".xltx" : ".xlsx";
string fileName = this._addinLib.GetTempFileName(odfFile, outputExtension);
ConversionOptions options = new ConversionOptions();
options.InputFullName = odfFile;
options.OutputFullName = fileName;
options.ConversionDirection = ConversionDirection.OdsToXlsx;
options.Generator = this.GetGenerator();
options.DocumentType = isTemplate ? DocumentType.Template : DocumentType.Document;
options.ShowProgress = true;
options.ShowUserInterface = true;
this._addinLib.OdfToOox(odfFile, fileName, options);
// open the document
bool confirmConversions = false;
bool readOnly = true;
bool addToRecentFiles = false;
bool isVisible = true;
bool openAndRepair = false;
// conversion may have been cancelled and file deleted.
if (File.Exists((string)fileName))
{
// Workaround to excel bug. "Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))"
System.Globalization.CultureInfo ci;
ci = System.Threading.Thread.CurrentThread.CurrentCulture;
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
LateBindingObject doc = OpenDocument(fileName, confirmConversions, readOnly, addToRecentFiles, isVisible, openAndRepair);
// and activate it
doc.Invoke("Activate");
System.Threading.Thread.CurrentThread.CurrentCulture = ci;
}
return(true);
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(ex.ToString());
System.Windows.Forms.MessageBox.Show(this._addinLib.GetString("OdfUnexpectedError"), DialogBoxTitle, System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Stop);
return(false);
}
}
/// <summary>
/// Save as ODF.
/// </summary>
public override bool ExportOdf()
{
System.Globalization.CultureInfo ci;
ci = System.Threading.Thread.CurrentThread.CurrentCulture;
try
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
LateBindingObject doc = _application.Invoke("ActiveWorkbook");
// the second test deals with blank documents
// (which are in a 'saved' state and have no extension yet(?))
if (!doc.GetBool("Saved") ||
doc.GetString("FullName").IndexOf('.') < 0 ||
doc.GetString("FullName").IndexOf("http://") == 0 ||
doc.GetString("FullName").IndexOf("https://") == 0 ||
doc.GetString("FullName").IndexOf("ftp://") == 0
)
{
System.Windows.Forms.MessageBox.Show(_addinLib.GetString("OdfSaveDocumentBeforeExport"), DialogBoxTitle, System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Stop);
return(false);
}
else
{
System.Windows.Forms.SaveFileDialog sfd = new System.Windows.Forms.SaveFileDialog();
sfd.AddExtension = true;
sfd.DefaultExt = "ods";
sfd.Filter = this._addinLib.GetString(this.OdfFileType) + this.ExportOdfFileFilter
+ this._addinLib.GetString(ALL_FILE_TYPE) + this.ExportAllFileFilter;
sfd.InitialDirectory = doc.GetString("Path");
sfd.OverwritePrompt = true;
sfd.Title = this._addinLib.GetString(EXPORT_LABEL);
string ext = '.' + sfd.DefaultExt;
sfd.FileName = doc.GetString("FullName").Substring(0, doc.GetString("FullName").LastIndexOf('.')) + ext;
// process the chosen documents
if (System.Windows.Forms.DialogResult.OK == sfd.ShowDialog())
{
// name of the file to create
string odfFileName = sfd.FileName;
// multi dotted extensions support
if (!odfFileName.EndsWith(ext))
{
odfFileName += ext;
}
// name of the document to convert
string sourceFileName = doc.GetString("FullName");
// name of the temporary Word12 file created if current file is not already a Word12 document
string tempXlsxName = null;
if (!(doc.GetInt32("FileFormat") == (int)XlFileFormat.xlOpenXMLWorkbook ||
doc.GetInt32("FileFormat") == (int)XlFileFormat.xlOpenXMLWorkbookMacroEnabled ||
doc.GetInt32("FileFormat") == (int)XlFileFormat.xlOpenXMLTemplate ||
doc.GetInt32("FileFormat") == (int)XlFileFormat.xlOpenXMLTemplateMacroEnabled ||
doc.GetInt32("FileFormat") == (int)XlFileFormat.xlExcel12))
{
// if file is not currently in Excel12 format
// 1. Create a copy
// 2. Open it and do a "Save as Excel12" (copy needed not to perturb current openened document
// 3. Convert the Excel12 copy to ODF
// 4. Remove both temporary created files
// duplicate the file to keep current file "as is"
string tempCopyName = Path.GetTempFileName() + Path.GetExtension((string)sourceFileName);
File.Copy((string)sourceFileName, (string)tempCopyName);
//BUG FIX #1743469
FileInfo fi = new FileInfo(tempCopyName);
if (fi.IsReadOnly)
{
fi.IsReadOnly = false;
}
//BUG FIX #1743469
// open the duplicated file
bool confirmConversions = false;
bool readOnly = false;
bool addToRecentFiles = false;
bool isVisible = false;
LateBindingObject newDoc = OpenDocument(tempCopyName, confirmConversions, readOnly, addToRecentFiles, isVisible, false);
newDoc.Invoke("Windows").Invoke("Item", 1).SetBool("Visible", false);
// generate xlsx file from the duplicated file (under a temporary file)
tempXlsxName = this._addinLib.GetTempPath((string)sourceFileName, ".xlsx");
SaveDocumentAs(newDoc, tempXlsxName);
// close and remove the duplicated file
newDoc.Invoke("Close", WdSaveOptions.wdDoNotSaveChanges, WdOriginalFormat.wdOriginalDocumentFormat, Type.Missing);
//BUG FIX #1743469
try
{
File.Delete((string)tempCopyName);
}
catch (Exception ex)
{
//If delete does not work, don't stop the rest of the process
//The tempFile will be deleted by the system
System.Diagnostics.Trace.WriteLine(ex.ToString());
}
//BUG FIX #1743469
// Now the file to be converted is
sourceFileName = tempXlsxName;
}
ConversionOptions options = new ConversionOptions();
options.InputFullName = sourceFileName;
options.InputFullNameOriginal = doc.GetString("FullName");
options.OutputFullName = odfFileName;
options.ConversionDirection = ConversionDirection.XlsxToOds;
options.Generator = this.GetGenerator();
options.DocumentType = Path.GetExtension(odfFileName).ToUpper().Equals(".OTS") ? DocumentType.Template : DocumentType.Document;
options.ShowProgress = true;
options.ShowUserInterface = true;
this._addinLib.OoxToOdf(sourceFileName, odfFileName, options);
if (tempXlsxName != null && File.Exists((string)tempXlsxName))
{
this._addinLib.DeleteTempPath((string)tempXlsxName);
}
}
return(true);
}
}
finally
{
System.Threading.Thread.CurrentThread.CurrentCulture = ci;
}
}
/// <summary>
/// Save as ODF.
/// </summary>
public override bool ExportOdf()
{
// check if Word12 converter is installed
if (_word12SaveFormat == -1)
{
System.Windows.Forms.MessageBox.Show(_addinLib.GetString("OdfConverterNotInstalled"), DialogBoxTitle, System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Stop);
return(false);
}
LateBindingObject doc = _application.Invoke("ActiveDocument");
// the second test deals with blank documents
// (which are in a 'saved' state and have no extension yet(?))
if (!doc.GetBool("Saved") ||
doc.GetString("FullName").IndexOf('.') < 0 ||
doc.GetString("FullName").IndexOf("http://") == 0 ||
doc.GetString("FullName").IndexOf("https://") == 0 ||
doc.GetString("FullName").IndexOf("ftp://") == 0
)
{
System.Windows.Forms.MessageBox.Show(_addinLib.GetString("OdfSaveDocumentBeforeExport"), DialogBoxTitle, System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Stop);
return(false);
}
else
{
System.Windows.Forms.SaveFileDialog sfd = new System.Windows.Forms.SaveFileDialog();
sfd.AddExtension = true;
sfd.DefaultExt = "odt";
sfd.Filter = this._addinLib.GetString(this.OdfFileType) + this.ExportOdfFileFilter
+ this._addinLib.GetString(ODF_FILE_TYPE_OTT) + EXPORT_ODF_FILE_FILTER_OTT
+ this._addinLib.GetString(ALL_FILE_TYPE) + this.ExportAllFileFilter;
sfd.InitialDirectory = doc.GetString("Path");
sfd.OverwritePrompt = true;
sfd.SupportMultiDottedExtensions = true;
sfd.Title = this._addinLib.GetString(EXPORT_LABEL);
string ext = '.' + sfd.DefaultExt;
sfd.FileName = doc.GetString("FullName").Substring(0, doc.GetString("FullName").LastIndexOf('.')); // +ext;
// process the chosen documents
if (System.Windows.Forms.DialogResult.OK == sfd.ShowDialog())
{
// name of the file to create
string odfFileName = sfd.FileName;
// multi dotted extensions support
// Note: sfd.FilterIndex is 1-based
if (!odfFileName.ToLower().EndsWith(".odt") && sfd.FilterIndex == 1)
{
odfFileName += ".odt";
}
else if (!odfFileName.ToLower().EndsWith(".ott") && sfd.FilterIndex == 2)
{
odfFileName += ".ott";
}
// name of the document to convert
string sourceFileName = doc.GetString("FullName");
// name of the temporary Word12 file created if current file is not already a Word12 document
string tempDocxName = null;
// store current cursor
WdCursorType currentCursor = (WdCursorType)_application.Invoke("System").GetInt32("Cursor");
// display hourglass
this._application.Invoke("System").SetInt32("Cursor", (int)WdCursorType.wdCursorWait);
if (!(doc.GetInt32("SaveFormat") == (int)WdSaveFormat.wdFormatXMLDocument ||
doc.GetInt32("SaveFormat") == (int)WdSaveFormat.wdFormatXMLDocumentMacroEnabled ||
doc.GetInt32("SaveFormat") == (int)WdSaveFormat.wdFormatXMLTemplate ||
doc.GetInt32("SaveFormat") == (int)WdSaveFormat.wdFormatXMLTemplateMacroEnabled))
{
try
{
// if file is not currently in Word12 format
// 1. Create a copy
// 2. Open it and do a "Save as Word12" (copy needed not to perturb current openened document
// 3. Convert the Word12 copy to ODF
// 4. Remove both temporary created files
// duplicate the file to keep current file "as is"
string tempCopyName = Path.GetTempFileName() + Path.GetExtension((string)sourceFileName);
File.Copy((string)sourceFileName, (string)tempCopyName);
//BUG FIX #1743469
FileInfo fi = new FileInfo(tempCopyName);
if (fi.IsReadOnly)
{
fi.IsReadOnly = false;
}
//BUG FIX #1743469
// open the duplicated file
bool confirmConversions = false;
bool readOnly = false;
bool addToRecentFiles = false;
bool isVisible = false;
LateBindingObject newDoc = OpenDocument(tempCopyName, confirmConversions, readOnly, addToRecentFiles, isVisible, false);
newDoc.Invoke("Windows").Invoke("Item", 1).SetBool("Visible", false);
// generate docx file from the duplicated file (under a temporary file)
string outputExtension =
tempDocxName = this._addinLib.GetTempPath((string)sourceFileName, ".docx");
SaveDocumentAs(newDoc, tempDocxName);
// close and remove the duplicated file
newDoc.Invoke("Close", WdSaveOptions.wdDoNotSaveChanges, WdOriginalFormat.wdOriginalDocumentFormat, Type.Missing);
//BUG FIX #1743469
try
{
File.Delete((string)tempCopyName);
}
catch (Exception ex)
{
//If delete does not work, don't stop the rest of the process
//The tempFile will be deleted by the system
System.Diagnostics.Trace.WriteLine(ex.ToString());
}
//BUG FIX #1743469
// Now the file to be converted is
sourceFileName = tempDocxName;
}
catch (Exception ex)
{
_application.Invoke("System").SetInt32("Cursor", (int)currentCursor);
String lMsg;
lMsg = _addinLib.GetString("OdfExportErrorTryDocxFirst");
System.Windows.Forms.MessageBox.Show(lMsg, DialogBoxTitle, System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Stop);
System.Diagnostics.Trace.WriteLine(ex.ToString());
return(false);
}
}
ConversionOptions options = new ConversionOptions();
options.InputFullName = sourceFileName;
options.OutputFullName = odfFileName;
options.InputFullNameOriginal = doc.GetString("FullName");
options.ConversionDirection = ConversionDirection.DocxToOdt;
options.Generator = this.GetGenerator();
options.DocumentType = Path.GetExtension(odfFileName).ToUpper().Equals(".OTT") ? DocumentType.Template : DocumentType.Document;
options.ShowProgress = true;
options.ShowUserInterface = true;
this._addinLib.OoxToOdf(sourceFileName, odfFileName, options);
if (tempDocxName != null && File.Exists((string)tempDocxName))
{
this._addinLib.DeleteTempPath((string)tempDocxName);
}
_application.Invoke("System").SetInt32("Cursor", (int)currentCursor);
}
return(true);
}
}