HMGforum.com

Code: Select all

/libxlsxwriter/include 

#-iflag={bcc}-a 

Code: Select all

-hblib
-inc

-o${hb_name}

-w3 -es2

-depkeyhead=xlsxwriter:xlsxwriter.h
-depcontrol=xlsxwriter:no{HB_BUILD_3RDEXT='no'}
-depcontrol=xlsxwriter:${HB_WITH_XLSXWRITER}
-depincpath=xlsxwriter:${HOME}/libxlsxwriter/include
-depincpath=xlsxwriter:/usr/include
-depincpath=xlsxwriter:/libxlsxwriter/include
-depfinish=xlsxwriter

#-iflag={bcc}-a

${hb_name}.hbx

#app.c
workbook.c
worksheet.c
format.c
chart.c
chartsheet.c
content_types.c
core.c
custom.c 
drawing.c
relationships.c
shared_strings.c
styles.c
utility.c
hb_misc.c

hb_others.prg
 

Code: Select all

//open .xlsx file for reading
xlsxioreader xlsxioread;
if ((xlsxioread = xlsxioread_open(filename)) == NULL) {
  fprintf(stderr, "Error opening .xlsx file\n");
  return 1;
}

//list available sheets
xlsxioreadersheetlist sheetlist;
const char* sheetname;
printf("Available sheets:\n");
if ((sheetlist = xlsxioread_sheetlist_open(xlsxioread)) != NULL) {
  while ((sheetname = xlsxioread_sheetlist_next(sheetlist)) != NULL) {
    printf(" - %s\n", sheetname);
  }
  xlsxioread_sheetlist_close(sheetlist);
}

//read values from first sheet
char* value;
printf("Contents of first sheet:\n");
xlsxioreadersheet sheet = xlsxioread_sheet_open(xlsxioread, NULL, XLSXIOREAD_SKIP_EMPTY_ROWS);
while (xlsxioread_sheet_next_row(sheet)) {
  while ((value = xlsxioread_sheet_next_cell(sheet)) != NULL) {
    printf("%s\t", value);
    free(value);
  }
  printf("\n");
}
xlsxioread_sheet_close(sheet);

//clean up
xlsxioread_close(xlsxioread);