Search
Sort Score
Result 10 results
Languages All
Labels All
Results 141 - 150 of 3,314 for

workbook formulas

(0.74 sec)

  1. Implement Custom Calculation Engine to extend t...

    This article describes how to extend the default calculation engine in JavaScript by implementing a custom calculation engine using the Aspose.Cells library for JavaScript via C++. Load an existing Excel file or create a new one to use the methods provided and save the modified Excel file....all of the Microsoft Excel formulas. Nevertheless, it also allows...is called for all of your formulas. Inside this method, we intercept...

    docs.aspose.com/cells/javascript-cpp/implement-...
    more..

  2. Delete Named Ranges|Documentation

    You can learn how to remove defined names or named ranges from Excel or OpenOffice files with Aspose.Cells for Python via .Net....Microsoft Excel and open the workbook that contains the named range...range. Go to the Formulas tab in the Excel ribbon. Click on the...

    docs.aspose.com/cells/python-net/delete-named-r...
    more..

  3. How to Edit Excel File using Node.js

    This step-by-step tutorial guides on how to edit Excel file using Node.js. It contains the information to set the environment, a list of steps, and a runnable sample code to edit Excel spreadsheet using Node.js....You will learn to edit data, formulas, and other types of data without...source Excel file using the Workbook class object Access the target...

    kb.aspose.com/cells/nodejs/how-to-edit-excel-fi...
    more..

  4. How to get OData Connection Information with Ja...

    Learn how to extract OData connection information from an Excel file using Aspose.Cells for JavaScript via C++....JavaScript via C++ provides the Workbook.dataMashup property which...Example - Read Power Query Formulas </ title > </ head > < body...

    docs.aspose.com/cells/javascript-cpp/how-to-get...
    more..

  5. Calculating IFNA Function with Python.NET using...

    Learn how to calculate IFNA function in Excel files using Aspose.Cells for Python.NET. Handle...returns a specified value if a formula results in #N/A error; otherwise...otherwise returns the formula’s result. Calculating IFNA Function...

    docs.aspose.com/cells/python-net/calculating-if...
    more..

  6. Add Cells to Microsoft Excel Formula Watch Wind...

    How to use the Aspose.Cells library to add cells to the formula watch window in Excel using Node.js via C++. By loading an existing Excel file or creating a new one, you can manipulate the cells in it and set Formulas. Finally, you save the modified Excel file to disk....Add Cells to Microsoft Excel Formula Watch Window with Node.js via...watch cell values and their formulas conveniently in a window....

    docs.aspose.com/cells/nodejs-cpp/add-cells-to-m...
    more..

  7. Saving Excel as .Docx having an issue with cell...

    When I try to save a excel document having a table with cell values wider than the column width as Docx, it ends up distorting the values in the resulting table. this is the table I am trying to convert to a word table …...saveOptions = new DocxSaveOptions(); workbook.Save(ms, saveOptions); ms...saveOptions = new DocxSaveOptions(); workbook.Save(ms, saveOptions); ms...

    forum.aspose.com/t/saving-excel-as-docx-having-...
    more..

  8. How to Lock Cells to Protect Them with C++|Docu...

    This article shows you code explaining how to lock cells to protect them using the Aspose.Cells library with C++....modifying important data or formulas. This is especially useful...protected. Protecting Formulas: Formulas are often crucial for...

    docs.aspose.com/cells/cpp/how-to-lock-cells-to-...
    more..

  9. 使用C++在工作表中显示公式而非值|Documentation

    本文提供了使用C++ API以编程方式在Excel工作表或电子表格中显示公式而非值的示例代码。...// Load the source workbook Workbook workbook ( filePath ); //...worksheet Worksheet worksheet = workbook . GetWorksheets (). Get (...

    docs.aspose.com/cells/zh/cpp/show-formulas-inst...
    more..

  10. 使用JavaScript通过C++更新Power Query公式项。|Documentation

    学习如何使用Aspose.Cells for JavaScript通过C++在Excel文件中更新Power Query公式项的数据源。...body > < h1 > Power Query Formula Update Example </ h1 > < p...Select the workbook containing Power Query formulas and an optional...

    docs.aspose.com/cells/zh/javascript-cpp/update-...
    more..