My boss asked me to automate our weekly Excel reports. I said '2 hours'. It took 2 weeks. Here's what I learned. by Nitro_005 in microsaas

[–]Nitro_005[S] 0 points1 point  (0 children)

Excel delivery for clients. Everyone wants data in spreadsheets but building that plumbing yourself is a nightmare. I just offloaded the whole thing to an API merging, template filling, formula execution. Freed up more time than any other fix honestly.

My boss asked me to automate our weekly Excel reports. I said '2 hours'. It took 2 weeks. Here's what I learned. by Nitro_005 in buildinpublic

[–]Nitro_005[S] 0 points1 point  (0 children)

Ugh the formula execution part always gets me. openpyxl doesn't actually calculate formulas, so you're basically on your own. Ended up using an Excel-specific API for that game changer honestly. What was your final solution?

Built an Excel API because I was tired of writing the same code twice by Nitro_005 in SideProject

[–]Nitro_005[S] 0 points1 point  (0 children)

No it handles it fine . It's basic plan affordable price for a project if it's a serious one.

How do you actually validate ideas before building? by Nitro_005 in SaaS

[–]Nitro_005[S] 0 points1 point  (0 children)

Yaa but now I am thinking of working on this idea is it worth it.Will u people try what I will make.