Tag feed

#excel

715 posts322 followers

Explore Hashnode

Alternatives

Trending tags this week

VYVamshi Yempallyvamshiindata.hashnode.dev2d ago · 6 min read

I Built a No-Code Email Automation Tool in Pure HTML — Here's How It Works

Send personalized bulk emails through Outlook without touching SMTP, credentials, or any third-party API. One HTML file. One Python script. Done. The Problem Every few weeks, my team needs to send p

0

UPUfumbuzi Progressive Web Appsufumbuzi.hashnode.devJun 20 · 1 min read

Generating SLK Files from Oracle to Open in Excel

A Robust Solution for Exporting Data to Excel In enterprise application development, the need to export data from Oracle databases to versatile formats such as Microsoft Excel is a common task. While

0

ASAnkur Sonijsontoexcel.hashnode.devJun 15 · 3 min read

Your JSON-to-Excel Converter Is Probably Corrupting Your Data. Here's the 30-Second Test

Last week a JSON-to-Excel tool quietly changed my data and I almost shipped it to a client. I pasted an API response into the top "JSON to Excel" tool on Google, downloaded the file, and opened it — a

0

Ccircobitgauchogrid.hashnode.devJun 12 · 5 min read

Designing Export Profiles for Different Data Workflows

A CSV is a CSV, right? Not when your user is a data analyst in Germany opening the file in Excel. Or a Python developer loading it into Pandas. Or a data engineer piping it into BigQuery. Each workflo

0

DADatadesk AUdatadeskau.hashnode.devJun 1 · 4 min read

How to Build a Clean Excel Dashboard (Step by Step)

Almost every business has the same spreadsheet somewhere: a dashboard that started clean and slowly turned into a tangle of colours, hidden tabs and formulas nobody dares touch. A good Excel dashboard

0

AVAloysius Vidhun Monaloysius05.hashnode.devMay 25 · 7 min read

How to Batch Convert Office Files to Google Docs & Sheets (Without Getting Timed Out)

If you've ever migrated an organization from Microsoft Office to Google Workspace, you know the headache of dealing with hundreds of legacy .docx, .doc, .xlsx, and .xls files. Sure, Google Drive lets

0

SSSoumyadeep Sarkarsoumyadeepbuilds.hashnode.devApr 29 · 13 min read

Automating a Twice-Daily Reporting Workflow with PowerShell, Excel VBA, Outlook, and Microsoft Teams

Daily reporting sounds simple until the same set of steps has to be repeated again and again with almost no room for mistakes. In one of my recent automation projects, the reporting process had to be

0

Ttwelvecharactersboredom-at-work.hashnode.devMar 17 · 3 min read

I Stopped Googling Excel Formulas & Here's What I Use Instead

Every office worker knows the pain: you need a formula, you Google it, you get 15 different Stack Overflow answers, and half of them don't work with your Excel version. I switched to asking ChatGPT ab

0

JBJames Browncodingwithfiles.hashnode.devMar 13 · 6 min read

Mastering Excel Gridlines with Python: Hide, Show, and Customize Colors

In data processing and report generation, Excel is one of the most ubiquitous tools. While gridlines serve as helpful background guides for aligning data during editing, they often appear redundant or

0

SJsiba janabestfreetools.hashnode.devMar 11 · 3 min read

How to Combine 20 CSV Files Without Writing a Single Line of Code

As developers and data workers, we've all been there: you export a large dataset from an analytics platform or database, and instead of one neat file, you get an archive containing 20 separate .csv fi

0

#excel

Search Hashnode

#excel

Explore Hashnode

Trending tags this week

I Built a No-Code Email Automation Tool in Pure HTML — Here's How It Works

Generating SLK Files from Oracle to Open in Excel

Your JSON-to-Excel Converter Is Probably Corrupting Your Data. Here's the 30-Second Test

Designing Export Profiles for Different Data Workflows

How to Build a Clean Excel Dashboard (Step by Step)

How to Batch Convert Office Files to Google Docs & Sheets (Without Getting Timed Out)

Automating a Twice-Daily Reporting Workflow with PowerShell, Excel VBA, Outlook, and Microsoft Teams

I Stopped Googling Excel Formulas & Here's What I Use Instead

Mastering Excel Gridlines with Python: Hide, Show, and Customize Colors

How to Combine 20 CSV Files Without Writing a Single Line of Code