added xlsx sheet selection

1 files changed, 9 insertions, 3 deletions

diff --git a/src/xlsx.c b/src/xlsx.c
index 7757fdd..ca90201 100644
--- a/src/xlsx.c
+++ b/src/xlsx.c
@@ -412,9 +412,15 @@ int open_xlsx(char * fname, char * encoding) {
     }
     zip_fclose(zf);
 
-
-    // open xl/worksheets/sheet1.xml
-    name = "xl/worksheets/sheet1.xml";
+    // open specified sheet
+    if (get_conf_value("sheet") != NULL){
+        char namebuf[256];
+        snprintf(namebuf,256,"xl/worksheets/%s.xml",get_conf_value("sheet"));
+        name = namebuf;
+    } else {
+        // open sheet1 if none specified
+        name = "xl/worksheets/sheet1.xml";
+    }
     zf = zip_fopen(za, name, ZIP_FL_UNCHANGED);
     if ( ! zf ) {
         sc_error("cannot open %s file.", name);