ByteScout Data Extraction Suite – C# – Hidden formula with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – C# – Hidden formula with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-C-sharp-Hidden-formula-with-spreadsheet-sdk.pdf

hidden formula with spreadsheet sdk in C# and ByteScout Data Extraction Suite

Learn hidden formula with spreadsheet sdk in C#

Easy to understand coding instructions are written to assist you to try-out the features without the requirement to write your own code. Hidden formula with spreadsheet sdk in C# can be applied with ByteScout Data Extraction Suite. ByteScout Data Extraction Suite is the bundle that includes three SDK tools for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK.

Want to speed up the application development? Then this C#, code samples for C#, developers help to speed up the application development and writing a code when using ByteScout Data Extraction Suite. If you want to know how it works, then this C# sample code should be copied and pasted into your application’s code editor. Then just compile and run it. Check these C# sample code examples to see if they acknowledge to your needs and requirements for the project.

ByteScout Data Extraction Suite is available as a 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");
        }
    }
}