xlsx

January 12, 2026 · View on GitHub

Description

A package in pure V for reading and writing Excel files in the XLSX format.

Roadmap

Read XLSX files.
Write XLSX files (basic support).

Installation

v install https://github.com/hungrybluedev/xlsx

Usage

Reading XLSX files

Take the data.xlsx file from the examples/01_marksheet directory for this example.

import xlsx

fn main() {
	workbook := xlsx.Document.from_file('data.xlsx')!
	println('[info] Loaded ${workbook.sheets.len} worksheets.')

	sheet1 := workbook.sheets[1]
	dataset := sheet1.get_all_data()!

	println('Row count: ${dataset.row_count()}')

	for row in dataset.raw_data {
		println(row.join(', '))
	}
}

Replace 'data.xlsx' with the actual path to your file.

For a more detailed example, see examples/01_marksheet/marks.v.

Writing XLSX files

import xlsx
import time

fn main() {
	mut doc := xlsx.Document.new()

	sheet_id := doc.add_sheet('Sheet1')
	mut sheet := doc.get_sheet_mut(sheet_id) or { return }

	sheet.set_cell(xlsx.Location.from_encoding('A1')!, 'Name')
	sheet.set_cell(xlsx.Location.from_encoding('B1')!, 'Score')

	sheet.set_number(xlsx.Location.from_encoding('B2')!, 95)
	sheet.set_number_f64(xlsx.Location.from_encoding('B3')!, 87.5)

	jan_1_2026 := time.Time{
		year:  2026
		month: 1
		day:   1
	}
	sheet.set_date(xlsx.Location.from_encoding('C2')!, jan_1_2026)

	sheet.set_formula(xlsx.Location.from_encoding('B4')!, 'SUM(B2:B3)')
	sheet.set_currency(xlsx.Location.from_encoding('D2')!, 1234.56, .usd)

	doc.to_file('output.xlsx')!
}

For more examples including background fills and styled formulas, see the spec/ directory.

Get Involved

It is a good idea to have examples files ready for testing. Ideally, the test files should be as small as possible.
If it is a feature request, please provide a detailed description of the feature and how it should work.

On GitHub

Create issues for bugs you find or features you want to see.
Fork the repository and create pull requests for contributions.

On Discord

Join the V Discord server: https://discord.gg/vlang
Write in the #xlsx channel about your ideas and what you want to do.

License

This project is licensed under the MIT License. See LICENSE for more details.

Support

If you like this project, please check out Set Theory for Beginners or read a few articles on the Coders' Compass website.