Save values without formulas

The following example shows you how to produce a values-only workbook. When CalcOptions.RemoveFormulas is true, the formula of every successfully calculated cell is removed and only the calculated value is kept, so the recipient cannot see the formulas behind the numbers.

C# example

using System;
using Independentsoft.Calc;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

            CalcSession session = new CalcSession();
            session.Options.RemoveFormulas = true;

            CalcResult result = session.Calculate(book);

            Console.WriteLine(result);

            book.Save("c:\\test\\values-only.xlsx", true);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Calc
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim book As New Workbook("c:\test\input.xlsx")

        Dim session As New CalcSession()
        session.Options.RemoveFormulas = True

        Dim result As CalcResult = session.Calculate(book)

        Console.WriteLine(result)

        book.Save("c:\test\values-only.xlsx", True)

    End Sub
End Module

Calc .NET > Tutorial > Save values without formulas

Need help? Ask our developers: