ByteScout Spreadsheet SDK – C# – Hidden Formula

Home
/
Articles
/
ByteScout Spreadsheet SDK – C# – Hidden Formula

printable version:
ByteScout-Spreadsheet-SDK-C-sharp-Hidden-Formula.pdf

hidden formula in C# with ByteScout Spreadsheet SDK

hidden formula in C#

ByteScout tutorials explain the material for programmers who use C#. ByteScout Spreadsheet SDK helps with hidden formula in C#. ByteScout Spreadsheet SDK is the library (SDK) that is capable of writing, reading, modifying and calculating Excel and CSV spreadsheets. Most popular formulas can be calculated and reculculated with Excel installed. You may import or export data to and from CSV, XML, JSON as well as to and from databases, arrays.

Fast application programming interfaces of ByteScout Spreadsheet SDK for C# plus the instruction and the C# code below will help you quickly learn hidden formula. In order to implement this functionality, you should copy and paste code below into your app using code editor. Then compile and run your application. Test C# sample code examples whether they respond your needs and requirements for the project.

ByteScout Spreadsheet SDK is available as free trial. You may get it from our website along with all other source code samples for C# applications.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Program.cs

      using System.Diagnostics;
using System.IO;
using Bytescout.Spreadsheet;

namespace HiddenFormula
{
    class Program
    {
        static void Main(string[] args)
        {
            // Open spreadsheet from file
            Spreadsheet document = new Spreadsheet();
           document.LoadFromFile("example.xls");

            // Get first worksheet
            Worksheet worksheet = document.Workbook.Worksheets[0];

            // Hide formula in B9 cell
            worksheet.Cell("B9").HiddenFormula = true;
            // Protect the worksheet with password
            worksheet.Protect("password");
            
            // Delete output file if exists
            if (File.Exists("changed.xls"))
            {
                File.Delete("changed.xls");
            }

            // Save document
            document.SaveAs("changed.xls");

            // Close spreadsheet
            document.Close();

            // Open generated XLS document in default program
            Process.Start("changed.xls");
        }
    }
}