如果可能的话，可以使用c#访问excel文件

本文关键字：访问 excel 文件 可以使 如果 | 更新日期: 2023-09-27 18:12:10

你好，简单的问题，我想进入一个文件夹寻找excel文件。然后进入每个excel文件，使用c#将红色字体颜色更改为黑色。这可能吗?

namespace Excel_font_color_change
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            List<string> HtmlPathList = new List<string>();
            string folderToSearch;
            FolderBrowserDialog fbd = new FolderBrowserDialog();
            fbd.ShowNewFolderButton = true;//allow user to create new folders through this dialog
            fbd.RootFolder = Environment.SpecialFolder.MyDocuments;//defaults to my computer
            System.Windows.Forms.DialogResult dr = fbd.ShowDialog();//make sure user clicks ok
            if (dr == DialogResult.OK)
            {
                folderToSearch = fbd.SelectedPath;//gets folder path
                try
                {
                    var allFiles = from files in Directory.EnumerateFiles(folderToSearch, "*.xls*", SearchOption.AllDirectories)
                                   select Path.GetFullPath(files);//gets all files with htm & htm + something for extensions
                    foreach (string filepath in allFiles)
                    {
                        HtmlPathList.Add(filepath);//adds each filepath found to the list
                    }
                }
                catch (UnauthorizedAccessException UAEx) { Console.WriteLine(UAEx.Message); }//error handling
                catch (PathTooLongException PathEx) { Console.WriteLine(PathEx.Message); }//error handling
                Console.WriteLine("1");
            }
        }
        private void button2_Click(object sender, EventArgs e)
        {
        }
    }

这就是我到目前为止所拥有的，我希望第二个按钮采用HtmlPathList中的文件路径，并将字体颜色编辑为黑色，如果它是红色的话。我正在寻找如何使用c#读取Excel文件的数据?现在。

如果可能的话，可以使用c#访问excel文件

查看这个库。它只适用于xlsx。

http://www.microsoft.com/en-us/download/details.aspx?id=5124

如果你想读取旧的xls文件，你可以使用互操作程序集。

http://www.microsoft.com/en-us/download/details.aspx?id=3508

此解决方案需要引用Excel互操作程序集(Excel必须安装在正在执行实用程序的机器上，因为互操作程序集在后台执行Excel):

    using Microsoft.Office.Interop.Excel;
    /// <summary>
    /// sets a cell range's font color
    /// </summary>
    /// <param name="filename"></param>
    /// <param name="startCell"></param>
    /// <param name="endCell"></param>
    /// <param name="color"></param>
    public void setCellRangeFontColor(string filename, string startCell, string endCell, string color)
    {
        Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
        if (xlApp == null)
        {
            MessageBox.Show("EXCEL could not be started. Check that your office installation and project references are correct.");
            return;
        }
        //xlApp.Visible = true;
        //Workbook wb = xlApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
        Workbook wb = xlApp.Workbooks.Open(filename,
                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);
        Worksheet ws = (Worksheet)wb.Worksheets[1];
        if (ws == null)
        {
            MessageBox.Show("Worksheet could not be created. Check that your office installation and project references are correct.");
        }
        ws.get_Range(startCell, endCell).Font.Color = System.Drawing.ColorTranslator.ToOle(Color.FromName(color));
        wb.Close(true, Type.Missing, Type.Missing);
        //wb.Save();
        xlApp.Quit();
        releaseObject(ws);
        releaseObject(wb);
        releaseObject(xlApp);
    }
    public static void releaseObject(object obj)
    {
        try
        {
            System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
            obj = null;
        }
        catch (Exception ex)
        {
            obj = null;
            //MessageBox.Show("Exception Occured while releasing object " + ex.ToString());
        }
        finally
        {
            GC.Collect();
        }
    }
相关文章：