Class: AsposeCellsCloud::CellsApi
- Inherits:
-
Object
- Object
- AsposeCellsCloud::CellsApi
- Defined in:
- lib/aspose_cells_cloud/api/cells_api.rb
Instance Attribute Summary collapse
-
#api_client ⇒ Object
Returns the value of attribute api_client.
Instance Method Summary collapse
-
#add_picture_in_cell(add_picture_in_cell_request, opts = {}) ⇒ Object
add new picture in the cells.
- #check_workbook_formula_errors(check_workbook_formula_errors_request, opts = {}) ⇒ Object
-
#check_wrokbook_external_reference(check_wrokbook_external_reference_request, opts = {}) ⇒ Object
Export Excel internal elements or the workbook itself to various format files.
- #copy_file(copy_file_request, opts = {}) ⇒ Object
- #copy_folder(copy_folder_request, opts = {}) ⇒ Object
- #create_folder(create_folder_request, opts = {}) ⇒ Object
-
#delete_decrypt_workbook(delete_decrypt_workbook_request, opts = {}) ⇒ Object
Excel files decryption.
-
#delete_document_properties(delete_document_properties_request, opts = {}) ⇒ Object
Delete all custom document properties and reset built-in ones.
-
#delete_document_property(delete_document_property_request, opts = {}) ⇒ Object
Delete an Excel property.
-
#delete_document_un_protect_from_changes(delete_document_un_protect_from_changes_request, opts = {}) ⇒ Object
Excel file cancel write protection.
- #delete_file(delete_file_request, opts = {}) ⇒ Object
- #delete_folder(delete_folder_request, opts = {}) ⇒ Object
-
#delete_header_footer(delete_header_footer_request, opts = {}) ⇒ Object
Clear header and footer in the worksheet.
-
#delete_horizontal_page_break(delete_horizontal_page_break_request, opts = {}) ⇒ Object
Delete a horizontal page break in the worksheet.
-
#delete_horizontal_page_breaks(delete_horizontal_page_breaks_request, opts = {}) ⇒ Object
Delete horizontal page breaks in the worksheet.
-
#delete_metadata(delete_metadata_request, opts = {}) ⇒ Object
Delete cells document properties in Excel file, and save them is various formats.
-
#delete_pivot_table_field(delete_pivot_table_field_request, opts = {}) ⇒ Object
Delete a pivot field in the PivotTable.
-
#delete_un_protect_workbook(delete_un_protect_workbook_request, opts = {}) ⇒ Object
Excel unprotection.
-
#delete_unprotect_worksheet(delete_unprotect_worksheet_request, opts = {}) ⇒ Object
Unprotect worksheet.
-
#delete_vertical_page_break(delete_vertical_page_break_request, opts = {}) ⇒ Object
Delete a vertical page break in the worksheet.
-
#delete_vertical_page_breaks(delete_vertical_page_breaks_request, opts = {}) ⇒ Object
Delete vertical page breaks in the worksheet.
-
#delete_workbook_background(delete_workbook_background_request, opts = {}) ⇒ Object
Delete background in the workbook.
-
#delete_workbook_name(delete_workbook_name_request, opts = {}) ⇒ Object
Delete a named range in the workbook.
-
#delete_workbook_names(delete_workbook_names_request, opts = {}) ⇒ Object
Delete all named ranges in the workbook.
-
#delete_worksheet(delete_worksheet_request, opts = {}) ⇒ Object
Delete a worksheet in the workbook.
-
#delete_worksheet_background(delete_worksheet_background_request, opts = {}) ⇒ Object
Delete background image in the worksheet.
-
#delete_worksheet_cells_range(delete_worksheet_cells_range_request, opts = {}) ⇒ Object
Delete a range of cells and shift existing cells based on the specified shift option.
-
#delete_worksheet_chart(delete_worksheet_chart_request, opts = {}) ⇒ Object
Delete a chart by index in the worksheet.
-
#delete_worksheet_chart_legend(delete_worksheet_chart_legend_request, opts = {}) ⇒ Object
Hides chart legend in the worksheet.
-
#delete_worksheet_chart_title(delete_worksheet_chart_title_request, opts = {}) ⇒ Object
Hide chart title in the worksheet.
-
#delete_worksheet_charts(delete_worksheet_charts_request, opts = {}) ⇒ Object
Clear the charts in the worksheets.
-
#delete_worksheet_columns(delete_worksheet_columns_request, opts = {}) ⇒ Object
Delete worksheet columns in the worksheet.
-
#delete_worksheet_comment(delete_worksheet_comment_request, opts = {}) ⇒ Object
Delete cell comment in the worksheet.
-
#delete_worksheet_comments(delete_worksheet_comments_request, opts = {}) ⇒ Object
Delete all comments in the worksheet.
-
#delete_worksheet_conditional_formatting(delete_worksheet_conditional_formatting_request, opts = {}) ⇒ Object
Remove a conditional formatting.
-
#delete_worksheet_conditional_formatting_area(delete_worksheet_conditional_formatting_area_request, opts = {}) ⇒ Object
Remove cell area from conditional formatting.
-
#delete_worksheet_conditional_formattings(delete_worksheet_conditional_formattings_request, opts = {}) ⇒ Object
Clear all conditional formattings in the worksheet.
-
#delete_worksheet_date_filter(delete_worksheet_date_filter_request, opts = {}) ⇒ Object
Remove a date filter in the worksheet.
-
#delete_worksheet_filter(delete_worksheet_filter_request, opts = {}) ⇒ Object
Delete a filter for a column in the worksheet.
-
#delete_worksheet_freeze_panes(delete_worksheet_freeze_panes_request, opts = {}) ⇒ Object
Unfreeze panes in worksheet.
-
#delete_worksheet_hyperlink(delete_worksheet_hyperlink_request, opts = {}) ⇒ Object
Delete hyperlink by index in the worksheet.
-
#delete_worksheet_hyperlinks(delete_worksheet_hyperlinks_request, opts = {}) ⇒ Object
Delete all hyperlinks in the worksheet.
-
#delete_worksheet_list_object(delete_worksheet_list_object_request, opts = {}) ⇒ Object
Delete list object by index in the worksheet.
-
#delete_worksheet_list_objects(delete_worksheet_list_objects_request, opts = {}) ⇒ Object
Delete ListObjects in the worksheet.
-
#delete_worksheet_ole_object(delete_worksheet_ole_object_request, opts = {}) ⇒ Object
Delete an OLE object in the worksheet.
-
#delete_worksheet_ole_objects(delete_worksheet_ole_objects_request, opts = {}) ⇒ Object
Delete all OLE objects in the worksheet.
-
#delete_worksheet_picture(delete_worksheet_picture_request, opts = {}) ⇒ Object
Delete a picture object by index in the worksheet.
-
#delete_worksheet_pictures(delete_worksheet_pictures_request, opts = {}) ⇒ Object
Delete all pictures in the worksheet.
-
#delete_worksheet_pivot_table(delete_worksheet_pivot_table_request, opts = {}) ⇒ Object
Delete PivotTable by index in the worksheet.
-
#delete_worksheet_pivot_table_filter(delete_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object
Delete a pivot filter in the PivotTable.
-
#delete_worksheet_pivot_table_filters(delete_worksheet_pivot_table_filters_request, opts = {}) ⇒ Object
Delete all pivot filters in the PivotTable.
-
#delete_worksheet_pivot_tables(delete_worksheet_pivot_tables_request, opts = {}) ⇒ Object
Delete PivotTables in the worksheet.
-
#delete_worksheet_row(delete_worksheet_row_request, opts = {}) ⇒ Object
Delete a row in the worksheet.
-
#delete_worksheet_rows(delete_worksheet_rows_request, opts = {}) ⇒ Object
Delete several rows in the worksheet.
-
#delete_worksheet_shape(delete_worksheet_shape_request, opts = {}) ⇒ Object
Delete a shape in the worksheet.
-
#delete_worksheet_shapes(delete_worksheet_shapes_request, opts = {}) ⇒ Object
Delete all shapes in the worksheet.
-
#delete_worksheet_sparkline_group(delete_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Delete a sparkline group in the worksheet.
-
#delete_worksheet_sparkline_groups(delete_worksheet_sparkline_groups_request, opts = {}) ⇒ Object
Delete sparkline groups in the worksheet.
-
#delete_worksheet_validation(delete_worksheet_validation_request, opts = {}) ⇒ Object
Delete a validation by index in worksheet.
-
#delete_worksheet_validations(delete_worksheet_validations_request, opts = {}) ⇒ Object
Delete all validations in the worksheet.
-
#delete_worksheets(delete_worksheets_request, opts = {}) ⇒ Object
Delete matched worksheets in the workbook.
- #download_file(download_file_request, opts = {}) ⇒ Object
-
#get_all_styles(get_all_styles_request, opts = {}) ⇒ Object
Get all style in the workbook.
-
#get_cell_html_string(get_cell_html_string_request, opts = {}) ⇒ Object
Retrieve the HTML string containing data and specific formats in this cell.
-
#get_cells_cloud_service_status(get_cells_cloud_service_status_request, opts = {}) ⇒ Object
Aspose.Cells Cloud service health status check.
-
#get_cells_cloud_services_health_check(get_cells_cloud_services_health_check_request, opts = {}) ⇒ Object
Retrieve cell descriptions in a specified format.
-
#get_chart_area(get_chart_area_request, opts = {}) ⇒ Object
Retrieve chart area description in the worksheet.
-
#get_chart_area_border(get_chart_area_border_request, opts = {}) ⇒ Object
Retrieve chart area border description.
-
#get_chart_area_fill_format(get_chart_area_fill_format_request, opts = {}) ⇒ Object
Retrieve chart area fill format description in the worksheet.
-
#get_chart_category_axis(get_chart_category_axis_request, opts = {}) ⇒ Object
Retrieve descriptions of chart series axis in the chart.
-
#get_chart_second_category_axis(get_chart_second_category_axis_request, opts = {}) ⇒ Object
Retrieve chart second category axis in the chart.
-
#get_chart_second_value_axis(get_chart_second_value_axis_request, opts = {}) ⇒ Object
Retrieve chart second value axis in the chart.
-
#get_chart_series_axis(get_chart_series_axis_request, opts = {}) ⇒ Object
Retrieve descriptions of chart seriesaxis in the chart.
-
#get_chart_value_axis(get_chart_value_axis_request, opts = {}) ⇒ Object
Retrieve chart value axis in the chart.
- #get_disc_usage(get_disc_usage_request, opts = {}) ⇒ Object
-
#get_document_properties(get_document_properties_request, opts = {}) ⇒ Object
Retrieve descriptions of Excel file properties.
-
#get_document_property(get_document_property_request, opts = {}) ⇒ Object
Get Excel property by name.
- #get_file_versions(get_file_versions_request, opts = {}) ⇒ Object
- #get_files_list(get_files_list_request, opts = {}) ⇒ Object
-
#get_footer(get_footer_request, opts = {}) ⇒ Object
Retrieve page footer description in the worksheet.
-
#get_header(get_header_request, opts = {}) ⇒ Object
Retrieve page header description in the worksheet.
-
#get_horizontal_page_break(get_horizontal_page_break_request, opts = {}) ⇒ Object
Retrieve a horizontal page break descripton in the worksheet.
-
#get_horizontal_page_breaks(get_horizontal_page_breaks_request, opts = {}) ⇒ Object
Retrieve descriptions of horizontal page breaks in the worksheet.
-
#get_metadata(get_metadata_request, opts = {}) ⇒ Object
Get cells document properties.
-
#get_named_range_value(get_named_range_value_request, opts = {}) ⇒ Object
Retrieve values in range.
-
#get_named_ranges(get_named_ranges_request, opts = {}) ⇒ Object
Retrieve descriptions of ranges in the worksheets.
-
#get_page_count(get_page_count_request, opts = {}) ⇒ Object
Get page count in the workbook.
-
#get_page_setup(get_page_setup_request, opts = {}) ⇒ Object
Retrieve page setup description in the worksheet.
-
#get_pivot_table_field(get_pivot_table_field_request, opts = {}) ⇒ Object
Retrieve descriptions of pivot fields in the PivotTable.
-
#get_vertical_page_break(get_vertical_page_break_request, opts = {}) ⇒ Object
Retrieve a vertical page break description in the worksheet.
-
#get_vertical_page_breaks(get_vertical_page_breaks_request, opts = {}) ⇒ Object
Retrieve descriptions of vertical page breaks in the worksheet.
-
#get_workbook(get_workbook_request, opts = {}) ⇒ Object
Retrieve workbooks in various formats.
-
#get_workbook_default_style(get_workbook_default_style_request, opts = {}) ⇒ Object
Retrieve the description of the default style for the workbook .
-
#get_workbook_name(get_workbook_name_request, opts = {}) ⇒ Object
Retrieve description of a named range in the workbook.
-
#get_workbook_name_value(get_workbook_name_value_request, opts = {}) ⇒ Object
Retrieve the value of a named range in the workbook.
-
#get_workbook_names(get_workbook_names_request, opts = {}) ⇒ Object
Retrieve named ranges in the workbook.
-
#get_workbook_settings(get_workbook_settings_request, opts = {}) ⇒ Object
Retrieve descriptions of workbook settings.
-
#get_workbook_text_items(get_workbook_text_items_request, opts = {}) ⇒ Object
Retrieve text items in the workbook.
-
#get_worksheet_auto_filter(get_worksheet_auto_filter_request, opts = {}) ⇒ Object
Retrieve the description of auto filters from a worksheet.
-
#get_worksheet_autoshape_with_format(get_worksheet_autoshape_with_format_request, opts = {}) ⇒ Object
Get autoshape description in some format.
-
#get_worksheet_autoshapes(get_worksheet_autoshapes_request, opts = {}) ⇒ Object
Get autoshapes description in worksheet.
-
#get_worksheet_calculate_formula(get_worksheet_calculate_formula_request, opts = {}) ⇒ Object
Calculate formula in the worksheet.
-
#get_worksheet_cell(get_worksheet_cell_request, opts = {}) ⇒ Object
Retrieve cell data using either cell reference or method name in the worksheet.
-
#get_worksheet_cell_style(get_worksheet_cell_style_request, opts = {}) ⇒ Object
Retrieve cell style descriptions in the worksheet.
-
#get_worksheet_cells(get_worksheet_cells_request, opts = {}) ⇒ Object
Retrieve cell descriptions in a specified format.
-
#get_worksheet_cells_range_value(get_worksheet_cells_range_value_request, opts = {}) ⇒ Object
Retrieve the values of cells within the specified range.
-
#get_worksheet_chart(get_worksheet_chart_request, opts = {}) ⇒ Object
Retrieve the chart in a specified format.
-
#get_worksheet_chart_legend(get_worksheet_chart_legend_request, opts = {}) ⇒ Object
Retrieve chart legend description in the worksheet.
-
#get_worksheet_chart_title(get_worksheet_chart_title_request, opts = {}) ⇒ Object
Retrieve chart title description in the worksheet.
-
#get_worksheet_charts(get_worksheet_charts_request, opts = {}) ⇒ Object
Retrieve descriptions of charts in the worksheet.
-
#get_worksheet_column(get_worksheet_column_request, opts = {}) ⇒ Object
Retrieve worksheet column data by column index.
-
#get_worksheet_columns(get_worksheet_columns_request, opts = {}) ⇒ Object
Retrieve descriptions of worksheet columns.
-
#get_worksheet_comment(get_worksheet_comment_request, opts = {}) ⇒ Object
Retrieve the description of comment in the worksheet.
-
#get_worksheet_comments(get_worksheet_comments_request, opts = {}) ⇒ Object
Retrieve the description of comments in the worksheet.
-
#get_worksheet_conditional_formatting(get_worksheet_conditional_formatting_request, opts = {}) ⇒ Object
Retrieve conditional formatting descriptions in the worksheet.
-
#get_worksheet_conditional_formattings(get_worksheet_conditional_formattings_request, opts = {}) ⇒ Object
Retrieve descriptions of conditional formattings in a worksheet.
-
#get_worksheet_hyperlink(get_worksheet_hyperlink_request, opts = {}) ⇒ Object
Retrieve hyperlink description by index in the worksheet.
-
#get_worksheet_hyperlinks(get_worksheet_hyperlinks_request, opts = {}) ⇒ Object
Retrieve descriptions of hyperlinks in the worksheet.
-
#get_worksheet_list_object(get_worksheet_list_object_request, opts = {}) ⇒ Object
Retrieve list object description by index in the worksheet.
-
#get_worksheet_list_objects(get_worksheet_list_objects_request, opts = {}) ⇒ Object
Retrieve descriptions of ListObjects in the worksheet.
-
#get_worksheet_merged_cell(get_worksheet_merged_cell_request, opts = {}) ⇒ Object
Retrieve description of a merged cell by its index in the worksheet.
-
#get_worksheet_merged_cells(get_worksheet_merged_cells_request, opts = {}) ⇒ Object
Get worksheet merged cells.
-
#get_worksheet_ole_object(get_worksheet_ole_object_request, opts = {}) ⇒ Object
Retrieve the OLE object in a specified format in the worksheet.
-
#get_worksheet_ole_objects(get_worksheet_ole_objects_request, opts = {}) ⇒ Object
Retrieve descriptions of OLE objects in the worksheet.
-
#get_worksheet_page_count(get_worksheet_page_count_request, opts = {}) ⇒ Object
Get page count in the worksheet.
-
#get_worksheet_picture_with_format(get_worksheet_picture_with_format_request, opts = {}) ⇒ Object
Retrieve a picture by number in the worksheet.
-
#get_worksheet_pictures(get_worksheet_pictures_request, opts = {}) ⇒ Object
Retrieve descriptions of pictures in the worksheet.
-
#get_worksheet_pivot_table(get_worksheet_pivot_table_request, opts = {}) ⇒ Object
Retrieve PivotTable information by index in the worksheet.
-
#get_worksheet_pivot_table_filter(get_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object
Retrieve PivotTable filters in the worksheet.
-
#get_worksheet_pivot_table_filters(get_worksheet_pivot_table_filters_request, opts = {}) ⇒ Object
Gets PivotTable filters in worksheet.
-
#get_worksheet_pivot_tables(get_worksheet_pivot_tables_request, opts = {}) ⇒ Object
Retrieve descriptions of pivottables in the worksheet.
-
#get_worksheet_row(get_worksheet_row_request, opts = {}) ⇒ Object
Retrieve row data by the row’s index in the worksheet.
-
#get_worksheet_rows(get_worksheet_rows_request, opts = {}) ⇒ Object
Retrieve descriptions of rows in the worksheet.
-
#get_worksheet_shape(get_worksheet_shape_request, opts = {}) ⇒ Object
Retrieve description of shape in the worksheet.
-
#get_worksheet_shapes(get_worksheet_shapes_request, opts = {}) ⇒ Object
Retrieve descriptions of shapes in the worksheet.
-
#get_worksheet_sparkline_group(get_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Retrieve description of a sparkline group in the worksheet.
-
#get_worksheet_sparkline_groups(get_worksheet_sparkline_groups_request, opts = {}) ⇒ Object
Retrieve descriptions of sparkline groups in the worksheet.
-
#get_worksheet_text_items(get_worksheet_text_items_request, opts = {}) ⇒ Object
Retrieve text items in the worksheet.
-
#get_worksheet_validation(get_worksheet_validation_request, opts = {}) ⇒ Object
Retrieve a validation by its index in the worksheet.
-
#get_worksheet_validations(get_worksheet_validations_request, opts = {}) ⇒ Object
Retrieve descriptions of validations in the worksheet.
-
#get_worksheet_with_format(get_worksheet_with_format_request, opts = {}) ⇒ Object
Retrieve the worksheet in a specified format from the workbook.
-
#get_worksheets(get_worksheets_request, opts = {}) ⇒ Object
Retrieve the description of worksheets from a workbook.
-
#initialize(client_id, client_secret, app_version = 'v3.0', app_host = 'api.aspose.cloud', api_client = ApiClient.default) ⇒ CellsApi
constructor
A new instance of CellsApi.
- #move_file(move_file_request, opts = {}) ⇒ Object
- #move_folder(move_folder_request, opts = {}) ⇒ Object
- #object_exists(object_exists_request, opts = {}) ⇒ Object
-
#post_access_token(post_access_token_request, opts = {}) ⇒ Object
Get Access Token Result.
-
#post_add_text_content(post_add_text_content_request, opts = {}) ⇒ Object
Adds text content to a workbook at specified positions within cells based on provided options using ASP.NET Core Web API.
-
#post_analyze_excel(post_analyze_excel_request, opts = {}) ⇒ Object
Perform business analysis of data in Excel files.
-
#post_assemble(post_assemble_request, opts = {}) ⇒ Object
Assemble data files with template files to generate files in various formats.
-
#post_autofit_workbook_columns(post_autofit_workbook_columns_request, opts = {}) ⇒ Object
Autofit columns in the workbook.
-
#post_autofit_workbook_rows(post_autofit_workbook_rows_request, opts = {}) ⇒ Object
Autofit rows in the workbook.
-
#post_autofit_worksheet_columns(post_autofit_worksheet_columns_request, opts = {}) ⇒ Object
Autofit columns in the worksheet.
-
#post_autofit_worksheet_row(post_autofit_worksheet_row_request, opts = {}) ⇒ Object
Autofit a row in the worksheet.
-
#post_autofit_worksheet_rows(post_autofit_worksheet_rows_request, opts = {}) ⇒ Object
Autofit rows in the worksheet.
-
#post_batch_convert(post_batch_convert_request, opts = {}) ⇒ Object
Batch converting files that meet specific matching conditions.
-
#post_batch_lock(post_batch_lock_request, opts = {}) ⇒ Object
Batch locking files that meet specific matching conditions.
-
#post_batch_protect(post_batch_protect_request, opts = {}) ⇒ Object
Batch protecting files that meet specific matching conditions.
-
#post_batch_split(post_batch_split_request, opts = {}) ⇒ Object
Batch splitting files that meet specific matching conditions.
-
#post_batch_unlock(post_batch_unlock_request, opts = {}) ⇒ Object
Batch unlocking files that meet specific matching conditions.
-
#post_cell_calculate(post_cell_calculate_request, opts = {}) ⇒ Object
Calculate cell formula in the worksheet.
-
#post_cell_characters(post_cell_characters_request, opts = {}) ⇒ Object
Set cell characters in the worksheet.
- #post_character_count(post_character_count_request, opts = {}) ⇒ Object
-
#post_chart_category_axis(post_chart_category_axis_request, opts = {}) ⇒ Object
Update chart category axis in the chart.
-
#post_chart_second_category_axis(post_chart_second_category_axis_request, opts = {}) ⇒ Object
Update chart sencond category axis in the chart.
-
#post_chart_second_value_axis(post_chart_second_value_axis_request, opts = {}) ⇒ Object
Update chart sencond value axis in the chart.
-
#post_chart_series_axis(post_chart_series_axis_request, opts = {}) ⇒ Object
Update chart series axis in the chart.
-
#post_chart_value_axis(post_chart_value_axis_request, opts = {}) ⇒ Object
Update chart value axis in the chart.
-
#post_clear_contents(post_clear_contents_request, opts = {}) ⇒ Object
Clear cell area contents in the worksheet.
-
#post_clear_formats(post_clear_formats_request, opts = {}) ⇒ Object
Clear cell formats in the worksheet.
-
#post_clear_objects(post_clear_objects_request, opts = {}) ⇒ Object
Clear internal elements in Excel files and generate output files in various formats.
-
#post_column_style(post_column_style_request, opts = {}) ⇒ Object
Set column style in the worksheet.
-
#post_compress(post_compress_request, opts = {}) ⇒ Object
Compress files and generate target files in various formats, supported file formats are include Xls, Xlsx, Xlsm, Xlsb, Ods and more.
- #post_convert_text(post_convert_text_request, opts = {}) ⇒ Object
- #post_convert_workbook(post_convert_workbook_request, opts = {}) ⇒ Object
-
#post_convert_workbook_to_csv(post_convert_workbook_to_csv_request, opts = {}) ⇒ Object
Convert Excel file to Csv files.
-
#post_convert_workbook_to_docx(post_convert_workbook_to_docx_request, opts = {}) ⇒ Object
Convert Excel file to Docx files.
-
#post_convert_workbook_to_html(post_convert_workbook_to_html_request, opts = {}) ⇒ Object
Convert Excel file to HTML files.
-
#post_convert_workbook_to_json(post_convert_workbook_to_json_request, opts = {}) ⇒ Object
Convert Excel file to Json files.
-
#post_convert_workbook_to_markdown(post_convert_workbook_to_markdown_request, opts = {}) ⇒ Object
Convert Excel file to Markdown files.
-
#post_convert_workbook_to_pdf(post_convert_workbook_to_pdf_request, opts = {}) ⇒ Object
Convert Excel file to PDF files.
-
#post_convert_workbook_to_png(post_convert_workbook_to_png_request, opts = {}) ⇒ Object
Convert Excel file to PNG files.
-
#post_convert_workbook_to_pptx(post_convert_workbook_to_pptx_request, opts = {}) ⇒ Object
Convert Excel file to Pptx files.
-
#post_convert_workbook_to_sql(post_convert_workbook_to_sql_request, opts = {}) ⇒ Object
Convert Excel file to SQL Script files.
- #post_convert_worksheet_to_image(post_convert_worksheet_to_image_request, opts = {}) ⇒ Object
-
#post_copy_cell_into_cell(post_copy_cell_into_cell_request, opts = {}) ⇒ Object
Copy data from a source cell to a destination cell in the worksheet.
-
#post_copy_worksheet(post_copy_worksheet_request, opts = {}) ⇒ Object
Copy contents and formats from another worksheet.
-
#post_copy_worksheet_columns(post_copy_worksheet_columns_request, opts = {}) ⇒ Object
Copy data from source columns to destination columns in the worksheet.
-
#post_copy_worksheet_rows(post_copy_worksheet_rows_request, opts = {}) ⇒ Object
Copy data and formats from specific entire rows in the worksheet.
-
#post_data_cleansing(post_data_cleansing_request, opts = {}) ⇒ Object
Data cleansing of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.
-
#post_data_deduplication(post_data_deduplication_request, opts = {}) ⇒ Object
Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.
-
#post_data_fill(post_data_fill_request, opts = {}) ⇒ Object
Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.
-
#post_data_transformation(post_data_transformation_request, opts = {}) ⇒ Object
Transform spreadsheet data is mainly used to pivot columns, unpivot columns.
-
#post_delete_incomplete_rows(post_delete_incomplete_rows_request, opts = {}) ⇒ Object
Deleting incomplete rows of spreadsheet files is mainly used to eliminate incomplete rows in tables and ranges.
-
#post_digital_signature(post_digital_signature_request, opts = {}) ⇒ Object
Excel file digital signature.
-
#post_encrypt_workbook(post_encrypt_workbook_request, opts = {}) ⇒ Object
Excel Encryption.
-
#post_export(post_export_request, opts = {}) ⇒ Object
Export Excel internal elements or the workbook itself to various format files.
- #post_extract_text(post_extract_text_request, opts = {}) ⇒ Object
-
#post_fit_tall_to_pages(post_fit_tall_to_pages_request, opts = {}) ⇒ Object
Set the scale at which the page will fit tall when printed on the sheet.
-
#post_fit_wide_to_pages(post_fit_wide_to_pages_request, opts = {}) ⇒ Object
Set the scale at which the page will fit wide when printed on the sheet.
-
#post_footer(post_footer_request, opts = {}) ⇒ Object
Update page footer in the worksheet.
-
#post_group_worksheet_columns(post_group_worksheet_columns_request, opts = {}) ⇒ Object
Group worksheet columns in the worksheet.
-
#post_group_worksheet_rows(post_group_worksheet_rows_request, opts = {}) ⇒ Object
Group rows in the worksheet.
-
#post_header(post_header_request, opts = {}) ⇒ Object
Update page header in the worksheet.
-
#post_hide_worksheet_columns(post_hide_worksheet_columns_request, opts = {}) ⇒ Object
Hide worksheet columns in the worksheet.
-
#post_hide_worksheet_rows(post_hide_worksheet_rows_request, opts = {}) ⇒ Object
Hide rows in worksheet.
-
#post_import(post_import_request, opts = {}) ⇒ Object
Import data into an Excel file and generate output files in various formats.
-
#post_import_data(post_import_data_request, opts = {}) ⇒ Object
Import data into the Excel file.
-
#post_lock(post_lock_request, opts = {}) ⇒ Object
Lock Excel files.
-
#post_merge(post_merge_request, opts = {}) ⇒ Object
Merge cells in the worksheet.
-
#post_metadata(post_metadata_request, opts = {}) ⇒ Object
Update document properties in Excel file, and save them is various formats.
-
#post_move_worksheet(post_move_worksheet_request, opts = {}) ⇒ Object
Move worksheet in the workbook.
-
#post_page_setup(post_page_setup_request, opts = {}) ⇒ Object
Update page setup in the worksheet.
-
#post_pivot_table_cell_style(post_pivot_table_cell_style_request, opts = {}) ⇒ Object
Update cell style in the PivotTable.
-
#post_pivot_table_field_hide_item(post_pivot_table_field_hide_item_request, opts = {}) ⇒ Object
Hide a pivot field item in the PivotTable.
-
#post_pivot_table_field_move_to(post_pivot_table_field_move_to_request, opts = {}) ⇒ Object
Move a pivot field in the PivotTable.
-
#post_pivot_table_style(post_pivot_table_style_request, opts = {}) ⇒ Object
Update style in the PivotTable.
-
#post_pivot_table_update_pivot_field(post_pivot_table_update_pivot_field_request, opts = {}) ⇒ Object
Update pivot field in the PivotTable.
-
#post_pivot_table_update_pivot_fields(post_pivot_table_update_pivot_fields_request, opts = {}) ⇒ Object
Update pivot fields in the PivotTable.
-
#post_protect(post_protect_request, opts = {}) ⇒ Object
Excel files encryption.
-
#post_protect_workbook(post_protect_workbook_request, opts = {}) ⇒ Object
Excel protection.
- #post_remove_characters(post_remove_characters_request, opts = {}) ⇒ Object
- #post_remove_duplicates(post_remove_duplicates_request, opts = {}) ⇒ Object
-
#post_rename_worksheet(post_rename_worksheet_request, opts = {}) ⇒ Object
Rename worksheet in the workbook.
-
#post_repair(post_repair_request, opts = {}) ⇒ Object
Repair abnormal files and generate files in various formats.
-
#post_replace(post_replace_request, opts = {}) ⇒ Object
Replace specified text with new text in Excel files.
-
#post_reverse(post_reverse_request, opts = {}) ⇒ Object
Reverse rows or columns in Excel files and create output files in various formats.
-
#post_rotate(post_rotate_request, opts = {}) ⇒ Object
Rotate rows, columns, or other objects in Excel files and save them in various formats.
-
#post_row_style(post_row_style_request, opts = {}) ⇒ Object
Apply formats to an entire row in the worksheet.
-
#post_run_task(post_run_task_request, opts = {}) ⇒ Object
Run tasks.
-
#post_search(post_search_request, opts = {}) ⇒ Object
Search for specified text within Excel files.
-
#post_set_cell_html_string(post_set_cell_html_string_request, opts = {}) ⇒ Object
Set the HTML string containing data and specific formats in this cell.
-
#post_set_cell_range_value(post_set_cell_range_value_request, opts = {}) ⇒ Object
Set the value of the range in the worksheet.
-
#post_set_worksheet_column_width(post_set_worksheet_column_width_request, opts = {}) ⇒ Object
Set worksheet column width.
- #post_specify_words_count(post_specify_words_count_request, opts = {}) ⇒ Object
-
#post_split(post_split_request, opts = {}) ⇒ Object
Split Excel spreadsheet files based on worksheets and create output files in various formats.
- #post_split_text(post_split_text_request, opts = {}) ⇒ Object
- #post_trim_content(post_trim_content_request, opts = {}) ⇒ Object
-
#post_ungroup_worksheet_columns(post_ungroup_worksheet_columns_request, opts = {}) ⇒ Object
Ungroup worksheet columns.
-
#post_ungroup_worksheet_rows(post_ungroup_worksheet_rows_request, opts = {}) ⇒ Object
Ungroup rows in the worksheet.
-
#post_unhide_worksheet_columns(post_unhide_worksheet_columns_request, opts = {}) ⇒ Object
Unhide worksheet columns in the worksheet.
-
#post_unhide_worksheet_rows(post_unhide_worksheet_rows_request, opts = {}) ⇒ Object
Unhide rows in the worksheet.
-
#post_unlock(post_unlock_request, opts = {}) ⇒ Object
Unlock Excel files.
- #post_update_word_case(post_update_word_case_request, opts = {}) ⇒ Object
-
#post_update_worksheet_cell_style(post_update_worksheet_cell_style_request, opts = {}) ⇒ Object
Set cell style using cell name in the worksheet.
-
#post_update_worksheet_ole_object(post_update_worksheet_ole_object_request, opts = {}) ⇒ Object
Update an OLE object in worksheet.
-
#post_update_worksheet_property(post_update_worksheet_property_request, opts = {}) ⇒ Object
Update worksheet properties in the workbook.
-
#post_update_worksheet_range_style(post_update_worksheet_range_style_request, opts = {}) ⇒ Object
Update cell range styles in the worksheet.
-
#post_update_worksheet_row(post_update_worksheet_row_request, opts = {}) ⇒ Object
Update height of rows in the worksheet.
-
#post_update_worksheet_zoom(post_update_worksheet_zoom_request, opts = {}) ⇒ Object
Update the scaling percentage in the worksheet.
-
#post_watermark(post_watermark_request, opts = {}) ⇒ Object
Add Text Watermark to Excel files and generate output files in various formats.
- #post_words_count(post_words_count_request, opts = {}) ⇒ Object
-
#post_workbook_calculate_formula(post_workbook_calculate_formula_request, opts = {}) ⇒ Object
Calculate all formulas in the workbook.
-
#post_workbook_data_cleansing(post_workbook_data_cleansing_request, opts = {}) ⇒ Object
Data cleaning of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.
-
#post_workbook_data_deduplication(post_workbook_data_deduplication_request, opts = {}) ⇒ Object
Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.
-
#post_workbook_data_fill(post_workbook_data_fill_request, opts = {}) ⇒ Object
Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.
-
#post_workbook_export_xml(post_workbook_export_xml_request, opts = {}) ⇒ Object
Export XML data from an Excel file.
-
#post_workbook_get_smart_marker_result(post_workbook_get_smart_marker_result_request, opts = {}) ⇒ Object
Smart marker processing.
-
#post_workbook_import_json(post_workbook_import_json_request, opts = {}) ⇒ Object
Import a JSON data file into the workbook.
-
#post_workbook_import_xml(post_workbook_import_xml_request, opts = {}) ⇒ Object
Import an XML data file into an Excel file.
-
#post_workbook_name(post_workbook_name_request, opts = {}) ⇒ Object
Update a named range in the workbook.
-
#post_workbook_save_as(post_workbook_save_as_request, opts = {}) ⇒ Object
Save an Excel file in various formats.
-
#post_workbook_settings(post_workbook_settings_request, opts = {}) ⇒ Object
Update setting in the workbook.
-
#post_workbook_split(post_workbook_split_request, opts = {}) ⇒ Object
Split the workbook with a specific format.
-
#post_workbook_text_replace(post_workbook_text_replace_request, opts = {}) ⇒ Object
Replace text in the workbook.
-
#post_workbooks_merge(post_workbooks_merge_request, opts = {}) ⇒ Object
Merge a workbook into the existing workbook.
-
#post_workbooks_text_search(post_workbooks_text_search_request, opts = {}) ⇒ Object
Search for text in the workbook.
-
#post_worksheet_auto_filter_refresh(post_worksheet_auto_filter_refresh_request, opts = {}) ⇒ Object
Refresh auto filters in the worksheet.
-
#post_worksheet_calculate_formula(post_worksheet_calculate_formula_request, opts = {}) ⇒ Object
Calculate formula in the worksheet.
-
#post_worksheet_cell_set_value(post_worksheet_cell_set_value_request, opts = {}) ⇒ Object
Set cell value using cell name in the worksheet.
-
#post_worksheet_cells_range_column_width(post_worksheet_cells_range_column_width_request, opts = {}) ⇒ Object
Set the column width of the specified range.
-
#post_worksheet_cells_range_merge(post_worksheet_cells_range_merge_request, opts = {}) ⇒ Object
Merge a range of cells into a single cell.
-
#post_worksheet_cells_range_move_to(post_worksheet_cells_range_move_to_request, opts = {}) ⇒ Object
Move the current range to the destination range.
-
#post_worksheet_cells_range_outline_border(post_worksheet_cells_range_outline_border_request, opts = {}) ⇒ Object
Apply an outline border around a range of cells.
-
#post_worksheet_cells_range_row_height(post_worksheet_cells_range_row_height_request, opts = {}) ⇒ Object
Sets row height of range.
-
#post_worksheet_cells_range_sort(post_worksheet_cells_range_sort_request, opts = {}) ⇒ Object
Perform data sorting around a range of cells.
-
#post_worksheet_cells_range_style(post_worksheet_cells_range_style_request, opts = {}) ⇒ Object
Set the style for the specified range.
- #post_worksheet_cells_range_to_image(post_worksheet_cells_range_to_image_request, opts = {}) ⇒ Object
-
#post_worksheet_cells_range_un_merge(post_worksheet_cells_range_un_merge_request, opts = {}) ⇒ Object
Unmerge merged cells within this range.
-
#post_worksheet_cells_range_value(post_worksheet_cells_range_value_request, opts = {}) ⇒ Object
Assign a value to the range; if necessary, the value will be converted to another data type, and the cell’s number format will be reset.
-
#post_worksheet_cells_ranges_copy(post_worksheet_cells_ranges_copy_request, opts = {}) ⇒ Object
Copy content from the source range to the destination range in the worksheet.
-
#post_worksheet_chart(post_worksheet_chart_request, opts = {}) ⇒ Object
Update chart properties in the worksheet.
-
#post_worksheet_chart_legend(post_worksheet_chart_legend_request, opts = {}) ⇒ Object
Update chart legend in the worksheet.
-
#post_worksheet_chart_title(post_worksheet_chart_title_request, opts = {}) ⇒ Object
Update chart title in the worksheet.
-
#post_worksheet_comment(post_worksheet_comment_request, opts = {}) ⇒ Object
Update cell comment in the worksheet.
-
#post_worksheet_group_shape(post_worksheet_group_shape_request, opts = {}) ⇒ Object
Group shapes in the worksheet.
-
#post_worksheet_hyperlink(post_worksheet_hyperlink_request, opts = {}) ⇒ Object
Update hyperlink by index in the worksheet.
-
#post_worksheet_list_column(post_worksheet_list_column_request, opts = {}) ⇒ Object
Update list column in list object.
-
#post_worksheet_list_columns_total(post_worksheet_list_columns_total_request, opts = {}) ⇒ Object
Update total of list columns in the table.
-
#post_worksheet_list_object(post_worksheet_list_object_request, opts = {}) ⇒ Object
Update list object by index in the worksheet.
-
#post_worksheet_list_object_convert_to_range(post_worksheet_list_object_convert_to_range_request, opts = {}) ⇒ Object
Convert list object to range in the worksheet.
-
#post_worksheet_list_object_insert_slicer(post_worksheet_list_object_insert_slicer_request, opts = {}) ⇒ Object
Insert slicer for list object.
-
#post_worksheet_list_object_remove_duplicates(post_worksheet_list_object_remove_duplicates_request, opts = {}) ⇒ Object
Remove duplicates in list object.
-
#post_worksheet_list_object_sort_table(post_worksheet_list_object_sort_table_request, opts = {}) ⇒ Object
Sort list object in the worksheet.
-
#post_worksheet_list_object_summarize_with_pivot_table(post_worksheet_list_object_summarize_with_pivot_table_request, opts = {}) ⇒ Object
Create a pivot table with a list object in the worksheet.
-
#post_worksheet_match_blanks(post_worksheet_match_blanks_request, opts = {}) ⇒ Object
Match all blank cells in the list.
-
#post_worksheet_match_non_blanks(post_worksheet_match_non_blanks_request, opts = {}) ⇒ Object
Match all not blank cells in the list.
-
#post_worksheet_merge(post_worksheet_merge_request, opts = {}) ⇒ Object
Merge cells in the worksheet.
-
#post_worksheet_picture(post_worksheet_picture_request, opts = {}) ⇒ Object
Update a picture by index in the worksheet.
-
#post_worksheet_pivot_table_calculate(post_worksheet_pivot_table_calculate_request, opts = {}) ⇒ Object
Calculate pivottable’s data to cells.
-
#post_worksheet_pivot_table_move(post_worksheet_pivot_table_move_request, opts = {}) ⇒ Object
Move PivotTable in the worksheet.
-
#post_worksheet_range_sort(post_worksheet_range_sort_request, opts = {}) ⇒ Object
Sort a range in the worksheet.
-
#post_worksheet_shape(post_worksheet_shape_request, opts = {}) ⇒ Object
Update a shape in the worksheet.
-
#post_worksheet_sparkline_group(post_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Update a sparkline group in the worksheet.
-
#post_worksheet_text_replace(post_worksheet_text_replace_request, opts = {}) ⇒ Object
Replace old text with new text in the worksheet.
-
#post_worksheet_text_search(post_worksheet_text_search_request, opts = {}) ⇒ Object
Search for text in the worksheet.
-
#post_worksheet_ungroup_shape(post_worksheet_ungroup_shape_request, opts = {}) ⇒ Object
Ungroup shapes in the worksheet.
-
#post_worksheet_unmerge(post_worksheet_unmerge_request, opts = {}) ⇒ Object
Unmerge cells in the worksheet.
-
#post_worksheet_validation(post_worksheet_validation_request, opts = {}) ⇒ Object
Update a validation by index in the worksheet.
-
#put_active_worksheet(put_active_worksheet_request, opts = {}) ⇒ Object
Set active worksheet index in the workbook.
-
#put_add_new_worksheet(put_add_new_worksheet_request, opts = {}) ⇒ Object
Add a new worksheet in the workbook.
-
#put_change_visibility_worksheet(put_change_visibility_worksheet_request, opts = {}) ⇒ Object
Change worksheet visibility in the workbook.
-
#put_convert_workbook(put_convert_workbook_request, opts = {}) ⇒ Object
Convert the workbook from the requested content into files in different formats.
-
#put_document_property(put_document_property_request, opts = {}) ⇒ Object
Set or add an Excel property.
-
#put_document_protect_from_changes(put_document_protect_from_changes_request, opts = {}) ⇒ Object
Excel file write protection.
-
#put_horizontal_page_break(put_horizontal_page_break_request, opts = {}) ⇒ Object
Add a horizontal page breaks in the worksheet.
-
#put_insert_new_worksheet(put_insert_new_worksheet_request, opts = {}) ⇒ Object
Insert a new worksheet in the workbook.
-
#put_insert_worksheet_columns(put_insert_worksheet_columns_request, opts = {}) ⇒ Object
Insert worksheet columns in the worksheet.
-
#put_insert_worksheet_row(put_insert_worksheet_row_request, opts = {}) ⇒ Object
Insert a new row in the worksheet.
-
#put_insert_worksheet_rows(put_insert_worksheet_rows_request, opts = {}) ⇒ Object
Insert several new rows in the worksheet.
-
#put_pivot_table_field(put_pivot_table_field_request, opts = {}) ⇒ Object
Add a pivot field in the PivotTable.
-
#put_protect_worksheet(put_protect_worksheet_request, opts = {}) ⇒ Object
Protect worksheet.
-
#put_vertical_page_break(put_vertical_page_break_request, opts = {}) ⇒ Object
Add a vertical page break in the worksheet.
-
#put_workbook_background(put_workbook_background_request, opts = {}) ⇒ Object
Set background in the workbook.
-
#put_workbook_create(put_workbook_create_request, opts = {}) ⇒ Object
Create a new workbook using different methods.
-
#put_workbook_name(put_workbook_name_request, opts = {}) ⇒ Object
Define a new name in the workbook.
-
#put_workbook_water_marker(put_workbook_water_marker_request, opts = {}) ⇒ Object
Set water marker in the workbook.
-
#put_worksheet_add_picture(put_worksheet_add_picture_request, opts = {}) ⇒ Object
Add a new picture in the worksheet.
-
#put_worksheet_background(put_worksheet_background_request, opts = {}) ⇒ Object
Set background image in the worksheet.
-
#put_worksheet_cells_range(put_worksheet_cells_range_request, opts = {}) ⇒ Object
Insert a range of cells and shift existing cells based on the specified shift option.
-
#put_worksheet_chart(put_worksheet_chart_request, opts = {}) ⇒ Object
Add a new chart in the worksheet.
-
#put_worksheet_chart_legend(put_worksheet_chart_legend_request, opts = {}) ⇒ Object
Show chart legend in the worksheet.
-
#put_worksheet_chart_title(put_worksheet_chart_title_request, opts = {}) ⇒ Object
Set chart title in the worksheet.
-
#put_worksheet_color_filter(put_worksheet_color_filter_request, opts = {}) ⇒ Object
Add a color filter in the worksheet.
-
#put_worksheet_comment(put_worksheet_comment_request, opts = {}) ⇒ Object
Add cell comment in the worksheet.
-
#put_worksheet_conditional_formatting(put_worksheet_conditional_formatting_request, opts = {}) ⇒ Object
Add conditional formatting in the worksheet.
-
#put_worksheet_custom_filter(put_worksheet_custom_filter_request, opts = {}) ⇒ Object
Filter a list with custom criteria in the worksheet.
-
#put_worksheet_date_filter(put_worksheet_date_filter_request, opts = {}) ⇒ Object
Apply a date filter in the worksheet.
-
#put_worksheet_dynamic_filter(put_worksheet_dynamic_filter_request, opts = {}) ⇒ Object
Add a dynamic filter in the worksheet.
-
#put_worksheet_filter(put_worksheet_filter_request, opts = {}) ⇒ Object
Add a filter for a column in the worksheet.
-
#put_worksheet_filter_top10(put_worksheet_filter_top10_request, opts = {}) ⇒ Object
Filter the top 10 items in the list in the worksheet.
-
#put_worksheet_format_condition(put_worksheet_format_condition_request, opts = {}) ⇒ Object
Add a format condition in the worksheet.
-
#put_worksheet_format_condition_area(put_worksheet_format_condition_area_request, opts = {}) ⇒ Object
Add a cell area for the format condition in the worksheet.
-
#put_worksheet_format_condition_condition(put_worksheet_format_condition_condition_request, opts = {}) ⇒ Object
Add a condition for the format condition in the worksheet.
-
#put_worksheet_freeze_panes(put_worksheet_freeze_panes_request, opts = {}) ⇒ Object
Set freeze panes in the worksheet.
-
#put_worksheet_hyperlink(put_worksheet_hyperlink_request, opts = {}) ⇒ Object
Add hyperlink in the worksheet.
-
#put_worksheet_icon_filter(put_worksheet_icon_filter_request, opts = {}) ⇒ Object
Add an icon filter in the worksheet.
-
#put_worksheet_list_object(put_worksheet_list_object_request, opts = {}) ⇒ Object
Add a ListObject in the worksheet.
-
#put_worksheet_ole_object(put_worksheet_ole_object_request, opts = {}) ⇒ Object
Add an OLE object in the worksheet.
-
#put_worksheet_pivot_table(put_worksheet_pivot_table_request, opts = {}) ⇒ Object
Add a PivotTable in the worksheet.
-
#put_worksheet_pivot_table_filter(put_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object
Add a pivot filter to the PivotTable.
-
#put_worksheet_shape(put_worksheet_shape_request, opts = {}) ⇒ Object
Add a shape in the worksheet.
-
#put_worksheet_sparkline_group(put_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Add a sparkline group in the worksheet.
-
#put_worksheet_validation(put_worksheet_validation_request, opts = {}) ⇒ Object
Add a validation at index in the worksheet.
- #storage_exists(storage_exists_request, opts = {}) ⇒ Object
- #upload_file(upload_file_request, opts = {}) ⇒ Object
Constructor Details
#initialize(client_id, client_secret, app_version = 'v3.0', app_host = 'api.aspose.cloud', api_client = ApiClient.default) ⇒ CellsApi
Returns a new instance of CellsApi.
35 36 37 38 39 40 41 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 35 def initialize(client_id,client_secret, app_version = 'v3.0', app_host = 'api.aspose.cloud', api_client = ApiClient.default) @api_client = api_client @api_client.config.client_secret = client_secret @api_client.config.client_id = client_id @api_client.config.api_version = app_version @api_client.config.host = app_host end |
Instance Attribute Details
#api_client ⇒ Object
Returns the value of attribute api_client.
33 34 35 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 33 def api_client @api_client end |
Instance Method Details
#add_picture_in_cell(add_picture_in_cell_request, opts = {}) ⇒ Object
add new picture in the cells.
1571 1572 1573 1574 1575 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1571 def add_picture_in_cell( add_picture_in_cell_request, opts = {}) data, _status_code, _headers = add_picture_in_cell_request.create_http_request(@api_client,opts ) return data end |
#check_workbook_formula_errors(check_workbook_formula_errors_request, opts = {}) ⇒ Object
962 963 964 965 966 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 962 def check_workbook_formula_errors( check_workbook_formula_errors_request, opts = {}) data, _status_code, _headers = check_workbook_formula_errors_request.create_http_request(@api_client,opts ) return data end |
#check_wrokbook_external_reference(check_wrokbook_external_reference_request, opts = {}) ⇒ Object
Export Excel internal elements or the workbook itself to various format files.
955 956 957 958 959 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 955 def check_wrokbook_external_reference( check_wrokbook_external_reference_request, opts = {}) data, _status_code, _headers = check_wrokbook_external_reference_request.create_http_request(@api_client,opts ) return data end |
#copy_file(copy_file_request, opts = {}) ⇒ Object
2773 2774 2775 2776 2777 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2773 def copy_file( copy_file_request, opts = {}) data, _status_code, _headers = copy_file_request.create_http_request(@api_client,opts ) return data end |
#copy_folder(copy_folder_request, opts = {}) ⇒ Object
2808 2809 2810 2811 2812 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2808 def copy_folder( copy_folder_request, opts = {}) data, _status_code, _headers = copy_folder_request.create_http_request(@api_client,opts ) return data end |
#create_folder(create_folder_request, opts = {}) ⇒ Object
2801 2802 2803 2804 2805 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2801 def create_folder( create_folder_request, opts = {}) data, _status_code, _headers = create_folder_request.create_http_request(@api_client,opts ) return data end |
#delete_decrypt_workbook(delete_decrypt_workbook_request, opts = {}) ⇒ Object
Excel files decryption.
1827 1828 1829 1830 1831 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1827 def delete_decrypt_workbook( delete_decrypt_workbook_request, opts = {}) data, _status_code, _headers = delete_decrypt_workbook_request.create_http_request(@api_client,opts ) return data end |
#delete_document_properties(delete_document_properties_request, opts = {}) ⇒ Object
Delete all custom document properties and reset built-in ones.
1803 1804 1805 1806 1807 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1803 def delete_document_properties( delete_document_properties_request, opts = {}) data, _status_code, _headers = delete_document_properties_request.create_http_request(@api_client,opts ) return data end |
#delete_document_property(delete_document_property_request, opts = {}) ⇒ Object
Delete an Excel property.
1795 1796 1797 1798 1799 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1795 def delete_document_property( delete_document_property_request, opts = {}) data, _status_code, _headers = delete_document_property_request.create_http_request(@api_client,opts ) return data end |
#delete_document_un_protect_from_changes(delete_document_un_protect_from_changes_request, opts = {}) ⇒ Object
Excel file cancel write protection.
1859 1860 1861 1862 1863 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1859 def delete_document_un_protect_from_changes( delete_document_un_protect_from_changes_request, opts = {}) data, _status_code, _headers = delete_document_un_protect_from_changes_request.create_http_request(@api_client,opts ) return data end |
#delete_file(delete_file_request, opts = {}) ⇒ Object
2787 2788 2789 2790 2791 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2787 def delete_file( delete_file_request, opts = {}) data, _status_code, _headers = delete_file_request.create_http_request(@api_client,opts ) return data end |
#delete_folder(delete_folder_request, opts = {}) ⇒ Object
2822 2823 2824 2825 2826 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2822 def delete_folder( delete_folder_request, opts = {}) data, _status_code, _headers = delete_folder_request.create_http_request(@api_client,opts ) return data end |
#delete_header_footer(delete_header_footer_request, opts = {}) ⇒ Object
Clear header and footer in the worksheet.
1491 1492 1493 1494 1495 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1491 def ( , opts = {}) data, _status_code, _headers = .create_http_request(@api_client,opts ) return data end |
#delete_horizontal_page_break(delete_horizontal_page_break_request, opts = {}) ⇒ Object
Delete a horizontal page break in the worksheet.
1467 1468 1469 1470 1471 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1467 def delete_horizontal_page_break( delete_horizontal_page_break_request, opts = {}) data, _status_code, _headers = delete_horizontal_page_break_request.create_http_request(@api_client,opts ) return data end |
#delete_horizontal_page_breaks(delete_horizontal_page_breaks_request, opts = {}) ⇒ Object
Delete horizontal page breaks in the worksheet.
1451 1452 1453 1454 1455 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1451 def delete_horizontal_page_breaks( delete_horizontal_page_breaks_request, opts = {}) data, _status_code, _headers = delete_horizontal_page_breaks_request.create_http_request(@api_client,opts ) return data end |
#delete_metadata(delete_metadata_request, opts = {}) ⇒ Object
Delete cells document properties in Excel file, and save them is various formats.
1235 1236 1237 1238 1239 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1235 def ( , opts = {}) data, _status_code, _headers = .create_http_request(@api_client,opts ) return data end |
#delete_pivot_table_field(delete_pivot_table_field_request, opts = {}) ⇒ Object
Delete a pivot field in the PivotTable.
1747 1748 1749 1750 1751 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1747 def delete_pivot_table_field( delete_pivot_table_field_request, opts = {}) data, _status_code, _headers = delete_pivot_table_field_request.create_http_request(@api_client,opts ) return data end |
#delete_un_protect_workbook(delete_un_protect_workbook_request, opts = {}) ⇒ Object
Excel unprotection.
1843 1844 1845 1846 1847 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1843 def delete_un_protect_workbook( delete_un_protect_workbook_request, opts = {}) data, _status_code, _headers = delete_un_protect_workbook_request.create_http_request(@api_client,opts ) return data end |
#delete_unprotect_worksheet(delete_unprotect_worksheet_request, opts = {}) ⇒ Object
Unprotect worksheet.
2480 2481 2482 2483 2484 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2480 def delete_unprotect_worksheet( delete_unprotect_worksheet_request, opts = {}) data, _status_code, _headers = delete_unprotect_worksheet_request.create_http_request(@api_client,opts ) return data end |
#delete_vertical_page_break(delete_vertical_page_break_request, opts = {}) ⇒ Object
Delete a vertical page break in the worksheet.
1459 1460 1461 1462 1463 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1459 def delete_vertical_page_break( delete_vertical_page_break_request, opts = {}) data, _status_code, _headers = delete_vertical_page_break_request.create_http_request(@api_client,opts ) return data end |
#delete_vertical_page_breaks(delete_vertical_page_breaks_request, opts = {}) ⇒ Object
Delete vertical page breaks in the worksheet.
1443 1444 1445 1446 1447 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1443 def delete_vertical_page_breaks( delete_vertical_page_breaks_request, opts = {}) data, _status_code, _headers = delete_vertical_page_breaks_request.create_http_request(@api_client,opts ) return data end |
#delete_workbook_background(delete_workbook_background_request, opts = {}) ⇒ Object
Delete background in the workbook.
2368 2369 2370 2371 2372 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2368 def delete_workbook_background( delete_workbook_background_request, opts = {}) data, _status_code, _headers = delete_workbook_background_request.create_http_request(@api_client,opts ) return data end |
#delete_workbook_name(delete_workbook_name_request, opts = {}) ⇒ Object
Delete a named range in the workbook.
2264 2265 2266 2267 2268 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2264 def delete_workbook_name( delete_workbook_name_request, opts = {}) data, _status_code, _headers = delete_workbook_name_request.create_http_request(@api_client,opts ) return data end |
#delete_workbook_names(delete_workbook_names_request, opts = {}) ⇒ Object
Delete all named ranges in the workbook.
2256 2257 2258 2259 2260 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2256 def delete_workbook_names( delete_workbook_names_request, opts = {}) data, _status_code, _headers = delete_workbook_names_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet(delete_worksheet_request, opts = {}) ⇒ Object
Delete a worksheet in the workbook.
2448 2449 2450 2451 2452 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2448 def delete_worksheet( delete_worksheet_request, opts = {}) data, _status_code, _headers = delete_worksheet_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_background(delete_worksheet_background_request, opts = {}) ⇒ Object
Delete background image in the worksheet.
2632 2633 2634 2635 2636 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2632 def delete_worksheet_background( delete_worksheet_background_request, opts = {}) data, _status_code, _headers = delete_worksheet_background_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_cells_range(delete_worksheet_cells_range_request, opts = {}) ⇒ Object
Delete a range of cells and shift existing cells based on the specified shift option.
1994 1995 1996 1997 1998 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1994 def delete_worksheet_cells_range( delete_worksheet_cells_range_request, opts = {}) data, _status_code, _headers = delete_worksheet_cells_range_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_chart(delete_worksheet_chart_request, opts = {}) ⇒ Object
Delete a chart by index in the worksheet.
605 606 607 608 609 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 605 def delete_worksheet_chart( delete_worksheet_chart_request, opts = {}) data, _status_code, _headers = delete_worksheet_chart_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_chart_legend(delete_worksheet_chart_legend_request, opts = {}) ⇒ Object
Hides chart legend in the worksheet.
645 646 647 648 649 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 645 def delete_worksheet_chart_legend( delete_worksheet_chart_legend_request, opts = {}) data, _status_code, _headers = delete_worksheet_chart_legend_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_chart_title(delete_worksheet_chart_title_request, opts = {}) ⇒ Object
Hide chart title in the worksheet.
685 686 687 688 689 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 685 def delete_worksheet_chart_title( delete_worksheet_chart_title_request, opts = {}) data, _status_code, _headers = delete_worksheet_chart_title_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_charts(delete_worksheet_charts_request, opts = {}) ⇒ Object
Clear the charts in the worksheets.
653 654 655 656 657 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 653 def delete_worksheet_charts( delete_worksheet_charts_request, opts = {}) data, _status_code, _headers = delete_worksheet_charts_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_columns(delete_worksheet_columns_request, opts = {}) ⇒ Object
Delete worksheet columns in the worksheet.
381 382 383 384 385 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 381 def delete_worksheet_columns( delete_worksheet_columns_request, opts = {}) data, _status_code, _headers = delete_worksheet_columns_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_comment(delete_worksheet_comment_request, opts = {}) ⇒ Object
Delete cell comment in the worksheet.
2528 2529 2530 2531 2532 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2528 def delete_worksheet_comment( delete_worksheet_comment_request, opts = {}) data, _status_code, _headers = delete_worksheet_comment_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_comments(delete_worksheet_comments_request, opts = {}) ⇒ Object
Delete all comments in the worksheet.
2536 2537 2538 2539 2540 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2536 def delete_worksheet_comments( delete_worksheet_comments_request, opts = {}) data, _status_code, _headers = delete_worksheet_comments_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_conditional_formatting(delete_worksheet_conditional_formatting_request, opts = {}) ⇒ Object
Remove a conditional formatting.
829 830 831 832 833 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 829 def delete_worksheet_conditional_formatting( delete_worksheet_conditional_formatting_request, opts = {}) data, _status_code, _headers = delete_worksheet_conditional_formatting_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_conditional_formatting_area(delete_worksheet_conditional_formatting_area_request, opts = {}) ⇒ Object
Remove cell area from conditional formatting.
837 838 839 840 841 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 837 def delete_worksheet_conditional_formatting_area( delete_worksheet_conditional_formatting_area_request, opts = {}) data, _status_code, _headers = delete_worksheet_conditional_formatting_area_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_conditional_formattings(delete_worksheet_conditional_formattings_request, opts = {}) ⇒ Object
Clear all conditional formattings in the worksheet.
821 822 823 824 825 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 821 def delete_worksheet_conditional_formattings( delete_worksheet_conditional_formattings_request, opts = {}) data, _status_code, _headers = delete_worksheet_conditional_formattings_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_date_filter(delete_worksheet_date_filter_request, opts = {}) ⇒ Object
Remove a date filter in the worksheet.
141 142 143 144 145 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 141 def delete_worksheet_date_filter( delete_worksheet_date_filter_request, opts = {}) data, _status_code, _headers = delete_worksheet_date_filter_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_filter(delete_worksheet_filter_request, opts = {}) ⇒ Object
Delete a filter for a column in the worksheet.
149 150 151 152 153 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 149 def delete_worksheet_filter( delete_worksheet_filter_request, opts = {}) data, _status_code, _headers = delete_worksheet_filter_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_freeze_panes(delete_worksheet_freeze_panes_request, opts = {}) ⇒ Object
Unfreeze panes in worksheet.
2648 2649 2650 2651 2652 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2648 def delete_worksheet_freeze_panes( delete_worksheet_freeze_panes_request, opts = {}) data, _status_code, _headers = delete_worksheet_freeze_panes_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_hyperlink(delete_worksheet_hyperlink_request, opts = {}) ⇒ Object
Delete hyperlink by index in the worksheet.
1091 1092 1093 1094 1095 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1091 def delete_worksheet_hyperlink( delete_worksheet_hyperlink_request, opts = {}) data, _status_code, _headers = delete_worksheet_hyperlink_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_hyperlinks(delete_worksheet_hyperlinks_request, opts = {}) ⇒ Object
Delete all hyperlinks in the worksheet.
1115 1116 1117 1118 1119 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1115 def delete_worksheet_hyperlinks( delete_worksheet_hyperlinks_request, opts = {}) data, _status_code, _headers = delete_worksheet_hyperlinks_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_list_object(delete_worksheet_list_object_request, opts = {}) ⇒ Object
Delete list object by index in the worksheet.
1275 1276 1277 1278 1279 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1275 def delete_worksheet_list_object( delete_worksheet_list_object_request, opts = {}) data, _status_code, _headers = delete_worksheet_list_object_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_list_objects(delete_worksheet_list_objects_request, opts = {}) ⇒ Object
Delete ListObjects in the worksheet.
1267 1268 1269 1270 1271 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1267 def delete_worksheet_list_objects( delete_worksheet_list_objects_request, opts = {}) data, _status_code, _headers = delete_worksheet_list_objects_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_ole_object(delete_worksheet_ole_object_request, opts = {}) ⇒ Object
Delete an OLE object in the worksheet.
1371 1372 1373 1374 1375 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1371 def delete_worksheet_ole_object( delete_worksheet_ole_object_request, opts = {}) data, _status_code, _headers = delete_worksheet_ole_object_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_ole_objects(delete_worksheet_ole_objects_request, opts = {}) ⇒ Object
Delete all OLE objects in the worksheet.
1363 1364 1365 1366 1367 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1363 def delete_worksheet_ole_objects( delete_worksheet_ole_objects_request, opts = {}) data, _status_code, _headers = delete_worksheet_ole_objects_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_picture(delete_worksheet_picture_request, opts = {}) ⇒ Object
Delete a picture object by index in the worksheet.
1587 1588 1589 1590 1591 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1587 def delete_worksheet_picture( delete_worksheet_picture_request, opts = {}) data, _status_code, _headers = delete_worksheet_picture_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_pictures(delete_worksheet_pictures_request, opts = {}) ⇒ Object
Delete all pictures in the worksheet.
1595 1596 1597 1598 1599 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1595 def delete_worksheet_pictures( delete_worksheet_pictures_request, opts = {}) data, _status_code, _headers = delete_worksheet_pictures_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_pivot_table(delete_worksheet_pivot_table_request, opts = {}) ⇒ Object
Delete PivotTable by index in the worksheet.
1739 1740 1741 1742 1743 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1739 def delete_worksheet_pivot_table( delete_worksheet_pivot_table_request, opts = {}) data, _status_code, _headers = delete_worksheet_pivot_table_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_pivot_table_filter(delete_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object
Delete a pivot filter in the PivotTable.
1763 1764 1765 1766 1767 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1763 def delete_worksheet_pivot_table_filter( delete_worksheet_pivot_table_filter_request, opts = {}) data, _status_code, _headers = delete_worksheet_pivot_table_filter_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_pivot_table_filters(delete_worksheet_pivot_table_filters_request, opts = {}) ⇒ Object
Delete all pivot filters in the PivotTable.
1755 1756 1757 1758 1759 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1755 def delete_worksheet_pivot_table_filters( delete_worksheet_pivot_table_filters_request, opts = {}) data, _status_code, _headers = delete_worksheet_pivot_table_filters_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_pivot_tables(delete_worksheet_pivot_tables_request, opts = {}) ⇒ Object
Delete PivotTables in the worksheet.
1731 1732 1733 1734 1735 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1731 def delete_worksheet_pivot_tables( delete_worksheet_pivot_tables_request, opts = {}) data, _status_code, _headers = delete_worksheet_pivot_tables_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_row(delete_worksheet_row_request, opts = {}) ⇒ Object
Delete a row in the worksheet.
453 454 455 456 457 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 453 def delete_worksheet_row( delete_worksheet_row_request, opts = {}) data, _status_code, _headers = delete_worksheet_row_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_rows(delete_worksheet_rows_request, opts = {}) ⇒ Object
Delete several rows in the worksheet.
461 462 463 464 465 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 461 def delete_worksheet_rows( delete_worksheet_rows_request, opts = {}) data, _status_code, _headers = delete_worksheet_rows_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_shape(delete_worksheet_shape_request, opts = {}) ⇒ Object
Delete a shape in the worksheet.
2034 2035 2036 2037 2038 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2034 def delete_worksheet_shape( delete_worksheet_shape_request, opts = {}) data, _status_code, _headers = delete_worksheet_shape_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_shapes(delete_worksheet_shapes_request, opts = {}) ⇒ Object
Delete all shapes in the worksheet.
2026 2027 2028 2029 2030 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2026 def delete_worksheet_shapes( delete_worksheet_shapes_request, opts = {}) data, _status_code, _headers = delete_worksheet_shapes_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_sparkline_group(delete_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Delete a sparkline group in the worksheet.
2090 2091 2092 2093 2094 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2090 def delete_worksheet_sparkline_group( delete_worksheet_sparkline_group_request, opts = {}) data, _status_code, _headers = delete_worksheet_sparkline_group_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_sparkline_groups(delete_worksheet_sparkline_groups_request, opts = {}) ⇒ Object
Delete sparkline groups in the worksheet.
2082 2083 2084 2085 2086 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2082 def delete_worksheet_sparkline_groups( delete_worksheet_sparkline_groups_request, opts = {}) data, _status_code, _headers = delete_worksheet_sparkline_groups_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_validation(delete_worksheet_validation_request, opts = {}) ⇒ Object
Delete a validation by index in worksheet.
2744 2745 2746 2747 2748 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2744 def delete_worksheet_validation( delete_worksheet_validation_request, opts = {}) data, _status_code, _headers = delete_worksheet_validation_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheet_validations(delete_worksheet_validations_request, opts = {}) ⇒ Object
Delete all validations in the worksheet.
2752 2753 2754 2755 2756 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2752 def delete_worksheet_validations( delete_worksheet_validations_request, opts = {}) data, _status_code, _headers = delete_worksheet_validations_request.create_http_request(@api_client,opts ) return data end |
#delete_worksheets(delete_worksheets_request, opts = {}) ⇒ Object
Delete matched worksheets in the workbook.
2456 2457 2458 2459 2460 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2456 def delete_worksheets( delete_worksheets_request, opts = {}) data, _status_code, _headers = delete_worksheets_request.create_http_request(@api_client,opts ) return data end |
#download_file(download_file_request, opts = {}) ⇒ Object
2759 2760 2761 2762 2763 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2759 def download_file( download_file_request, opts = {}) data, _status_code, _headers = download_file_request.create_http_request(@api_client,opts ) return data end |
#get_all_styles(get_all_styles_request, opts = {}) ⇒ Object
Get all style in the workbook.
2392 2393 2394 2395 2396 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2392 def get_all_styles( get_all_styles_request, opts = {}) data, _status_code, _headers = get_all_styles_request.create_http_request(@api_client,opts ) return data end |
#get_cell_html_string(get_cell_html_string_request, opts = {}) ⇒ Object
Retrieve the HTML string containing data and specific formats in this cell.
317 318 319 320 321 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 317 def get_cell_html_string( get_cell_html_string_request, opts = {}) data, _status_code, _headers = get_cell_html_string_request.create_http_request(@api_client,opts ) return data end |
#get_cells_cloud_service_status(get_cells_cloud_service_status_request, opts = {}) ⇒ Object
Aspose.Cells Cloud service health status check.
549 550 551 552 553 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 549 def get_cells_cloud_service_status( get_cells_cloud_service_status_request, opts = {}) data, _status_code, _headers = get_cells_cloud_service_status_request.create_http_request(@api_client,opts ) return data end |
#get_cells_cloud_services_health_check(get_cells_cloud_services_health_check_request, opts = {}) ⇒ Object
Retrieve cell descriptions in a specified format.
541 542 543 544 545 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 541 def get_cells_cloud_services_health_check( get_cells_cloud_services_health_check_request, opts = {}) data, _status_code, _headers = get_cells_cloud_services_health_check_request.create_http_request(@api_client,opts ) return data end |
#get_chart_area(get_chart_area_request, opts = {}) ⇒ Object
Retrieve chart area description in the worksheet.
557 558 559 560 561 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 557 def get_chart_area( get_chart_area_request, opts = {}) data, _status_code, _headers = get_chart_area_request.create_http_request(@api_client,opts ) return data end |
#get_chart_area_border(get_chart_area_border_request, opts = {}) ⇒ Object
Retrieve chart area border description.
573 574 575 576 577 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 573 def get_chart_area_border( get_chart_area_border_request, opts = {}) data, _status_code, _headers = get_chart_area_border_request.create_http_request(@api_client,opts ) return data end |
#get_chart_area_fill_format(get_chart_area_fill_format_request, opts = {}) ⇒ Object
Retrieve chart area fill format description in the worksheet.
565 566 567 568 569 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 565 def get_chart_area_fill_format( get_chart_area_fill_format_request, opts = {}) data, _status_code, _headers = get_chart_area_fill_format_request.create_http_request(@api_client,opts ) return data end |
#get_chart_category_axis(get_chart_category_axis_request, opts = {}) ⇒ Object
Retrieve descriptions of chart series axis in the chart.
701 702 703 704 705 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 701 def get_chart_category_axis( get_chart_category_axis_request, opts = {}) data, _status_code, _headers = get_chart_category_axis_request.create_http_request(@api_client,opts ) return data end |
#get_chart_second_category_axis(get_chart_second_category_axis_request, opts = {}) ⇒ Object
Retrieve chart second category axis in the chart
717 718 719 720 721 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 717 def get_chart_second_category_axis( get_chart_second_category_axis_request, opts = {}) data, _status_code, _headers = get_chart_second_category_axis_request.create_http_request(@api_client,opts ) return data end |
#get_chart_second_value_axis(get_chart_second_value_axis_request, opts = {}) ⇒ Object
Retrieve chart second value axis in the chart.
725 726 727 728 729 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 725 def get_chart_second_value_axis( get_chart_second_value_axis_request, opts = {}) data, _status_code, _headers = get_chart_second_value_axis_request.create_http_request(@api_client,opts ) return data end |
#get_chart_series_axis(get_chart_series_axis_request, opts = {}) ⇒ Object
Retrieve descriptions of chart seriesaxis in the chart.
693 694 695 696 697 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 693 def get_chart_series_axis( get_chart_series_axis_request, opts = {}) data, _status_code, _headers = get_chart_series_axis_request.create_http_request(@api_client,opts ) return data end |
#get_chart_value_axis(get_chart_value_axis_request, opts = {}) ⇒ Object
Retrieve chart value axis in the chart.
709 710 711 712 713 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 709 def get_chart_value_axis( get_chart_value_axis_request, opts = {}) data, _status_code, _headers = get_chart_value_axis_request.create_http_request(@api_client,opts ) return data end |
#get_disc_usage(get_disc_usage_request, opts = {}) ⇒ Object
2843 2844 2845 2846 2847 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2843 def get_disc_usage( get_disc_usage_request, opts = {}) data, _status_code, _headers = get_disc_usage_request.create_http_request(@api_client,opts ) return data end |
#get_document_properties(get_document_properties_request, opts = {}) ⇒ Object
Retrieve descriptions of Excel file properties.
1771 1772 1773 1774 1775 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1771 def get_document_properties( get_document_properties_request, opts = {}) data, _status_code, _headers = get_document_properties_request.create_http_request(@api_client,opts ) return data end |
#get_document_property(get_document_property_request, opts = {}) ⇒ Object
Get Excel property by name.
1787 1788 1789 1790 1791 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1787 def get_document_property( get_document_property_request, opts = {}) data, _status_code, _headers = get_document_property_request.create_http_request(@api_client,opts ) return data end |
#get_file_versions(get_file_versions_request, opts = {}) ⇒ Object
2850 2851 2852 2853 2854 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2850 def get_file_versions( get_file_versions_request, opts = {}) data, _status_code, _headers = get_file_versions_request.create_http_request(@api_client,opts ) return data end |
#get_files_list(get_files_list_request, opts = {}) ⇒ Object
2794 2795 2796 2797 2798 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2794 def get_files_list( get_files_list_request, opts = {}) data, _status_code, _headers = get_files_list_request.create_http_request(@api_client,opts ) return data end |
#get_footer(get_footer_request, opts = {}) ⇒ Object
Retrieve page footer description in the worksheet.
1515 1516 1517 1518 1519 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1515 def ( , opts = {}) data, _status_code, _headers = .create_http_request(@api_client,opts ) return data end |
#get_header(get_header_request, opts = {}) ⇒ Object
Retrieve page header description in the worksheet.
1499 1500 1501 1502 1503 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1499 def get_header( get_header_request, opts = {}) data, _status_code, _headers = get_header_request.create_http_request(@api_client,opts ) return data end |
#get_horizontal_page_break(get_horizontal_page_break_request, opts = {}) ⇒ Object
Retrieve a horizontal page break descripton in the worksheet.
1419 1420 1421 1422 1423 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1419 def get_horizontal_page_break( get_horizontal_page_break_request, opts = {}) data, _status_code, _headers = get_horizontal_page_break_request.create_http_request(@api_client,opts ) return data end |
#get_horizontal_page_breaks(get_horizontal_page_breaks_request, opts = {}) ⇒ Object
Retrieve descriptions of horizontal page breaks in the worksheet.
1403 1404 1405 1406 1407 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1403 def get_horizontal_page_breaks( get_horizontal_page_breaks_request, opts = {}) data, _status_code, _headers = get_horizontal_page_breaks_request.create_http_request(@api_client,opts ) return data end |
#get_metadata(get_metadata_request, opts = {}) ⇒ Object
Get cells document properties.
1227 1228 1229 1230 1231 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1227 def ( , opts = {}) data, _status_code, _headers = .create_http_request(@api_client,opts ) return data end |
#get_named_range_value(get_named_range_value_request, opts = {}) ⇒ Object
Retrieve values in range.
2688 2689 2690 2691 2692 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2688 def get_named_range_value( get_named_range_value_request, opts = {}) data, _status_code, _headers = get_named_range_value_request.create_http_request(@api_client,opts ) return data end |
#get_named_ranges(get_named_ranges_request, opts = {}) ⇒ Object
Retrieve descriptions of ranges in the worksheets.
2680 2681 2682 2683 2684 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2680 def get_named_ranges( get_named_ranges_request, opts = {}) data, _status_code, _headers = get_named_ranges_request.create_http_request(@api_client,opts ) return data end |
#get_page_count(get_page_count_request, opts = {}) ⇒ Object
Get page count in the workbook.
2384 2385 2386 2387 2388 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2384 def get_page_count( get_page_count_request, opts = {}) data, _status_code, _headers = get_page_count_request.create_http_request(@api_client,opts ) return data end |
#get_page_setup(get_page_setup_request, opts = {}) ⇒ Object
Retrieve page setup description in the worksheet.
1475 1476 1477 1478 1479 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1475 def get_page_setup( get_page_setup_request, opts = {}) data, _status_code, _headers = get_page_setup_request.create_http_request(@api_client,opts ) return data end |
#get_pivot_table_field(get_pivot_table_field_request, opts = {}) ⇒ Object
Retrieve descriptions of pivot fields in the PivotTable.
1619 1620 1621 1622 1623 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1619 def get_pivot_table_field( get_pivot_table_field_request, opts = {}) data, _status_code, _headers = get_pivot_table_field_request.create_http_request(@api_client,opts ) return data end |
#get_vertical_page_break(get_vertical_page_break_request, opts = {}) ⇒ Object
Retrieve a vertical page break description in the worksheet.
1411 1412 1413 1414 1415 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1411 def get_vertical_page_break( get_vertical_page_break_request, opts = {}) data, _status_code, _headers = get_vertical_page_break_request.create_http_request(@api_client,opts ) return data end |
#get_vertical_page_breaks(get_vertical_page_breaks_request, opts = {}) ⇒ Object
Retrieve descriptions of vertical page breaks in the worksheet.
1395 1396 1397 1398 1399 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1395 def get_vertical_page_breaks( get_vertical_page_breaks_request, opts = {}) data, _status_code, _headers = get_vertical_page_breaks_request.create_http_request(@api_client,opts ) return data end |
#get_workbook(get_workbook_request, opts = {}) ⇒ Object
Retrieve workbooks in various formats.
845 846 847 848 849 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 845 def get_workbook( get_workbook_request, opts = {}) data, _status_code, _headers = get_workbook_request.create_http_request(@api_client,opts ) return data end |
#get_workbook_default_style(get_workbook_default_style_request, opts = {}) ⇒ Object
Retrieve the description of the default style for the workbook .
2200 2201 2202 2203 2204 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2200 def get_workbook_default_style( get_workbook_default_style_request, opts = {}) data, _status_code, _headers = get_workbook_default_style_request.create_http_request(@api_client,opts ) return data end |
#get_workbook_name(get_workbook_name_request, opts = {}) ⇒ Object
Retrieve description of a named range in the workbook.
2232 2233 2234 2235 2236 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2232 def get_workbook_name( get_workbook_name_request, opts = {}) data, _status_code, _headers = get_workbook_name_request.create_http_request(@api_client,opts ) return data end |
#get_workbook_name_value(get_workbook_name_value_request, opts = {}) ⇒ Object
Retrieve the value of a named range in the workbook.
2248 2249 2250 2251 2252 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2248 def get_workbook_name_value( get_workbook_name_value_request, opts = {}) data, _status_code, _headers = get_workbook_name_value_request.create_http_request(@api_client,opts ) return data end |
#get_workbook_names(get_workbook_names_request, opts = {}) ⇒ Object
Retrieve named ranges in the workbook.
2216 2217 2218 2219 2220 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2216 def get_workbook_names( get_workbook_names_request, opts = {}) data, _status_code, _headers = get_workbook_names_request.create_http_request(@api_client,opts ) return data end |
#get_workbook_settings(get_workbook_settings_request, opts = {}) ⇒ Object
Retrieve descriptions of workbook settings.
2344 2345 2346 2347 2348 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2344 def get_workbook_settings( get_workbook_settings_request, opts = {}) data, _status_code, _headers = get_workbook_settings_request.create_http_request(@api_client,opts ) return data end |
#get_workbook_text_items(get_workbook_text_items_request, opts = {}) ⇒ Object
Retrieve text items in the workbook.
2208 2209 2210 2211 2212 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2208 def get_workbook_text_items( get_workbook_text_items_request, opts = {}) data, _status_code, _headers = get_workbook_text_items_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_auto_filter(get_worksheet_auto_filter_request, opts = {}) ⇒ Object
Retrieve the description of auto filters from a worksheet.
53 54 55 56 57 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 53 def get_worksheet_auto_filter( get_worksheet_auto_filter_request, opts = {}) data, _status_code, _headers = get_worksheet_auto_filter_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_autoshape_with_format(get_worksheet_autoshape_with_format_request, opts = {}) ⇒ Object
Get autoshape description in some format.
165 166 167 168 169 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 165 def get_worksheet_autoshape_with_format( get_worksheet_autoshape_with_format_request, opts = {}) data, _status_code, _headers = get_worksheet_autoshape_with_format_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_autoshapes(get_worksheet_autoshapes_request, opts = {}) ⇒ Object
Get autoshapes description in worksheet.
157 158 159 160 161 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 157 def get_worksheet_autoshapes( get_worksheet_autoshapes_request, opts = {}) data, _status_code, _headers = get_worksheet_autoshapes_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_calculate_formula(get_worksheet_calculate_formula_request, opts = {}) ⇒ Object
Calculate formula in the worksheet.
2560 2561 2562 2563 2564 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2560 def get_worksheet_calculate_formula( get_worksheet_calculate_formula_request, opts = {}) data, _status_code, _headers = get_worksheet_calculate_formula_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_cell(get_worksheet_cell_request, opts = {}) ⇒ Object
Retrieve cell data using either cell reference or method name in the worksheet.
269 270 271 272 273 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 269 def get_worksheet_cell( get_worksheet_cell_request, opts = {}) data, _status_code, _headers = get_worksheet_cell_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_cell_style(get_worksheet_cell_style_request, opts = {}) ⇒ Object
Retrieve cell style descriptions in the worksheet.
277 278 279 280 281 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 277 def get_worksheet_cell_style( get_worksheet_cell_style_request, opts = {}) data, _status_code, _headers = get_worksheet_cell_style_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_cells(get_worksheet_cells_request, opts = {}) ⇒ Object
Retrieve cell descriptions in a specified format.
261 262 263 264 265 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 261 def get_worksheet_cells( get_worksheet_cells_request, opts = {}) data, _status_code, _headers = get_worksheet_cells_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_cells_range_value(get_worksheet_cells_range_value_request, opts = {}) ⇒ Object
Retrieve the values of cells within the specified range.
1923 1924 1925 1926 1927 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1923 def get_worksheet_cells_range_value( get_worksheet_cells_range_value_request, opts = {}) data, _status_code, _headers = get_worksheet_cells_range_value_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_chart(get_worksheet_chart_request, opts = {}) ⇒ Object
Retrieve the chart in a specified format.
589 590 591 592 593 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 589 def get_worksheet_chart( get_worksheet_chart_request, opts = {}) data, _status_code, _headers = get_worksheet_chart_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_chart_legend(get_worksheet_chart_legend_request, opts = {}) ⇒ Object
Retrieve chart legend description in the worksheet.
621 622 623 624 625 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 621 def get_worksheet_chart_legend( get_worksheet_chart_legend_request, opts = {}) data, _status_code, _headers = get_worksheet_chart_legend_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_chart_title(get_worksheet_chart_title_request, opts = {}) ⇒ Object
Retrieve chart title description in the worksheet.
661 662 663 664 665 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 661 def get_worksheet_chart_title( get_worksheet_chart_title_request, opts = {}) data, _status_code, _headers = get_worksheet_chart_title_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_charts(get_worksheet_charts_request, opts = {}) ⇒ Object
Retrieve descriptions of charts in the worksheet.
581 582 583 584 585 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 581 def get_worksheet_charts( get_worksheet_charts_request, opts = {}) data, _status_code, _headers = get_worksheet_charts_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_column(get_worksheet_column_request, opts = {}) ⇒ Object
Retrieve worksheet column data by column index.
365 366 367 368 369 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 365 def get_worksheet_column( get_worksheet_column_request, opts = {}) data, _status_code, _headers = get_worksheet_column_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_columns(get_worksheet_columns_request, opts = {}) ⇒ Object
Retrieve descriptions of worksheet columns.
349 350 351 352 353 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 349 def get_worksheet_columns( get_worksheet_columns_request, opts = {}) data, _status_code, _headers = get_worksheet_columns_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_comment(get_worksheet_comment_request, opts = {}) ⇒ Object
Retrieve the description of comment in the worksheet.
2504 2505 2506 2507 2508 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2504 def get_worksheet_comment( get_worksheet_comment_request, opts = {}) data, _status_code, _headers = get_worksheet_comment_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_comments(get_worksheet_comments_request, opts = {}) ⇒ Object
Retrieve the description of comments in the worksheet.
2496 2497 2498 2499 2500 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2496 def get_worksheet_comments( get_worksheet_comments_request, opts = {}) data, _status_code, _headers = get_worksheet_comments_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_conditional_formatting(get_worksheet_conditional_formatting_request, opts = {}) ⇒ Object
Retrieve conditional formatting descriptions in the worksheet.
781 782 783 784 785 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 781 def get_worksheet_conditional_formatting( get_worksheet_conditional_formatting_request, opts = {}) data, _status_code, _headers = get_worksheet_conditional_formatting_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_conditional_formattings(get_worksheet_conditional_formattings_request, opts = {}) ⇒ Object
Retrieve descriptions of conditional formattings in a worksheet.
773 774 775 776 777 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 773 def get_worksheet_conditional_formattings( get_worksheet_conditional_formattings_request, opts = {}) data, _status_code, _headers = get_worksheet_conditional_formattings_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_hyperlink(get_worksheet_hyperlink_request, opts = {}) ⇒ Object
Retrieve hyperlink description by index in the worksheet.
1083 1084 1085 1086 1087 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1083 def get_worksheet_hyperlink( get_worksheet_hyperlink_request, opts = {}) data, _status_code, _headers = get_worksheet_hyperlink_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_hyperlinks(get_worksheet_hyperlinks_request, opts = {}) ⇒ Object
Retrieve descriptions of hyperlinks in the worksheet.
1075 1076 1077 1078 1079 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1075 def get_worksheet_hyperlinks( get_worksheet_hyperlinks_request, opts = {}) data, _status_code, _headers = get_worksheet_hyperlinks_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_list_object(get_worksheet_list_object_request, opts = {}) ⇒ Object
Retrieve list object description by index in the worksheet.
1251 1252 1253 1254 1255 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1251 def get_worksheet_list_object( get_worksheet_list_object_request, opts = {}) data, _status_code, _headers = get_worksheet_list_object_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_list_objects(get_worksheet_list_objects_request, opts = {}) ⇒ Object
Retrieve descriptions of ListObjects in the worksheet.
1243 1244 1245 1246 1247 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1243 def get_worksheet_list_objects( get_worksheet_list_objects_request, opts = {}) data, _status_code, _headers = get_worksheet_list_objects_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_merged_cell(get_worksheet_merged_cell_request, opts = {}) ⇒ Object
Retrieve description of a merged cell by its index in the worksheet.
2552 2553 2554 2555 2556 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2552 def get_worksheet_merged_cell( get_worksheet_merged_cell_request, opts = {}) data, _status_code, _headers = get_worksheet_merged_cell_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_merged_cells(get_worksheet_merged_cells_request, opts = {}) ⇒ Object
Get worksheet merged cells.
2544 2545 2546 2547 2548 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2544 def get_worksheet_merged_cells( get_worksheet_merged_cells_request, opts = {}) data, _status_code, _headers = get_worksheet_merged_cells_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_ole_object(get_worksheet_ole_object_request, opts = {}) ⇒ Object
Retrieve the OLE object in a specified format in the worksheet.
1355 1356 1357 1358 1359 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1355 def get_worksheet_ole_object( get_worksheet_ole_object_request, opts = {}) data, _status_code, _headers = get_worksheet_ole_object_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_ole_objects(get_worksheet_ole_objects_request, opts = {}) ⇒ Object
Retrieve descriptions of OLE objects in the worksheet.
1347 1348 1349 1350 1351 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1347 def get_worksheet_ole_objects( get_worksheet_ole_objects_request, opts = {}) data, _status_code, _headers = get_worksheet_ole_objects_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_page_count(get_worksheet_page_count_request, opts = {}) ⇒ Object
Get page count in the worksheet.
2704 2705 2706 2707 2708 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2704 def get_worksheet_page_count( get_worksheet_page_count_request, opts = {}) data, _status_code, _headers = get_worksheet_page_count_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_picture_with_format(get_worksheet_picture_with_format_request, opts = {}) ⇒ Object
Retrieve a picture by number in the worksheet.
1555 1556 1557 1558 1559 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1555 def get_worksheet_picture_with_format( get_worksheet_picture_with_format_request, opts = {}) data, _status_code, _headers = get_worksheet_picture_with_format_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_pictures(get_worksheet_pictures_request, opts = {}) ⇒ Object
Retrieve descriptions of pictures in the worksheet.
1547 1548 1549 1550 1551 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1547 def get_worksheet_pictures( get_worksheet_pictures_request, opts = {}) data, _status_code, _headers = get_worksheet_pictures_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_pivot_table(get_worksheet_pivot_table_request, opts = {}) ⇒ Object
Retrieve PivotTable information by index in the worksheet.
1611 1612 1613 1614 1615 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1611 def get_worksheet_pivot_table( get_worksheet_pivot_table_request, opts = {}) data, _status_code, _headers = get_worksheet_pivot_table_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_pivot_table_filter(get_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object
Retrieve PivotTable filters in the worksheet.
1635 1636 1637 1638 1639 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1635 def get_worksheet_pivot_table_filter( get_worksheet_pivot_table_filter_request, opts = {}) data, _status_code, _headers = get_worksheet_pivot_table_filter_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_pivot_table_filters(get_worksheet_pivot_table_filters_request, opts = {}) ⇒ Object
Gets PivotTable filters in worksheet.
1627 1628 1629 1630 1631 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1627 def get_worksheet_pivot_table_filters( get_worksheet_pivot_table_filters_request, opts = {}) data, _status_code, _headers = get_worksheet_pivot_table_filters_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_pivot_tables(get_worksheet_pivot_tables_request, opts = {}) ⇒ Object
Retrieve descriptions of pivottables in the worksheet.
1603 1604 1605 1606 1607 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1603 def get_worksheet_pivot_tables( get_worksheet_pivot_tables_request, opts = {}) data, _status_code, _headers = get_worksheet_pivot_tables_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_row(get_worksheet_row_request, opts = {}) ⇒ Object
Retrieve row data by the row’s index in the worksheet.
445 446 447 448 449 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 445 def get_worksheet_row( get_worksheet_row_request, opts = {}) data, _status_code, _headers = get_worksheet_row_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_rows(get_worksheet_rows_request, opts = {}) ⇒ Object
Retrieve descriptions of rows in the worksheet.
437 438 439 440 441 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 437 def get_worksheet_rows( get_worksheet_rows_request, opts = {}) data, _status_code, _headers = get_worksheet_rows_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_shape(get_worksheet_shape_request, opts = {}) ⇒ Object
Retrieve description of shape in the worksheet.
2010 2011 2012 2013 2014 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2010 def get_worksheet_shape( get_worksheet_shape_request, opts = {}) data, _status_code, _headers = get_worksheet_shape_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_shapes(get_worksheet_shapes_request, opts = {}) ⇒ Object
Retrieve descriptions of shapes in the worksheet.
2002 2003 2004 2005 2006 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2002 def get_worksheet_shapes( get_worksheet_shapes_request, opts = {}) data, _status_code, _headers = get_worksheet_shapes_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_sparkline_group(get_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Retrieve description of a sparkline group in the worksheet.
2074 2075 2076 2077 2078 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2074 def get_worksheet_sparkline_group( get_worksheet_sparkline_group_request, opts = {}) data, _status_code, _headers = get_worksheet_sparkline_group_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_sparkline_groups(get_worksheet_sparkline_groups_request, opts = {}) ⇒ Object
Retrieve descriptions of sparkline groups in the worksheet.
2066 2067 2068 2069 2070 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2066 def get_worksheet_sparkline_groups( get_worksheet_sparkline_groups_request, opts = {}) data, _status_code, _headers = get_worksheet_sparkline_groups_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_text_items(get_worksheet_text_items_request, opts = {}) ⇒ Object
Retrieve text items in the worksheet.
2488 2489 2490 2491 2492 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2488 def get_worksheet_text_items( get_worksheet_text_items_request, opts = {}) data, _status_code, _headers = get_worksheet_text_items_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_validation(get_worksheet_validation_request, opts = {}) ⇒ Object
Retrieve a validation by its index in the worksheet.
2720 2721 2722 2723 2724 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2720 def get_worksheet_validation( get_worksheet_validation_request, opts = {}) data, _status_code, _headers = get_worksheet_validation_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_validations(get_worksheet_validations_request, opts = {}) ⇒ Object
Retrieve descriptions of validations in the worksheet.
2712 2713 2714 2715 2716 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2712 def get_worksheet_validations( get_worksheet_validations_request, opts = {}) data, _status_code, _headers = get_worksheet_validations_request.create_http_request(@api_client,opts ) return data end |
#get_worksheet_with_format(get_worksheet_with_format_request, opts = {}) ⇒ Object
Retrieve the worksheet in a specified format from the workbook.
2408 2409 2410 2411 2412 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2408 def get_worksheet_with_format( get_worksheet_with_format_request, opts = {}) data, _status_code, _headers = get_worksheet_with_format_request.create_http_request(@api_client,opts ) return data end |
#get_worksheets(get_worksheets_request, opts = {}) ⇒ Object
Retrieve the description of worksheets from a workbook.
2400 2401 2402 2403 2404 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2400 def get_worksheets( get_worksheets_request, opts = {}) data, _status_code, _headers = get_worksheets_request.create_http_request(@api_client,opts ) return data end |
#move_file(move_file_request, opts = {}) ⇒ Object
2780 2781 2782 2783 2784 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2780 def move_file( move_file_request, opts = {}) data, _status_code, _headers = move_file_request.create_http_request(@api_client,opts ) return data end |
#move_folder(move_folder_request, opts = {}) ⇒ Object
2815 2816 2817 2818 2819 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2815 def move_folder( move_folder_request, opts = {}) data, _status_code, _headers = move_folder_request.create_http_request(@api_client,opts ) return data end |
#object_exists(object_exists_request, opts = {}) ⇒ Object
2836 2837 2838 2839 2840 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2836 def object_exists( object_exists_request, opts = {}) data, _status_code, _headers = object_exists_request.create_http_request(@api_client,opts ) return data end |
#post_access_token(post_access_token_request, opts = {}) ⇒ Object
Get Access Token Result
213 214 215 216 217 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 213 def post_access_token( post_access_token_request, opts = {}) data, _status_code, _headers = post_access_token_request.create_http_request(@api_client,opts ) return data end |
#post_add_text_content(post_add_text_content_request, opts = {}) ⇒ Object
Adds text content to a workbook at specified positions within cells based on provided options using ASP.NET Core Web API.
2143 2144 2145 2146 2147 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2143 def post_add_text_content( post_add_text_content_request, opts = {}) data, _status_code, _headers = post_add_text_content_request.create_http_request(@api_client,opts ) return data end |
#post_analyze_excel(post_analyze_excel_request, opts = {}) ⇒ Object
Perform business analysis of data in Excel files.
45 46 47 48 49 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 45 def post_analyze_excel( post_analyze_excel_request, opts = {}) data, _status_code, _headers = post_analyze_excel_request.create_http_request(@api_client,opts ) return data end |
#post_assemble(post_assemble_request, opts = {}) ⇒ Object
Assemble data files with template files to generate files in various formats.
1123 1124 1125 1126 1127 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1123 def post_assemble( post_assemble_request, opts = {}) data, _status_code, _headers = post_assemble_request.create_http_request(@api_client,opts ) return data end |
#post_autofit_workbook_columns(post_autofit_workbook_columns_request, opts = {}) ⇒ Object
Autofit columns in the workbook.
2336 2337 2338 2339 2340 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2336 def post_autofit_workbook_columns( post_autofit_workbook_columns_request, opts = {}) data, _status_code, _headers = post_autofit_workbook_columns_request.create_http_request(@api_client,opts ) return data end |
#post_autofit_workbook_rows(post_autofit_workbook_rows_request, opts = {}) ⇒ Object
Autofit rows in the workbook.
2328 2329 2330 2331 2332 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2328 def post_autofit_workbook_rows( post_autofit_workbook_rows_request, opts = {}) data, _status_code, _headers = post_autofit_workbook_rows_request.create_http_request(@api_client,opts ) return data end |
#post_autofit_worksheet_columns(post_autofit_worksheet_columns_request, opts = {}) ⇒ Object
Autofit columns in the worksheet.
2616 2617 2618 2619 2620 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2616 def post_autofit_worksheet_columns( post_autofit_worksheet_columns_request, opts = {}) data, _status_code, _headers = post_autofit_worksheet_columns_request.create_http_request(@api_client,opts ) return data end |
#post_autofit_worksheet_row(post_autofit_worksheet_row_request, opts = {}) ⇒ Object
Autofit a row in the worksheet.
2600 2601 2602 2603 2604 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2600 def post_autofit_worksheet_row( post_autofit_worksheet_row_request, opts = {}) data, _status_code, _headers = post_autofit_worksheet_row_request.create_http_request(@api_client,opts ) return data end |
#post_autofit_worksheet_rows(post_autofit_worksheet_rows_request, opts = {}) ⇒ Object
Autofit rows in the worksheet.
2608 2609 2610 2611 2612 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2608 def post_autofit_worksheet_rows( post_autofit_worksheet_rows_request, opts = {}) data, _status_code, _headers = post_autofit_worksheet_rows_request.create_http_request(@api_client,opts ) return data end |
#post_batch_convert(post_batch_convert_request, opts = {}) ⇒ Object
Batch converting files that meet specific matching conditions.
173 174 175 176 177 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 173 def post_batch_convert( post_batch_convert_request, opts = {}) data, _status_code, _headers = post_batch_convert_request.create_http_request(@api_client,opts ) return data end |
#post_batch_lock(post_batch_lock_request, opts = {}) ⇒ Object
Batch locking files that meet specific matching conditions.
189 190 191 192 193 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 189 def post_batch_lock( post_batch_lock_request, opts = {}) data, _status_code, _headers = post_batch_lock_request.create_http_request(@api_client,opts ) return data end |
#post_batch_protect(post_batch_protect_request, opts = {}) ⇒ Object
Batch protecting files that meet specific matching conditions.
181 182 183 184 185 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 181 def post_batch_protect( post_batch_protect_request, opts = {}) data, _status_code, _headers = post_batch_protect_request.create_http_request(@api_client,opts ) return data end |
#post_batch_split(post_batch_split_request, opts = {}) ⇒ Object
Batch splitting files that meet specific matching conditions.
205 206 207 208 209 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 205 def post_batch_split( post_batch_split_request, opts = {}) data, _status_code, _headers = post_batch_split_request.create_http_request(@api_client,opts ) return data end |
#post_batch_unlock(post_batch_unlock_request, opts = {}) ⇒ Object
Batch unlocking files that meet specific matching conditions.
197 198 199 200 201 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 197 def post_batch_unlock( post_batch_unlock_request, opts = {}) data, _status_code, _headers = post_batch_unlock_request.create_http_request(@api_client,opts ) return data end |
#post_cell_calculate(post_cell_calculate_request, opts = {}) ⇒ Object
Calculate cell formula in the worksheet.
333 334 335 336 337 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 333 def post_cell_calculate( post_cell_calculate_request, opts = {}) data, _status_code, _headers = post_cell_calculate_request.create_http_request(@api_client,opts ) return data end |
#post_cell_characters(post_cell_characters_request, opts = {}) ⇒ Object
Set cell characters in the worksheet.
341 342 343 344 345 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 341 def post_cell_characters( post_cell_characters_request, opts = {}) data, _status_code, _headers = post_cell_characters_request.create_http_request(@api_client,opts ) return data end |
#post_character_count(post_character_count_request, opts = {}) ⇒ Object
2113 2114 2115 2116 2117 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2113 def post_character_count( post_character_count_request, opts = {}) data, _status_code, _headers = post_character_count_request.create_http_request(@api_client,opts ) return data end |
#post_chart_category_axis(post_chart_category_axis_request, opts = {}) ⇒ Object
Update chart category axis in the chart.
741 742 743 744 745 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 741 def post_chart_category_axis( post_chart_category_axis_request, opts = {}) data, _status_code, _headers = post_chart_category_axis_request.create_http_request(@api_client,opts ) return data end |
#post_chart_second_category_axis(post_chart_second_category_axis_request, opts = {}) ⇒ Object
Update chart sencond category axis in the chart.
757 758 759 760 761 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 757 def post_chart_second_category_axis( post_chart_second_category_axis_request, opts = {}) data, _status_code, _headers = post_chart_second_category_axis_request.create_http_request(@api_client,opts ) return data end |
#post_chart_second_value_axis(post_chart_second_value_axis_request, opts = {}) ⇒ Object
Update chart sencond value axis in the chart.
765 766 767 768 769 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 765 def post_chart_second_value_axis( post_chart_second_value_axis_request, opts = {}) data, _status_code, _headers = post_chart_second_value_axis_request.create_http_request(@api_client,opts ) return data end |
#post_chart_series_axis(post_chart_series_axis_request, opts = {}) ⇒ Object
Update chart series axis in the chart.
733 734 735 736 737 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 733 def post_chart_series_axis( post_chart_series_axis_request, opts = {}) data, _status_code, _headers = post_chart_series_axis_request.create_http_request(@api_client,opts ) return data end |
#post_chart_value_axis(post_chart_value_axis_request, opts = {}) ⇒ Object
Update chart value axis in the chart.
749 750 751 752 753 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 749 def post_chart_value_axis( post_chart_value_axis_request, opts = {}) data, _status_code, _headers = post_chart_value_axis_request.create_http_request(@api_client,opts ) return data end |
#post_clear_contents(post_clear_contents_request, opts = {}) ⇒ Object
Clear cell area contents in the worksheet.
221 222 223 224 225 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 221 def post_clear_contents( post_clear_contents_request, opts = {}) data, _status_code, _headers = post_clear_contents_request.create_http_request(@api_client,opts ) return data end |
#post_clear_formats(post_clear_formats_request, opts = {}) ⇒ Object
Clear cell formats in the worksheet.
229 230 231 232 233 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 229 def post_clear_formats( post_clear_formats_request, opts = {}) data, _status_code, _headers = post_clear_formats_request.create_http_request(@api_client,opts ) return data end |
#post_clear_objects(post_clear_objects_request, opts = {}) ⇒ Object
Clear internal elements in Excel files and generate output files in various formats.
1187 1188 1189 1190 1191 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1187 def post_clear_objects( post_clear_objects_request, opts = {}) data, _status_code, _headers = post_clear_objects_request.create_http_request(@api_client,opts ) return data end |
#post_column_style(post_column_style_request, opts = {}) ⇒ Object
Set column style in the worksheet.
429 430 431 432 433 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 429 def post_column_style( post_column_style_request, opts = {}) data, _status_code, _headers = post_column_style_request.create_http_request(@api_client,opts ) return data end |
#post_compress(post_compress_request, opts = {}) ⇒ Object
Compress files and generate target files in various formats, supported file formats are include Xls, Xlsx, Xlsm, Xlsb, Ods and more.
1131 1132 1133 1134 1135 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1131 def post_compress( post_compress_request, opts = {}) data, _status_code, _headers = post_compress_request.create_http_request(@api_client,opts ) return data end |
#post_convert_text(post_convert_text_request, opts = {}) ⇒ Object
2171 2172 2173 2174 2175 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2171 def post_convert_text( post_convert_text_request, opts = {}) data, _status_code, _headers = post_convert_text_request.create_http_request(@api_client,opts ) return data end |
#post_convert_workbook(post_convert_workbook_request, opts = {}) ⇒ Object
947 948 949 950 951 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 947 def post_convert_workbook( post_convert_workbook_request, opts = {}) data, _status_code, _headers = post_convert_workbook_request.create_http_request(@api_client,opts ) return data end |
#post_convert_workbook_to_csv(post_convert_workbook_to_csv_request, opts = {}) ⇒ Object
Convert Excel file to Csv files.
933 934 935 936 937 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 933 def post_convert_workbook_to_csv( post_convert_workbook_to_csv_request, opts = {}) data, _status_code, _headers = post_convert_workbook_to_csv_request.create_http_request(@api_client,opts ) return data end |
#post_convert_workbook_to_docx(post_convert_workbook_to_docx_request, opts = {}) ⇒ Object
Convert Excel file to Docx files.
885 886 887 888 889 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 885 def post_convert_workbook_to_docx( post_convert_workbook_to_docx_request, opts = {}) data, _status_code, _headers = post_convert_workbook_to_docx_request.create_http_request(@api_client,opts ) return data end |
#post_convert_workbook_to_html(post_convert_workbook_to_html_request, opts = {}) ⇒ Object
Convert Excel file to HTML files.
901 902 903 904 905 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 901 def post_convert_workbook_to_html( post_convert_workbook_to_html_request, opts = {}) data, _status_code, _headers = post_convert_workbook_to_html_request.create_http_request(@api_client,opts ) return data end |
#post_convert_workbook_to_json(post_convert_workbook_to_json_request, opts = {}) ⇒ Object
Convert Excel file to Json files.
917 918 919 920 921 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 917 def post_convert_workbook_to_json( post_convert_workbook_to_json_request, opts = {}) data, _status_code, _headers = post_convert_workbook_to_json_request.create_http_request(@api_client,opts ) return data end |
#post_convert_workbook_to_markdown(post_convert_workbook_to_markdown_request, opts = {}) ⇒ Object
Convert Excel file to Markdown files.
909 910 911 912 913 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 909 def post_convert_workbook_to_markdown( post_convert_workbook_to_markdown_request, opts = {}) data, _status_code, _headers = post_convert_workbook_to_markdown_request.create_http_request(@api_client,opts ) return data end |
#post_convert_workbook_to_pdf(post_convert_workbook_to_pdf_request, opts = {}) ⇒ Object
Convert Excel file to PDF files.
869 870 871 872 873 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 869 def post_convert_workbook_to_pdf( post_convert_workbook_to_pdf_request, opts = {}) data, _status_code, _headers = post_convert_workbook_to_pdf_request.create_http_request(@api_client,opts ) return data end |
#post_convert_workbook_to_png(post_convert_workbook_to_png_request, opts = {}) ⇒ Object
Convert Excel file to PNG files.
877 878 879 880 881 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 877 def post_convert_workbook_to_png( post_convert_workbook_to_png_request, opts = {}) data, _status_code, _headers = post_convert_workbook_to_png_request.create_http_request(@api_client,opts ) return data end |
#post_convert_workbook_to_pptx(post_convert_workbook_to_pptx_request, opts = {}) ⇒ Object
Convert Excel file to Pptx files.
893 894 895 896 897 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 893 def post_convert_workbook_to_pptx( post_convert_workbook_to_pptx_request, opts = {}) data, _status_code, _headers = post_convert_workbook_to_pptx_request.create_http_request(@api_client,opts ) return data end |
#post_convert_workbook_to_sql(post_convert_workbook_to_sql_request, opts = {}) ⇒ Object
Convert Excel file to SQL Script files.
925 926 927 928 929 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 925 def post_convert_workbook_to_sql( post_convert_workbook_to_sql_request, opts = {}) data, _status_code, _headers = post_convert_workbook_to_sql_request.create_http_request(@api_client,opts ) return data end |
#post_convert_worksheet_to_image(post_convert_worksheet_to_image_request, opts = {}) ⇒ Object
940 941 942 943 944 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 940 def post_convert_worksheet_to_image( post_convert_worksheet_to_image_request, opts = {}) data, _status_code, _headers = post_convert_worksheet_to_image_request.create_http_request(@api_client,opts ) return data end |
#post_copy_cell_into_cell(post_copy_cell_into_cell_request, opts = {}) ⇒ Object
Copy data from a source cell to a destination cell in the worksheet.
309 310 311 312 313 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 309 def post_copy_cell_into_cell( post_copy_cell_into_cell_request, opts = {}) data, _status_code, _headers = post_copy_cell_into_cell_request.create_http_request(@api_client,opts ) return data end |
#post_copy_worksheet(post_copy_worksheet_request, opts = {}) ⇒ Object
Copy contents and formats from another worksheet.
2656 2657 2658 2659 2660 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2656 def post_copy_worksheet( post_copy_worksheet_request, opts = {}) data, _status_code, _headers = post_copy_worksheet_request.create_http_request(@api_client,opts ) return data end |
#post_copy_worksheet_columns(post_copy_worksheet_columns_request, opts = {}) ⇒ Object
Copy data from source columns to destination columns in the worksheet.
421 422 423 424 425 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 421 def post_copy_worksheet_columns( post_copy_worksheet_columns_request, opts = {}) data, _status_code, _headers = post_copy_worksheet_columns_request.create_http_request(@api_client,opts ) return data end |
#post_copy_worksheet_rows(post_copy_worksheet_rows_request, opts = {}) ⇒ Object
Copy data and formats from specific entire rows in the worksheet.
525 526 527 528 529 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 525 def post_copy_worksheet_rows( post_copy_worksheet_rows_request, opts = {}) data, _status_code, _headers = post_copy_worksheet_rows_request.create_http_request(@api_client,opts ) return data end |
#post_data_cleansing(post_data_cleansing_request, opts = {}) ⇒ Object
Data cleansing of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.
1019 1020 1021 1022 1023 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1019 def post_data_cleansing( post_data_cleansing_request, opts = {}) data, _status_code, _headers = post_data_cleansing_request.create_http_request(@api_client,opts ) return data end |
#post_data_deduplication(post_data_deduplication_request, opts = {}) ⇒ Object
Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.
1035 1036 1037 1038 1039 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1035 def post_data_deduplication( post_data_deduplication_request, opts = {}) data, _status_code, _headers = post_data_deduplication_request.create_http_request(@api_client,opts ) return data end |
#post_data_fill(post_data_fill_request, opts = {}) ⇒ Object
Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.
1051 1052 1053 1054 1055 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1051 def post_data_fill( post_data_fill_request, opts = {}) data, _status_code, _headers = post_data_fill_request.create_http_request(@api_client,opts ) return data end |
#post_data_transformation(post_data_transformation_request, opts = {}) ⇒ Object
Transform spreadsheet data is mainly used to pivot columns, unpivot columns.
1067 1068 1069 1070 1071 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1067 def post_data_transformation( post_data_transformation_request, opts = {}) data, _status_code, _headers = post_data_transformation_request.create_http_request(@api_client,opts ) return data end |
#post_delete_incomplete_rows(post_delete_incomplete_rows_request, opts = {}) ⇒ Object
Deleting incomplete rows of spreadsheet files is mainly used to eliminate incomplete rows in tables and ranges.
1059 1060 1061 1062 1063 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1059 def post_delete_incomplete_rows( post_delete_incomplete_rows_request, opts = {}) data, _status_code, _headers = post_delete_incomplete_rows_request.create_http_request(@api_client,opts ) return data end |
#post_digital_signature(post_digital_signature_request, opts = {}) ⇒ Object
Excel file digital signature.
1811 1812 1813 1814 1815 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1811 def post_digital_signature( post_digital_signature_request, opts = {}) data, _status_code, _headers = post_digital_signature_request.create_http_request(@api_client,opts ) return data end |
#post_encrypt_workbook(post_encrypt_workbook_request, opts = {}) ⇒ Object
Excel Encryption.
1819 1820 1821 1822 1823 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1819 def post_encrypt_workbook( post_encrypt_workbook_request, opts = {}) data, _status_code, _headers = post_encrypt_workbook_request.create_http_request(@api_client,opts ) return data end |
#post_export(post_export_request, opts = {}) ⇒ Object
Export Excel internal elements or the workbook itself to various format files.
970 971 972 973 974 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 970 def post_export( post_export_request, opts = {}) data, _status_code, _headers = post_export_request.create_http_request(@api_client,opts ) return data end |
#post_extract_text(post_extract_text_request, opts = {}) ⇒ Object
2185 2186 2187 2188 2189 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2185 def post_extract_text( post_extract_text_request, opts = {}) data, _status_code, _headers = post_extract_text_request.create_http_request(@api_client,opts ) return data end |
#post_fit_tall_to_pages(post_fit_tall_to_pages_request, opts = {}) ⇒ Object
Set the scale at which the page will fit tall when printed on the sheet.
1539 1540 1541 1542 1543 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1539 def post_fit_tall_to_pages( post_fit_tall_to_pages_request, opts = {}) data, _status_code, _headers = post_fit_tall_to_pages_request.create_http_request(@api_client,opts ) return data end |
#post_fit_wide_to_pages(post_fit_wide_to_pages_request, opts = {}) ⇒ Object
Set the scale at which the page will fit wide when printed on the sheet.
1531 1532 1533 1534 1535 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1531 def post_fit_wide_to_pages( post_fit_wide_to_pages_request, opts = {}) data, _status_code, _headers = post_fit_wide_to_pages_request.create_http_request(@api_client,opts ) return data end |
#post_footer(post_footer_request, opts = {}) ⇒ Object
Update page footer in the worksheet.
1523 1524 1525 1526 1527 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1523 def ( , opts = {}) data, _status_code, _headers = .create_http_request(@api_client,opts ) return data end |
#post_group_worksheet_columns(post_group_worksheet_columns_request, opts = {}) ⇒ Object
Group worksheet columns in the worksheet.
405 406 407 408 409 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 405 def post_group_worksheet_columns( post_group_worksheet_columns_request, opts = {}) data, _status_code, _headers = post_group_worksheet_columns_request.create_http_request(@api_client,opts ) return data end |
#post_group_worksheet_rows(post_group_worksheet_rows_request, opts = {}) ⇒ Object
Group rows in the worksheet.
509 510 511 512 513 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 509 def post_group_worksheet_rows( post_group_worksheet_rows_request, opts = {}) data, _status_code, _headers = post_group_worksheet_rows_request.create_http_request(@api_client,opts ) return data end |
#post_header(post_header_request, opts = {}) ⇒ Object
Update page header in the worksheet.
1507 1508 1509 1510 1511 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1507 def post_header( post_header_request, opts = {}) data, _status_code, _headers = post_header_request.create_http_request(@api_client,opts ) return data end |
#post_hide_worksheet_columns(post_hide_worksheet_columns_request, opts = {}) ⇒ Object
Hide worksheet columns in the worksheet.
389 390 391 392 393 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 389 def post_hide_worksheet_columns( post_hide_worksheet_columns_request, opts = {}) data, _status_code, _headers = post_hide_worksheet_columns_request.create_http_request(@api_client,opts ) return data end |
#post_hide_worksheet_rows(post_hide_worksheet_rows_request, opts = {}) ⇒ Object
Hide rows in worksheet.
493 494 495 496 497 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 493 def post_hide_worksheet_rows( post_hide_worksheet_rows_request, opts = {}) data, _status_code, _headers = post_hide_worksheet_rows_request.create_http_request(@api_client,opts ) return data end |
#post_import(post_import_request, opts = {}) ⇒ Object
Import data into an Excel file and generate output files in various formats.
1171 1172 1173 1174 1175 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1171 def post_import( post_import_request, opts = {}) data, _status_code, _headers = post_import_request.create_http_request(@api_client,opts ) return data end |
#post_import_data(post_import_data_request, opts = {}) ⇒ Object
Import data into the Excel file.
1003 1004 1005 1006 1007 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1003 def post_import_data( post_import_data_request, opts = {}) data, _status_code, _headers = post_import_data_request.create_http_request(@api_client,opts ) return data end |
#post_lock(post_lock_request, opts = {}) ⇒ Object
Lock Excel files.
1875 1876 1877 1878 1879 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1875 def post_lock( post_lock_request, opts = {}) data, _status_code, _headers = post_lock_request.create_http_request(@api_client,opts ) return data end |
#post_merge(post_merge_request, opts = {}) ⇒ Object
Merge cells in the worksheet.
1139 1140 1141 1142 1143 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1139 def post_merge( post_merge_request, opts = {}) data, _status_code, _headers = post_merge_request.create_http_request(@api_client,opts ) return data end |
#post_metadata(post_metadata_request, opts = {}) ⇒ Object
Update document properties in Excel file, and save them is various formats.
1219 1220 1221 1222 1223 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1219 def ( , opts = {}) data, _status_code, _headers = .create_http_request(@api_client,opts ) return data end |
#post_move_worksheet(post_move_worksheet_request, opts = {}) ⇒ Object
Move worksheet in the workbook.
2464 2465 2466 2467 2468 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2464 def post_move_worksheet( post_move_worksheet_request, opts = {}) data, _status_code, _headers = post_move_worksheet_request.create_http_request(@api_client,opts ) return data end |
#post_page_setup(post_page_setup_request, opts = {}) ⇒ Object
Update page setup in the worksheet.
1483 1484 1485 1486 1487 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1483 def post_page_setup( post_page_setup_request, opts = {}) data, _status_code, _headers = post_page_setup_request.create_http_request(@api_client,opts ) return data end |
#post_pivot_table_cell_style(post_pivot_table_cell_style_request, opts = {}) ⇒ Object
Update cell style in the PivotTable.
1683 1684 1685 1686 1687 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1683 def post_pivot_table_cell_style( post_pivot_table_cell_style_request, opts = {}) data, _status_code, _headers = post_pivot_table_cell_style_request.create_http_request(@api_client,opts ) return data end |
#post_pivot_table_field_hide_item(post_pivot_table_field_hide_item_request, opts = {}) ⇒ Object
Hide a pivot field item in the PivotTable.
1667 1668 1669 1670 1671 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1667 def post_pivot_table_field_hide_item( post_pivot_table_field_hide_item_request, opts = {}) data, _status_code, _headers = post_pivot_table_field_hide_item_request.create_http_request(@api_client,opts ) return data end |
#post_pivot_table_field_move_to(post_pivot_table_field_move_to_request, opts = {}) ⇒ Object
Move a pivot field in the PivotTable.
1675 1676 1677 1678 1679 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1675 def post_pivot_table_field_move_to( post_pivot_table_field_move_to_request, opts = {}) data, _status_code, _headers = post_pivot_table_field_move_to_request.create_http_request(@api_client,opts ) return data end |
#post_pivot_table_style(post_pivot_table_style_request, opts = {}) ⇒ Object
Update style in the PivotTable.
1691 1692 1693 1694 1695 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1691 def post_pivot_table_style( post_pivot_table_style_request, opts = {}) data, _status_code, _headers = post_pivot_table_style_request.create_http_request(@api_client,opts ) return data end |
#post_pivot_table_update_pivot_field(post_pivot_table_update_pivot_field_request, opts = {}) ⇒ Object
Update pivot field in the PivotTable.
1707 1708 1709 1710 1711 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1707 def post_pivot_table_update_pivot_field( post_pivot_table_update_pivot_field_request, opts = {}) data, _status_code, _headers = post_pivot_table_update_pivot_field_request.create_http_request(@api_client,opts ) return data end |
#post_pivot_table_update_pivot_fields(post_pivot_table_update_pivot_fields_request, opts = {}) ⇒ Object
Update pivot fields in the PivotTable.
1699 1700 1701 1702 1703 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1699 def post_pivot_table_update_pivot_fields( post_pivot_table_update_pivot_fields_request, opts = {}) data, _status_code, _headers = post_pivot_table_update_pivot_fields_request.create_http_request(@api_client,opts ) return data end |
#post_protect(post_protect_request, opts = {}) ⇒ Object
Excel files encryption.
1883 1884 1885 1886 1887 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1883 def post_protect( post_protect_request, opts = {}) data, _status_code, _headers = post_protect_request.create_http_request(@api_client,opts ) return data end |
#post_protect_workbook(post_protect_workbook_request, opts = {}) ⇒ Object
Excel protection.
1835 1836 1837 1838 1839 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1835 def post_protect_workbook( post_protect_workbook_request, opts = {}) data, _status_code, _headers = post_protect_workbook_request.create_http_request(@api_client,opts ) return data end |
#post_remove_characters(post_remove_characters_request, opts = {}) ⇒ Object
2164 2165 2166 2167 2168 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2164 def post_remove_characters( post_remove_characters_request, opts = {}) data, _status_code, _headers = post_remove_characters_request.create_http_request(@api_client,opts ) return data end |
#post_remove_duplicates(post_remove_duplicates_request, opts = {}) ⇒ Object
2178 2179 2180 2181 2182 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2178 def post_remove_duplicates( post_remove_duplicates_request, opts = {}) data, _status_code, _headers = post_remove_duplicates_request.create_http_request(@api_client,opts ) return data end |
#post_rename_worksheet(post_rename_worksheet_request, opts = {}) ⇒ Object
Rename worksheet in the workbook.
2664 2665 2666 2667 2668 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2664 def post_rename_worksheet( post_rename_worksheet_request, opts = {}) data, _status_code, _headers = post_rename_worksheet_request.create_http_request(@api_client,opts ) return data end |
#post_repair(post_repair_request, opts = {}) ⇒ Object
Repair abnormal files and generate files in various formats.
1203 1204 1205 1206 1207 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1203 def post_repair( post_repair_request, opts = {}) data, _status_code, _headers = post_repair_request.create_http_request(@api_client,opts ) return data end |
#post_replace(post_replace_request, opts = {}) ⇒ Object
Replace specified text with new text in Excel files.
1163 1164 1165 1166 1167 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1163 def post_replace( post_replace_request, opts = {}) data, _status_code, _headers = post_replace_request.create_http_request(@api_client,opts ) return data end |
#post_reverse(post_reverse_request, opts = {}) ⇒ Object
Reverse rows or columns in Excel files and create output files in various formats.
1195 1196 1197 1198 1199 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1195 def post_reverse( post_reverse_request, opts = {}) data, _status_code, _headers = post_reverse_request.create_http_request(@api_client,opts ) return data end |
#post_rotate(post_rotate_request, opts = {}) ⇒ Object
Rotate rows, columns, or other objects in Excel files and save them in various formats.
1211 1212 1213 1214 1215 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1211 def post_rotate( post_rotate_request, opts = {}) data, _status_code, _headers = post_rotate_request.create_http_request(@api_client,opts ) return data end |
#post_row_style(post_row_style_request, opts = {}) ⇒ Object
Apply formats to an entire row in the worksheet.
533 534 535 536 537 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 533 def post_row_style( post_row_style_request, opts = {}) data, _status_code, _headers = post_row_style_request.create_http_request(@api_client,opts ) return data end |
#post_run_task(post_run_task_request, opts = {}) ⇒ Object
Run tasks.
2135 2136 2137 2138 2139 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2135 def post_run_task( post_run_task_request, opts = {}) data, _status_code, _headers = post_run_task_request.create_http_request(@api_client,opts ) return data end |
#post_search(post_search_request, opts = {}) ⇒ Object
Search for specified text within Excel files.
1155 1156 1157 1158 1159 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1155 def post_search( post_search_request, opts = {}) data, _status_code, _headers = post_search_request.create_http_request(@api_client,opts ) return data end |
#post_set_cell_html_string(post_set_cell_html_string_request, opts = {}) ⇒ Object
Set the HTML string containing data and specific formats in this cell.
325 326 327 328 329 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 325 def post_set_cell_html_string( post_set_cell_html_string_request, opts = {}) data, _status_code, _headers = post_set_cell_html_string_request.create_http_request(@api_client,opts ) return data end |
#post_set_cell_range_value(post_set_cell_range_value_request, opts = {}) ⇒ Object
Set the value of the range in the worksheet.
301 302 303 304 305 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 301 def post_set_cell_range_value( post_set_cell_range_value_request, opts = {}) data, _status_code, _headers = post_set_cell_range_value_request.create_http_request(@api_client,opts ) return data end |
#post_set_worksheet_column_width(post_set_worksheet_column_width_request, opts = {}) ⇒ Object
Set worksheet column width.
357 358 359 360 361 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 357 def post_set_worksheet_column_width( post_set_worksheet_column_width_request, opts = {}) data, _status_code, _headers = post_set_worksheet_column_width_request.create_http_request(@api_client,opts ) return data end |
#post_specify_words_count(post_specify_words_count_request, opts = {}) ⇒ Object
2127 2128 2129 2130 2131 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2127 def post_specify_words_count( post_specify_words_count_request, opts = {}) data, _status_code, _headers = post_specify_words_count_request.create_http_request(@api_client,opts ) return data end |
#post_split(post_split_request, opts = {}) ⇒ Object
Split Excel spreadsheet files based on worksheets and create output files in various formats.
1147 1148 1149 1150 1151 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1147 def post_split( post_split_request, opts = {}) data, _status_code, _headers = post_split_request.create_http_request(@api_client,opts ) return data end |
#post_split_text(post_split_text_request, opts = {}) ⇒ Object
2192 2193 2194 2195 2196 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2192 def post_split_text( post_split_text_request, opts = {}) data, _status_code, _headers = post_split_text_request.create_http_request(@api_client,opts ) return data end |
#post_trim_content(post_trim_content_request, opts = {}) ⇒ Object
2150 2151 2152 2153 2154 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2150 def post_trim_content( post_trim_content_request, opts = {}) data, _status_code, _headers = post_trim_content_request.create_http_request(@api_client,opts ) return data end |
#post_ungroup_worksheet_columns(post_ungroup_worksheet_columns_request, opts = {}) ⇒ Object
Ungroup worksheet columns.
413 414 415 416 417 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 413 def post_ungroup_worksheet_columns( post_ungroup_worksheet_columns_request, opts = {}) data, _status_code, _headers = post_ungroup_worksheet_columns_request.create_http_request(@api_client,opts ) return data end |
#post_ungroup_worksheet_rows(post_ungroup_worksheet_rows_request, opts = {}) ⇒ Object
Ungroup rows in the worksheet.
517 518 519 520 521 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 517 def post_ungroup_worksheet_rows( post_ungroup_worksheet_rows_request, opts = {}) data, _status_code, _headers = post_ungroup_worksheet_rows_request.create_http_request(@api_client,opts ) return data end |
#post_unhide_worksheet_columns(post_unhide_worksheet_columns_request, opts = {}) ⇒ Object
Unhide worksheet columns in the worksheet.
397 398 399 400 401 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 397 def post_unhide_worksheet_columns( post_unhide_worksheet_columns_request, opts = {}) data, _status_code, _headers = post_unhide_worksheet_columns_request.create_http_request(@api_client,opts ) return data end |
#post_unhide_worksheet_rows(post_unhide_worksheet_rows_request, opts = {}) ⇒ Object
Unhide rows in the worksheet.
501 502 503 504 505 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 501 def post_unhide_worksheet_rows( post_unhide_worksheet_rows_request, opts = {}) data, _status_code, _headers = post_unhide_worksheet_rows_request.create_http_request(@api_client,opts ) return data end |
#post_unlock(post_unlock_request, opts = {}) ⇒ Object
Unlock Excel files.
1867 1868 1869 1870 1871 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1867 def post_unlock( post_unlock_request, opts = {}) data, _status_code, _headers = post_unlock_request.create_http_request(@api_client,opts ) return data end |
#post_update_word_case(post_update_word_case_request, opts = {}) ⇒ Object
2157 2158 2159 2160 2161 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2157 def post_update_word_case( post_update_word_case_request, opts = {}) data, _status_code, _headers = post_update_word_case_request.create_http_request(@api_client,opts ) return data end |
#post_update_worksheet_cell_style(post_update_worksheet_cell_style_request, opts = {}) ⇒ Object
Set cell style using cell name in the worksheet.
293 294 295 296 297 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 293 def post_update_worksheet_cell_style( post_update_worksheet_cell_style_request, opts = {}) data, _status_code, _headers = post_update_worksheet_cell_style_request.create_http_request(@api_client,opts ) return data end |
#post_update_worksheet_ole_object(post_update_worksheet_ole_object_request, opts = {}) ⇒ Object
Update an OLE object in worksheet.
1379 1380 1381 1382 1383 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1379 def post_update_worksheet_ole_object( post_update_worksheet_ole_object_request, opts = {}) data, _status_code, _headers = post_update_worksheet_ole_object_request.create_http_request(@api_client,opts ) return data end |
#post_update_worksheet_property(post_update_worksheet_property_request, opts = {}) ⇒ Object
Update worksheet properties in the workbook.
2672 2673 2674 2675 2676 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2672 def post_update_worksheet_property( post_update_worksheet_property_request, opts = {}) data, _status_code, _headers = post_update_worksheet_property_request.create_http_request(@api_client,opts ) return data end |
#post_update_worksheet_range_style(post_update_worksheet_range_style_request, opts = {}) ⇒ Object
Update cell range styles in the worksheet.
237 238 239 240 241 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 237 def post_update_worksheet_range_style( post_update_worksheet_range_style_request, opts = {}) data, _status_code, _headers = post_update_worksheet_range_style_request.create_http_request(@api_client,opts ) return data end |
#post_update_worksheet_row(post_update_worksheet_row_request, opts = {}) ⇒ Object
Update height of rows in the worksheet.
485 486 487 488 489 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 485 def post_update_worksheet_row( post_update_worksheet_row_request, opts = {}) data, _status_code, _headers = post_update_worksheet_row_request.create_http_request(@api_client,opts ) return data end |
#post_update_worksheet_zoom(post_update_worksheet_zoom_request, opts = {}) ⇒ Object
Update the scaling percentage in the worksheet. It should be between 10 and 400.
2696 2697 2698 2699 2700 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2696 def post_update_worksheet_zoom( post_update_worksheet_zoom_request, opts = {}) data, _status_code, _headers = post_update_worksheet_zoom_request.create_http_request(@api_client,opts ) return data end |
#post_watermark(post_watermark_request, opts = {}) ⇒ Object
Add Text Watermark to Excel files and generate output files in various formats.
1179 1180 1181 1182 1183 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1179 def post_watermark( post_watermark_request, opts = {}) data, _status_code, _headers = post_watermark_request.create_http_request(@api_client,opts ) return data end |
#post_words_count(post_words_count_request, opts = {}) ⇒ Object
2120 2121 2122 2123 2124 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2120 def post_words_count( post_words_count_request, opts = {}) data, _status_code, _headers = post_words_count_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_calculate_formula(post_workbook_calculate_formula_request, opts = {}) ⇒ Object
Calculate all formulas in the workbook.
2320 2321 2322 2323 2324 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2320 def post_workbook_calculate_formula( post_workbook_calculate_formula_request, opts = {}) data, _status_code, _headers = post_workbook_calculate_formula_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_data_cleansing(post_workbook_data_cleansing_request, opts = {}) ⇒ Object
Data cleaning of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.
1011 1012 1013 1014 1015 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1011 def post_workbook_data_cleansing( post_workbook_data_cleansing_request, opts = {}) data, _status_code, _headers = post_workbook_data_cleansing_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_data_deduplication(post_workbook_data_deduplication_request, opts = {}) ⇒ Object
Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.
1027 1028 1029 1030 1031 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1027 def post_workbook_data_deduplication( post_workbook_data_deduplication_request, opts = {}) data, _status_code, _headers = post_workbook_data_deduplication_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_data_fill(post_workbook_data_fill_request, opts = {}) ⇒ Object
Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.
1043 1044 1045 1046 1047 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1043 def post_workbook_data_fill( post_workbook_data_fill_request, opts = {}) data, _status_code, _headers = post_workbook_data_fill_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_export_xml(post_workbook_export_xml_request, opts = {}) ⇒ Object
Export XML data from an Excel file. When there are XML Maps in an Excel file, export XML data. When there is no XML map in the Excel file, convert the Excel file to an XML file.
979 980 981 982 983 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 979 def post_workbook_export_xml( post_workbook_export_xml_request, opts = {}) data, _status_code, _headers = post_workbook_export_xml_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_get_smart_marker_result(post_workbook_get_smart_marker_result_request, opts = {}) ⇒ Object
Smart marker processing.
2296 2297 2298 2299 2300 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2296 def post_workbook_get_smart_marker_result( post_workbook_get_smart_marker_result_request, opts = {}) data, _status_code, _headers = post_workbook_get_smart_marker_result_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_import_json(post_workbook_import_json_request, opts = {}) ⇒ Object
Import a JSON data file into the workbook. The JSON data file can either be a cloud file or data from an HTTP URI.
987 988 989 990 991 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 987 def post_workbook_import_json( post_workbook_import_json_request, opts = {}) data, _status_code, _headers = post_workbook_import_json_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_import_xml(post_workbook_import_xml_request, opts = {}) ⇒ Object
Import an XML data file into an Excel file. The XML data file can either be a cloud file or data from an HTTP URI.
995 996 997 998 999 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 995 def post_workbook_import_xml( post_workbook_import_xml_request, opts = {}) data, _status_code, _headers = post_workbook_import_xml_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_name(post_workbook_name_request, opts = {}) ⇒ Object
Update a named range in the workbook.
2240 2241 2242 2243 2244 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2240 def post_workbook_name( post_workbook_name_request, opts = {}) data, _status_code, _headers = post_workbook_name_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_save_as(post_workbook_save_as_request, opts = {}) ⇒ Object
Save an Excel file in various formats.
861 862 863 864 865 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 861 def post_workbook_save_as( post_workbook_save_as_request, opts = {}) data, _status_code, _headers = post_workbook_save_as_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_settings(post_workbook_settings_request, opts = {}) ⇒ Object
Update setting in the workbook.
2352 2353 2354 2355 2356 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2352 def post_workbook_settings( post_workbook_settings_request, opts = {}) data, _status_code, _headers = post_workbook_settings_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_split(post_workbook_split_request, opts = {}) ⇒ Object
Split the workbook with a specific format.
2312 2313 2314 2315 2316 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2312 def post_workbook_split( post_workbook_split_request, opts = {}) data, _status_code, _headers = post_workbook_split_request.create_http_request(@api_client,opts ) return data end |
#post_workbook_text_replace(post_workbook_text_replace_request, opts = {}) ⇒ Object
Replace text in the workbook.
2288 2289 2290 2291 2292 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2288 def post_workbook_text_replace( post_workbook_text_replace_request, opts = {}) data, _status_code, _headers = post_workbook_text_replace_request.create_http_request(@api_client,opts ) return data end |
#post_workbooks_merge(post_workbooks_merge_request, opts = {}) ⇒ Object
Merge a workbook into the existing workbook.
2272 2273 2274 2275 2276 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2272 def post_workbooks_merge( post_workbooks_merge_request, opts = {}) data, _status_code, _headers = post_workbooks_merge_request.create_http_request(@api_client,opts ) return data end |
#post_workbooks_text_search(post_workbooks_text_search_request, opts = {}) ⇒ Object
Search for text in the workbook.
2280 2281 2282 2283 2284 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2280 def post_workbooks_text_search( post_workbooks_text_search_request, opts = {}) data, _status_code, _headers = post_workbooks_text_search_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_auto_filter_refresh(post_worksheet_auto_filter_refresh_request, opts = {}) ⇒ Object
Refresh auto filters in the worksheet.
133 134 135 136 137 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 133 def post_worksheet_auto_filter_refresh( post_worksheet_auto_filter_refresh_request, opts = {}) data, _status_code, _headers = post_worksheet_auto_filter_refresh_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_calculate_formula(post_worksheet_calculate_formula_request, opts = {}) ⇒ Object
Calculate formula in the worksheet.
2568 2569 2570 2571 2572 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2568 def post_worksheet_calculate_formula( post_worksheet_calculate_formula_request, opts = {}) data, _status_code, _headers = post_worksheet_calculate_formula_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cell_set_value(post_worksheet_cell_set_value_request, opts = {}) ⇒ Object
Set cell value using cell name in the worksheet.
285 286 287 288 289 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 285 def post_worksheet_cell_set_value( post_worksheet_cell_set_value_request, opts = {}) data, _status_code, _headers = post_worksheet_cell_set_value_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cells_range_column_width(post_worksheet_cells_range_column_width_request, opts = {}) ⇒ Object
Set the column width of the specified range.
1963 1964 1965 1966 1967 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1963 def post_worksheet_cells_range_column_width( post_worksheet_cells_range_column_width_request, opts = {}) data, _status_code, _headers = post_worksheet_cells_range_column_width_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cells_range_merge(post_worksheet_cells_range_merge_request, opts = {}) ⇒ Object
Merge a range of cells into a single cell.
1899 1900 1901 1902 1903 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1899 def post_worksheet_cells_range_merge( post_worksheet_cells_range_merge_request, opts = {}) data, _status_code, _headers = post_worksheet_cells_range_merge_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cells_range_move_to(post_worksheet_cells_range_move_to_request, opts = {}) ⇒ Object
Move the current range to the destination range.
1939 1940 1941 1942 1943 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1939 def post_worksheet_cells_range_move_to( post_worksheet_cells_range_move_to_request, opts = {}) data, _status_code, _headers = post_worksheet_cells_range_move_to_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cells_range_outline_border(post_worksheet_cells_range_outline_border_request, opts = {}) ⇒ Object
Apply an outline border around a range of cells.
1955 1956 1957 1958 1959 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1955 def post_worksheet_cells_range_outline_border( post_worksheet_cells_range_outline_border_request, opts = {}) data, _status_code, _headers = post_worksheet_cells_range_outline_border_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cells_range_row_height(post_worksheet_cells_range_row_height_request, opts = {}) ⇒ Object
Sets row height of range.
1971 1972 1973 1974 1975 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1971 def post_worksheet_cells_range_row_height( post_worksheet_cells_range_row_height_request, opts = {}) data, _status_code, _headers = post_worksheet_cells_range_row_height_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cells_range_sort(post_worksheet_cells_range_sort_request, opts = {}) ⇒ Object
Perform data sorting around a range of cells.
1947 1948 1949 1950 1951 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1947 def post_worksheet_cells_range_sort( post_worksheet_cells_range_sort_request, opts = {}) data, _status_code, _headers = post_worksheet_cells_range_sort_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cells_range_style(post_worksheet_cells_range_style_request, opts = {}) ⇒ Object
Set the style for the specified range.
1915 1916 1917 1918 1919 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1915 def post_worksheet_cells_range_style( post_worksheet_cells_range_style_request, opts = {}) data, _status_code, _headers = post_worksheet_cells_range_style_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cells_range_to_image(post_worksheet_cells_range_to_image_request, opts = {}) ⇒ Object
1978 1979 1980 1981 1982 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1978 def post_worksheet_cells_range_to_image( post_worksheet_cells_range_to_image_request, opts = {}) data, _status_code, _headers = post_worksheet_cells_range_to_image_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cells_range_un_merge(post_worksheet_cells_range_un_merge_request, opts = {}) ⇒ Object
Unmerge merged cells within this range.
1907 1908 1909 1910 1911 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1907 def post_worksheet_cells_range_un_merge( post_worksheet_cells_range_un_merge_request, opts = {}) data, _status_code, _headers = post_worksheet_cells_range_un_merge_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cells_range_value(post_worksheet_cells_range_value_request, opts = {}) ⇒ Object
Assign a value to the range; if necessary, the value will be converted to another data type, and the cell’s number format will be reset.
1931 1932 1933 1934 1935 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1931 def post_worksheet_cells_range_value( post_worksheet_cells_range_value_request, opts = {}) data, _status_code, _headers = post_worksheet_cells_range_value_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_cells_ranges_copy(post_worksheet_cells_ranges_copy_request, opts = {}) ⇒ Object
Copy content from the source range to the destination range in the worksheet.
1891 1892 1893 1894 1895 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1891 def post_worksheet_cells_ranges_copy( post_worksheet_cells_ranges_copy_request, opts = {}) data, _status_code, _headers = post_worksheet_cells_ranges_copy_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_chart(post_worksheet_chart_request, opts = {}) ⇒ Object
Update chart properties in the worksheet.
613 614 615 616 617 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 613 def post_worksheet_chart( post_worksheet_chart_request, opts = {}) data, _status_code, _headers = post_worksheet_chart_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_chart_legend(post_worksheet_chart_legend_request, opts = {}) ⇒ Object
Update chart legend in the worksheet.
629 630 631 632 633 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 629 def post_worksheet_chart_legend( post_worksheet_chart_legend_request, opts = {}) data, _status_code, _headers = post_worksheet_chart_legend_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_chart_title(post_worksheet_chart_title_request, opts = {}) ⇒ Object
Update chart title in the worksheet.
669 670 671 672 673 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 669 def post_worksheet_chart_title( post_worksheet_chart_title_request, opts = {}) data, _status_code, _headers = post_worksheet_chart_title_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_comment(post_worksheet_comment_request, opts = {}) ⇒ Object
Update cell comment in the worksheet.
2520 2521 2522 2523 2524 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2520 def post_worksheet_comment( post_worksheet_comment_request, opts = {}) data, _status_code, _headers = post_worksheet_comment_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_group_shape(post_worksheet_group_shape_request, opts = {}) ⇒ Object
Group shapes in the worksheet.
2050 2051 2052 2053 2054 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2050 def post_worksheet_group_shape( post_worksheet_group_shape_request, opts = {}) data, _status_code, _headers = post_worksheet_group_shape_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_hyperlink(post_worksheet_hyperlink_request, opts = {}) ⇒ Object
Update hyperlink by index in the worksheet.
1099 1100 1101 1102 1103 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1099 def post_worksheet_hyperlink( post_worksheet_hyperlink_request, opts = {}) data, _status_code, _headers = post_worksheet_hyperlink_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_list_column(post_worksheet_list_column_request, opts = {}) ⇒ Object
Update list column in list object.
1331 1332 1333 1334 1335 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1331 def post_worksheet_list_column( post_worksheet_list_column_request, opts = {}) data, _status_code, _headers = post_worksheet_list_column_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_list_columns_total(post_worksheet_list_columns_total_request, opts = {}) ⇒ Object
Update total of list columns in the table.
1339 1340 1341 1342 1343 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1339 def post_worksheet_list_columns_total( post_worksheet_list_columns_total_request, opts = {}) data, _status_code, _headers = post_worksheet_list_columns_total_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_list_object(post_worksheet_list_object_request, opts = {}) ⇒ Object
Update list object by index in the worksheet.
1283 1284 1285 1286 1287 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1283 def post_worksheet_list_object( post_worksheet_list_object_request, opts = {}) data, _status_code, _headers = post_worksheet_list_object_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_list_object_convert_to_range(post_worksheet_list_object_convert_to_range_request, opts = {}) ⇒ Object
Convert list object to range in the worksheet.
1291 1292 1293 1294 1295 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1291 def post_worksheet_list_object_convert_to_range( post_worksheet_list_object_convert_to_range_request, opts = {}) data, _status_code, _headers = post_worksheet_list_object_convert_to_range_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_list_object_insert_slicer(post_worksheet_list_object_insert_slicer_request, opts = {}) ⇒ Object
Insert slicer for list object.
1323 1324 1325 1326 1327 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1323 def post_worksheet_list_object_insert_slicer( post_worksheet_list_object_insert_slicer_request, opts = {}) data, _status_code, _headers = post_worksheet_list_object_insert_slicer_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_list_object_remove_duplicates(post_worksheet_list_object_remove_duplicates_request, opts = {}) ⇒ Object
Remove duplicates in list object.
1315 1316 1317 1318 1319 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1315 def post_worksheet_list_object_remove_duplicates( post_worksheet_list_object_remove_duplicates_request, opts = {}) data, _status_code, _headers = post_worksheet_list_object_remove_duplicates_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_list_object_sort_table(post_worksheet_list_object_sort_table_request, opts = {}) ⇒ Object
Sort list object in the worksheet.
1307 1308 1309 1310 1311 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1307 def post_worksheet_list_object_sort_table( post_worksheet_list_object_sort_table_request, opts = {}) data, _status_code, _headers = post_worksheet_list_object_sort_table_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_list_object_summarize_with_pivot_table(post_worksheet_list_object_summarize_with_pivot_table_request, opts = {}) ⇒ Object
Create a pivot table with a list object in the worksheet.
1299 1300 1301 1302 1303 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1299 def post_worksheet_list_object_summarize_with_pivot_table( post_worksheet_list_object_summarize_with_pivot_table_request, opts = {}) data, _status_code, _headers = post_worksheet_list_object_summarize_with_pivot_table_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_match_blanks(post_worksheet_match_blanks_request, opts = {}) ⇒ Object
Match all blank cells in the list.
117 118 119 120 121 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 117 def post_worksheet_match_blanks( post_worksheet_match_blanks_request, opts = {}) data, _status_code, _headers = post_worksheet_match_blanks_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_match_non_blanks(post_worksheet_match_non_blanks_request, opts = {}) ⇒ Object
Match all not blank cells in the list.
125 126 127 128 129 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 125 def post_worksheet_match_non_blanks( post_worksheet_match_non_blanks_request, opts = {}) data, _status_code, _headers = post_worksheet_match_non_blanks_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_merge(post_worksheet_merge_request, opts = {}) ⇒ Object
Merge cells in the worksheet.
245 246 247 248 249 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 245 def post_worksheet_merge( post_worksheet_merge_request, opts = {}) data, _status_code, _headers = post_worksheet_merge_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_picture(post_worksheet_picture_request, opts = {}) ⇒ Object
Update a picture by index in the worksheet.
1579 1580 1581 1582 1583 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1579 def post_worksheet_picture( post_worksheet_picture_request, opts = {}) data, _status_code, _headers = post_worksheet_picture_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_pivot_table_calculate(post_worksheet_pivot_table_calculate_request, opts = {}) ⇒ Object
Calculate pivottable’s data to cells.
1715 1716 1717 1718 1719 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1715 def post_worksheet_pivot_table_calculate( post_worksheet_pivot_table_calculate_request, opts = {}) data, _status_code, _headers = post_worksheet_pivot_table_calculate_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_pivot_table_move(post_worksheet_pivot_table_move_request, opts = {}) ⇒ Object
Move PivotTable in the worksheet.
1723 1724 1725 1726 1727 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1723 def post_worksheet_pivot_table_move( post_worksheet_pivot_table_move_request, opts = {}) data, _status_code, _headers = post_worksheet_pivot_table_move_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_range_sort(post_worksheet_range_sort_request, opts = {}) ⇒ Object
Sort a range in the worksheet.
2592 2593 2594 2595 2596 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2592 def post_worksheet_range_sort( post_worksheet_range_sort_request, opts = {}) data, _status_code, _headers = post_worksheet_range_sort_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_shape(post_worksheet_shape_request, opts = {}) ⇒ Object
Update a shape in the worksheet.
2042 2043 2044 2045 2046 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2042 def post_worksheet_shape( post_worksheet_shape_request, opts = {}) data, _status_code, _headers = post_worksheet_shape_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_sparkline_group(post_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Update a sparkline group in the worksheet.
2106 2107 2108 2109 2110 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2106 def post_worksheet_sparkline_group( post_worksheet_sparkline_group_request, opts = {}) data, _status_code, _headers = post_worksheet_sparkline_group_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_text_replace(post_worksheet_text_replace_request, opts = {}) ⇒ Object
Replace old text with new text in the worksheet.
2584 2585 2586 2587 2588 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2584 def post_worksheet_text_replace( post_worksheet_text_replace_request, opts = {}) data, _status_code, _headers = post_worksheet_text_replace_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_text_search(post_worksheet_text_search_request, opts = {}) ⇒ Object
Search for text in the worksheet.
2576 2577 2578 2579 2580 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2576 def post_worksheet_text_search( post_worksheet_text_search_request, opts = {}) data, _status_code, _headers = post_worksheet_text_search_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_ungroup_shape(post_worksheet_ungroup_shape_request, opts = {}) ⇒ Object
Ungroup shapes in the worksheet.
2058 2059 2060 2061 2062 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2058 def post_worksheet_ungroup_shape( post_worksheet_ungroup_shape_request, opts = {}) data, _status_code, _headers = post_worksheet_ungroup_shape_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_unmerge(post_worksheet_unmerge_request, opts = {}) ⇒ Object
Unmerge cells in the worksheet.
253 254 255 256 257 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 253 def post_worksheet_unmerge( post_worksheet_unmerge_request, opts = {}) data, _status_code, _headers = post_worksheet_unmerge_request.create_http_request(@api_client,opts ) return data end |
#post_worksheet_validation(post_worksheet_validation_request, opts = {}) ⇒ Object
Update a validation by index in the worksheet.
2736 2737 2738 2739 2740 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2736 def post_worksheet_validation( post_worksheet_validation_request, opts = {}) data, _status_code, _headers = post_worksheet_validation_request.create_http_request(@api_client,opts ) return data end |
#put_active_worksheet(put_active_worksheet_request, opts = {}) ⇒ Object
Set active worksheet index in the workbook.
2424 2425 2426 2427 2428 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2424 def put_active_worksheet( put_active_worksheet_request, opts = {}) data, _status_code, _headers = put_active_worksheet_request.create_http_request(@api_client,opts ) return data end |
#put_add_new_worksheet(put_add_new_worksheet_request, opts = {}) ⇒ Object
Add a new worksheet in the workbook.
2440 2441 2442 2443 2444 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2440 def put_add_new_worksheet( put_add_new_worksheet_request, opts = {}) data, _status_code, _headers = put_add_new_worksheet_request.create_http_request(@api_client,opts ) return data end |
#put_change_visibility_worksheet(put_change_visibility_worksheet_request, opts = {}) ⇒ Object
Change worksheet visibility in the workbook.
2416 2417 2418 2419 2420 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2416 def put_change_visibility_worksheet( put_change_visibility_worksheet_request, opts = {}) data, _status_code, _headers = put_change_visibility_worksheet_request.create_http_request(@api_client,opts ) return data end |
#put_convert_workbook(put_convert_workbook_request, opts = {}) ⇒ Object
Convert the workbook from the requested content into files in different formats.
853 854 855 856 857 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 853 def put_convert_workbook( put_convert_workbook_request, opts = {}) data, _status_code, _headers = put_convert_workbook_request.create_http_request(@api_client,opts ) return data end |
#put_document_property(put_document_property_request, opts = {}) ⇒ Object
Set or add an Excel property.
1779 1780 1781 1782 1783 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1779 def put_document_property( put_document_property_request, opts = {}) data, _status_code, _headers = put_document_property_request.create_http_request(@api_client,opts ) return data end |
#put_document_protect_from_changes(put_document_protect_from_changes_request, opts = {}) ⇒ Object
Excel file write protection.
1851 1852 1853 1854 1855 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1851 def put_document_protect_from_changes( put_document_protect_from_changes_request, opts = {}) data, _status_code, _headers = put_document_protect_from_changes_request.create_http_request(@api_client,opts ) return data end |
#put_horizontal_page_break(put_horizontal_page_break_request, opts = {}) ⇒ Object
Add a horizontal page breaks in the worksheet.
1435 1436 1437 1438 1439 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1435 def put_horizontal_page_break( put_horizontal_page_break_request, opts = {}) data, _status_code, _headers = put_horizontal_page_break_request.create_http_request(@api_client,opts ) return data end |
#put_insert_new_worksheet(put_insert_new_worksheet_request, opts = {}) ⇒ Object
Insert a new worksheet in the workbook.
2432 2433 2434 2435 2436 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2432 def put_insert_new_worksheet( put_insert_new_worksheet_request, opts = {}) data, _status_code, _headers = put_insert_new_worksheet_request.create_http_request(@api_client,opts ) return data end |
#put_insert_worksheet_columns(put_insert_worksheet_columns_request, opts = {}) ⇒ Object
Insert worksheet columns in the worksheet.
373 374 375 376 377 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 373 def put_insert_worksheet_columns( put_insert_worksheet_columns_request, opts = {}) data, _status_code, _headers = put_insert_worksheet_columns_request.create_http_request(@api_client,opts ) return data end |
#put_insert_worksheet_row(put_insert_worksheet_row_request, opts = {}) ⇒ Object
Insert a new row in the worksheet.
477 478 479 480 481 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 477 def put_insert_worksheet_row( put_insert_worksheet_row_request, opts = {}) data, _status_code, _headers = put_insert_worksheet_row_request.create_http_request(@api_client,opts ) return data end |
#put_insert_worksheet_rows(put_insert_worksheet_rows_request, opts = {}) ⇒ Object
Insert several new rows in the worksheet.
469 470 471 472 473 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 469 def put_insert_worksheet_rows( put_insert_worksheet_rows_request, opts = {}) data, _status_code, _headers = put_insert_worksheet_rows_request.create_http_request(@api_client,opts ) return data end |
#put_pivot_table_field(put_pivot_table_field_request, opts = {}) ⇒ Object
Add a pivot field in the PivotTable.
1651 1652 1653 1654 1655 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1651 def put_pivot_table_field( put_pivot_table_field_request, opts = {}) data, _status_code, _headers = put_pivot_table_field_request.create_http_request(@api_client,opts ) return data end |
#put_protect_worksheet(put_protect_worksheet_request, opts = {}) ⇒ Object
Protect worksheet.
2472 2473 2474 2475 2476 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2472 def put_protect_worksheet( put_protect_worksheet_request, opts = {}) data, _status_code, _headers = put_protect_worksheet_request.create_http_request(@api_client,opts ) return data end |
#put_vertical_page_break(put_vertical_page_break_request, opts = {}) ⇒ Object
Add a vertical page break in the worksheet.
1427 1428 1429 1430 1431 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1427 def put_vertical_page_break( put_vertical_page_break_request, opts = {}) data, _status_code, _headers = put_vertical_page_break_request.create_http_request(@api_client,opts ) return data end |
#put_workbook_background(put_workbook_background_request, opts = {}) ⇒ Object
Set background in the workbook.
2360 2361 2362 2363 2364 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2360 def put_workbook_background( put_workbook_background_request, opts = {}) data, _status_code, _headers = put_workbook_background_request.create_http_request(@api_client,opts ) return data end |
#put_workbook_create(put_workbook_create_request, opts = {}) ⇒ Object
Create a new workbook using different methods.
2304 2305 2306 2307 2308 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2304 def put_workbook_create( put_workbook_create_request, opts = {}) data, _status_code, _headers = put_workbook_create_request.create_http_request(@api_client,opts ) return data end |
#put_workbook_name(put_workbook_name_request, opts = {}) ⇒ Object
Define a new name in the workbook.
2224 2225 2226 2227 2228 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2224 def put_workbook_name( put_workbook_name_request, opts = {}) data, _status_code, _headers = put_workbook_name_request.create_http_request(@api_client,opts ) return data end |
#put_workbook_water_marker(put_workbook_water_marker_request, opts = {}) ⇒ Object
Set water marker in the workbook.
2376 2377 2378 2379 2380 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2376 def put_workbook_water_marker( put_workbook_water_marker_request, opts = {}) data, _status_code, _headers = put_workbook_water_marker_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_add_picture(put_worksheet_add_picture_request, opts = {}) ⇒ Object
Add a new picture in the worksheet.
1563 1564 1565 1566 1567 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1563 def put_worksheet_add_picture( put_worksheet_add_picture_request, opts = {}) data, _status_code, _headers = put_worksheet_add_picture_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_background(put_worksheet_background_request, opts = {}) ⇒ Object
Set background image in the worksheet.
2624 2625 2626 2627 2628 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2624 def put_worksheet_background( put_worksheet_background_request, opts = {}) data, _status_code, _headers = put_worksheet_background_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_cells_range(put_worksheet_cells_range_request, opts = {}) ⇒ Object
Insert a range of cells and shift existing cells based on the specified shift option.
1986 1987 1988 1989 1990 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1986 def put_worksheet_cells_range( put_worksheet_cells_range_request, opts = {}) data, _status_code, _headers = put_worksheet_cells_range_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_chart(put_worksheet_chart_request, opts = {}) ⇒ Object
Add a new chart in the worksheet.
597 598 599 600 601 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 597 def put_worksheet_chart( put_worksheet_chart_request, opts = {}) data, _status_code, _headers = put_worksheet_chart_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_chart_legend(put_worksheet_chart_legend_request, opts = {}) ⇒ Object
Show chart legend in the worksheet.
637 638 639 640 641 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 637 def put_worksheet_chart_legend( put_worksheet_chart_legend_request, opts = {}) data, _status_code, _headers = put_worksheet_chart_legend_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_chart_title(put_worksheet_chart_title_request, opts = {}) ⇒ Object
Set chart title in the worksheet.
677 678 679 680 681 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 677 def put_worksheet_chart_title( put_worksheet_chart_title_request, opts = {}) data, _status_code, _headers = put_worksheet_chart_title_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_color_filter(put_worksheet_color_filter_request, opts = {}) ⇒ Object
Add a color filter in the worksheet.
109 110 111 112 113 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 109 def put_worksheet_color_filter( put_worksheet_color_filter_request, opts = {}) data, _status_code, _headers = put_worksheet_color_filter_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_comment(put_worksheet_comment_request, opts = {}) ⇒ Object
Add cell comment in the worksheet.
2512 2513 2514 2515 2516 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2512 def put_worksheet_comment( put_worksheet_comment_request, opts = {}) data, _status_code, _headers = put_worksheet_comment_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_conditional_formatting(put_worksheet_conditional_formatting_request, opts = {}) ⇒ Object
Add conditional formatting in the worksheet.
789 790 791 792 793 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 789 def put_worksheet_conditional_formatting( put_worksheet_conditional_formatting_request, opts = {}) data, _status_code, _headers = put_worksheet_conditional_formatting_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_custom_filter(put_worksheet_custom_filter_request, opts = {}) ⇒ Object
Filter a list with custom criteria in the worksheet.
85 86 87 88 89 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 85 def put_worksheet_custom_filter( put_worksheet_custom_filter_request, opts = {}) data, _status_code, _headers = put_worksheet_custom_filter_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_date_filter(put_worksheet_date_filter_request, opts = {}) ⇒ Object
Apply a date filter in the worksheet.
61 62 63 64 65 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 61 def put_worksheet_date_filter( put_worksheet_date_filter_request, opts = {}) data, _status_code, _headers = put_worksheet_date_filter_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_dynamic_filter(put_worksheet_dynamic_filter_request, opts = {}) ⇒ Object
Add a dynamic filter in the worksheet.
93 94 95 96 97 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 93 def put_worksheet_dynamic_filter( put_worksheet_dynamic_filter_request, opts = {}) data, _status_code, _headers = put_worksheet_dynamic_filter_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_filter(put_worksheet_filter_request, opts = {}) ⇒ Object
Add a filter for a column in the worksheet.
69 70 71 72 73 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 69 def put_worksheet_filter( put_worksheet_filter_request, opts = {}) data, _status_code, _headers = put_worksheet_filter_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_filter_top10(put_worksheet_filter_top10_request, opts = {}) ⇒ Object
Filter the top 10 items in the list in the worksheet.
101 102 103 104 105 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 101 def put_worksheet_filter_top10( put_worksheet_filter_top10_request, opts = {}) data, _status_code, _headers = put_worksheet_filter_top10_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_format_condition(put_worksheet_format_condition_request, opts = {}) ⇒ Object
Add a format condition in the worksheet.
797 798 799 800 801 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 797 def put_worksheet_format_condition( put_worksheet_format_condition_request, opts = {}) data, _status_code, _headers = put_worksheet_format_condition_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_format_condition_area(put_worksheet_format_condition_area_request, opts = {}) ⇒ Object
Add a cell area for the format condition in the worksheet.
805 806 807 808 809 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 805 def put_worksheet_format_condition_area( put_worksheet_format_condition_area_request, opts = {}) data, _status_code, _headers = put_worksheet_format_condition_area_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_format_condition_condition(put_worksheet_format_condition_condition_request, opts = {}) ⇒ Object
Add a condition for the format condition in the worksheet.
813 814 815 816 817 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 813 def put_worksheet_format_condition_condition( put_worksheet_format_condition_condition_request, opts = {}) data, _status_code, _headers = put_worksheet_format_condition_condition_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_freeze_panes(put_worksheet_freeze_panes_request, opts = {}) ⇒ Object
Set freeze panes in the worksheet.
2640 2641 2642 2643 2644 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2640 def put_worksheet_freeze_panes( put_worksheet_freeze_panes_request, opts = {}) data, _status_code, _headers = put_worksheet_freeze_panes_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_hyperlink(put_worksheet_hyperlink_request, opts = {}) ⇒ Object
Add hyperlink in the worksheet.
1107 1108 1109 1110 1111 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1107 def put_worksheet_hyperlink( put_worksheet_hyperlink_request, opts = {}) data, _status_code, _headers = put_worksheet_hyperlink_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_icon_filter(put_worksheet_icon_filter_request, opts = {}) ⇒ Object
Add an icon filter in the worksheet.
77 78 79 80 81 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 77 def put_worksheet_icon_filter( put_worksheet_icon_filter_request, opts = {}) data, _status_code, _headers = put_worksheet_icon_filter_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_list_object(put_worksheet_list_object_request, opts = {}) ⇒ Object
Add a ListObject in the worksheet.
1259 1260 1261 1262 1263 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1259 def put_worksheet_list_object( put_worksheet_list_object_request, opts = {}) data, _status_code, _headers = put_worksheet_list_object_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_ole_object(put_worksheet_ole_object_request, opts = {}) ⇒ Object
Add an OLE object in the worksheet.
1387 1388 1389 1390 1391 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1387 def put_worksheet_ole_object( put_worksheet_ole_object_request, opts = {}) data, _status_code, _headers = put_worksheet_ole_object_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_pivot_table(put_worksheet_pivot_table_request, opts = {}) ⇒ Object
Add a PivotTable in the worksheet.
1643 1644 1645 1646 1647 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1643 def put_worksheet_pivot_table( put_worksheet_pivot_table_request, opts = {}) data, _status_code, _headers = put_worksheet_pivot_table_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_pivot_table_filter(put_worksheet_pivot_table_filter_request, opts = {}) ⇒ Object
Add a pivot filter to the PivotTable.
1659 1660 1661 1662 1663 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1659 def put_worksheet_pivot_table_filter( put_worksheet_pivot_table_filter_request, opts = {}) data, _status_code, _headers = put_worksheet_pivot_table_filter_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_shape(put_worksheet_shape_request, opts = {}) ⇒ Object
Add a shape in the worksheet.
2018 2019 2020 2021 2022 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2018 def put_worksheet_shape( put_worksheet_shape_request, opts = {}) data, _status_code, _headers = put_worksheet_shape_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_sparkline_group(put_worksheet_sparkline_group_request, opts = {}) ⇒ Object
Add a sparkline group in the worksheet.
2098 2099 2100 2101 2102 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2098 def put_worksheet_sparkline_group( put_worksheet_sparkline_group_request, opts = {}) data, _status_code, _headers = put_worksheet_sparkline_group_request.create_http_request(@api_client,opts ) return data end |
#put_worksheet_validation(put_worksheet_validation_request, opts = {}) ⇒ Object
Add a validation at index in the worksheet.
2728 2729 2730 2731 2732 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2728 def put_worksheet_validation( put_worksheet_validation_request, opts = {}) data, _status_code, _headers = put_worksheet_validation_request.create_http_request(@api_client,opts ) return data end |
#storage_exists(storage_exists_request, opts = {}) ⇒ Object
2829 2830 2831 2832 2833 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2829 def storage_exists( storage_exists_request, opts = {}) data, _status_code, _headers = storage_exists_request.create_http_request(@api_client,opts ) return data end |
#upload_file(upload_file_request, opts = {}) ⇒ Object
2766 2767 2768 2769 2770 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2766 def upload_file( upload_file_request, opts = {}) data, _status_code, _headers = upload_file_request.create_http_request(@api_client,opts ) return data end |