Python CalculationOptions Examples

Example #1

File: test_cells_workbook_api.py Project: sabir-gmail/aspose-cells-cloud-python

    def test_cells_workbook_post_workbook_calculate_formula(self):
        """
        Test case for cells_workbook_post_workbook_calculate_formula

        Calculate all formulas in workbook.
        """
        name ='Book1.xlsx'       
        folder = "Temp"
        options = CalculationOptions()
        options.ignore_error = True
        ignore_error = True
        AuthUtil.Ready(name, folder)
        result = self.api.cells_workbook_post_workbook_calculate_formula(name, options=options, ignore_error=ignore_error, folder=folder)
        pass

Example #2

    def test_cells_post_cell_calculate(self):
        """
        Test case for cells_post_cell_calculate

        Cell calculate formula
        """
        name ='Book1.xlsx'
        sheet_name ='Sheet1'
        cellName = 'C1'  
        options = CalculationOptions()
        options.recursive = True
        options.ignore_error = True
        folder = "Temp"
        AuthUtil.Ready(name, folder)
        self.api.cells_post_cell_calculate(name, sheet_name,cellName, options = options, folder = folder)
        pass

Example #3

File: test_cells_workbook_api.py Project: NtiyisoN/aspose-cells-cloud-python

    def test_cells_workbook_post_workbook_calculate_formula(self):
        """
        Test case for cells_workbook_post_workbook_calculate_formula

        Calculate all formulas in workbook.
        """
        name = 'Book1.xlsx'
        folder = "PythonTest"
        options = CalculationOptions()
        options.ignore_error = True
        ignore_error = True
        result = AuthUtil.Ready(self.api, name, folder)
        self.assertTrue(len(result.uploaded) > 0)
        result = self.api.cells_workbook_post_workbook_calculate_formula(
            name, options=options, ignore_error=ignore_error, folder=folder)
        self.assertEqual(result.code, 200)
        pass

Example #4

File: test_cells_api.py Project: NtiyisoN/aspose-cells-cloud-python

    def test_cells_post_cell_calculate(self):
        """
        Test case for cells_post_cell_calculate

        Cell calculate formula
        """
        name = 'Book1.xlsx'
        sheet_name = 'Sheet1'
        cellName = 'C1'
        options = CalculationOptions()
        options.recursive = True
        options.ignore_error = True
        folder = "PythonTest"
        result = AuthUtil.Ready(self.api, name, folder)
        self.assertTrue(len(result.uploaded) > 0)

        result = self.api.cells_post_cell_calculate(name,
                                                    sheet_name,
                                                    cellName,
                                                    options=options,
                                                    folder=folder)
        self.assertEqual(result.code, 200)
        pass

Example #5

import os
import sys

ABSPATH = os.path.abspath(os.path.realpath(os.path.dirname(__file__)) + "/..")
sys.path.append(ABSPATH)
import asposecellscloud
from asposecellscloud.rest import ApiException
from asposecellscloud.apis.cells_api import CellsApi
import AuthUtil
from asposecellscloud.models import CalculationOptions
from asposecellscloud.models import FontSetting
from asposecellscloud.models import Font
from asposecellscloud.models import Style


api_client = AuthUtil.GetApiClient()
api = asposecellscloud.apis.cells_api.CellsApi(api_client)
        name ='Book1.xlsx'       
        folder = "Temp"
        options = CalculationOptions()
        options.ignore_error = True
        ignore_error = True
        AuthUtil.Ready(name, folder)
        result = self.api.cells_workbook_post_workbook_calculate_formula(name, options=options, ignore_error=ignore_error, folder=folder)

Example #6

import os
import sys

ABSPATH = os.path.abspath(os.path.realpath(os.path.dirname(__file__)) + "/..")
sys.path.append(ABSPATH)
import asposecellscloud
from asposecellscloud.rest import ApiException
from asposecellscloud.apis.cells_api import CellsApi
import AuthUtil
from asposecellscloud.models import CalculationOptions
from asposecellscloud.models import FontSetting
from asposecellscloud.models import Font
from asposecellscloud.models import Style


api_client = AuthUtil.GetApiClient()
api = asposecellscloud.apis.cells_api.CellsApi(api_client)
        name ='Book1.xlsx'
        sheet_name ='Sheet1'
        cellName = 'C1'  
        options = CalculationOptions()
        options.recursive = True
        options.ignore_error = True
        folder = "Temp"
        AuthUtil.Ready(name, folder)
        self.api.cells_post_cell_calculate(name, sheet_name,cellName, options = options, folder = folder)