用C++在范围内搜索和替换数据
Contents
[
Hide
]
有时你需要在范围内搜索并替换特定数据,而忽略范围外的任何单元格值。Aspose.Cells允许你将搜索限制在特定范围内。本文将对此进行说明。
Aspose.Cells提供了FindOptions::SetRange()方法,用于在搜索数据时指定范围。下面的示例演示了如何在范围内搜索和替换数据。
#include <iostream>
#include "Aspose.Cells.h"
using namespace Aspose::Cells;
int main()
{
Aspose::Cells::Startup();
// Source directory path
U16String srcDir(u"..\\Data\\01_SourceDirectory\\");
// Path of input excel file
U16String filePath = srcDir + u"input.xlsx";
// Create workbook
Workbook workbook(filePath);
// Get the first worksheet
Worksheet worksheet = workbook.GetWorksheets().Get(0);
// Specify the range where you want to search
// Here the range is E9:H15
CellArea area = CellArea::CreateCellArea(u"E9", u"H15");
// Specify Find options
FindOptions opts;
opts.SetLookInType(LookInType::Values);
opts.SetLookAtType(LookAtType::EntireContent);
opts.SetRange(area);
Cell cell;
do
{
// Search the cell with value search within range
cell = worksheet.GetCells().Find(u"search", cell, opts);
// If no such cell found, then break the loop
if (!cell)
break;
// Replace the cell with value replace
cell.PutValue(u"replace");
} while (true);
// Save the workbook
U16String outputPath = srcDir + u"output.out.xlsx";
workbook.Save(outputPath);
std::cout << "Workbook saved successfully!" << std::endl;
Aspose::Cells::Cleanup();
}