ByteScout Spreadsheet SDK - C# - Hidden Formula - ByteScout

ByteScout Spreadsheet SDK – C# – Hidden Formula

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

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.

Try ByteScout Spreadsheet SDK today:  60 Day Free Trial (on-premise) or  Web API (on-demand version)

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"); } } }

Try ByteScout Spreadsheet SDK today:  60 Day Free Trial (on-premise) or  Web API (on-demand version)



Get 60 Day Free Trial or Visit ByteScout Spreadsheet SDK Home Page

Explore ByteScout Spreadsheet SDK Documentation

Get ByteScout Spreadsheet SDK Free Training


Get Your Free API Key

Explore Web API Documentation