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.
- #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.
1556 1557 1558 1559 1560 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1556 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 |
#copy_file(copy_file_request, opts = {}) ⇒ Object
2758 2759 2760 2761 2762 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2758 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
2793 2794 2795 2796 2797 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2793 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
2786 2787 2788 2789 2790 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2786 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.
1812 1813 1814 1815 1816 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1812 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.
1788 1789 1790 1791 1792 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1788 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.
1780 1781 1782 1783 1784 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1780 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.
1844 1845 1846 1847 1848 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1844 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
2772 2773 2774 2775 2776 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2772 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
2807 2808 2809 2810 2811 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2807 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.
1476 1477 1478 1479 1480 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1476 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.
1452 1453 1454 1455 1456 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1452 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.
1436 1437 1438 1439 1440 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1436 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.
1220 1221 1222 1223 1224 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1220 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.
1732 1733 1734 1735 1736 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1732 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.
1828 1829 1830 1831 1832 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1828 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.
2465 2466 2467 2468 2469 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2465 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.
1444 1445 1446 1447 1448 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1444 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.
1428 1429 1430 1431 1432 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1428 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.
2353 2354 2355 2356 2357 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2353 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.
2249 2250 2251 2252 2253 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2249 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.
2241 2242 2243 2244 2245 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2241 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.
2433 2434 2435 2436 2437 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2433 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.
2617 2618 2619 2620 2621 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2617 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.
1979 1980 1981 1982 1983 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1979 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.
2513 2514 2515 2516 2517 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2513 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.
2521 2522 2523 2524 2525 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2521 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.
2633 2634 2635 2636 2637 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2633 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.
1076 1077 1078 1079 1080 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1076 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.
1100 1101 1102 1103 1104 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1100 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.
1260 1261 1262 1263 1264 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1260 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.
1252 1253 1254 1255 1256 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1252 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.
1356 1357 1358 1359 1360 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1356 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.
1348 1349 1350 1351 1352 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1348 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.
1572 1573 1574 1575 1576 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1572 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.
1580 1581 1582 1583 1584 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1580 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.
1724 1725 1726 1727 1728 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1724 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.
1748 1749 1750 1751 1752 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1748 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.
1740 1741 1742 1743 1744 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1740 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.
1716 1717 1718 1719 1720 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1716 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.
2019 2020 2021 2022 2023 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2019 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.
2011 2012 2013 2014 2015 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2011 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.
2075 2076 2077 2078 2079 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2075 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.
2067 2068 2069 2070 2071 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2067 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.
2729 2730 2731 2732 2733 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2729 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.
2737 2738 2739 2740 2741 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2737 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.
2441 2442 2443 2444 2445 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2441 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
2744 2745 2746 2747 2748 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2744 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.
2377 2378 2379 2380 2381 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2377 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
2828 2829 2830 2831 2832 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2828 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.
1756 1757 1758 1759 1760 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1756 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.
1772 1773 1774 1775 1776 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1772 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
2835 2836 2837 2838 2839 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2835 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
2779 2780 2781 2782 2783 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2779 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.
1500 1501 1502 1503 1504 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1500 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.
1484 1485 1486 1487 1488 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1484 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.
1404 1405 1406 1407 1408 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1404 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.
1388 1389 1390 1391 1392 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1388 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.
1212 1213 1214 1215 1216 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1212 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.
2673 2674 2675 2676 2677 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2673 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.
2665 2666 2667 2668 2669 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2665 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.
2369 2370 2371 2372 2373 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2369 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.
1460 1461 1462 1463 1464 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1460 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.
1604 1605 1606 1607 1608 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1604 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.
1396 1397 1398 1399 1400 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1396 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.
1380 1381 1382 1383 1384 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1380 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 .
2185 2186 2187 2188 2189 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2185 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.
2217 2218 2219 2220 2221 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2217 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.
2233 2234 2235 2236 2237 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2233 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.
2201 2202 2203 2204 2205 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2201 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.
2329 2330 2331 2332 2333 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2329 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.
2193 2194 2195 2196 2197 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2193 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.
2545 2546 2547 2548 2549 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2545 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.
1908 1909 1910 1911 1912 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1908 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.
2489 2490 2491 2492 2493 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2489 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.
2481 2482 2483 2484 2485 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2481 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.
1068 1069 1070 1071 1072 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1068 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.
1060 1061 1062 1063 1064 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1060 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.
1236 1237 1238 1239 1240 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1236 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.
1228 1229 1230 1231 1232 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1228 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.
2537 2538 2539 2540 2541 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2537 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.
2529 2530 2531 2532 2533 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2529 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.
1340 1341 1342 1343 1344 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1340 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.
1332 1333 1334 1335 1336 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1332 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.
2689 2690 2691 2692 2693 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2689 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.
1540 1541 1542 1543 1544 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1540 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.
1532 1533 1534 1535 1536 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1532 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.
1596 1597 1598 1599 1600 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1596 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.
1620 1621 1622 1623 1624 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1620 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.
1612 1613 1614 1615 1616 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1612 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.
1588 1589 1590 1591 1592 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1588 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.
1995 1996 1997 1998 1999 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1995 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.
1987 1988 1989 1990 1991 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1987 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.
2059 2060 2061 2062 2063 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2059 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.
2051 2052 2053 2054 2055 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2051 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.
2473 2474 2475 2476 2477 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2473 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.
2705 2706 2707 2708 2709 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2705 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.
2697 2698 2699 2700 2701 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2697 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.
2393 2394 2395 2396 2397 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2393 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.
2385 2386 2387 2388 2389 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2385 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
2765 2766 2767 2768 2769 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2765 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
2800 2801 2802 2803 2804 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2800 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
2821 2822 2823 2824 2825 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2821 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.
2128 2129 2130 2131 2132 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2128 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.
1108 1109 1110 1111 1112 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1108 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.
2321 2322 2323 2324 2325 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2321 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.
2313 2314 2315 2316 2317 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2313 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.
2601 2602 2603 2604 2605 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2601 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.
2585 2586 2587 2588 2589 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2585 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.
2593 2594 2595 2596 2597 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2593 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
2098 2099 2100 2101 2102 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2098 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.
1172 1173 1174 1175 1176 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1172 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.
1116 1117 1118 1119 1120 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1116 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
2156 2157 2158 2159 2160 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2156 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.
2641 2642 2643 2644 2645 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2641 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.
1004 1005 1006 1007 1008 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1004 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.
1020 1021 1022 1023 1024 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1020 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.
1036 1037 1038 1039 1040 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1036 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.
1052 1053 1054 1055 1056 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1052 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.
1044 1045 1046 1047 1048 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1044 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.
1796 1797 1798 1799 1800 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1796 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.
1804 1805 1806 1807 1808 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1804 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.
955 956 957 958 959 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 955 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
2170 2171 2172 2173 2174 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2170 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.
1524 1525 1526 1527 1528 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1524 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.
1516 1517 1518 1519 1520 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1516 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.
1508 1509 1510 1511 1512 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1508 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.
1492 1493 1494 1495 1496 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1492 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.
1156 1157 1158 1159 1160 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1156 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.
988 989 990 991 992 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 988 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.
1860 1861 1862 1863 1864 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1860 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.
1124 1125 1126 1127 1128 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1124 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.
1204 1205 1206 1207 1208 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1204 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.
2449 2450 2451 2452 2453 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2449 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.
1468 1469 1470 1471 1472 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1468 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.
1668 1669 1670 1671 1672 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1668 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.
1652 1653 1654 1655 1656 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1652 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.
1660 1661 1662 1663 1664 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1660 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.
1676 1677 1678 1679 1680 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1676 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.
1692 1693 1694 1695 1696 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1692 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.
1684 1685 1686 1687 1688 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1684 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.
1868 1869 1870 1871 1872 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1868 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.
1820 1821 1822 1823 1824 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1820 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
2149 2150 2151 2152 2153 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2149 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
2163 2164 2165 2166 2167 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2163 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.
2649 2650 2651 2652 2653 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2649 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.
1188 1189 1190 1191 1192 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1188 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.
1148 1149 1150 1151 1152 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1148 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.
1180 1181 1182 1183 1184 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1180 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.
1196 1197 1198 1199 1200 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1196 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.
2120 2121 2122 2123 2124 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2120 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.
1140 1141 1142 1143 1144 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1140 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
2112 2113 2114 2115 2116 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2112 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.
1132 1133 1134 1135 1136 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1132 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
2177 2178 2179 2180 2181 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2177 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
2135 2136 2137 2138 2139 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2135 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.
1852 1853 1854 1855 1856 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1852 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
2142 2143 2144 2145 2146 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2142 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.
1364 1365 1366 1367 1368 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1364 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.
2657 2658 2659 2660 2661 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2657 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.
2681 2682 2683 2684 2685 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2681 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.
1164 1165 1166 1167 1168 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1164 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
2105 2106 2107 2108 2109 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2105 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.
2305 2306 2307 2308 2309 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2305 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.
996 997 998 999 1000 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 996 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.
1012 1013 1014 1015 1016 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1012 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.
1028 1029 1030 1031 1032 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1028 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.
964 965 966 967 968 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 964 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.
2281 2282 2283 2284 2285 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2281 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.
972 973 974 975 976 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 972 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.
980 981 982 983 984 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 980 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.
2225 2226 2227 2228 2229 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2225 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.
2337 2338 2339 2340 2341 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2337 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.
2297 2298 2299 2300 2301 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2297 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.
2273 2274 2275 2276 2277 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2273 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.
2257 2258 2259 2260 2261 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2257 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.
2265 2266 2267 2268 2269 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2265 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.
2553 2554 2555 2556 2557 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2553 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.
1948 1949 1950 1951 1952 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1948 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.
1884 1885 1886 1887 1888 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1884 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.
1924 1925 1926 1927 1928 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1924 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.
1940 1941 1942 1943 1944 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1940 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.
1956 1957 1958 1959 1960 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1956 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.
1932 1933 1934 1935 1936 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1932 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.
1900 1901 1902 1903 1904 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1900 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
1963 1964 1965 1966 1967 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1963 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.
1892 1893 1894 1895 1896 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1892 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.
1916 1917 1918 1919 1920 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1916 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.
1876 1877 1878 1879 1880 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1876 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.
2505 2506 2507 2508 2509 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2505 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.
2035 2036 2037 2038 2039 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2035 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.
1084 1085 1086 1087 1088 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1084 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.
1316 1317 1318 1319 1320 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1316 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.
1324 1325 1326 1327 1328 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1324 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.
1268 1269 1270 1271 1272 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1268 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.
1276 1277 1278 1279 1280 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1276 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.
1308 1309 1310 1311 1312 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1308 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.
1300 1301 1302 1303 1304 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1300 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.
1292 1293 1294 1295 1296 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1292 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.
1284 1285 1286 1287 1288 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1284 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.
1564 1565 1566 1567 1568 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1564 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.
1700 1701 1702 1703 1704 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1700 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.
1708 1709 1710 1711 1712 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1708 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.
2577 2578 2579 2580 2581 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2577 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.
2027 2028 2029 2030 2031 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2027 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.
2091 2092 2093 2094 2095 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2091 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.
2569 2570 2571 2572 2573 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2569 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.
2561 2562 2563 2564 2565 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2561 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.
2043 2044 2045 2046 2047 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2043 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.
2721 2722 2723 2724 2725 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2721 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.
2409 2410 2411 2412 2413 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2409 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.
2425 2426 2427 2428 2429 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2425 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.
2401 2402 2403 2404 2405 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2401 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.
1764 1765 1766 1767 1768 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1764 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.
1836 1837 1838 1839 1840 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1836 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.
1420 1421 1422 1423 1424 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1420 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.
2417 2418 2419 2420 2421 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2417 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.
1636 1637 1638 1639 1640 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1636 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.
2457 2458 2459 2460 2461 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2457 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.
1412 1413 1414 1415 1416 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1412 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.
2345 2346 2347 2348 2349 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2345 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.
2289 2290 2291 2292 2293 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2289 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.
2209 2210 2211 2212 2213 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2209 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.
2361 2362 2363 2364 2365 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2361 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.
1548 1549 1550 1551 1552 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1548 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.
2609 2610 2611 2612 2613 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2609 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.
1971 1972 1973 1974 1975 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1971 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.
2497 2498 2499 2500 2501 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2497 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.
2625 2626 2627 2628 2629 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2625 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.
1092 1093 1094 1095 1096 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1092 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.
1244 1245 1246 1247 1248 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1244 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.
1372 1373 1374 1375 1376 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1372 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.
1628 1629 1630 1631 1632 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1628 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.
1644 1645 1646 1647 1648 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 1644 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.
2003 2004 2005 2006 2007 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2003 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.
2083 2084 2085 2086 2087 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2083 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.
2713 2714 2715 2716 2717 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2713 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
2814 2815 2816 2817 2818 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2814 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
2751 2752 2753 2754 2755 |
# File 'lib/aspose_cells_cloud/api/cells_api.rb', line 2751 def upload_file( upload_file_request, opts = {}) data, _status_code, _headers = upload_file_request.create_http_request(@api_client,opts ) return data end |