#Perl odbc excel examples plus

Converting dates and times to an Excel date or time.Spreadsheet::WriteExcel doesn't automatically convert date/time strings.

#Perl odbc excel examples plus

An Excel date/time is a number plus a format.print_area($first_row, $first_col, $last_row, $last_col).autofilter($first_row, $first_col, $last_row, $last_col).merge_range($first_row, $first_col, $last_row, $last_col, $token, $format, $utf_16_be).split_panes($y, $x, $top_row, $left_col).freeze_panes($row, $col, $top_row, $left_col).outline_settings($visible, $symbols_below, $symbols_right, $auto_style).set_column($first_col, $last_col, $width, $format, $hidden, $level, $collapsed).set_row($row, $height, $format, $hidden, $level, $collapsed).set_selection($first_row, $first_col, $last_row, $last_col).embed_chart($row, $col, $filename, $x, $y, $scale_x, $scale_y).insert_chart($row, $col, $chart, $x, $y, $scale_x, $scale_y).insert_image($row, $col, $filename, $x, $y, $scale_x, $scale_y).repeat_formula($row, $col, $formula, $format, ($pattern => $replace.write_formula($row, $column, $formula, $format, $value).write_url($row, $col, $url, $label, $format).write_date_time($row, $col, $date_string, $format).write_col($row, $column, $array_ref, $format).write_row($row, $column, $array_ref, $format).write_utf16le_string($row, $column, $string, $format).write_utf16be_string($row, $column, $string, $format).write_string($row, $column, $string, $format).write_number($row, $column, $number, $format).set_custom_color($index, $red, $green, $blue).