Enterprise Shortcode Category: Excelsheet
excel.info
Read and return the excel info
Parameters supported : file_path, file_format(default: Excel2007)
It returns: total_rows
excel.dataset_write
Write the excel file
Parameters supported : file_name, folder, file_format(default: Excel2007), dataset, template_file, template_folder
excel.write_bulk_csv
Bulk write the excel file as csv
Parameters supported : file_name, folder, data
excel.read_header
Read the header info of the excel file
Parameters supported : file_name, folder
It returns: array
excel.read_post_data
Read the post data
Parameters supported : file_name, folder, posts_per_page, offset(default: 0)
It returns: array