Hi All,
I am creating a .csv file which is mailed to business.The Excel file is then opened by the business and formatted (increase the width of certain columns, change to landscape orientation, etc.) and then printed
They are wondering if you can have an Excel file pre-formatted to certain column widths and orientation before being emailed so that they can just open and print.
What is the best solution for this request.
Below is the sample code that I used from PL SQL to generate the .Csv
output_file := utl_file.fopen (path,filename, 'W');
utl_file.put_line (output_file, firstline);
utl_file.put_line (output_file, secondline);
utl_file.fclose(output_file);
I know i can achieve the requirement using BI publisher, but wondering if I can minimize the effort using the existing program which is PL SQL.
Thanks &Regards,
Debanjan