True or False Transate to yes or no

Aspose.Cells Product Family
1

i have a question.
i work in a company in holland and i have true or false columns but i want to this
translate to yes or no
is this possible in aspose ?
Thanx

2

Could you elaborate your need? Do you want to replace all cells with TRUE value to "Yes" and FALSE value to "No"?

Could a replace method serve your need?

excel.Replace(true, "Yes");
excel.Replace(false, "No");

If yes, I can add this feature to Aspose.Excel. It will be available in the next week.

3

Yes i want to replace all cells with True value to Yes and false value to NO

Thank you very much

4

Hi laurance

I must say that i using the designer part van aspose.
i think i can beter use ==> designer.replace(true, "yes")

Is that good?

5

I will add the method in Excel object and you can use:
designer.Excel.Replace(true, “yes”)

6

Thnx
you 're great

7

Please download and try v3.0.5 at

Now you can use the new Replace method.

8

@zizu77,
Aspose.Excel is discarded now and no more under development. It is replaced by Aspose.Cells that is much advanced than its predecessor and supports all the latest features in different versions of MS Excel. You can replace some text with other text throughout the workbook at once or find strings one by one from each worksheet and replace them with the desired string.

Here are examples that demonstrate these features:

Replace string throughout the workbook

Workbook workbook = new Workbook("Book1.xlsx");
workbook.Replace(true, "Yes");
workbook.Replace(false, "NO");
workbook.Save("BookOutput1.xlsx");

Replace string by parsing contents throughout the worksheet

Workbook workbook = new Workbook("Book1.xlsx");

Cell cell = null;

do
{
    // Search the cell with value search within range
    cell = workbook.Worksheets[0].Cells.Find(true, cell);

    // If no such cell found, then break the loop
    if (cell == null)
        break;
    else
        // Replace the cell with value replace
        cell.PutValue("YES");

} while (true);

do
{
    // Search the cell with value search within range
    cell = workbook.Worksheets[0].Cells.Find(false, cell);

    // If no such cell found, then break the loop
    if (cell == null)
        break;
    else
        // Replace the cell with value replace
        cell.PutValue("NO");

} while (true);

// Save the workbook
workbook.Save("BookOutput2.xlsx");

For more information about replacing text refer to the following articles:
Search and Replace Data in a Range
Find and Replace in Spreadsheet
Replace text in a workbook using Regular Expression

Here you will find the latest version of this new product which can be freely downloaded for trials:
Aspose.Cells for .NET (Latest Version)

A detailed runnable solution is prepared which can be used to test the product features without writing any code. It can be downloaded here.