当前位置：文江博客话题详情

使用 SpreadSheetGear 在 MS Excel 中隐藏单元格包含？

发布于 2024-08-28 14:26:24 字数 33 浏览 7 评论 0原文

嘿，任何人都知道如何使用电子表格设备隐藏单元格包含。

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

月亮坠入山谷 2024-09-04 14:26:24

您可以将 IRange.NumberFormat 设置为“;;;”使单元格的内容被隐藏。还有 IRange.FormulaHidden、IRange.Rows.Hidden、IRange.Columns.Hidden 以及可能其他我没有考虑的方法。下面是一些演示这些方法的代码：

namespace Program
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create a new workbook and get a reference to Sheet1!A1.
            var workbook = SpreadsheetGear.Factory.GetWorkbook();
            var sheet1 = workbook.Worksheets[0];
            var a1 = workbook.Worksheets[0].Cells["A1"];
            // Put some text in A1.
            a1.Value = "Hello World!";
            // Set a number format which causes nothing to be displayed.
            //
            // This is probably the best way to hide the contents of 
            // a single cell.
            a1.NumberFormat = ";;;";
            // Set FormulaHidden to true - must set IWorksheet.ProtectContents 
            // to true for this make any difference. This will not hide values
            // in cells.
            a1.FormulaHidden = true;
            // Hide the row containing A1.
            a1.Rows.Hidden = true;
            // Hide the column containing A1.
            a1.Columns.Hidden = true;
        }
    }
}

You can set IRange.NumberFormat to ";;;" to cause the contents of a cell to be hidden. There are also IRange.FormulaHidden, IRange.Rows.Hidden, IRange.Columns.Hidden and probably other ways to approach it that I am not thinking about. Here is some code which demonstrates these approaches:

namespace Program
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create a new workbook and get a reference to Sheet1!A1.
            var workbook = SpreadsheetGear.Factory.GetWorkbook();
            var sheet1 = workbook.Worksheets[0];
            var a1 = workbook.Worksheets[0].Cells["A1"];
            // Put some text in A1.
            a1.Value = "Hello World!";
            // Set a number format which causes nothing to be displayed.
            //
            // This is probably the best way to hide the contents of 
            // a single cell.
            a1.NumberFormat = ";;;";
            // Set FormulaHidden to true - must set IWorksheet.ProtectContents 
            // to true for this make any difference. This will not hide values
            // in cells.
            a1.FormulaHidden = true;
            // Hide the row containing A1.
            a1.Rows.Hidden = true;
            // Hide the column containing A1.
            a1.Columns.Hidden = true;
        }
    }
}

回复收藏 0 原文

~没有更多了~