From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id 4J+nIw7NXV8LQAAA0tVLHw (envelope-from ) for ; Sun, 13 Sep 2020 07:41:02 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id 0Mn8HQ7NXV/8cAAAbx9fmQ (envelope-from ) for ; Sun, 13 Sep 2020 07:41:02 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 568D294050D for ; Sun, 13 Sep 2020 07:41:01 +0000 (UTC) Received: from localhost ([::1]:52842 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kHMd8-0004it-OD for larch@yhetil.org; Sun, 13 Sep 2020 03:40:58 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:42074) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kHMci-0004iV-44 for emacs-orgmode@gnu.org; Sun, 13 Sep 2020 03:40:32 -0400 Received: from mx1.riseup.net ([198.252.153.129]:58664) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kHMcf-0004v1-Lm for emacs-orgmode@gnu.org; Sun, 13 Sep 2020 03:40:31 -0400 Received: from capuchin.riseup.net (capuchin-pn.riseup.net [10.0.1.176]) (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (Client CN "*.riseup.net", Issuer "Sectigo RSA Domain Validation Secure Server CA" (not verified)) by mx1.riseup.net (Postfix) with ESMTPS id 4Bq1c936klzFmZC for ; Sun, 13 Sep 2020 00:40:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=riseup.net; s=squak; t=1599982828; bh=ltAFBExOyw/D8eSg+EiB6qhp1VhtWaPPdxn/Zsvt0Kk=; h=Date:From:To:Subject:In-Reply-To:References:From; b=GGpg2gM/xLlV4a6sc27V4gVsEod0cOKYKSRX4OyHu9FIsriAsMz3JWmnXGD6A6q+g hQyJgWPWm1So9ETMW/iUwzCVZ5/zrV2DBUf33HpLImlgH/pmcKhOiV4NU9cW94whbL 0NlZowcU5KuwGFz/N1JxHzhCpGLCcso0SPfC3fn8= X-Riseup-User-ID: 7530BB331CC0E14584297AC7E2815DDF5B70E903B96E22612929B9417B3F7011 Received: from [127.0.0.1] (localhost [127.0.0.1]) by capuchin.riseup.net (Postfix) with ESMTPSA id 4Bq1c85Q0Lz8t1T for ; Sun, 13 Sep 2020 00:40:08 -0700 (PDT) Date: Sun, 13 Sep 2020 09:40:03 +0200 From: swedebugia To: emacs-orgmode@gnu.org Subject: Re: Bug: org-table-import fails to import xlxs files Message-ID: <20200913094003.69fa761c@parabola> In-Reply-To: <20200912135043.0354bac4@parabola> References: <20200912135043.0354bac4@parabola> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Received-SPF: pass client-ip=198.252.153.129; envelope-from=swedebugia@riseup.net; helo=mx1.riseup.net X-detected-operating-system: by eggs.gnu.org: First seen = 2020/09/13 03:12:23 X-ACL-Warn: Detected OS = Linux 3.11 and newer [fuzzy] X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=riseup.net header.s=squak header.b=GGpg2gM/; dmarc=pass (policy=none) header.from=riseup.net; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: -1.21 X-TUID: exSORTazwNj9 On Sat, 12 Sep 2020 13:50:43 +0200 swedebugia wrote: > Hi > > Thanks for a making this fantastic program! > > I think I found a bug. > > When trying to import a xslx table into org-mode I get a lot of binary > data instead of a table back. > > I would rather either get an error saying it is not supported yet or > an org-table. > > Recoll supports xlsx files it seems, so it should be possible > with python 3 at least to make this work also in org-mode. See > https://www.lesbonscomptes.com/recoll/pages/features.html > > I found this in Arch: > $ pacman -Ss xlsx > community/python-openpyxl 3.0.5-1 > A Python library to read/write Excel 2007 xlsx/xlsm files > > Other ones written in python: > https://github.com/dilshod/xlsx2csv (not that active) > https://github.com/wireservice/csvkit (active) > > Also gnumeric can convert it: > The Gnumeric spreadsheet application comes with a command line utility > called ssconvert that can convert between a variety of spreadsheet > formats: > > $ ssconvert Book1.xlsx newfile.csv > Unfortunately it is only available with the gnumeric GUI currently > which is ~14MB bloat. > See > http://stackoverflow.com/questions/10557360/ddg#10580741 > Source here https://gitlab.gnome.org/GNOME/gnumeric (active) > > Cheers > swedebugia > I also found this nice and small rust program that works well: https://github.com/zitsen/xlsx2csv.rs It is surprisingly large though: 8.7M Sep 12 16:53 .cargo/bin/xlsx2csv Which is way more than ssconvert, but on the other hand it does not require any gnome dependencies or GUI stuff: 38K Sep 5 16:21 /usr/bin/ssconvert cheers