def Run(self):
# Create instance of the API
api = Common_Utilities.Get_ViewApi_Instance()
try:
viewOptions = groupdocs_viewer_cloud.ViewOptions()
fileInfo = groupdocs_viewer_cloud.FileInfo()
fileInfo.file_path = "viewerdocs\\with-hidden-rows-and-columns.xlsx"
fileInfo.password = ""
fileInfo.storage_name = Common_Utilities.myStorage
viewOptions.file_info = fileInfo
renderOptions = groupdocs_viewer_cloud.RenderOptions()
spreadsheetOptions = groupdocs_viewer_cloud.SpreadsheetOptions()
spreadsheetOptions.paginate_sheets = True
spreadsheetOptions.count_rows_per_page = 5
renderOptions.spreadsheet_options = spreadsheetOptions
viewOptions.render_options = renderOptions
renderOptions.spreadsheet_options = spreadsheetOptions
viewOptions.render_options = renderOptions
request = groupdocs_viewer_cloud.CreateViewRequest(viewOptions)
response = api.create_view(request)
print("Expected response type is ViewResult: " + str(response))
except groupdocs_viewer_cloud.ApiException as e:
print("Exception while calling API: {0}".format(e.message))
def Run(cls):
apiInstance = groupdocs_viewer_cloud.ViewApi.from_config(
Common.GetConfig())
view_options = groupdocs_viewer_cloud.ViewOptions()
view_options.file_info = groupdocs_viewer_cloud.FileInfo()
view_options.file_info.file_path = "SampleFiles/with_empty_row.xlsx"
view_options.view_format = "HTML"
view_options.render_options = groupdocs_viewer_cloud.HtmlOptions()
view_options.render_options.spreadsheet_options = groupdocs_viewer_cloud.SpreadsheetOptions(
)
view_options.render_options.spreadsheet_options.render_empty_rows = False
request = groupdocs_viewer_cloud.CreateViewRequest(view_options)
response = apiInstance.create_view(request)
print("SkipRenderingOfEmptyRows completed: " +
str(len(response.pages)))
def Run(cls):
apiInstance = groupdocs_viewer_cloud.ViewApi.from_config(
Common.GetConfig())
view_options = groupdocs_viewer_cloud.ViewOptions()
view_options.file_info = groupdocs_viewer_cloud.FileInfo()
view_options.file_info.file_path = "SampleFiles/sample.xlsx"
view_options.view_format = "HTML"
view_options.render_options = groupdocs_viewer_cloud.HtmlOptions()
view_options.render_options.spreadsheet_options = groupdocs_viewer_cloud.SpreadsheetOptions(
)
view_options.render_options.spreadsheet_options.render_grid_lines = True
request = groupdocs_viewer_cloud.CreateViewRequest(view_options)
response = apiInstance.create_view(request)
print("RenderSpreadsheetWithGridLines completed: " +
str(len(response.pages)))
def Run(cls):
apiInstance = groupdocs_viewer_cloud.ViewApi.from_config(
Common.GetConfig())
view_options = groupdocs_viewer_cloud.ViewOptions()
view_options.file_info = groupdocs_viewer_cloud.FileInfo()
view_options.file_info.file_path = "SampleFiles/with_hidden_row_and_column.xlsx"
view_options.view_format = "HTML"
view_options.render_options = groupdocs_viewer_cloud.HtmlOptions()
view_options.render_options.spreadsheet_options = groupdocs_viewer_cloud.SpreadsheetOptions(
)
view_options.render_options.spreadsheet_options.render_hidden_columns = True
view_options.render_options.spreadsheet_options.render_hidden_rows = True
request = groupdocs_viewer_cloud.CreateViewRequest(view_options)
response = apiInstance.create_view(request)
print("RenderHiddenColumnsAndRows completed: " +
str(len(response.pages)))
def Run(cls):
apiInstance = groupdocs_viewer_cloud.ViewApi.from_config(
Common.GetConfig())
view_options = groupdocs_viewer_cloud.ViewOptions()
view_options.file_info = groupdocs_viewer_cloud.FileInfo()
view_options.file_info.file_path = "SampleFiles/sample.xlsx"
view_options.view_format = "HTML"
view_options.render_options = groupdocs_viewer_cloud.HtmlOptions()
view_options.render_options.spreadsheet_options = groupdocs_viewer_cloud.SpreadsheetOptions(
)
view_options.render_options.spreadsheet_options.paginate_sheets = True
view_options.render_options.spreadsheet_options.count_rows_per_page = 45
request = groupdocs_viewer_cloud.CreateViewRequest(view_options)
response = apiInstance.create_view(request)
print("SplitWorksheetsIntoPages completed: " +
str(len(response.pages)))