Objective: Investigate and evaluate different tools and libraries for ingesting Excel files into our data platform, ensuring efficient and reliable data extraction and processing.
Questions to Explore:
- What are the available tools or libraries (e.g., OpenPyXL, Pandas, xlrd) that can handle Excel file ingestion efficiently?
- How do these tools compare in terms of handling complex Excel features like formulas, charts, and multiple sheets?
- Which tool best aligns with our requirements for scalability, performance, and compatibility with the rest of our data platform?
Objective: Investigate and evaluate different tools and libraries for ingesting Excel files into our data platform, ensuring efficient and reliable data extraction and processing.
Questions to Explore:
- What are the available tools or libraries (e.g., OpenPyXL, Pandas, xlrd) that can handle Excel file ingestion efficiently?
- How do these tools compare in terms of handling complex Excel features like formulas, charts, and multiple sheets?
- Which tool best aligns with our requirements for scalability, performance, and compatibility with the rest of our data platform?