Search
Sort Score
Result 10 results
Languages All
Labels All
Results 1,131 - 1,140 of 2,836 for

workbook formulas

(0.04 sec)

  1. Find and Replace Text in Excel using Java

    Follow this article to find and replace text in Excel using Java. It has all the details to set the IDE, a list of steps, and a sample code to implement text find and replace in Excel using Java....source Excel file into the Workbook containing the text that you...if found Save the updated workbook after replacing a specific...

    kb.aspose.com/cells/java/find-and-replace-text-...
    more..

  2. How to Add Filter in XLSX File using C++

    In this tutorial, we will learn how to add filter in XLSX file using C++. You can insert filter in Excel worksheet on MS Windows or Linux programmatically in C++....Aspose::Cells namespace Initialize the Workbook Class object to instantiate...instantiate new Excel workbook Insert sample values into the cells Set...

    kb.aspose.com/cells/cpp/how-to-add-filter-in-xl...
    more..

  3. Calculation of Excel 2016 MINIFS and MAXIFS fun...

    This article introduces how to use the Aspose.Cells library to calculate MINIFS and MAXIFS functions in Microsoft Excel 2016 using C++....sample excel file and calls the Workbook.CalculateFormula() method...method to perform the formula calculation via Aspose.Cells and then...

    docs.aspose.com/cells/go-cpp/calculation-of-exc...
    more..

  4. How to Add Picture to Excel in C#

    Learn how to add picture to Excel using Aspose.Cells for .NET. Follow our simple guide with C# code examples for seamless integration....Create a new instance of the Workbook class. Access the desired...into the worksheet. Save the workbook to a file using the Save()...

    blog.aspose.com/cells/add-picture-to-excel-in-c...
    more..

  5. Calculation of Excel 2016 MINIFS and MAXIFS fun...

    This article introduces how to use the Aspose.Cells library to calculate MINIFS and MAXIFS functions in Microsoft Excel 2016. By loading an existing Excel file or creating a new one, we can use the methods provided by Aspose.Cells to calculate the MINIFS and MAXIFS functions and get the results. Finally, we save the modified Excel file to disk....sample excel file and calls the Workbook.CalculateFormula() method...method to perform the formula calculation via Aspose.Cells and then...

    docs.aspose.com/cells/net/calculation-of-excel-...
    more..

  6. Update Power Query Formula Item|Documentation

    Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS & Android platforms....Update Power Query Formula Item Contents [ Hide ] Usage Scenario...to update the Power Query Formula item by using the PowerQueryFormulaIte...

    docs.aspose.com/cells/python-net/update-power-q...
    more..

  7. How to Update Excel File in Java

    In this step-by-step tutorial we will learn how to update Excel file in Java using a simple code. This code can be executed in many operating systems supporting Java like Windows, macOS and Linux....project Add a reference to Workbook and Cell classes using Import...Import in the program Load the workbook that is to be updated Get...

    kb.aspose.com/cells/java/how-to-update-excel-fi...
    more..

  8. Direct Calculation of Custom Function without W...

    This article introduces how to use Aspose.Cells library to directly calculate custom functions in Microsoft Excel without writing the function in a worksheet. By loading an existing Excel file or creating a new Excel file, we can use the methods provided by Aspose.Cells to calculate the custom function and get the result. Finally, we save the modified Excel file to disk....Worksheet::CalculateFormula(System::String formula, CalculationOptions opts) method...) override { // Check the formula name and calculate it yourself...

    docs.aspose.com/cells/cpp/direct-calculation-of...
    more..

  9. Direct calculation of custom function without w...

    This article introduces how to use Aspose.Cells library to directly calculate custom functions in Microsoft Excel without writing the function in a worksheet using Node.js via C++. Load an existing Excel file or create a new one, calculate the custom function, and save the modified file....calculateFormula(formula, opts) method for this purpose...calculate ( data ) { // Check the formula name and calculate it yourself...

    docs.aspose.com/cells/nodejs-cpp/direct-calcula...
    more..

  10. Using Image Markers while Grouping Data in Smar...

    Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS & Android platforms....following sample creates a workbook and then adds the following...Data with Smart Markers Using Formula parameter in Smart Marker field...

    docs.aspose.com/cells/net/using-image-markers-w...
    more..