view release on metacpan or  search on metacpan

lib/Google/RestApi/SheetsApi4.pm  view on Meta::CPAN

Merge cells with specified type ('all', 'row', 'col').

=item unmerge() / unmerge_cells()

Unmerge cells.

=back

=head3 Insert/Delete Operations

=over

=item insert_dimension(dimension => $dim, inherit => $bool)

Insert rows or columns. C<dimension> is 'row' or 'col'.

=item insert_d($dimension, $inherit)

Shorthand for insert_dimension.

=item insert_range(dimension => $dim)

Insert range, shifting existing cells.

=item insert_r($dimension)

Shorthand for insert_range.

=item delete_dimension(dimension => $dim)

Delete rows or columns.

=item delete_d($dimension)

Shorthand for delete_dimension.

=item delete_range(dimension => $dim)

Delete range, shifting remaining cells.

=item delete_r($dimension)

Shorthand for delete_range.

=item move_dimension(dimension => $dim, destination => $range)

Move rows or columns to a new position.

=item move($dimension, $destination)

Shorthand for move_dimension.

=back

=head3 Copy/Paste

=over

=item copy_paste(destination => $range, type => $type, orientation => $orient)

Copy and paste. C<type>: 'normal', 'values', 'format', 'no_borders', 'formula', 'data_validation', 'conditional_formatting'. C<orientation>: 'normal', 'transpose'.

=item cut_paste(destination => $range, type => $type)

Cut and paste.

=back

=head3 Named Ranges

=over

=item add_named(name => $name) / named_a($name)

Create a named range.

=item delete_named() / named_d()

Delete the named range.

=item update_named(%args) / named_u(%args)

Update a named range. Args: C<name>, C<range>, C<fields>.

=back

=head3 Data Operations

=over

=item auto_fill(source => $range, use_template => $bool)

Auto-fill based on a source range pattern.

=item append_cells(rows => \@rows, fields => $fields)

Append rows of cell data.

=item paste_data(data => $data, delimiter => $delim, type => $type, html => $bool)

Paste delimited or HTML data.

=item text_to_columns(delimiter => $delim, delimiter_type => $type)

Split text in column to multiple columns.

=item find_replace(%args)

Find and replace. Args: C<find> (required), C<replacement>, C<match_case>, C<match_entire_cell>, C<search_by_regex>, C<include_formulas>.

=back

=head3 Data Validation

=over

=item set_data_validation(rule => \%rule)

Set data validation rule.

=item clear_data_validation()

Clear data validation.

=item data_validation_list(values => \@values, strict => $bool, show_custom => $bool, input_message => $msg)

Create a dropdown list validation.

=item data_validation_range(source => $range, strict => $bool, show_custom => $bool, input_message => $msg)

Create validation from a range of values.

=back

=head3 Sorting and Cleanup

=over

=item sort_range(sort_specs => \@specs)

Sort range by specified columns.

=item sort_asc($col) / sort_desc($col)

Sort ascending or descending by column index (default 0).

=item randomize_range()

Randomize the order of rows in the range.

=item trim_whitespace()

Trim leading/trailing whitespace from cells.

=item delete_duplicates(comparison_columns => \@cols)

Delete duplicate rows. Optional column indices for comparison.

=back

=head3 Clearing (Range)

=over

=item clear_values()

Clear values in the range.

=item clear_formatting()