c#更新Excel中的数据链接

最新推荐文章于 2020-08-20 12:45:37 发布

转载最新推荐文章于 2020-08-20 12:45:37 发布 · 445 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/tanxstar/archive/2009/05/14/1456984.html

文章标签：

#c#

本文介绍了一个使用C#和Microsoft Office Interop Excel库的方法，用于递归地打开并更新Excel文件中的链接数据。此方法首先定义了一个名为RefreshExcelData的过程，该过程接受一个字符串参数作为Excel文件的路径。

Code
using Microsoft.Office.Interop.Excel;

private bool RefreshExcelData(string strFileName){
    object missing = System.Reflection.Missing.Value;
    ApplicationClass readApp = new ApplicationClass();
    Workbook readBook = null;
    try{
        readBook = readApp.Workbooks.Open(strFileName, 3, false, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
        Array links = (Array)readBook.LinkSources(XlLink.xlExcelLinks);
        if (links != null)
        {
            //递归更新源Excel
            foreach (string strName in links)
                RefreshExcelData(strName);

            //更新当前Excel
            foreach (string strName in links)
                readBook.UpdateLink(strName, XlLinkType.xlLinkTypeExcelLinks);

            //刷新计算
            readBook.RefreshAll();
            readBook.Save();
        }
    }
    catch(){}
}

using Microsoft.Office.Interop.Excel;

private bool RefreshExcelData(string strFileName){
    object missing = System.Reflection.Missing.Value;
    ApplicationClass readApp = new ApplicationClass();
    Workbook readBook = null;
    try{
        readBook = readApp.Workbooks.Open(strFileName, 3, false, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
        Array links = (Array)readBook.LinkSources(XlLink.xlExcelLinks
        if (links != null)
        {
            //递归更新源Excel
            foreach (string strName in links)
                RefreshExcelData(strName);

            //更新当前Excel
            foreach (string strName in links)
                readBook.UpdateLink(strName, XlLinkType.xlLinkTypeExcelLinks);

            //刷新计算
            readBook.RefreshAll();
            readBook.Save();
        }
    }
    catch(){}
} using Microsoft.Office.Interop.Excel;

private bool RefreshExcelData(string strFileName){
    object missing = System.Reflection.Missing.Value;
    ApplicationClass readApp = new ApplicationClass();
    Workbook readBook = null;
    try{
        readBook = readApp.Workbooks.Open(strFileName, 3, false, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
        Array links = (Array)readBook.LinkSources(XlLink.xlExcelLinks
        if (links != null)
        {
            //递归更新源Excel
            foreach (string strName in links)
                RefreshExcelData(strName);

            //更新当前Excel
            foreach (string strName in links)
                readBook.UpdateLink(strName, XlLinkType.xlLinkTypeExcelLinks);

            //刷新计算
            readBook.RefreshAll();
            readBook.Save();
        }
    }
    catch(){}
}
using Microsoft.Office.Interop.Excel;

object missing = System.Reflection.Missing.Value;
ApplicationClass readApp = new ApplicationClass();
Workbook readBook = null;
try{
readBook = readApp.Workbooks.Open(strFileName, 3, false, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
Array links = (Array)readBook.LinkSources(XlLink.xlExcelLinks
if (links != null)
                {
                    //递归更新源Excel
                    foreach (string strName in links)
                        RefreshExcelData(strName);

                    //更新当前Excel
                    foreach (string strName in links)
                        readBook.UpdateLink(strName, XlLinkType.xlLinkTypeExcelLinks);
                    //刷新计算
                    readBook.RefreshAll();
                    readBook.Save();
}
}

转载于:https://www.cnblogs.com/tanxstar/archive/2009/05/14/1456984.html