require "minitest/autorun"
require "minitest/unit"
require_relative '../lib/aspose_cells_cloud'
class CellsTests < Minitest::Test
include MiniTest::Assertions
include AsposeCellsCloud
include AsposeStorageCloud
def setup
#Get App key and App SID from https://cloud.aspose.com
AsposeApp.app_key_and_sid("", "")
@cells_api = CellsApi.new
end
def teardown
end
def upload_file(file_name)
@storage_api = StorageApi.new
response = @storage_api.put_create(file_name, File.open("../../../data/" << file_name,"r") { |io| io.read } )
assert(response, message="Failed to upload {file_name} file.")
end
def test_put_convert_work_book
file_name = "Book1.xlsx"
convert_to_format = "pdf"
response = @cells_api.put_convert_work_book(File.open("../../../data/" << file_name,"r") { |io| io.read }, {format: convert_to_format})
puts response
assert(response, message="convert a workbook to a different file format without uploading to any storage.")
end
def test_put_convert_work_book_with_additional_settings
file_name = "Book1.xlsx"
convert_to_format = "pdf"
pdf_save_options = PdfSaveOptions.new
pdf_save_options.calculate_formula = true
pdf_save_options.check_font_compatibility = false
pdf_save_options.compliance = "None"
pdf_save_options.one_page_per_sheet = false
pdf_save_options.save_format = "PDF"
response = @cells_api.put_convert_work_book(File.open("../../../data/" << file_name,"r") { |io| io.read }, {format: convert_to_format, save_options: pdf_save_options})
puts response
assert(response, message="convert a workbook to a different file format without uploading to any storage.")
end
def test_get_work_book_with_format
file_name = "myWorkbook.xlsx"
upload_file(file_name)
response = @cells_api.get_work_book_with_format(file_name, "pdf")
assert(response, message="Failed to convert excel workbook to different file formats.")
end
def test_get_work_book
file_name = "myWorkbook.xlsx"
#upload_file(file_name)
response = @cells_api.get_work_book(file_name)
puts response
assert(response, message="Failed to read workbook info.")
end
def test_put_workbook_create
#file_name = "calendar.xlsx"
#upload_file(file_name)
response = @cells_api.put_workbook_create("newworkbook_02.xlsx", {template_file: "calendar.xlsx"})
puts response
assert(response, message="Failed to create new workbook.")
end
def test_post_document_save_as
file_name = "SAASCELLS-157-6.xltx"
upload_file(file_name)
pdf_save_options = PdfSaveOptions.new
pdf_save_options.calculate_formula = true
pdf_save_options.check_font_compatibility = false
pdf_save_options.compliance = "None"
pdf_save_options.one_page_per_sheet = false
pdf_save_options.save_format = "PDF"
response = @cells_api.post_document_save_as(file_name, pdf_save_options, {newfilename: "SAASCELLS-157-6.pdf"})
puts response
assert(response, message="Failed to convert document and save result to storage.")
end
def test_post_autofit_workbook_rows
file_name = "myWorkbook.xlsx"
upload_file(file_name)
auto_fitter_options = AutoFitterOptions.new
auto_fitter_options.auto_fit_merged_cells = true
auto_fitter_options.ignore_hidden = true
response = @cells_api.post_autofit_workbook_rows(file_name, auto_fitter_options, {startRow: 1, endRow: 300, onlyAuto: true})
assert(response, message="Failed to autofit workbook rows")
end
def test_post_workbook_calculate_formula
file_name = "Book1.xlsx"
upload_file(file_name)
ignore_error = true
post_workbook_calculate_formula(file_name, options, ignore_error, opts = {})
response = @cells_api.post_workbook_calculate_formula(file_name)
assert(response, message="Failed to calculate all formulas in workbook")
end
def test_get_work_book_default_style
file_name = "myWorkbook.xlsx"
upload_file(file_name)
response = @cells_api.get_work_book_default_style(file_name)
assert(response, message="Failed to read workbook default style info")
end
def test_get_document_properties
file_name = "myWorkbook.xlsx"
upload_file(file_name)
response = @cells_api.get_document_properties(file_name)
assert(response, message="Failed to read document properties")
end
def test_delete_document_properties
file_name = "myWorkbook.xlsx"
upload_file(file_name)
response = @cells_api.delete_document_properties(file_name)
assert(response, message="Failed to delete all custom document properties and clean built-in ones")
end
def test_get_document_property
file_name = "myWorkbook.xlsx"
upload_file(file_name)
property_name = "Title"
response = @cells_api.get_document_property(file_name, property_name)
assert(response, message="Failed to read document property by name")
end
def test_put_document_property
file_name = "myWorkbook.xlsx"
upload_file(file_name)
property_name = "Title"
cells_document_property = CellsDocumentProperty.new
cells_document_property.name = "Title"
cells_document_property.value = "Tax Reforms"
response = @cells_api.put_document_property(file_name, property_name, cells_document_property)
assert(response, message="Failed to set/create document property")
end
def test_delete_document_property
file_name = "myWorkbook.xlsx"
upload_file(file_name)
property_name = "author"
response = @cells_api.delete_document_property(file_name, property_name)
assert(response, message="Failed to delete document property")
end
def test_post_encrypt_document
file_name = "myWorkbook.xlsx"
upload_file(file_name)
encryption_request = WorkbookEncryptionRequest.new
encryption_request.encryption_type = "EnhancedCryptographicProviderV1"
encryption_request.password = "password1234"
encryption_request.key_length = 128
response = @cells_api.post_encrypt_document(file_name, encryption_request)
assert(response, message="Failed to encrypt document")
end
def test_delete_decrypt_document
file_name = "myWorkbook.xlsx"
upload_file(file_name)
encryption_request = WorkbookEncryptionRequest.new
encryption_request.password = "password1234"
response = @cells_api.delete_decrypt_document(file_name, encryption_request)
assert(response, message="Failed to decrypt document")
end
def test_post_workbooks_text_search
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
text = "aspose"
response = @cells_api.post_workbooks_text_search(file_name, text)
assert(response, message="Failed to search text")
end
def test_post_import_data
import_batch_data_option = ImportBatchDataOption.new
import_batch_data_option.destination_worksheet = "Sheet1"
import_batch_data_option.is_insert = false
import_batch_data_option.import_data_type = "BatchData"
import_source = ImportSource.new
import_source.file_source_type = "CloudFileSystem"
import_source.file_path = "Batch_data_json.txt"
import_batch_data_option.source = import_source
import_string_array_option = ImportStringArrayOption.new
import_string_array_option.first_row = 1
import_string_array_option.first_column = 2
import_string_array_option.is_vertical = true
import_string_array_option.destination_worksheet = "Sheet1"
import_string_array_option.is_insert = true
import_string_array_option.import_data_type = "StringArray"
import_source = ImportSource.new
import_source.file_source_type = "CloudFileSystem"
import_source.file_path = "Array_string_json.txt"
import_string_array_option.source = import_source
import_int_array_option = ImportIntArrayOption.new
import_int_array_option.first_row = 1
import_int_array_option.first_column = 2
import_int_array_option.is_vertical = true
import_int_array_option.destination_worksheet = "Sheet1"
import_int_array_option.is_insert = true
import_int_array_option.import_data_type = "IntArray"
import_source = ImportSource.new
import_source.file_source_type = "CloudFileSystem"
import_source.file_path = "Array_int_json.txt"
import_int_array_option.source = import_source
import_double_array_option = ImportDoubleArrayOption.new
import_double_array_option.first_row = 1
import_double_array_option.first_column = 2
import_double_array_option.is_vertical = true
import_double_array_option.destination_worksheet = "Sheet1"
import_double_array_option.is_insert = true
import_double_array_option.import_data_type = "DoubleArray"
import_source = ImportSource.new
import_source.file_source_type = "CloudFileSystem"
import_source.file_path = "Array_double_json.txt"
import_double_array_option.source = import_source
import_data_options = [import_batch_data_option, import_string_array_option, import_int_array_option, import_double_array_option]
data_files = ["Batch_data_json.txt", "Array_string_json.txt", "Array_int_json.txt", "Array_double_json.txt"]
import_data_options.each_with_index { |option, index|
file_name = "Book1.xlsx"
upload_file(file_name)
data_file = data_files.at(index)
upload_file(data_file)
response = @cells_api.post_import_data(file_name, option)
assert(response, message="Failed to import data into the worksheet.")
}
end
def test_post_import_data_without_using_storage
file_name = "Book1.xlsx"
upload_file(file_name)
import_batch_data_option = ImportBatchDataOption.new
import_batch_data_option.destination_worksheet = "Sheet1"
import_batch_data_option.is_insert = false
import_batch_data_option.import_data_type = "BatchData"
import_source = ImportSource.new
import_source.file_source_type = "RequestFiles"
import_source.file_path = "Batch_data_json.txt"
import_batch_data_option.source = import_source
file = File.open("../../../data/Batch_data_json.txt","r") { |io| io.read }
response = @cells_api.post_import_data(file_name, import_batch_data_option, {file: file})
puts response
assert(response, message="Failed to import data into the worksheet.")
end
def test_post_run_task
file_name = "TaskBook.xlsx"
upload_file(file_name)
tasks_data = TasksData.new
# First Task
task_description_1 = TaskDescription.new
task_description_1.task_type = "ImportData"
import_data_task_parameter = ImportDataTaskParameter.new
workbook = ImportSource.new
workbook.file_source_type = "CloudFileSystem"
workbook.file_path = "TaskBook.xlsx"
import_data_task_parameter.workbook = workbook
import_batch_data_option = ImportBatchDataOption.new
import_batch_data_option.destination_worksheet = "Sheet1"
import_batch_data_option.is_insert = true
source = ImportSource.new
source.file_source_type = "RequestFiles"
source.file_path = "Batch_data_xml.txt"
import_batch_data_option.source = source
import_data_task_parameter.import_batch_data_option = import_batch_data_option
task_description_1.import_data_task_parameter = import_data_task_parameter
# Second Task
task_description_2 = TaskDescription.new
task_description_2.task_type = "ImportData"
import_data_task_parameter = ImportDataTaskParameter.new
workbook = ImportSource.new
workbook.file_source_type = "InMemoryFiles"
workbook.file_path = "TaskBook.xlsx"
import_data_task_parameter.workbook = workbook
import_batch_data_option = ImportBatchDataOption.new
import_batch_data_option.destination_worksheet = "Sheet2"
import_batch_data_option.is_insert = true
source = ImportSource.new
source.file_source_type = "RequestFiles"
source.file_path = "Batch_data_xml_2.txt"
import_batch_data_option.source = source
import_data_task_parameter.import_batch_data_option = import_batch_data_option
task_description_2.import_data_task_parameter = import_data_task_parameter
# Third task
task_description_3 = TaskDescription.new
task_description_3.task_type = "ImportData"
save_result_task_parameter = SaveResultTaskParameter.new
save_result_task_parameter.result_source = "InMemoryFiles"
result_destination = ResultDestination.new
result_destination.destination_type = "CloudFileSystem"
result_destination.input_file = "TaskBook.xlsx"
result_destination.output_file = "ImpDataBook.xlsx"
save_result_task_parameter.result_destination = result_destination
task_description_3.save_result_task_parameter = save_result_task_parameter
tasks_data.tasks = [task_description_1, task_description_2, task_description_3]
file1 = File.open("../../../data/Batch_data_xml.txt","r") { |io| io.read }
file2 = File.open("../../../data/Batch_data_xml_2.txt","r") { |io| io.read }
files = [file1, file2]
response = @cells_api.post_run_task(tasks_data, files)
assert(response, message="Failed to import data into the worksheet")
end
def test_post_workbooks_merge
file_name = "Sample_Book1.xlsx"
upload_file(file_name)
merge_with = "Sample_Book2.xls"
upload_file(merge_with)
response = @cells_api.post_workbooks_merge(file_name, merge_with)
assert(response, message="Failed to merge workbooks")
end
def test_get_work_book_names
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
response = @cells_api.get_work_book_names(file_name)
assert(response, message="Failed to read workbook's names")
end
def test_get_work_book_name
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
name_name = "TestRange"
response = @cells_api.get_work_book_name(file_name, name_name)
assert(response, message="Failed to read workbook's name")
end
def test_post_protect_document
file_name = "myWorkbook.xlsx"
upload_file(file_name)
protection_request = WorkbookProtectionRequest.new
protection_request.protection_type = "All"
protection_request.password = "password1234"
response = @cells_api.post_protect_document(file_name, protection_request)
assert(response, message="Failed to protect document")
end
def test_delete_un_protect_document
file_name = "myWorkbook.xlsx"
upload_file(file_name)
protection_request = WorkbookProtectionRequest.new
protection_request.password = "password1234"
response = @cells_api.delete_un_protect_document(file_name, protection_request)
assert(response, message="Failed to unprotect document")
end
def test_post_workbooks_text_replace
file_name = "myWorkbook.xlsx"
upload_file(file_name)
old_value = "Averages"
new_value = "Median"
response = @cells_api.post_workbooks_text_replace(file_name, old_value, new_value)
assert(response, message="Failed to replace text")
end
def test_get_workbook_settings
file_name = "myWorkbook.xlsx"
upload_file(file_name)
response = @cells_api.get_workbook_settings(file_name)
assert(response, message="Failed to get workbook settings")
end
def test_post_workbook_settings
file_name = "myWorkbook.xlsx"
upload_file(file_name)
workbook_settings = WorkbookSettings.new
workbook_settings.auto_compress_pictures = true
workbook_settings.enable_macros = true
workbook_settings.is_h_scroll_bar_visible = false
response = @cells_api.post_workbook_settings(file_name, {settings: workbook_settings})
assert(response, message="Failed to update workbook settings")
end
def test_post_workbook_get_smart_marker_result
file_name = "Sample_SmartMarker.xlsx"
upload_file(file_name)
data_file = "Sample_SmartMarker_Data.xml"
response = @cells_api.post_workbook_get_smart_marker_result(file_name, File.open("../../../data/" << data_file,"r") { |io| io.read })
assert(response, message="Failed to get smart marker processing result")
end
def test_post_workbook_split
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
response = @cells_api.post_workbook_split(file_name, {format: "png", from: 1, to: 1})
assert(response, message="Failed to split workbook")
end
def test_get_work_book_text_items
file_name = "myWorkbook.xlsx"
upload_file(file_name)
response = @cells_api.get_work_book_text_items(file_name)
assert(response, message="Failed to read workbook's text items")
end
def test_get_work_sheets
file_name = "myWorkbook.xlsx"
upload_file(file_name)
response = @cells_api.get_work_sheets(file_name)
assert(response, message="Failed to read worksheets info")
end
def test_get_work_sheet
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.get_work_sheet(file_name, sheet_name)
assert(response, message="Failed to read worksheet info")
end
def test_get_work_sheet_with_format
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
format = "gif"
response = @cells_api.get_work_sheet_with_format(file_name, sheet_name, format)
assert(response, message="Failed to read worksheet in {format} format.")
end
def test_put_add_new_worksheet
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Tasks"
response = @cells_api.put_add_new_worksheet(file_name, sheet_name)
assert(response, message="Failed to add new worksheet")
end
def test_post_update_worksheet_property
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
worksheet = Worksheet.new
worksheet.type = "Worksheet"
worksheet.name = "sheet1"
worksheet.is_gridlines_visible = true
worksheet.is_row_column_headers_visible = true
worksheet.display_zeros = true
worksheet.display_right_to_left = true
worksheet.is_outline_shown = true
worksheet.is_selected = true
worksheet.transition_evaluation = true
worksheet.transition_entry = true
worksheet.is_visible = true
worksheet.index = 0
worksheet.first_visible_row = 1
worksheet.first_visible_column = 1
worksheet.zoom = 80
worksheet.view_type = "PageBreakPreview"
worksheet.is_page_break_preview = true
worksheet.is_ruler_visible = true
response = @cells_api.post_update_worksheet_property(file_name, sheet_name, worksheet)
assert(response, message="Failed to update worksheet property")
end
def test_delete_worksheet
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet3"
response = @cells_api.delete_worksheet(file_name, sheet_name)
assert(response, message="Failed to delete worksheet")
end
def test_post_autofit_worksheet_rows
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
auto_fitter_options = AutoFitterOptions.new
auto_fitter_options.auto_fit_merged_cells = true
auto_fitter_options.ignore_hidden = true
auto_fitter_options.only_auto = true
response = @cells_api.post_autofit_worksheet_rows(file_name, sheet_name, auto_fitter_options, {startRow: 1, endRow: 10, onlyAuto: true})
assert(response, message="Failed to autofit worksheet rows")
end
def test_get_worksheet_autoshapes
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet4"
response = @cells_api.get_worksheet_autoshapes(file_name, sheet_name)
assert(response, message="Failed to get worksheet autoshapes info")
end
def test_get_worksheet_autoshape
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet4"
autoshape_number = 1
response = @cells_api.get_worksheet_autoshape(file_name, sheet_name, autoshape_number)
assert(response, message="Failed to get autoshape info")
end
def test_get_worksheet_autoshape_with_format
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet4"
autoshape_number = 1
format = "png"
response = @cells_api.get_worksheet_autoshape_with_format(file_name, sheet_name, autoshape_number, format)
assert(response, message="Failed to get autoshape info")
end
def test_put_work_sheet_background
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
background_image = File.open("../../../data/Creative.jpg","r") { |io| io.read }
response = @cells_api.put_work_sheet_background(file_name, sheet_name, background_image)
assert(response, message="Failed to set worksheet background image")
end
def test_delete_work_sheet_background
file_name = "WorkSheetBackground_Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.delete_work_sheet_background(file_name, sheet_name)
assert(response, message="Failed to delete worksheet background image")
end
def test_get_worksheet_cells
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.get_worksheet_cells(file_name, sheet_name)
assert(response, message="Failed to get cells info")
end
def test_post_set_cell_range_value
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
cellarea = "A10:B20"
value = "1234"
type = "int"
response = @cells_api.post_set_cell_range_value(file_name, sheet_name, cellarea, value, type)
assert(response, message="Failed to set cell range value")
end
def test_post_clear_contents
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.post_clear_contents(file_name, sheet_name, {range: "A2:C11", startRow: 2, startColumn: 1, endRow: 11, endColumn: 3})
assert(response, message="Failed to clear cells contents")
end
def test_post_clear_formats
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.post_clear_formats(file_name, sheet_name, {range: "A2:C11", startRow: 2, startColumn: 1, endRow: 11, endColumn: 3})
assert(response, message="Failed to clear cells format")
end
def test_get_worksheet_columns
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.get_worksheet_columns(file_name, sheet_name)
assert(response, message="Failed to read worksheet columns info")
end
def test_post_copy_worksheet_columns
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
source_column_index = 2
destination_column_index = 0
column_number = 4
response = @cells_api.post_copy_worksheet_columns(file_name, sheet_name, source_column_index, destination_column_index, column_number)
assert(response, message="Failed to copy worksheet columns")
end
def test_post_group_worksheet_columns
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
first_index = 0
last_index = 2
response = @cells_api.post_group_worksheet_columns(file_name, sheet_name, first_index, last_index, {hide: true})
assert(response, message="Failed to group worksheet columns")
end
def test_post_hide_worksheet_columns
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
start_column = 0
total_columns = 1
response = @cells_api.post_hide_worksheet_columns(file_name, sheet_name, start_column, total_columns)
assert(response, message="Failed to hide worksheet columns")
end
def test_post_ungroup_worksheet_columns
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
first_index = 0
last_index = 2
response = @cells_api.post_ungroup_worksheet_columns(file_name, sheet_name, first_index, last_index)
assert(response, message="Failed to ungroup worksheet columns")
end
def test_post_unhide_worksheet_columns
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
startcolumn = 0
total_columns = 2
response = @cells_api.post_unhide_worksheet_columns(file_name, sheet_name, startcolumn, total_columns)
assert(response, message="Failed to unhide worksheet columns")
end
def test_get_worksheet_column
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
column_index = 1
response = @cells_api.get_worksheet_column(file_name, sheet_name, column_index)
assert(response, message="Failed to read worksheet column data by column's index")
end
def test_put_insert_worksheet_columns
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
column_index = 5
columns = 3
response = @cells_api.put_insert_worksheet_columns(file_name, sheet_name, column_index, columns, {updateReference: true})
assert(response, message="Failed to insert worksheet columns")
end
def test_post_set_worksheet_column_width
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
column_index = 3
width = 25.0
response = @cells_api.post_set_worksheet_column_width(file_name, sheet_name, column_index, width)
assert(response, message="Failed to set worksheet column width")
end
def test_delete_worksheet_columns
file_name = "test_cells.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
column_index = 0
columns = 0
update_reference = true
response = @cells_api.delete_worksheet_columns(file_name, sheet_name, column_index, columns, update_reference)
assert(response, message="Failed to delete worksheet columns")
end
def test_post_column_style
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
column_index = 0
column_style = Style.new
background_color = Color.new
background_color.a = "1"
background_color.r = "245"
background_color.g = "200"
background_color.b = "178"
column_style.background_color = background_color
response = @cells_api.post_column_style(file_name, sheet_name, column_index, column_style)
assert(response, message="Failed to set column style")
end
def test_post_worksheet_merge
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
start_row = 0
start_column = 0
total_rows = 5
total_columns = 2
response = @cells_api.post_worksheet_merge(file_name, sheet_name, start_row, start_column, total_rows, total_columns)
assert(response, message="Failed to merge cells")
end
def test_get_worksheet_rows
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.get_worksheet_rows(file_name, sheet_name)
assert(response, message="Failed to read worksheet rows info")
end
def test_put_insert_worksheet_rows
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
startrow = 10
response = @cells_api.put_insert_worksheet_rows(file_name, sheet_name, startrow, {totalRows: 10, updateReference: true})
assert(response, message="Failed to insert new worksheet rows")
end
def test_delete_worksheet_rows
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
startrow = 2
response = @cells_api.delete_worksheet_rows(file_name, sheet_name, startrow, {totalRows: 5, updateReference: true})
assert(response, message="Failed to delete worksheet rows")
end
def test_post_copy_worksheet_rows
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
source_row_index = 5
destination_row_index = 7
row_number = 3
response = @cells_api.post_copy_worksheet_rows(file_name, sheet_name, source_row_index, destination_row_index, row_number)
assert(response, message="Failed to copy worksheet rows")
end
def test_post_group_worksheet_rows
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
first_index = 1
last_index = 5
response = @cells_api.post_group_worksheet_rows(file_name, sheet_name, first_index, last_index, {hide: false})
assert(response, message="Failed to group worksheet rows")
end
def test_post_hide_worksheet_rows
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
startrow = 1
total_rows = 5
response = @cells_api.post_hide_worksheet_rows(file_name, sheet_name, startrow, total_rows)
assert(response, message="Failed to hide worksheet rows")
end
def test_post_ungroup_worksheet_rows
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
first_index = 1
last_index = 5
response = @cells_api.post_ungroup_worksheet_rows(file_name, sheet_name, first_index, last_index, {isAll: true})
assert(response, message="Failed to ungroup worksheet rows")
end
def test_post_unhide_worksheet_rows
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
startrow = 1
total_rows = 3
response = @cells_api.post_unhide_worksheet_rows(file_name, sheet_name, startrow, total_rows, {height: 30.0})
assert(response, message="Failed to unhide worksheet rows")
end
def test_get_worksheet_row
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
row_index = 1
response = @cells_api.get_worksheet_row(file_name, sheet_name, row_index)
assert(response, message="Failed to read worksheet row data by row's index")
end
def test_put_insert_worksheet_row
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
row_index = 10
response = @cells_api.put_insert_worksheet_row(file_name, sheet_name, row_index)
assert(response, message="Failed to insert new worksheet row")
end
def test_post_update_worksheet_row
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
row_index = 1
response = @cells_api.post_update_worksheet_row(file_name, sheet_name, row_index, {height: 25.0})
assert(response, message="Failed to update worksheet row")
end
def test_delete_worksheet_row
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
row_index = 1
response = @cells_api.delete_worksheet_row(file_name, sheet_name, row_index)
assert(response, message="Failed to delete worksheet row")
end
def test_post_row_style
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
row_index = 1
row_style = Style.new
background_color = Color.new
background_color.a = "1"
background_color.r = "245"
background_color.g = "200"
background_color.b = "178"
row_style.background_color = background_color
response = @cells_api.post_row_style(file_name, sheet_name, row_index, row_style)
assert(response, message="Failed to set row style")
end
def test_post_update_worksheet_range_style
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
range = "A1:C4"
style = Style.new
font = Font.new
font.double_size = 20
font.is_bold = true
font.is_italic = true
font.is_strikeout = true
font.size = 15
style.font = font
style.shrink_to_fit = true
background_color = Color.new
background_color.r = "255"
background_color.g = "255"
background_color.b = "255"
style.background_color = background_color
response = @cells_api.post_update_worksheet_range_style(file_name, sheet_name, range, style)
assert(response, message="Failed to update cell's range style")
end
def test_post_worksheet_unmerge
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
start_row = 1
start_column = 1
total_rows = 5
total_columns = 3
response = @cells_api.post_worksheet_unmerge(file_name, sheet_name, start_row, start_column, total_rows, total_columns)
assert(response, message="Failed to unmerge cells")
end
def test_post_worksheet_cell_set_value
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
cell_name = "A3"
response = @cells_api.post_worksheet_cell_set_value(file_name, sheet_name, cell_name, {value: "1234", type: "string", formula: "sum(a1,a2)"})
assert(response, message="Failed to set cell value")
end
def test_post_set_cell_html_string
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
cell_name = "A3"
response = @cells_api.post_set_cell_html_string(file_name, sheet_name, cell_name)
assert(response, message="Failed to set htmlstring value into cell")
end
def test_get_worksheet_cell_style
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
cell_name = "A7"
response = @cells_api.get_worksheet_cell_style(file_name, sheet_name, cell_name)
assert(response, message="Failed to read cell's style info")
end
def test_get_worksheet_cell
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
cell_or_method_name = "A3"
response = @cells_api.get_worksheet_cell(file_name, sheet_name, cell_or_method_name)
assert(response, message="Failed to read cell data by cell's name")
end
def test_post_copy_cell_into_cell
file_name = "myWorkbook.xlsx"
upload_file(file_name)
dest_cell_name = "C5"
sheet_name = "Sheet1"
worksheet = "Sheet1"
response = @cells_api.post_copy_cell_into_cell(file_name, dest_cell_name, sheet_name, worksheet, {cellname: "A5"})
assert(response, message="Failed to copy cell into cell")
end
def test_get_worksheet_charts
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.get_worksheet_charts(file_name, sheet_name)
assert(response, message="Failed to get worksheet charts info")
end
def test_put_worksheet_add_chart
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
chart_type = "Bar"
response = @cells_api.put_worksheet_add_chart(file_name, sheet_name, chart_type, {upperLeftRow: 12, upperLeftColumn: 12, lowerRightRow: 20, lowerRightColumn: 20, area: "B1:F2", isVertical: true, categoryData: "A1:A2", isAutoGetSerialName: true, title: "SalesState"})
assert(response, message="Failed to add new chart to worksheet")
end
def test_delete_worksheet_clear_charts
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.delete_worksheet_clear_charts(file_name, sheet_name)
assert(response, message="Failed to clear the charts")
end
def test_delete_worksheet_delete_chart
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_index = 0
response = @cells_api.delete_worksheet_delete_chart(file_name, sheet_name, chart_index)
assert(response, message="Failed to delete worksheet chart by index")
end
def test_get_chart_area
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_index = 0
response = @cells_api.get_chart_area(file_name, sheet_name, chart_index)
assert(response, message="Failed to get chart area info")
end
def test_get_chart_area_border
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_index = 0
response = @cells_api.get_chart_area_border(file_name, sheet_name, chart_index)
assert(response, message="Failed to get chart area border info")
end
def test_get_chart_area_fill_format
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_index = 0
response = @cells_api.get_chart_area_fill_format(file_name, sheet_name, chart_index)
assert(response, message="Failed to get chart area fill format info")
end
def test_get_worksheet_chart_legend
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_index = 0
response = @cells_api.get_worksheet_chart_legend(file_name, sheet_name, chart_index)
assert(response, message="Failed to get chart legend")
end
def test_put_worksheet_chart_legend
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_index = 0
response = @cells_api.put_worksheet_chart_legend(file_name, sheet_name, chart_index)
assert(response, message="Failed to show legend in chart")
end
def test_post_worksheet_chart_legend
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_index = 0
charts_legend = ChartsLegend.new
font = Font.new
color = Color.new
color.a = "1"
color.r = "255"
color.g = "0"
color.b = "0"
font.color = color
font.double_size = 10.0
font.is_bold = true
font.is_italic = false
font.is_strikeout = false
font.is_subscript = false
font.is_superscript = false
font.name = "Arial"
font.size = 10
font.size = 15
font.underline = "None"
charts_legend.font = font
charts_legend.shadow = true
response = @cells_api.post_worksheet_chart_legend(file_name, sheet_name, chart_index, charts_legend)
assert(response, message="Failed to update chart legend")
end
def test_delete_worksheet_chart_legend
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_index = 0
response = @cells_api.delete_worksheet_chart_legend(file_name, sheet_name, chart_index)
assert(response, message="Failed to delete worksheet chart legend")
end
def test_put_worksheet_chart_title
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_index = 0
chart_title = ChartsTitle.new
chart_title.text = "Sales Chart"
response = @cells_api.put_worksheet_chart_title(file_name, sheet_name, chart_index, chart_title)
assert(response, message="Failed to add chart title / Set chart title visible")
end
def test_post_worksheet_chart_title
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_index = 0
chart_title = ChartsTitle.new
chart_title.text = "Stock exchange"
response = @cells_api.post_worksheet_chart_title(file_name, sheet_name, chart_index, chart_title)
assert(response, message="Failed to update chart title")
end
def test_delete_worksheet_chart_title
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_index = 0
response = @cells_api.delete_worksheet_chart_title(file_name, sheet_name, chart_index)
assert(response, message="Failed to delete worksheet chart title")
end
def test_get_worksheet_chart_with_format
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_number = 0
format = "png"
response = @cells_api.get_worksheet_chart_with_format(file_name, sheet_name, chart_number, format)
assert(response, message="Failed to get chart in specified format.")
end
def test_get_worksheet_chart
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet5"
chart_number = 0
response = @cells_api.get_worksheet_chart(file_name, sheet_name, chart_number)
assert(response, message="Failed to get chart info")
end
def test_get_work_sheet_comments
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet2"
response = @cells_api.get_work_sheet_comments(file_name, sheet_name)
assert(response, message="Failed to get worksheet comments")
end
def test_get_work_sheet_comment
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet2"
cell_name = "A4"
response = @cells_api.get_work_sheet_comment(file_name, sheet_name, cell_name)
assert(response, message="Failed to get worksheet comment by cell name")
end
def test_put_work_sheet_comment
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
cell_name = "D18"
comment = Comment.new
comment.html_note = "Sohail:\nShopping"
comment.cell_name = "D18"
response = @cells_api.put_work_sheet_comment(file_name, sheet_name, cell_name, comment)
assert(response, message="Failed to add worksheet's cell comment")
end
def test_post_work_sheet_comment
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet2"
cell_name = "A4"
comment = Comment.new
comment.auto_size = true
comment.note = "aspose"
response = @cells_api.post_work_sheet_comment(file_name, sheet_name, cell_name, comment)
assert(response, message="Failed to update worksheet's cell comment")
end
def test_delete_work_sheet_comment
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
cell_name = "D19"
response = @cells_api.delete_work_sheet_comment(file_name, sheet_name, cell_name)
assert(response, message="Failed to delete worksheet's cell comment")
end
def test_post_work_sheet_text_search
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
text = "All"
response = @cells_api.post_work_sheet_text_search(file_name, sheet_name, text)
assert(response, message="Failed to search text")
end
def test_get_work_sheet_calculate_formula
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet2"
formula = "SUM(A5:A10)"
response = @cells_api.get_work_sheet_calculate_formula(file_name, sheet_name, formula)
assert(response, message="Failed to calculate formula value")
end
def test_put_worksheet_freeze_panes
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
row = 1
column = 1
freezed_rows = 1
freezed_columns = 1
response = @cells_api.put_worksheet_freeze_panes(file_name, sheet_name, row, column, freezed_rows, freezed_columns)
assert(response, message="Failed to set freeze panes")
end
def test_delete_worksheet_freeze_panes
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
row = 1
column = 1
freezed_rows = 1
freezed_columns = 1
response = @cells_api.delete_worksheet_freeze_panes(file_name, sheet_name, row, column, freezed_rows, freezed_columns)
assert(response, message="Failed to unfreeze panes")
end
def test_get_work_sheet_hyperlinks
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet2"
response = @cells_api.get_work_sheet_hyperlinks(file_name, sheet_name)
assert(response, message="Failed to get worksheet hyperlinks")
end
def test_put_work_sheet_hyperlink
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
first_row = 1
first_column = 1
total_rows = 2
total_columns = 2
address = "http://www.aspose.com/"
response = @cells_api.put_work_sheet_hyperlink(file_name, sheet_name, first_row, first_column, total_rows, total_columns, address)
assert(response, message="Failed to add worksheet hyperlink")
end
def test_delete_work_sheet_hyperlinks
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet2"
response = @cells_api.delete_work_sheet_hyperlinks(file_name, sheet_name)
assert(response, message="Failed to delete all hyperlinks in worksheet")
end
def test_get_work_sheet_hyperlink
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet2"
hyperlink_index = 0
response = @cells_api.get_work_sheet_hyperlink(file_name, sheet_name, hyperlink_index)
assert(response, message="Failed to get worksheet hyperlink by index")
end
def test_post_work_sheet_hyperlink
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
hyperlink_index = 0
hyperlink = Hyperlink.new
area = CellArea.new
area.start_row = 1
area.start_column = 1
area.end_row = 3
area.end_column = 3
hyperlink.area = area
hyperlink.address = "http://www.aspose.com/"
hyperlink.text_to_display = "Aspose"
response = @cells_api.post_work_sheet_hyperlink(file_name, sheet_name, hyperlink_index, hyperlink)
assert(response, message="Failed to update worksheet hyperlink by index")
end
def test_delete_work_sheet_hyperlink
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet2"
hyperlink_index = 0
response = @cells_api.delete_work_sheet_hyperlink(file_name, sheet_name, hyperlink_index)
assert(response, message="Failed to delete worksheet hyperlink by index")
end
def test_get_work_sheet_merged_cells
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.get_work_sheet_merged_cells(file_name, sheet_name)
assert(response, message="Failed to get worksheet merged cells")
end
def test_get_work_sheet_merged_cell
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
merged_cell_index = 0
response = @cells_api.get_work_sheet_merged_cell(file_name, sheet_name, merged_cell_index)
assert(response, message="Failed to get worksheet merged cell by its index")
end
def test_get_worksheet_ole_objects
file_name = "Embeded_OleObject_Sample_Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.get_worksheet_ole_objects(file_name, sheet_name)
assert(response, message="Failed to get worksheet OLE objects info")
end
def test_put_worksheet_ole_object
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
source_file_name = "Sample_Book2.xls"
upload_file(source_file_name)
image_file_name = "aspose-logo.png"
upload_file(image_file_name)
sheet_name = "Sheet1"
ole_object = DrawingOleObject.new
ole_object.source_full_name = source_file_name
ole_object.image_source_full_name = image_file_name
ole_object.upper_left_row = 15
ole_object.upper_left_column = 5
ole_object.top = 10
ole_object.left = 10
ole_object.height = 400
ole_object.width = 400
ole_object.is_auto_size = true
response = @cells_api.put_worksheet_ole_object(file_name, sheet_name, ole_object)
assert(response, message="Failed to add OLE object")
end
def test_delete_worksheet_ole_objects
file_name = "Embeded_OleObject_Sample_Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.delete_worksheet_ole_objects(file_name, sheet_name)
assert(response, message="Failed to delete all OLE objects")
end
def test_get_worksheet_ole_object_with_format
file_name = "Embeded_OleObject_Sample_Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
object_number = 0
format = "png"
response = @cells_api.get_worksheet_ole_object_with_format(file_name, sheet_name, object_number, format)
assert(response, message="Failed to get OLE object in specified format")
end
def test_get_worksheet_ole_object
file_name = "Embeded_OleObject_Sample_Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
object_number = 0
response = @cells_api.get_worksheet_ole_object(file_name, sheet_name, object_number)
assert(response, message="Failed to get OLE object info")
end
def test_post_update_worksheet_ole_object
file_name = "Embeded_OleObject_Sample_Book1.xlsx"
upload_file(file_name)
source_file_name = "Sample_Book2.xls"
image_file_name = "aspose-logo.png"
sheet_name = "Sheet1"
ole_object_index = 0
ole_object = DrawingOleObject.new
ole_object.source_full_name = source_file_name
ole_object.image_source_full_name = image_file_name
ole_object.upper_left_row = 15
ole_object.upper_left_column = 5
ole_object.top = 10
ole_object.left = 10
ole_object.height = 400
ole_object.width = 400
ole_object.is_auto_size = true
response = @cells_api.post_update_worksheet_ole_object(file_name, sheet_name, ole_object_index, ole_object)
assert(response, message="Failed to update OLE object")
end
def test_delete_worksheet_ole_object
file_name = "Embeded_OleObject_Sample_Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
ole_object_index = 0
response = @cells_api.delete_worksheet_ole_object(file_name, sheet_name, ole_object_index)
assert(response, message="Failed to delete OLE object")
end
def test_get_worksheet_pictures
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet6"
response = @cells_api.get_worksheet_pictures(file_name, sheet_name)
assert(response, message="Failed to read worksheet pictures")
end
def test_put_worksheet_add_picture
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
picture_path = "aspose-cloud.png"
upload_file(picture_path)
sheet_name = "Sheet6"
upperLeftRow = 5
upperLeftColumn = 5
lowerRightRow = 10
lowerRightColumn = 10
response = @cells_api.put_worksheet_add_picture(file_name, sheet_name, picture_path, {upperLeftRow: 5, upperLeftColumn: 5, lowerRightRow: 10, lowerRightColumn: 10})
assert(response, message="Failed to add a new worksheet picture")
end
def test_delete_work_sheet_pictures
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet6"
response = @cells_api.delete_work_sheet_pictures(file_name, sheet_name)
assert(response, message="Failed to delete all pictures in worksheet")
end
def test_post_work_sheet_picture
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
pic_name = "aspose-cloud.png"
upload_file(pic_name)
sheet_name = "Sheet6"
picture_index = 0
picture = DrawingPicture.new
picture.name = pic_name
picture.rotation_angle = 90
response = @cells_api.post_work_sheet_picture(file_name, sheet_name, picture_index, picture)
assert(response, message="Failed to update worksheet picture by index")
end
def test_get_extract_barcodes
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet6"
picture_number = 0
response = @cells_api.get_extract_barcodes(file_name, sheet_name, picture_number)
assert(response, message="Failed to extract barcodes from worksheet picture")
end
def test_get_worksheet_pivot_tables
file_name = "Sample_Pivot_Table_Example.xls"
upload_file(file_name)
sheet_name = "Sheet2"
response = @cells_api.get_worksheet_pivot_tables(file_name, sheet_name)
assert(response, message="Failed to get worksheet pivottables info")
end
def test_put_worksheet_pivot_table
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
create_pivot_table_request = CreatePivotTableRequest.new
create_pivot_table_request.name = "MyPivot"
create_pivot_table_request.source_data = "A5:E10"
create_pivot_table_request.dest_cell_name = "H20"
create_pivot_table_request.use_same_source = true
create_pivot_table_request.pivot_field_rows = [1]
create_pivot_table_request.pivot_field_columns = [1]
create_pivot_table_request.pivot_field_data = [1]
response = @cells_api.put_worksheet_pivot_table(file_name, sheet_name, create_pivot_table_request)
assert(response, message="Failed to add a pivot table into worksheet")
end
def test_delete_worksheet_pivot_tables
file_name = "Sample_Pivot_Table_Example.xls"
upload_file(file_name)
sheet_name = "Sheet2"
response = @cells_api.delete_worksheet_pivot_tables(file_name, sheet_name)
assert(response, message="Failed to delete worksheet pivot tables")
end
def test_delete_worksheet_pivot_table
file_name = "Sample_Pivot_Table_Example.xls"
upload_file(file_name)
sheet_name = "Sheet2"
pivot_table_index = 0
response = @cells_api.delete_worksheet_pivot_table(file_name, sheet_name, pivot_table_index)
assert(response, message="Failed to delete worksheet pivot table by index")
end
def test_post_worksheet_pivot_table_calculate
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet2"
pivot_table_index = 0
response = @cells_api.post_worksheet_pivot_table_calculate(file_name, sheet_name, pivot_table_index)
assert(response, message="Failed to calculates pivottable's data to cells")
end
def test_post_pivot_table_cell_style
file_name = "Sample_Pivot_Table_Example.xls"
upload_file(file_name)
sheet_name = "Sheet2"
pivot_table_index = 0
column = 1
row = 1
style = Style.new
font = Font.new
font.name = "Arial"
font.size = 10
style.font = font
response = @cells_api.post_pivot_table_cell_style(file_name, sheet_name, pivot_table_index, column, row, style)
assert(response, message="Failed to update cell style for pivot table")
end
def test_post_pivot_table_style
file_name = "Sample_Pivot_Table_Example.xls"
upload_file(file_name)
sheet_name = "Sheet2"
pivot_table_index = 0
style = Style.new
font = Font.new
font.name = "Arial"
font.size = 10
style.font = font
response = @cells_api.post_pivot_table_style(file_name, sheet_name, pivot_table_index, style)
assert(response, message="Failed to update style for pivot table")
end
def test_put_pivot_table_field
file_name = "Sample_Pivot_Table_Example.xls"
upload_file(file_name)
sheet_name = "Sheet2"
pivot_table_index = 0
pivot_field_type = "Row"
pivot_table_field_request = PivotTableFieldRequest.new
pivot_table_field_request.data = [1, 2]
response = @cells_api.put_pivot_table_field(file_name, sheet_name, pivot_table_index, pivot_field_type, pivot_table_field_request)
assert(response, message="Failed to add pivot field into into pivot table")
end
def test_get_pivot_table_field
file_name = "Sample_Pivot_Table_Example.xls"
upload_file(file_name)
sheet_name = "Sheet2"
pivot_table_index = 0
pivot_field_index = 0
pivot_field_type = "Row"
response = @cells_api.get_pivot_table_field(file_name, sheet_name, pivot_table_index, pivot_field_index, pivot_field_type)
assert(response, message="Failed to get pivot field into pivot table")
end
def test_delete_pivot_table_field
file_name = "Sample_Pivot_Table_Example.xls"
upload_file(file_name)
sheet_name = "Sheet2"
pivot_table_index = 0
pivot_field_type = "Row"
pivot_table_field_request = PivotTableFieldRequest.new
pivot_table_field_request.data = [1, 2]
response = @cells_api.delete_pivot_table_field(file_name, sheet_name, pivot_table_index, pivot_field_type, pivot_table_field_request)
assert(response, message="Failed to delete pivot field into pivot table")
end
def test_get_worksheet_pivot_table
file_name = "Sample_Pivot_Table_Example.xls"
upload_file(file_name)
sheet_name = "Sheet2"
pivottable_index = 0
response = @cells_api.get_worksheet_pivot_table(file_name, sheet_name, pivottable_index)
assert(response, message="Failed to get worksheet pivot table info by index")
end
def test_post_move_worksheet
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
moving_request = WorksheetMovingRequest.new
moving_request.destination_worksheet = "Sheet5"
moving_request.position = "after"
response = @cells_api.post_move_worksheet(file_name, sheet_name, moving_request)
assert(response, message="Failed to move worksheet")
end
def test_put_protect_worksheet
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
protect_parameter = ProtectSheetParameter.new
protect_parameter.protection_type = "All"
protect_parameter.password = "123456"
response = @cells_api.put_protect_worksheet(file_name, sheet_name, protect_parameter)
assert(response, message="Failed to protect worksheet")
end
def test_delete_unprotect_worksheet
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
protect_parameter = ProtectSheetParameter.new
protect_parameter.protection_type = "None"
response = @cells_api.delete_unprotect_worksheet(file_name, sheet_name, protect_parameter)
assert(response, message="Failed to unprotect worksheet")
end
def test_post_rename_worksheet
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
newname = "newSheet"
response = @cells_api.post_rename_worksheet(file_name, sheet_name, newname)
assert(response, message="Failed to rename worksheet")
end
def test_post_worsheet_text_replace
file_name = "myWorkbook.xlsx"
upload_file(file_name)
sheet_name = "Sheet2"
old_value = "aspose"
new_value = "aspose.com"
response = @cells_api.post_worsheet_text_replace(file_name, sheet_name, old_value, new_value)
assert(response, message="Failed to replace text")
end
def test_post_worksheet_range_sort
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
cell_area = "A5:A10"
data_sorter = DataSorter.new
data_sorter.case_sensitive = false
data_sorter.has_headers = false
data_sorter.sort_left_to_right = false
sort_key = SortKey.new
sort_key.key = 0
sort_key.sort_order = "descending"
data_sorter.key_list = [sort_key]
response = @cells_api.post_worksheet_range_sort(file_name, sheet_name, cell_area, data_sorter)
assert(response, message="Failed to sort worksheet range")
end
def test_get_work_sheet_text_items
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.get_work_sheet_text_items(file_name, sheet_name)
assert(response, message="Failed to get worksheet text items")
end
def test_get_work_sheet_validations
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet3"
response = @cells_api.get_work_sheet_validations(file_name, sheet_name)
assert(response, message="Failed to get worksheet validations")
end
def test_put_work_sheet_validation
file_name = "myWorkBook.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.put_work_sheet_validation(file_name, sheet_name, {range: "A1:C10"})
assert(response, message="Failed to add worksheet validation at index")
end
def test_get_work_sheet_validation
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet3"
validation_index = 0
response = @cells_api.get_work_sheet_validation(file_name, sheet_name, validation_index)
assert(response, message="Failed to get worksheet validation by index")
end
def test_post_work_sheet_validation
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet3"
validation_index = 0
response = @cells_api.post_work_sheet_validation(file_name, sheet_name, validation_index)
assert(response, message="Failed to update worksheet validation by index")
end
def test_delete_work_sheet_validation
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet3"
validation_index = 0
response = @cells_api.delete_work_sheet_validation(file_name, sheet_name, validation_index)
assert(response, message="Failed to delete worksheet validation by index")
end
def test_put_change_visibility_worksheet
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet1"
is_visible = false
response = @cells_api.put_change_visibility_worksheet(file_name, sheet_name, is_visible)
assert(response, message="Failed to change worksheet visibility")
end
def test_put_document_protect_from_changes
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
password_request = PasswordRequest.new
password_request.password = "aspose"
response = @cells_api.put_document_protect_from_changes(file_name, password_request)
assert(response, message="Failed to protect document from changes")
end
def test_delete_document_un_protect_from_changes
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
response = @cells_api.delete_document_un_protect_from_changes(file_name)
assert(response, message="Failed to unprotect document from changes")
end
def test_get_worksheet_picture
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet6"
picture_number = 0
response = @cells_api.get_worksheet_picture(file_name, sheet_name, picture_number)
assert(response, message="Failed to get worksheet picture by index")
end
def test_get_worksheet_picture_with_format
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet6"
picture_number = 0
format = "png"
response = @cells_api.get_worksheet_picture_with_format(file_name, sheet_name, picture_number, format)
assert(response, message="Failed to read worksheet pictures")
end
def test_delete_worksheet_picture
file_name = "Sample_Test_Book.xls"
upload_file(file_name)
sheet_name = "Sheet6"
picture_index = 0
response = @cells_api.delete_worksheet_picture(file_name, sheet_name, picture_index)
assert(response, message="Failed to delete a picture from excel worksheet")
end
def test_post_update_worksheet_cell_style
file_name = "test_cells.xlsx"
upload_file(file_name)
sheet_name = "Sheet3"
cell_name = "A1"
cell_style = Style.new
background_theme_color = ThemeColor.new
background_theme_color.color_type = "Text2"
background_theme_color.tint = 1
cell_style.background_theme_color = background_theme_color
response = @cells_api.post_update_worksheet_cell_style(file_name, sheet_name, cell_name, cell_style)
assert(response, message="Failed to update cell's style of a worksheet")
end
def test_post_copy_worksheet
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "NewSheet"
source_sheet = "Sheet3"
copy_options = CopyOptions.new
copy_options.copy_names = true
response = @cells_api.post_copy_worksheet(file_name, sheet_name, source_sheet, copy_options)
assert(response, message="Failed to copy a worksheet")
end
def test_delete_work_sheet_comments
file_name = "test_cells.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.delete_work_sheet_comments(file_name, sheet_name)
assert(response, message="Failed to delete all comments in a worksheet")
end
def test_get_worksheet_auto_filter
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.get_worksheet_auto_filter(file_name, sheet_name)
puts response
assert(response, message="Failed to get Auto filter description")
end
def test_put_worksheet_date_filter
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
range="A1:B1"
field_index=0
date_time_grouping_type="Year"
response = @cells_api.put_worksheet_date_filter(file_name, sheet_name, range, field_index, date_time_grouping_type,
{year: 1920, match_blanks:false, refresh:true})
assert(response, message="Failed to add date filter in worksheet")
end
def test_delete_worksheet_date_filter
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
field_index=0
date_time_grouping_type="Year"
response = @cells_api.delete_worksheet_date_filter(file_name, sheet_name, field_index, date_time_grouping_type, {year: 1920})
assert(response, message="Failed to remove a date filter")
end
def test_put_worksheet_filter
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
range="A1:B1"
field_index=0
criteria="Year"
response = @cells_api.put_worksheet_filter(file_name, sheet_name, range, field_index, criteria)
assert(response, message="Failed to add a filter for a filter column")
end
def test_delete_worksheet_filter
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
field_index=0
response = @cells_api.delete_worksheet_filter(file_name, sheet_name, field_index, {criteria: "Year"})
assert(response, message="Failed to delete a filter for a filter column")
end
def test_put_worksheet_icon_filter
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
range="A1:B1"
field_index=0
icon_set_type="ArrowsGray3"
icon_id = 1
response = @cells_api.put_worksheet_icon_filter(file_name, sheet_name, range, field_index, icon_set_type, icon_id, {match_blanks: false})
assert(response, message="Failed to add an icon filter")
end
def test_put_worksheet_custom_filter
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
range="A1:B1"
field_index=0
operator_type1="LessOrEqual"
criteria1 = 1
response = @cells_api.put_worksheet_custom_filter(file_name, sheet_name, range, field_index, operator_type1, criteria1, {match_blanks: false})
assert(response, message="Failed to filters a list with a custom criteria")
end
def test_put_worksheet_dynamic_filter
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
range="A1:B1"
field_index=0
dynamic_filter_type="BelowAverage"
response = @cells_api.put_worksheet_dynamic_filter(file_name, sheet_name, range, field_index, dynamic_filter_type, {match_blanks: true})
assert(response, message="Failed to add dynamic filter")
end
def test_put_worksheet_filter_top10
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
range="A1:B1"
field_index=0
is_top=true
item_count = 1
response = @cells_api.put_worksheet_filter_top10(file_name, sheet_name, range, field_index, is_top, item_count, opts = {match_blanks: true, is_percent: true})
assert(response, message="Failed to filter the top 10 item in the list")
end
def test_put_worksheet_color_filter
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
range="A1:B1"
field_index=0
color_filter_request = ColorFilterRequest.new
color_filter_request.pattern = "Solid"
foreground_color = CellsColor.new
color = Color.new
color.a = "255"
color.r = "0"
color.g = "255"
color.b = "255"
foreground_color.color = color
foreground_theme_color = ThemeColor.new
foreground_theme_color.color_type = "Text2"
foreground_theme_color.tint = 1
foreground_color.theme_color = foreground_theme_color
foreground_color.type = "Automatic"
color_filter_request.foreground_color = foreground_color
background_color = CellsColor.new
color = Color.new
color.a = "255"
color.r = "255"
color.g = "0"
color.b = "0"
background_color.color = color
background_theme_color = ThemeColor.new
background_theme_color.color_type = "Text2"
background_theme_color.tint = 1
background_color.theme_color = background_theme_color
background_color.type = "Automatic"
color_filter_request.background_color = background_color
response = @cells_api.put_worksheet_color_filter(file_name, sheet_name, range, field_index, color_filter_request, {match_blanks: true})
assert(response, message="Failed to add color filter")
end
def test_post_worksheet_match_blanks
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
field_index=0
response = @cells_api.post_worksheet_match_blanks(file_name, sheet_name, field_index)
assert(response, message="Failed to match all blank cell in the list")
end
def test_post_worksheet_match_non_blanks
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
field_index=0
response = @cells_api.post_worksheet_match_non_blanks(file_name, sheet_name, field_index)
assert(response, message="Failed to match all not blank cell in the list")
end
def test_post_worksheet_auto_filter_refresh
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "Sheet1"
response = @cells_api.post_worksheet_auto_filter_refresh(file_name, sheet_name)
assert(response, message="Failed to refresh auto filter")
end
def test_post_workbook_calculate_formula
file_name = "Book1.xlsx"
upload_file(file_name)
ignore_error = true
calculation_options = CalculationOptions.new
calculation_options.calc_stack_size = 1
response = @cells_api.post_workbook_calculate_formula(file_name, calculation_options, ignore_error)
assert(response, message="Failed to calculate all formulas in workbook")
end
def test_post_cell_text_formatting
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "sheet1"
cell_name = "A1"
# Set cell value
response = @cells_api.post_worksheet_cell_set_value(file_name, sheet_name, cell_name, {value: "121211212112", type: "string"})
fontSetting1 = FontSetting.new
fontSetting1.length = 5
fontSetting1.start_index = 0
font1 = Font.new
font1.is_bold = true
font1.size = 24
fontSetting1.font = font1
fontSetting2 = FontSetting.new
fontSetting2.length = 4
fontSetting2.start_index = 5
font2 = Font.new
font2.is_italic = true
font2.size = 15
fontSetting2.font = font2
options = [fontSetting1, fontSetting2]
# Rich text formatting in a single cell
response = @cells_api.post_cell_text_formatting(file_name, sheet_name, cell_name, options, opts = {})
assert(response, message="Failed to set rich text formatting in a single cell")
end
def test_post_sort_table_data
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "sheet7"
list_object_index = 1
data_sorter = DataSorter.new
data_sorter.case_sensitive = true
sort_key = SortKey.new
sort_key.key = 1
sort_key.sort_order = "Ascending"
data_sorter.key_list = [sort_key]
response = @cells_api.post_sort_table_data(file_name, sheet_name, list_object_index, data_sorter, opts = {})
assert(response, message="Failed to sort table's data")
end
def test_post_calulate_cell_formula
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "sheet1"
cell_name = "A1"
# Set cell value
response = @cells_api.post_worksheet_cell_set_value(file_name, sheet_name, cell_name, {formula: "NOW()"})
options = CalculationOptions.new
options.calc_stack_size = 1
response = @cells_api.post_calulate_cell_formula(file_name, sheet_name, cell_name, options, opts = {})
assert(response, message="Failed to calculate cell's formula")
end
def test_cells_charts_post_worksheet_chart
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "sheet4"
chart_index = 1
chart = Chart.new
chart.type = "line"
response = @cells_api.cells_charts_post_worksheet_chart(file_name, sheet_name, chart_index, chart, opts = {})
assert(response, message="Failed to update chart propreties")
end
def test_get_worksheet_conditional_formattings
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "sheet1"
response = @cells_api.get_worksheet_conditional_formattings(file_name, sheet_name)
assert(response, message="Failed to get conditional formattings")
end
def test_get_worksheet_conditional_formatting
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "sheet1"
index = 0
response = @cells_api.get_worksheet_conditional_formatting(file_name, sheet_name, index)
assert(response, message="Failed to get conditional formatting")
end
def test_put_worksheet_format_condition
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "sheet1"
index = 0
cell_area = "A1:C3"
type = "Expression"
operator_type = "Between"
formula1 = "v1"
formula2 = "v2"
response = @cells_api.put_worksheet_format_condition(file_name, sheet_name, index, cell_area, type, operator_type, formula1, formula2)
assert(response, message="Failed to add a format condition")
end
def test_put_worksheet_format_condition_area
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "sheet1"
index = 0
cell_area = "A1:C3"
response = @cells_api.put_worksheet_format_condition_area(file_name, sheet_name, index, cell_area)
assert(response, message="Failed to add a cell area for format condition")
end
def test_put_worksheet_format_condition_condition
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "sheet1"
index = 0
type = "CellValue"
operator_type = "Equal"
formula1 = "v1"
formula2 = "v2"
response = @cells_api.put_worksheet_format_condition_condition(file_name, sheet_name, index, type, operator_type, formula1, formula2)
assert(response, message="Failed to add a condition for format condition")
end
def test_put_worksheet_conditional_formatting
file_name = "Book1.xlsx"
#upload_file(file_name)
sheet_name = "Sheet4"
cell_area = "C7:D11"
keys = ["CellValue", "Expression", "BeginsWith", "ContainsBlanks", "ContainsErrors",
"ContainsText", "DuplicateValues", "EndsWith", "NotContainsBlanks",
"NotContainsText", "UniqueValues" , "AboveAverage","TimePeriod","Top10",
"ColorScale","DataBar","IconSet"]
# CellValue
cell_value_format_condition = FormatCondition.new
cell_value_format_condition.type = "CellValue"
cell_value_format_condition.operator = "Between"
cell_value_format_condition.formula1 = "v1"
cell_value_format_condition.formula2 = "v2"
style = Style.new
style.font = Font.new
style.font.is_bold = true
cell_value_format_condition.style = style
# Expression
expression_format_condition = FormatCondition.new
expression_format_condition.type = "Expression"
expression_format_condition.operator = "Between"
expression_format_condition.formula1 = "v1"
expression_format_condition.formula2 = "v2"
style = Style.new
style.font = Font.new
style.font.is_bold = true
expression_format_condition.style = style
# BeginsWith
beginsWith_format_condition = FormatCondition.new
beginsWith_format_condition.type = "BeginsWith"
beginsWith_format_condition.text = "Between"
beginsWith_format_condition.operator = "LessThan"
beginsWith_format_condition.formula1 = "v1"
beginsWith_format_condition.formula2 = "v2"
style = Style.new
style.font = Font.new
style.font.is_bold = true
beginsWith_format_condition.style = style
# ContainsBlanks
contains_blanks_format_condition = FormatCondition.new
contains_blanks_format_condition.type = "ContainsBlanks"
contains_blanks_format_condition.text = "ContainsBlanks"
contains_blanks_format_condition.operator = "LessThan"
contains_blanks_format_condition.formula1 = "v1"
contains_blanks_format_condition.formula2 = "v2"
style = Style.new
style.font = Font.new
style.font.is_bold = true
contains_blanks_format_condition.style = style
# ContainsErrors
contains_errors_format_condition = FormatCondition.new
contains_errors_format_condition.type = "ContainsErrors"
contains_errors_format_condition.text = "Between"
contains_errors_format_condition.operator = "LessThan"
contains_errors_format_condition.formula1 = "v1"
contains_errors_format_condition.formula2 = "v2"
style = Style.new
style.font = Font.new
style.font.is_bold = true
contains_errors_format_condition.style = style
# ContainsText
contains_text_format_condition = FormatCondition.new
contains_text_format_condition.type = "ContainsText"
contains_text_format_condition.text = "Between"
contains_text_format_condition.operator = "LessThan"
contains_text_format_condition.formula1 = "v1"
contains_text_format_condition.formula2 = "v2"
style = Style.new
style.font = Font.new
style.font.is_bold = true
contains_text_format_condition.style = style
# DuplicateValues
duplicate_values_format_condition = FormatCondition.new
duplicate_values_format_condition.type = "DuplicateValues"
duplicate_values_format_condition.text = "Between"
duplicate_values_format_condition.operator = "LessThan"
duplicate_values_format_condition.formula1 = "v1"
duplicate_values_format_condition.formula2 = "v2"
style = Style.new
style.font = Font.new
style.font.is_bold = true
duplicate_values_format_condition.style = style
# EndsWith
ends_with_format_condition = FormatCondition.new
ends_with_format_condition.type = "EndsWith"
ends_with_format_condition.text = "EndsWith"
ends_with_format_condition.operator = "LessThan"
ends_with_format_condition.formula1 = "v1"
ends_with_format_condition.formula2 = "v2"
style = Style.new
style.font = Font.new
style.font.is_bold = true
ends_with_format_condition.style = style
# NotContainsBlanks
not_contains_blanks_format_condition = FormatCondition.new
not_contains_blanks_format_condition.type = "NotContainsBlanks"
not_contains_blanks_format_condition.text = "NotContainsBlanks"
not_contains_blanks_format_condition.operator = "LessThan"
not_contains_blanks_format_condition.formula1 = "v1"
not_contains_blanks_format_condition.formula2 = "v2"
style = Style.new
style.font = Font.new
style.font.is_bold = true
not_contains_blanks_format_condition.style = style
# NotContainsText
not_contains_text_format_condition = FormatCondition.new
not_contains_text_format_condition.type = "NotContainsText"
not_contains_text_format_condition.text = "NotContainsText"
not_contains_text_format_condition.operator = "LessThan"
not_contains_text_format_condition.formula1 = "v1"
not_contains_text_format_condition.formula2 = "v2"
style = Style.new
style.font = Font.new
style.font.is_bold = true
not_contains_text_format_condition.style = style
# UniqueValues
unique_values_format_condition = FormatCondition.new
unique_values_format_condition.type = "UniqueValues"
unique_values_format_condition.text = "UniqueValues"
unique_values_format_condition.operator = "LessThan"
unique_values_format_condition.formula1 = "v1"
unique_values_format_condition.formula2 = "v2"
style = Style.new
style.font = Font.new
style.font.is_bold = true
unique_values_format_condition.style = style
# AboveAverage
above_average_format_condition = FormatCondition.new
above_average_format_condition.type = "AboveAverage"
above_average = AboveAverage.new
above_average.is_above_average = true
above_average.is_equal_average = true
above_average.std_dev = 1
above_average_format_condition.above_average = above_average
style = Style.new
style.font = Font.new
style.font.is_bold = true
above_average_format_condition.style = style
# TimePeriod
time_period_format_condition = FormatCondition.new
time_period_format_condition.type = "TimePeriod"
time_period_format_condition.time_period = "Last7Days"
style = Style.new
style.font = Font.new
style.font.is_bold = true
time_period_format_condition.style = style
# Top10
top_10_format_condition = FormatCondition.new
top_10_format_condition.type = "Top10"
top_10 = Top10.new
top_10.is_bottom = true
top_10.is_percent = true
top_10.rank = 1
top_10_format_condition.top10 = top_10
style = Style.new
style.font = Font.new
style.font.is_bold = true
top_10_format_condition.style = style
# ColorScale
color_scale_format_condition = FormatCondition.new
color_scale_format_condition.type = "ColorScale"
color_scale = ColorScale.new
max_cfvo = ConditionalFormattingValue.new
max_cfvo.is_gte = true
max_cfvo.type = "AutomaticMax"
max_cfvo.value = "AutomaticMax"
color_scale.max_cfvo = max_cfvo
max_color = Color.new
max_color.a = 255
max_color.r = 255
max_color.g = 0
max_color.b = 255
color_scale.max_color = max_color
mid_cfvo = ConditionalFormattingValue.new
mid_cfvo.is_gte = true
mid_cfvo.type = "Number"
mid_cfvo.value = "Number"
color_scale.mid_cfvo = mid_cfvo
mid_color = Color.new
mid_color.a = 0
mid_color.r = 255
mid_color.g = 0
mid_color.b = 0
color_scale.mid_color = mid_color
min_color = Color.new
min_color.a = 0
min_color.r = 255
min_color.g = 0
min_color.b = 0
color_scale.min_color = min_color
color_scale_format_condition.color_scale = color_scale
style = Style.new
style.font = Font.new
style.font.is_bold = true
color_scale_format_condition.style = style
# DataBar
databar_format_condition = FormatCondition.new
databar_format_condition.type = "DataBar"
data_bar = DataBar.new
axis_color = Color.new
axis_color.a = 0
axis_color.r = 0
axis_color.g = 0
axis_color.b = 255
data_bar.axis_color = axis_color
data_bar.axis_position = "DataBarAxisAutomatic"
bar_border = BarBorder.new
color = Color.new
color.a = 0
color.r = 255
color.g = 0
color.b = 0
bar_border.color = color
bar_border.type = "None"
data_bar.bar_border = bar_border
data_bar.bar_fill_type = "Solid"
color = Color.new
color.a = 0
color.r = 0
color.g = 255
color.b = 0
data_bar.color = color
data_bar.direction = "LeftToRight"
max_cfvo = ConditionalFormattingValue.new
max_cfvo.is_gte = true
max_cfvo.type = "Number"
max_cfvo.value = "Number"
data_bar.max_cfvo = max_cfvo
data_bar.max_length = 1
min_cfvo = ConditionalFormattingValue.new
min_cfvo.is_gte = true
min_cfvo.type = "Number"
min_cfvo.value = "Number"
data_bar.min_cfvo = min_cfvo
data_bar.min_length = 1
negative_bar_format = NegativeBarFormat.new
border_color = Color.new
border_color.a = 0
border_color.r = 0
border_color.g = 255
border_color.b = 0
negative_bar_format.border_color = border_color
negative_bar_format.border_color_type = "Color"
color = Color.new
color.a = 0
color.r = 0
color.g = 255
color.b = 0
negative_bar_format.color = color
negative_bar_format.color_type = "Color"
data_bar.negative_bar_format = negative_bar_format
data_bar.show_value = true
databar_format_condition.data_bar = data_bar
style = Style.new
style.font = Font.new
style.font.is_bold = true
databar_format_condition.style = style
# IconSet
iconset_format_condition = FormatCondition.new
iconset_format_condition.type = "IconSet"
icon_set = IconSet.new
conditional_formatting_icon = ConditionalFormattingIcon.new
conditional_formatting_icon.index = 0
conditional_formatting_icon.type = "Arrows3"
icon_set.cf_icons = [conditional_formatting_icon]
conditional_formatting_val = ConditionalFormattingValue.new
conditional_formatting_val.is_gte = true
conditional_formatting_val.type = "AutomaticMax"
conditional_formatting_val.value = "AutomaticMax"
icon_set.cfvos = [conditional_formatting_val]
icon_set.is_custom = true
icon_set.reverse = true
icon_set.show_value = true
icon_set.icon_set_type = "Rating4"
iconset_format_condition.icon_set = icon_set
style = Style.new
style.font = Font.new
style.font.is_bold = true
iconset_format_condition.style = style
response = @cells_api.put_worksheet_conditional_formatting(file_name, sheet_name, cell_area, opts = {formatcondition: format_condition})
assert(response, message="Failed to add a condition formatting")
end
def test_delete_worksheet_conditional_formatting_area
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "sheet1"
start_row = 3
start_column = 3
total_rows = 1
total_columns = 1
response = @cells_api.delete_worksheet_conditional_formatting_area(file_name, sheet_name, start_row, start_column, total_rows, total_columns, opts = {})
assert(response, message="Failed to remove cell area from conditional formatting.")
end
def test_delete_worksheet_conditional_formatting
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "sheet1"
index = 0
response = @cells_api.delete_worksheet_conditional_formatting(file_name, sheet_name, index, opts = {})
assert(response, message="Failed to remove conditional formatting.")
end
def test_delete_worksheet_conditional_formattings
file_name = "Book1.xlsx"
upload_file(file_name)
sheet_name = "sheet1"
response = @cells_api.delete_worksheet_conditional_formattings(file_name, sheet_name, opts = {})
assert(response, message="Failed to remove conditional formatting.")
end
end