Skip to content

damian-m-g/xlsx_drone

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

39 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

xlsx_drone

Fast Microsoft Excel's *.xlsx reader.

Table of contents

Features

  • Doesn't use any external application to parse them.
  • Focus on speed over functionality.
  • Simple interface.
  • UTF-8 support.

Installation

Straightforward copy and paste of the src and ext folders into your project root folder and #include "xlsx_drone.h" in your source code. It's understandable that you might want to accommodate files differently, just note that xlsx_drone.h calls its deppendencies with relative paths:

// external libraries
#include "../ext/zip.h"
#include "../ext/sxmlc.h"
#include "../ext/sxmlsearch.h"

..., you might want to modify that according to your needs.

Usage

Essential

// open *.xlsx
xlsx_workbook_t wb;
xlsx_open("foo.xlsx", &wb);
// be free to inspect some wb data
int number_of_sheets = wb.n_sheets;
// load sheet
xlsx_sheet_t *sheet_1 = xlsx_load_sheet(&wb, 1, NULL);
// be free to inspect some sheet data
char *sheet_name = sheet_1->name;
int last_row = sheet_1->last_row; // valued 0 if the sheet is empty
// as of version 0.2.0 you can retrieve the last column (more info below)
char *last_column = xlsx_get_last_column(sheet_1); // i.e.: "FB" or "R", etc.
// read cell
xlsx_cell_t cell_data_holder;    
xlsx_read_cell(sheet_1, 4, "B", &cell_data_holder);
// inspect result
switch(cell_data_holder.value_type) {
  case XLSX_POINTER_TO_CHAR:
    printf("Cell 4B has value: %s", cell_data_holder.value.pointer_to_char_value);
    break;
  case XLSX_INT:
    printf("Cell 4B has value: %d", cell_data_holder.value.int_value);
    break;
  case XLSX_LONG_LONG:
    printf("Cell 4B has value: %lld", cell_data_holder.value.long_long_value);
    break;
  case XLSX_DOUBLE:
    printf("Cell 4B has value: %f", cell_data_holder.value.double_value);
    break;
  default:
    printf("Cell 4B has no value");
}
// you can also inspect the cell category
int cell_category = cell_data_holder.style->related_category

...which is one of:

typedef enum xlsx_cell_category {
  XLSX_NUMBER, // int, long long, or double
  XLSX_TEXT, // string
  XLSX_DATE, // int
  XLSX_TIME, // double
  XLSX_DATE_TIME, // double
  XLSX_UNKNOWN
} xlsx_cell_category;

...which is a summary of what can be set in Excel:

Note that:

  • XLSX_TIME category is represented as a double between 0 and 1.
  • XLSX_DATE category is represented as an int that stars with 1 for the first day of 1900 and raises until the last day of 9999. Values that fall out of the range are represented as text (string) although they will be pointed as XLSX_DATE if the cell has that category manually fixed.
  • XLSX_DATE_TIME category is a combination of XLSX_TIME and XLSX_DATE.
// when you're done reading the XLSX, close the workbook to properly free resources
xlsx_close(&wb);

Extended

This section shows brief descriptions of extra features of the library.

// sets on and off errors printing in stdout (default: on (1))
void xlsx_set_print_err_messages(int flag);
// inspect xlsx_errno to know what happened after some function fails
int xlsx_get_xlsx_errno(void);

// if memory is of your concern, you can unload any loaded sheet if it's of no use
void xlsx_unload_sheet(xlsx_sheet_t *sheet);

The rest of the public functions will return 0 or NULL if fail, and 1 or a valid pointer for success. When they return 0 or NULL, you can check xlsx_errno and compare it against the respective error values of the function.

For full documentation of the API, check src/xlsx_drone.h.

Getting the last column of certain sheet (since version 0.2.0)

This feature wasn't originally included in the release version since has a time cost to be discovered (this issue gets noted with big files). Version 0.2.0 (and forth) provide a solution without killing the essence of the library (speed over funcionality).

This value won't be discovered when xlsx_load_sheet() because you can be working with well known *.xlsx files, -so you already know where things are, what columns matter, and so on- and basically you don't need the information. But sometimes, you'll be working blindly with unknown files, so you may need to know the limits of the sheet: what is the last row, and what is the last column with information.

In the last case, you now have char* xlsx_get_last_column(xlsx_sheet_t *sheet);. Which takes an already loaded sheet, and returns a string representing the last column. Could also return NULL, in case of an error or empty sheet (check src/xlsx_drone.h for more info). After this first call, sheet->last_column gets populated with the function returned value, so after that first call, you can either keep calling the function, or consult straightforward the sheet member, your choice.

Bindings

Using foreign function calls, a binding to Ruby was made.

Project Status

  • Reading capabilities for ASCII
  • Reading capabilities for UTF-8
  • Writting capabilities (ON HOLD)

TODO

All ideas about new implementations are thoroughly thought to keep the essence of the library, which is to be fast and simple. Hence, next TODOs could be taken into account or dismissed based on that.

  • Consider make xlsx_open() work independently of having the *.xlsx opened (grabbed) or closed.

Credits & Thanks

  • Matthieu Labas for sxmlc.
  • Kuba Podgórski for zip.
  • Gilles Vollant (@gvollant)

License