DEV Community

Cover image for Day 3: Fixed the Data Insertion Bug – SpeakSheet Now Generates Working Excel Files
Varun Krishnan
Varun Krishnan

Posted on

Day 3: Fixed the Data Insertion Bug – SpeakSheet Now Generates Working Excel Files

TL;DR: The product now works. Excel files generate correctly with actual data.

The bug: I was sending an object instead of an array.
Time wasted: 2 hours.
Lesson learned: Always log your data structures.

Here's what happened.

🐛 The Problem
Yesterday, SpeakSheet was generating Excel files... but they were completely empty.

The prompt the user provided and the excel file that is generated. This is done just by typing.

The structure was there:

✅ Columns
✅ Headers
✅ Formatting
But no data was populating.

🧠 What I Learned

  1. Data structure bugs are silent killers
    No error messages. No stack traces. Just... nothing works.
    These are the hardest bugs to debug because there's no obvious failure point.

  2. Always log the EXACT data you're sending
    Don't just log console.log(data).

  3. Small bugs block everything
    This one bug prevented:

  4. Testing the full user flow

  5. Recording demo videos

  6. Getting user feedback

  7. Moving on to formulas/formatting

Fixing it unlocked everything.


What's your most frustrating "it was just a data structure" bug?
Drop a comment. I need to know I'm not alone in wasting 2 hours on square brackets 😅

Top comments (0)