Example of Replace Options in ASP.NET MVC Excel (XlsIO) Library

This sample demonstrates how to find a particular text in a cell in the spreadsheet and replace it using Excel (XlsIO) Library.

DEMO

SOURCE

Click the "Input Template" button to view the input Excel document and "Replace" button to view the created Excel document. Please note that the Microsoft Excel viewer or Microsoft Excel is required to view the Excel document.

Find what:		Match case

Replace with:		Match entire cell contents

This sample demonstrates some of the replace options in Essential XlsIO.

Features:

Find numbers, text, boolean or dates and replaces them with the given data on specified replace options