[Question] Automating Report Generation with Camel Framework Using Natural Language Rules and Excel Templates

[DavidLyn]

Required prerequisites

• I have read the documentation https://camel-ai.github.io/camel/camel.html.
• I have searched the Issue Tracker and Discussions that this hasn't already been reported. (+1 or comment there if it has.)
• Consider asking first in a Discussion.

Questions

Hi, can the Camel framework achieve the following requirement: Given an Excel template and data retrieval rules based on natural language, can the framework use a large model to generate data retrieval SQL statements (possibly multiple SQLs) based on this information, execute the SQL, and then populate the generated data into the template to form the final report? If feasible, please provide a brief description of the implementation approach.

[Wendong-Fan]

hey @DavidLyn ,yeah it's doable, first we can extract the column name & description, then based on the NL query using ChatAgent generate SQL, then let agent call the code interpreter tool to execute the SQL query which could make effect to the Excel, also ask the ChatAgent to generate final report, we will also make a cookbook for this use case

cc @nitpicker55555

[nitpicker55555]

Hi~You can check this pr #2448