有没有什么简单的方法可以将 .xls 文件转换为 .csv 文件?(Excel) [英] Is there any simple way to convert .xls file to .csv file? (Excel)

问题描述

有没有什么简单的方法可以将 .xls 文件转换为 .csv 文件?(Excel)

Is there any simple way to convert .xls file to .csv file ? (Excel)

在 C# 代码中?

我的意思是将现有的 .xls 文件转换为 .csv 文件

i mean to take an existing .xls file and convert them to .csv file

提前致谢

推荐答案

这里有一个 C# 方法可以做到这一点.请记住添加您自己的错误处理 - 这主要是为了简洁起见假设事情有效.它只是 4.0+ 框架，但这主要是因为可选的 worksheetNumber 参数.如果需要支持早期版本，可以重载该方法.

Here's a C# method to do this. Remember to add your own error handling - this mostly assumes that things work for the sake of brevity. It's 4.0+ framework only, but that's mostly because of the optional worksheetNumber parameter. You can overload the method if you need to support earlier versions.

static void ConvertExcelToCsv(string excelFilePath, string csvOutputFile, int worksheetNumber = 1) {
   if (!File.Exists(excelFilePath)) throw new FileNotFoundException(excelFilePath);
   if (File.Exists(csvOutputFile)) throw new ArgumentException("File exists: " + csvOutputFile);

   // connection string
   var cnnStr = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties="Excel 8.0;IMEX=1;HDR=NO"", excelFilePath);
   var cnn = new OleDbConnection(cnnStr);

   // get schema, then data
   var dt = new DataTable();
   try {
      cnn.Open();
      var schemaTable = cnn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
      if (schemaTable.Rows.Count < worksheetNumber) throw new ArgumentException("The worksheet number provided cannot be found in the spreadsheet");
      string worksheet = schemaTable.Rows[worksheetNumber - 1]["table_name"].ToString().Replace("'", "");
      string sql = String.Format("select * from [{0}]", worksheet);
      var da = new OleDbDataAdapter(sql, cnn);
      da.Fill(dt);
   }
   catch (Exception e) {
      // ???
      throw e;
   }
   finally {
      // free resources
      cnn.Close();
   }

   // write out CSV data
   using (var wtr = new StreamWriter(csvOutputFile)) {
      foreach (DataRow row in dt.Rows) {
         bool firstLine = true;
         foreach (DataColumn col in dt.Columns) {
            if (!firstLine) { wtr.Write(","); } else { firstLine = false; }
            var data = row[col.ColumnName].ToString().Replace(""", """");
            wtr.Write(String.Format(""{0}"", data));
         }
         wtr.WriteLine();
      }
   }
}

这篇关于有没有什么简单的方法可以将 .xls 文件转换为 .csv 文件?(Excel)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！