[Excel Package] How to write an Excel file from the Excel Package?

Forge Component
(5)
Published on 2018-08-02 by Carlos Alfaro
5 votes
Published on 2018-08-02 by Carlos Alfaro

Can someone post a full example on how to create an excel spreadsheet from the Excel Package and write to disk.

Victor to create spreadsheets you dont need that package..

Use the record to list to excel (define what list and what attributes you want in the excel file) and then download (define the name of your file "lalalala.xlsx",  and set save to disk to yes) in an action. You can set the action to be triggered by a button


Hope that helps or was there something more advanced that you were looking for? 

Victor Torres wrote:

Can someone post a full example on how to create an excel spreadsheet from the Excel Package and write to disk.


Hi Victor,

Please find the attached sample file for how to create an excel sheet using EXCEL PACKAGE.

Hope this helps.

Best Regards,

Amit Verma

Amit Verma wrote:

Victor Torres wrote:

Can someone post a full example on how to create an excel spreadsheet from the Excel Package and write to disk.


Hi Victor,

Please find the attached sample file for how to create an excel sheet using EXCEL PACKAGE.

Hope this helps.

Best Regards,

Amit Verma

Thank you Amit, will look at it at work.



André P wrote:

Victor to create spreadsheets you dont need that package..

Use the record to list to excel (define what list and what attributes you want in the excel file) and then download (define the name of your file "lalalala.xlsx",  and set save to disk to yes) in an action. You can set the action to be triggered by a button


Hope that helps or was there something more advanced that you were looking for? 

Thanks Andre for the quick response.  The problem is I have to create multiple worksheets in a workbook and this only lets me create one.  Thanks again.


Victor Torres wrote:

Amit Verma wrote:

Victor Torres wrote:

Can someone post a full example on how to create an excel spreadsheet from the Excel Package and write to disk.


Hi Victor,

Please find the attached sample file for how to create an excel sheet using EXCEL PACKAGE.

Hope this helps.

Best Regards,

Amit Verma

Thank you Amit, will look at it at work.



Welcome Victor :)

If you need help, please let me know.

Best Regards,

Amit Verma


Solution

Thanks Amit Veran.  I added to his sample how to create a new spreadsheet with multiple worksheets.  

Hope this help.


Victor

Solution

Victor Torres wrote:

Thanks Amit Veran.  I added to his sample how to create a new spreadsheet with multiple worksheets.  

Hope this help.


Victor

Welcome Victor :)

Enjoy Coding !!!!

Best Regards,

AV

Amit Verma wrote:

Victor Torres wrote:

Can someone post a full example on how to create an excel spreadsheet from the Excel Package and write to disk.


Hi Victor,

Please find the attached sample file for how to create an excel sheet using EXCEL PACKAGE.

Hope this helps.

Best Regards,

Amit Verma

Hi, 

Your question is simple and I will advise you to try ZetExcel.

Peter Ferguson


Hi Amit,

Do i need to have predefined excel sheet in resources with headers ? How can i export it to excel with headers coming from source list, where i dont want to give header in predefined excel.

Nitesh Ahirwar wrote:

Hi Amit,

Do i need to have predefined excel sheet in resources with headers ? How can i export it to excel with headers coming from source list, where i dont want to give header in predefined excel.

Hi Ahirwar,

Do you already did? I need Also the same thing.

Regards