xlsx 0.0.8

Simple XLSX file parser.


To use this package, run the following command in your project's root directory:

Manual usage
Put the following dependency into your project's dependences section:

dlang-xlsx

An XLSX (Excel 2007+) sheet extractor/parser written in D

Really defines just one useful function: readSheet(string fileName, int sheet). See the docs folder for specifics.

Build with dub build. I would have written it with only the D standard library (Phobos), but std.zip has issues with expandedData on members of XLSX files returning empty (zero-length) byte arrays. The Dub archive package, on the other hand, works perfectly.

This branch (dxml) is, as the name implies, a switch to using dxml for XML parsing, rather than the long-deprecated std.xml.

Example usage:

import std.stdio;
import xlsx;

void main() {
    //Reads sheet 1 from file "test.xlsx"
    writeln(readSheet("test.xlsx", 1));
    
    //Read a named sheet
    writeln(readSheet("test.xlsx", "My Sheet"));
}

As of version 0.0.4 now properly reads from the Shared String Table for spreadsheets with many oft-repeating strings and/or whenever Excel decides to make use of it.

Tested on Windows and Linux (x64), but written purely in D with no external dependencies, so it should run on all platforms D supports.

Authors:
  • Rudolph
Dependencies:
dxml, archive
Versions:
0.0.8 2019-Jul-04
0.0.7 2019-Jul-01
0.0.6 2018-Jul-08
0.0.5 2018-Jul-01
0.0.4 2017-Nov-15
Show all 11 versions
Download Stats:
  • 0 downloads today

  • 12 downloads this week

  • 31 downloads this month

  • 110256 downloads total

Score:
1.5
Short URL:
xlsx.dub.pm