Search
Sort Score
Result 10 results
Languages All
Labels All
Results 1,231 - 1,240 of 3,312 for

workbook formulas

(0.08 sec)

  1. 用C++直接计算自定义函数，无需在工作表中编写|Documentation

    本文介绍如何使用Aspose.Cells库在Microsoft Excel中直接计算自定义函数，而无需在工作表中编写函数。 通过加载现有的Excel文件或创建一个新的Excel文件，我们可以使用Aspose.Cells提供的方法来计算自定义函数并获得结果。 最后，我们将修改后的Excel文件保存到磁盘。...Worksheet::CalculateFormula(System::String formula, CalculationOptions opts) 方法实现此目的。...) override { // Check the formula name and calculate it yourself...

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

  2. Add Calculated Field in Pivot Table with C#

    Learn how to add calculated field in Pivot Table using C# and Aspose.Cells for .NET. Enhance your Excel data analysis with this simple guide....that you create by using a formula to perform calculations on...calculated field a name, enter your formula, and select the fields you...

    blog.aspose.com/cells/add-calculated-field-in-p...
    more..

  3. 通过 Node.js + C++ 指定共享公式的最大行数|Documentation

    学习如何使用 Aspose.Cells for Node.js via C++ 指定共享公式的最大行数。...Create a new workbook const wb = new AsposeCells . Workbook (); //...Set the max rows of shared formula to 5 wb . getSettings (). ...

    docs.aspose.com/cells/zh/nodejs-cpp/specify-max...
    more..

  4. 将工作表转换为CSV|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....a new workbook with Excel file path Workbook workbook = new Workbook...Workbook ( dataPath + "workbook.xls" ); //Save the document in...

    docs.aspose.com/cells/zh/java/convert-worksheet...
    more..

  5. Convert PS to XLT in Android Apps | products.as...

    Render PS to XLT in Android Apps API without using Microsoft Excel or Adobe Reader...such as data import/export, formula calculation, chart creation...Load XLSX document by using Workbook class Save the document to...

    products.aspose.com/total/android-java/conversi...
    more..

  6. 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..

  7. Tracing Precedents in Excel using C#

    Refer to this article for tracing precedents in Excel using C#. It has the IDE settings, steps, and a sample code to fetch precedents and dependents in Excel with C#....empty Excel file using the Workbook class for analyzing precedents...and precedent and set the formula in the dependent cell accordingly...

    kb.aspose.com/cells/net/tracing-precedents-in-e...
    more..

  8. 用 C++ 实现类似于 Excel VBA Range.FormulaLocal 的 Cell...

    学习如何使用 Aspose.Cells 与 C++ 实现类似于 Excel VBA Range.FormulaLocal 的 Cell.FormulaLocal。...Local () { // Create workbook Workbook wb ; // Assign GlobalizationSetting...( u "C4" ); // Assign SUM formula and print its FormulaLocal...

    docs.aspose.com/cells/zh/cpp/implement-cell-for...
    more..

  9. 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....Ask AI Update Power Query Formula Item Contents [ Hide ] Usage...to update the Power Query Formula item by using the PowerQueryFormulaIte...

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

  10. 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..