本文整理汇总了C#中Microsoft.Office.Interop.Excel.SaveAs方法的典型用法代码示例。如果您正苦于以下问题:C# Microsoft.Office.Interop.Excel.SaveAs方法的具体用法?C# Microsoft.Office.Interop.Excel.SaveAs怎么用?C# Microsoft.Office.Interop.Excel.SaveAs使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Microsoft.Office.Interop.Excel
的用法示例。
在下文中一共展示了Microsoft.Office.Interop.Excel.SaveAs方法的10个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ExcelDispose
/// <summary>
/// 저장및 메모리 해제
/// </summary>
/// <param name="excelApp"></param>
/// <param name="wb"></param>
/// <param name="workSheet"></param>
public static void ExcelDispose(Excel.Application excelApp, Excel.Workbook wb, Excel._Worksheet workSheet)
{
wb.SaveAs(@"C:\users\user\Desktop\수강신청시간표", Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
wb.Close(Type.Missing, Type.Missing, Type.Missing);
excelApp.Quit();
releaseObject(excelApp);
releaseObject(workSheet);
releaseObject(wb);
}
示例2: SaveExcel
public static void SaveExcel(string filePath, Excel.Workbook workbook)
{
try
{
object misValue = System.Reflection.Missing.Value;
workbook.SaveAs(filePath, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
workbook.Close(true, misValue, misValue);
}
catch (Exception ex)
{
throw ex;
}
}
示例3: saveAsWorkBook
public static void saveAsWorkBook(Excel.Workbook wb, string path)
{
wb.SaveAs(path, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}
示例4: PrintFpcLotCard
//.........这里部分代码省略.........
dgvList.AutoResizeColumns();
//显示
Application.DoEvents();
//设置为活动
((Excel._Workbook)xlBook).Activate();
((Excel._Worksheet)xlSheet).Select();
//在excel中插入该图片并设置分页
string strError = string.Empty;
if (!InsertDanTiTuImageToExcelSheet(xlSheet, imgName, out strError))
{
//返回错误
dgvRow.Cells["print_msg"].Value = "插入单体图图片到批量卡失败!";
return;
}
}
//退出
break;
}
//待打印成的文件名称
string tmpFileName = string.Format("{0}lotcard.xls", strPath);
//删除之前的文件
if (File.Exists(tmpFileName))
{
File.Delete(tmpFileName);
}
//打印设置
var xlPageSetup = xlSheet.PageSetup;
xlPageSetup.FitToPagesWide = 1;
xlPageSetup.FitToPagesTall = 1;
xlPageSetup.RightFooter = @"&""宋体,倾斜""&10打印时间:&D &T";
xlPageSetup.FooterMargin = xlApp.InchesToPoints(0.18d);
//保存该批量卡
xlBook.SaveAs(tmpFileName);
//不打印只保存批量卡和cov卡
//不打印只保存单元图
//不打印保存批量卡和cov卡以及单元图
//只打印批量卡和cov卡
//只打印单元图
//打印批量卡和cov卡以及单元图
//打印
switch (cboPrintSettings.Text.Trim())
{
case "打印批量卡和cov卡以及单元图":
//显示状态
dgvRow.Cells["print_msg"].Value = "正在打印批量卡和cov卡以及单元图...";
//各列列宽
dgvList.AutoResizeColumns();
//显示
Application.DoEvents();
//打印LOT卡和单体图
xlSheet.PrintOut(From: 1, To: 2, Copies: 1, Collate: true);
break;
case "只打印批量卡":
//显示状态
dgvRow.Cells["print_msg"].Value = "正在打印批量卡...";
//各列列宽
dgvList.AutoResizeColumns();
//显示
Application.DoEvents();
//打印LOT卡
xlSheet.PrintOut(From: 1, To: 1, Copies: 1, Collate: true);
break;
case "只打印批量卡和cov卡":
//显示状态
示例5: SaveAsWB
public static void SaveAsWB(Excel.Workbook xlWb, string filePath)
{
xlWb.SaveAs(filePath, System.Type.Missing, System.Type.Missing, System.Type.Missing
, System.Type.Missing, System.Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, System.Type.Missing
, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing);
}
示例6: SaveAs
/// <summary>
/// 另存为文件
/// </summary>
/// <param name="CurBook">Workbook</param>
/// <param name="strFilePath">文件路径</param>
public void SaveAs(Excel._Workbook CurBook, string strFilePath)
{
CurBook.SaveAs(strFilePath, mValue, mValue, mValue, mValue, mValue, Excel.XlSaveAsAccessMode.xlNoChange, mValue, mValue, mValue, mValue, mValue);
}
示例7: SaveAs
/// <summary>
/// Workbookを別名保存
/// </summary>
/// <param name="book">Workbook</param>
/// <param name="oPath">保存先のファイルパス</param>
public void SaveAs(Excel.Workbook book, string oPath)
{
foreach (char c in Path.GetInvalidPathChars()) {
if (oPath.Contains(c))
throw new FormatException(
this.GetType().FullName + "." +
MethodBase.GetCurrentMethod().Name);
}
Excel.XlSaveAsAccessMode oMod = Excel.XlSaveAsAccessMode.xlNoChange;
object oFmt = Excel.XlFileFormat.xlOpenXMLWorkbook;//xlsx
book.SaveAs(
Filename: oPath,
FileFormat: oFmt,
AccessMode: oMod);
}
示例8: SaveExportCustom
public static string SaveExportCustom(Excel.Workbook Book, string report_name, bool isXlsFormat = false)
{
object Missing = System.Reflection.Missing.Value;
string str = "";
try
{
report_name = report_name.Remove(report_name.LastIndexOf('.'));
SaveFileDialog sDialog = new SaveFileDialog();
str = string.Format(@"{0}_{1}_{2}", report_name, DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss"), DateTime.Now.Ticks);
sDialog.Filter = isXlsFormat ? "Microsoft Excel (*.xls)|*.xls" : "Microsoft Excel 2007 (*.xlsx)|*.xlsx";
sDialog.Title = LanguageEngine.GetMessageCaption("000007", ConfigEngine.Language);
sDialog.InitialDirectory = Temp;
sDialog.FileName = str;
if (sDialog.ShowDialog() == DialogResult.OK)
{
str = sDialog.FileName;
Book.SaveAs(str, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Missing, Missing, Missing, Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Missing, Missing, Missing, Missing, Missing);
CommonEngine.ShowMessage(ConfigEngine.Language.Equals("vi") ? "Tải tập tin mẫu thành công!" : "Download template success!", MessageType.Success);
}
}
catch (Exception ex)
{
logger.Error(ex);
}
return str;
}
示例9: SaveTempWorkbook
public static void SaveTempWorkbook(Excel.Workbook tempWorkbook)
{
if (tempWorkbook != null)
{
//string folder = System.Reflection.Assembly.GetExecutingAssembly().CodeBase.Remove(System.Reflection.Assembly.GetExecutingAssembly().CodeBase.LastIndexOf("/"));
//folder = folder.Replace(@"file:///", "");
//if (!Directory.Exists(folder + "/temp"))
// Directory.CreateDirectory(folder + "/temp");
//tempWorkbook.SaveAs(folder + "/temp/book1.xls");
tempWorkbook.SaveAs("book1.xls");
string fullname = tempWorkbook.FullName;
tempWorkbook.Close();
if (File.Exists(fullname))
File.Delete(fullname);
ExcelUtilies.ReleaseComObject(tempWorkbook);
}
}
示例10: SaveExcel
private void SaveExcel(string file, MSExcel.Application excel, MSExcel.Workbook wbook)
{
try
{
File.Delete(file);
}
catch //(Exception ex)
{
wbook.Close(false);
excel.Quit();
return;
}
try
{
wbook.SaveAs(file, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, MSExcel.XlSaveAsAccessMode.xlExclusive);
}
catch//(Exception ex)
{
}
wbook.Close(false);
excel.Quit();
}