Agent and MS Excel files - Read and Write

[yozart]

I’m still experiencing issues with my agents when loading Excel data.

When I load the JSON file using the JSONSearchTool, it works correctly the first time. However, if I modify the data in the file afterward, the agent continues to provide the same response, even though the data has changed.

I discovered that the embeddings aren’t being reset each time. I tried using the command crewai reset-memories -kn, but I’m encountering the same problem described here, despite being on version 0.150.

Crewai reset-memories -kn failes but -l works

When running crewai reset-memories -kn i get the following error crewai reset-memories -kn An unexpected error occurred: No module named 'chromadb.utils.embedding_functions.openai_embedding_function'; 'chromadb.utils.embedding_functions' is not a package Anyone know how to fix this… as crewai reset-memories -l works.

Additionally, I’m concerned this might not solve my issue because, from what I understand, knowledge bases are shared across all users.

What’s the best way to load Excel content into the agent’s memory so it can query and retrieve the necessary data to perform its tasks? I feel like I might be missing a step.

Here’s what I’m trying to achieve:

1. Extract data from an Excel file, such as container number, expected arrival date, and planned date.

2. Iterate over each container to set a planned date.

Right now, I’m struggling to even get consistent data retrieval working.

Any advice would be appreciated!