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);
}
