×

Loading...
Ad by
Ad by

@Las Vegas

贴出原代码，欢迎转载，讨论

binghongcha76(一只大猫)
   1:   
   2:  using System;
   3:  using System.Collections.Generic;
   4:  using System.Linq;
   5:  using System.Text;
   6:  using System.IO;
   7:  using Excel = Microsoft.Office.Interop.Excel;
   8:   
   9:  namespace ConsoleApplication4
  10:  {
  11:      class Program
  12:      {
  13:          static void Main(string[] args)
  14:          {
  15:              if (args.Length == 3)
  16:              {
  17:                  string dir = args[0];
  18:                  string oldName = args[1];
  19:                  string newName = args[2];
  20:   
  21:                  var excelFiles = (new DirectoryInfo(dir))
  22:                                  .GetFiles()
  23:                                  .Where(file => file.Extension.EndsWith("xlsx"));
  24:   
  25:                  foreach (var excelFile in excelFiles)
  26:                  {
  27:                      changeSheetNameAndSave(excelFile.FullName, oldName, newName);
  28:                  }
  29:   
  30:                  Console.WriteLine("finished converting, press enter to exist");
  31:                  Console.ReadLine();
  32:              }
  33:              else
  34:              {
  35:                  Console.ForegroundColor = ConsoleColor.Yellow;
  36:                  Console.WriteLine("you have to input 3 parameters: folder path(example: c:\\zzz\\ccc\\xxx),old sheet name to be replaced, new sheet name");
  37:                  Console.ForegroundColor = ConsoleColor.White;
  38:                  Console.ReadLine();
  39:              }
  40:          }
  41:   
  42:          static void changeSheetNameAndSave(string excelFileName, string oldSheetName, string newSheetName)
  43:          {
  44:              var excelApplication = new Excel.Application();
  45:              excelApplication.Workbooks.Open(excelFileName);
  46:              var workBook = excelApplication.ActiveWorkbook;
  47:              foreach (var sheet in workBook.Sheets)
  48:              {
  49:                  if (((dynamic)sheet).Name == oldSheetName)
  50:                  {
  51:                      ((dynamic)sheet).Name = newSheetName;
  52:                      break;
  53:                  }
  54:              }
  55:   
  56:              workBook.Save();
  57:              workBook.Close();
  58:          }
  59:      }
  60:  }
(#6632261@0)
Last Updated: 2011-4-20
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / 学科技术讨论 / Excel question: there are multiple excel files that all contain a sheet with same sheet name, such as AAA. Now I want to change the sheet name to BBB. I don't want to repeat open-rename-close the files, does anyone know how to change sheet name at once. -xxu99(春眠不觉晓); 2011-4-19 {10} (#6630530@0)
    Thank you.
    • 不知道有什么常规做法，但是花了几分钟写了一个.net程序可以帮你转换，如果需要，pm 你的邮箱，前提是你需要安装.net 4.0 -binghongcha76(一只大猫); 2011-4-20 (#6632172@0)
      • 贴出原代码，欢迎转载，讨论 -binghongcha76(一只大猫); 2011-4-20 {6510} (#6632261@0) 
           1:   
           2:  using System;
           3:  using System.Collections.Generic;
           4:  using System.Linq;
           5:  using System.Text;
           6:  using System.IO;
           7:  using Excel = Microsoft.Office.Interop.Excel;
           8:   
           9:  namespace ConsoleApplication4
          10:  {
          11:      class Program
          12:      {
          13:          static void Main(string[] args)
          14:          {
          15:              if (args.Length == 3)
          16:              {
          17:                  string dir = args[0];
          18:                  string oldName = args[1];
          19:                  string newName = args[2];
          20:   
          21:                  var excelFiles = (new DirectoryInfo(dir))
          22:                                  .GetFiles()
          23:                                  .Where(file => file.Extension.EndsWith("xlsx"));
          24:   
          25:                  foreach (var excelFile in excelFiles)
          26:                  {
          27:                      changeSheetNameAndSave(excelFile.FullName, oldName, newName);
          28:                  }
          29:   
          30:                  Console.WriteLine("finished converting, press enter to exist");
          31:                  Console.ReadLine();
          32:              }
          33:              else
          34:              {
          35:                  Console.ForegroundColor = ConsoleColor.Yellow;
          36:                  Console.WriteLine("you have to input 3 parameters: folder path(example: c:\\zzz\\ccc\\xxx),old sheet name to be replaced, new sheet name");
          37:                  Console.ForegroundColor = ConsoleColor.White;
          38:                  Console.ReadLine();
          39:              }
          40:          }
          41:   
          42:          static void changeSheetNameAndSave(string excelFileName, string oldSheetName, string newSheetName)
          43:          {
          44:              var excelApplication = new Excel.Application();
          45:              excelApplication.Workbooks.Open(excelFileName);
          46:              var workBook = excelApplication.ActiveWorkbook;
          47:              foreach (var sheet in workBook.Sheets)
          48:              {
          49:                  if (((dynamic)sheet).Name == oldSheetName)
          50:                  {
          51:                      ((dynamic)sheet).Name = newSheetName;
          52:                      break;
          53:                  }
          54:              }
          55:   
          56:              workBook.Save();
          57:              workBook.Close();
          58:          }
          59:      }
          60:  }
        • workBook.Save(); 要在改名字之后，要不白存一次 -c1xwy(洪兴罩俺去战斗); 2011-4-20 {325} (#6632296@0)
          49: if (((dynamic)sheet).Name == oldSheetName)
          50: {
          51: ((dynamic)sheet).Name = newSheetName;
          workBook.Save();

          52: break;
          53: }
          54: }
          55:
          56: 57: workBook.Close();
          • OK，明白你的意思，确实应该这么改一下，thanks -binghongcha76(一只大猫); 2011-4-20 (#6632369@0)
        • 快猫． -healthy321(领导说:做人要低调.); 2011-4-20 (#6632368@0)
        • If we have both 2007 and 2003 spreadsheets? -deep_blue(BLUE); 2011-4-24 (#6638560@0)

More Topics

  • 现在社区游泳池招救生员巡逻，过一会还要不停的点人头，这工作是否很快就被AI代替了，装一个摄像头后面是AI处理系统，这样只招一个等着救人就行了，人头沉下水一定时间立马强光照射，还可以分析水下人的状况来判断是否溺水等
  • 新冠疫苗引发心肌炎? 最新研究这样看
  • 这道几何题有解吗?
  • SAM 2 Demo
  • 如何在 AWS EC2 实例上构建 WordPress 应用程序?
    • 枫下论坛主坛 /  工作学习 /  学科技术讨论