我想打开一个excel文件,并将其另存为csv文件。谷歌搜索不走运。我需要用C语言编写这样的代码。
谢谢你的帮助。
发布于 2014-06-18 04:27:07
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Office.Interop.Excel;
using System.IO;
namespace TestConsoleApp
{
class Program
{
static void Main(string[] args)
{
String fromFile = @"C:\ExlTest\Test.xlsx";
String toFile = @"C:\ExlTest\csv\Test.csv";
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wb = app.Workbooks.Open(fromFile, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
// this does not throw exception if file doesnt exist
File.Delete(toFile);
wb.SaveAs(toFile, Microsoft.Office.Interop.Excel.XlFileFormat.xlCSVWindows, Type.Missing, Type.Missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Microsoft.Office.Interop.Excel.XlSaveConflictResolution.xlLocalSessionChanges, false, Type.Missing, Type.Missing, Type.Missing);
wb.Close(false,Type.Missing,Type.Missing);
app.Quit();
}
}
}https://stackoverflow.com/questions/5034717
复制相似问题