public void SaveAsTest() { _Workbook target = Create_Workbook(); // TODO: Initialize to an appropriate value object Filename = null; // TODO: Initialize to an appropriate value object FileFormat = null; // TODO: Initialize to an appropriate value object Password = null; // TODO: Initialize to an appropriate value object WriteResPassword = null; // TODO: Initialize to an appropriate value object ReadOnlyRecommended = null; // TODO: Initialize to an appropriate value object CreateBackup = null; // TODO: Initialize to an appropriate value XlSaveAsAccessMode AccessMode = new XlSaveAsAccessMode(); // TODO: Initialize to an appropriate value object ConflictResolution = null; // TODO: Initialize to an appropriate value object AddToMru = null; // TODO: Initialize to an appropriate value object TextCodepage = null; // TODO: Initialize to an appropriate value object TextVisualLayout = null; // TODO: Initialize to an appropriate value object Local = null; // TODO: Initialize to an appropriate value target.SaveAs(Filename, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AccessMode, ConflictResolution, AddToMru, TextCodepage, TextVisualLayout, Local); Assert.Inconclusive("A method that does not return a value cannot be verified."); }
public void _SaveAs(object filename, object fileFormat, object password, object writeResPassword, object readOnlyRecommended, object createBackup, XlSaveAsAccessMode accessMode, object conflictResolution, object addToMru, object textCodepage, object textVisualLayout) { throw new NotImplementedException(); }
static void ExcelToPDF(string sourcePath, string ExportPath) { Microsoft.Office.Interop.Excel.Application excelApplication = new Microsoft.Office.Interop.Excel.Application(); Workbook excelWorkBook = null; string paramSourceBookPath = sourcePath; //@"C:\Users\Lucky s\Desktop\New folder (2)\StocksOnTheMove.xls"; object paramMissing = Type.Missing; string paramExportFilePath = ExportPath; // @"C:\Users\Lucky s\Desktop\New folder (2)\Test.pdf"; XlFixedFormatType paramExportFormat = XlFixedFormatType.xlTypePDF; XlFixedFormatQuality paramExportQuality = XlFixedFormatQuality.xlQualityStandard; bool paramOpenAfterPublish = true; bool paramIncludeDocProps = true; bool paramIgnorePrintAreas = false; object paramFromPage = Type.Missing; object paramToPage = Type.Missing; object oMissing = System.Reflection.Missing.Value; // object Format=XlFixedFormatType XlSaveAsAccessMode Mode = XlSaveAsAccessMode.xlNoChange; //excelWorkBook.Application.DisplayAlerts = false; try { // Open the source workbook. excelWorkBook = excelApplication.Workbooks.Open(paramSourceBookPath, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing); excelWorkBook.Activate(); // Save it in the target format. if (excelWorkBook != null) { //excelWorkBook.SaveAs(paramExportFilePath); // excelWorkBook.SaveAs(paramExportFilePath, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, true, false, XlSaveAsAccessMode.xlNoChange, XlSaveConflictResolution.xlLocalSessionChanges, Type.Missing, Type.Missing); excelWorkBook.ExportAsFixedFormat(paramExportFormat, paramExportFilePath, paramExportQuality, paramIncludeDocProps, paramIgnorePrintAreas, paramFromPage, paramToPage, paramOpenAfterPublish, paramMissing); } } catch (Exception ex) { // Respond to the error. } finally { // Close the workbook object. if (excelWorkBook != null) { excelWorkBook.Close(false, paramMissing, paramMissing); excelWorkBook = null; } // Quit Excel and release the ApplicationClass object. if (excelApplication != null) { excelApplication.Quit(); excelApplication = null; } GC.Collect(); GC.WaitForPendingFinalizers(); GC.Collect(); GC.WaitForPendingFinalizers(); } }
public void SaveAs(object filename, object fileFormat, object password, object writeResPassword, object readOnlyRecommended, object createBackup, XlSaveAsAccessMode accessMode, object conflictResolution, object addToMru, object textCodepage, object textVisualLayout, object local) { throw new NotImplementedException(); }
/// <summary>在另一不同文件中保存对工作簿所做的更改。 /// </summary> /// <param name="FileName">一个表示要保存文件的文件名的字符串。可包含完整路径,如果不指定路径,Microsoft Excel 将文件保存到当前文件夹中。</param> /// <param name="FileFormat">保存文件时使用的文件格式。要查看有效的选项列表,请参阅 FileFormat 属性。对于现有文件,默认采用上一次指定的文件格式;对于新文件,默认采用当前所用 Excel 版本的格式。</param> /// <param name="Password">它是一个区分大小写的字符串(最长不超过 15 个字符),用于指定文件的保护密码。</param> /// <param name="WriteResPassword">一个表示文件写保护密码的字符串。如果文件保存时带有密码,但打开文件时不输入密码,则该文件以只读方式打开。</param> /// <param name="ReadOnlyRecommended">如果为 True,则在打开文件时显示一条消息,提示该文件以只读方式打开。</param> /// <param name="CreateBackup">如果为 True,则创建备份文件。</param> /// <param name="AccessMode">工作簿的访问模式。</param> /// <param name="ConflictResolution">一个 XlSaveConflictResolution 值,它确定该方法在保存工作簿时如何解决冲突。如果设为 xlUserResolution,则显示冲突解决对话框。如果设为 xlLocalSessionChanges,则自动接受本地用户的更改。如果设为 xlOtherSessionChanges,则自动接受来自其他会话的更改(而不是本地用户的更改)。如果省略此参数,则显示冲突处理对话框。</param> /// <param name="AddToMru">如果为 True,则将该工作簿添加到最近使用的文件列表中。默认值为 False。</param> /// <param name="TextCodepage">不在美国英语版的 Microsoft Excel 中使用。</param> /// <param name="TextVisualLayout">不在美国英语版的 Microsoft Excel 中使用。</param> /// <param name="Local">如果为 True,则以 Microsoft Excel(包括控制面板设置)的语言保存文件。如果为 False(默认值),则以 Visual Basic for Applications (VBA) (Visual Basic for Applications (VBA):Microsoft Visual Basic 的宏语言版本,用于编写基于 Microsoft Windows 的应用程序,内置于多个 Microsoft 程序中。) 的语言保存文件,其中 Visual Basic for Applications (VBA) 通常为美国英语版本,除非从中运行 Workbooks.Open 的 VBA 项目是旧的已国际化的 XL5/95 VBA 项目。</param> public void SaveAs(string FileName, XlFileFormat? FileFormat = null, string Password = null, string WriteResPassword = null, bool? ReadOnlyRecommended = null, bool? CreateBackup = null, XlSaveAsAccessMode? AccessMode = null, XlSaveConflictResolution? ConflictResolution = null, bool? AddToMru = null, object TextCodepage = null, object TextVisualLayout = null, bool? Local = null) { if (FileName == null || FileName == string.Empty) throw new ArgumentNullException("The param \"FileName\" can't be a null value"); _objaParameters = new Object[12] { FileName, FileFormat == null ? System.Type.Missing : FileFormat, Password == null ? System.Type.Missing : Password, WriteResPassword == null ? System.Type.Missing : WriteResPassword, ReadOnlyRecommended == null ? System.Type.Missing : ReadOnlyRecommended, CreateBackup == null ? System.Type.Missing : CreateBackup, AccessMode == null ? System.Type.Missing : AccessMode, ConflictResolution == null ? System.Type.Missing : ConflictResolution, AddToMru == null ? System.Type.Missing : AddToMru, TextCodepage == null ? System.Type.Missing : TextCodepage, TextVisualLayout == null ? System.Type.Missing : TextVisualLayout, Local == null ? System.Type.Missing : Local }; _objWorkbook.GetType().InvokeMember("SaveAs", BindingFlags.InvokeMethod, null, _objWorkbook, _objaParameters); }