Enterprise Shortcode Category: Excelsheet
excel.write_bulk
Bulk write in the excel file. Use excel.write_bulk
Parameters supported : file_name, folder, file_format(default: Excel2007), data, template_file, template_folder
excel.file_reader
Read the excel file
Parameters supported : file_path, folder, file_format(default: Excel2007), start_from(default: 2), limit
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