---
title: "#excel articles | Hashnode"
description: "Explore 800 articles tagged #excel on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/excel"
---

Tag

# #excel

800 posts · 323 followers

[Pilalo](https://hashnode.com/@Yahey) · [58m ago](https://hashnode.com/posts/when-your-spreadsheet-needs-to-live-on-the-web-notes-on-excel-to-svg-conversion-in-java/6afe51db1d6c6fad2fac5b40)

### [When Your Spreadsheet Needs to Live on the Web: Notes on Excel-to-SVG Conversion in Java](https://file-and-code.hashnode.dev/when-your-spreadsheet-needs-to-live-on-the-web-notes-on-excel-to-svg-conversion-in-java?utm_source=hashnode&utm_medium=feed)

Learn how to convert Excel to SVG in Java, covering single and batch conversion, output dimensions, vector fidelity, and when SVG is the right choice.

5 min read · [file-and-code.hashnode.dev](https://file-and-code.hashnode.dev/when-your-spreadsheet-needs-to-live-on-the-web-notes-on-excel-to-svg-conversion-in-java?utm_source=hashnode&utm_medium=feed)

[Adan Potyondy](https://hashnode.com/@apotyondy) · [6h ago](https://hashnode.com/posts/data-cleaning-edge-cases-that-break-integrations-excel-serial-dates-erp-negatives-and-match-keys/6afdfd1513ce7768832080c1)

### [Data-cleaning edge cases that break integrations: Excel serial dates, ERP negatives and match keys](https://apotyondy.hashnode.dev/data-cleaning-edge-cases-that-break-integrations-excel-serial-dates-erp-negatives-and-match-keys?utm_source=hashnode&utm_medium=feed)

Excel serial dates, ERP negatives like 1,234- and company match keys: the edge cases that load as wrong values, and open-source fixes.

5 min read · [apotyondy.hashnode.dev](https://apotyondy.hashnode.dev/data-cleaning-edge-cases-that-break-integrations-excel-serial-dates-erp-negatives-and-match-keys?utm_source=hashnode&utm_medium=feed)

[Rick Zhang](https://hashnode.com/@rickzhang) · [18h ago](https://hashnode.com/posts/material-shortage-calculation-in-excel-4-silent-math-traps-that-stall-small-batch-hardware-builds/6afd5f0569b7df84848e3031)

### [Material Shortage Calculation in Excel: 4 Silent Math Traps That Stall Small-Batch Hardware Builds](https://specrivet.hashnode.dev/material-shortage-calculation-in-excel-4-silent-math-traps-that-stall-small-batch-hardware-builds?utm_source=hashnode&utm_medium=feed)

Why basic Gross-minus-Stock formulas miss real component shortages on multi-level BOMs—and a reproducible Excel workflow for hardware buyers and material planners.

9 min read · [specrivet.hashnode.dev](https://specrivet.hashnode.dev/material-shortage-calculation-in-excel-4-silent-math-traps-that-stall-small-batch-hardware-builds?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/material-shortage-calculation-in-excel-4-silent-math-traps-that-stall-small-batch-hardware-builds/6afd5f0569b7df84848e3031)

[Label Peel](https://hashnode.com/@labelpeel) · [14h ago](https://hashnode.com/posts/turn-a-google-sheets-or-excel-list-into-printable-avery-labels-without-word-mail-merge/6afd90104f426f9b8eb83470)

### [Turn a Google Sheets or Excel list into printable Avery labels without Word mail merge](https://labelpeel.hashnode.dev/turn-a-google-sheets-or-excel-list-into-printable-avery-labels-without-word-mail-merge?utm_source=hashnode&utm_medium=feed)

Neither Google Sheets nor Excel has a simple "print this list as labels" button. Google Sheets can't print labels at all. If you choose File → Print, it prints the grid of cells, and there is no built

5 min read · [labelpeel.hashnode.dev](https://labelpeel.hashnode.dev/turn-a-google-sheets-or-excel-list-into-printable-avery-labels-without-word-mail-merge?utm_source=hashnode&utm_medium=feed)

[Blogs World](https://hashnode.com/@blogs-world) · [20h ago](https://hashnode.com/posts/openpyxl-returns-none-for-formula-cells-excel-calculates-openpyxl-only-reads-the-cache/6afd3a00ebcc0b38d6184745)

### [openpyxl Returns None for Formula Cells: Excel Calculates, openpyxl Only Reads the Cache](https://ankitkhoiwal.hashnode.dev/openpyxl-returns-none-for-formula-cells-excel-calculates-openpyxl-only-reads-the-cache?utm_source=hashnode&utm_medium=feed)

Why data\_only=True gives None, how saving destroys formulas, and how to force a real recalculation with LibreOffice headless.

6 min read · [ankitkhoiwal.hashnode.dev](https://ankitkhoiwal.hashnode.dev/openpyxl-returns-none-for-formula-cells-excel-calculates-openpyxl-only-reads-the-cache?utm_source=hashnode&utm_medium=feed)

[Rick Zhang](https://hashnode.com/@rickzhang) · [1d ago](https://hashnode.com/posts/why-the-lowest-unit-price-costs-403-more-auditing-supplier-quotes-for-moq-reel-multiples-and-mov-in-excel/6afbe0d33d2a66adc488a8db)

### [Why the Lowest Unit Price Costs $403 More: Auditing Supplier Quotes for MOQ, Reel Multiples, and MOV in Excel](https://specrivet.hashnode.dev/why-the-lowest-unit-price-costs-403-more-auditing-supplier-quotes-for-moq-reel-multiples-and-mov-in-excel?utm_source=hashnode&utm_medium=feed)

When a hardware buyer or NPI engineer collects three distributor or broker quotes for a small production batch, the most natural reflex in Excel is writing =MIN(C2:E2) across unit prices. On high-volu

4 min read · [specrivet.hashnode.dev](https://specrivet.hashnode.dev/why-the-lowest-unit-price-costs-403-more-auditing-supplier-quotes-for-moq-reel-multiples-and-mov-in-excel?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/why-the-lowest-unit-price-costs-403-more-auditing-supplier-quotes-for-moq-reel-multiples-and-mov-in-excel/6afbe0d33d2a66adc488a8db)

[Rushabh Mehta](https://hashnode.com/@specialforcesofai) · [1d ago](https://hashnode.com/posts/copilot-in-excel-for-finance-teams-a-check-every-number-workflow/6afbe3089f99024ac051a306)

### [Copilot in Excel for Finance Teams: A Check-Every-Number Workflow](https://specialforcesofai.hashnode.dev/copilot-in-excel-for-finance-teams-a-check-every-number-workflow?utm_source=hashnode&utm_medium=feed)

How to use Microsoft 365 Copilot on month-end and reporting work without letting an unchecked figure leave the team.

5 min read · [specialforcesofai.hashnode.dev](https://specialforcesofai.hashnode.dev/copilot-in-excel-for-finance-teams-a-check-every-number-workflow?utm_source=hashnode&utm_medium=feed)

[JH-A](https://hashnode.com/@charretteairoom) · [3d ago](https://hashnode.com/posts/ai-office-workflows-that-actually-work-verified-guides-for-excel-pdfs-and-documents-2026/6af9b29790294c4b7fa6d77b)

### [AI Office Workflows That Actually Work: Verified Guides for Excel, PDFs, and Documents (2026)](https://charretteairoom.hashnode.dev/ai-office-workflows-that-actually-work-verified-guides-for-excel-pdfs-and-documents-2026?utm_source=hashnode&utm_medium=feed)

Nine tested office workflows for spreadsheets and Word or Docs: measured numbers, reproducible files, and the checks that catch a wrong AI answer.

18 min read · [charretteairoom.hashnode.dev](https://charretteairoom.hashnode.dev/ai-office-workflows-that-actually-work-verified-guides-for-excel-pdfs-and-documents-2026?utm_source=hashnode&utm_medium=feed)

[John Scott](https://hashnode.com/@jes-dev) · [5d ago](https://hashnode.com/posts/generate-word-excel-and-powerpoint-from-oracle-sqlcl/6af735705584757c61ffb192)

### [Generate Word, Excel and PowerPoint from Oracle SQLcl](https://jes-dev.hashnode.dev/generate-word-excel-and-powerpoint-from-oracle-sqlcl?utm_source=hashnode&utm_medium=feed)

Integrate ETCH with Oracle SQLcl to generate Word, Excel and PowerPoint documents from your Oracle Database

9 min read · [jes-dev.hashnode.dev](https://jes-dev.hashnode.dev/generate-word-excel-and-powerpoint-from-oracle-sqlcl?utm_source=hashnode&utm_medium=feed)

[Mahmoud Daghash](https://hashnode.com/@mahmouddaghash) · [5d ago](https://hashnode.com/posts/unix-timestamp-to-excel-date-why-serial-60-is-a-day-that-never-existed/6af736bbbc3059303572572f)

### [Unix Timestamp to Excel Date: Why Serial 60 Is a Day That Never Existed](https://confileo-eng.hashnode.dev/unix-timestamp-to-excel-date-why-serial-60-is-a-day-that-never-existed?utm_source=hashnode&utm_medium=feed)

You paste 1756771200 into a spreadsheet and want to see a date. Or you export a sheet and your API receives a column of numbers like 46236.5 instead of dates. Both directions look trivial and both go

5 min read · [confileo-eng.hashnode.dev](https://confileo-eng.hashnode.dev/unix-timestamp-to-excel-date-why-serial-60-is-a-day-that-never-existed?utm_source=hashnode&utm_medium=feed)
