Convert CSV to XLS with Logic App.

Celso Javier Guzmán Díaz 1 Reputation point
2020-10-30T20:16:07.633+00:00

Good afternoon community;

I am generating a report with Azure Monitor Logs, I am recovering it in CSV format and saving it to my OneDrive and sending it to my email, the idea is that it is now saved in XLSX (Excel) with the respective column formats. Can it be done? it?.

Thank you so much.

36423-screenshot-102.png

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,542 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. JayaC-MSFT 5,606 Reputation points
    2020-11-02T09:05:50.677+00:00

    @Celso Javier Guzmán Díaz Could you please check convert-csv-to-excel-in-azure-blob-storage and let me know if this helps achieving what you are trying to do?

    0 comments No comments

  2. Priyanka Duggal 1 Reputation point
    2022-07-17T08:47:18.72+00:00

    I am trying to convert csv to excel (size 350 MB) with Plum sail converter in Logic apps but getting below error:-
    Unable to process template language expressions in action 'Csv_to_Excel' inputs at line '0' and column '0': 'The template language function 'body' cannot be used when the referenced action outputs body has large aggregated partial content. Actions with large aggregated partial content can only be referenced by actions that support chunked transfer mode.'.

    Is there any limit to size of csv file that can be converted

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.