Re: how to exclude a file from appearing in the refile target cache?
Den Tue, 15 Sep 2020 22:54:28 + skrev Re: how to exclude a file from appearing in the refile target cache?: > Sent from my iPhone > > > On Sep 15, 2020, at 3:37 PM, swedebugia > > wrote: > > > > Hi > > > > I read: > > https://orgmode.org/manual/Refile-and-Copy.html > > > > But its unclear to me how to exclude a file from appearing in the > > refile target cache. > > > > My cache takes 13s to build and its too long for my taste. I have > > archived all old notes now. I want to exclude my archive.org from > > the refile targets. Is there a way to do that? > > > > You can use org-refile-targets to explicitly tell which files to > include when you want to Copy and Refile. I am not near my computer, > otherwise I would have shared an example. Thanks! This should be added in the manual page linked above I think.
how to exclude a file from appearing in the refile target cache?
Hi I read: https://orgmode.org/manual/Refile-and-Copy.html But its unclear to me how to exclude a file from appearing in the refile target cache. My cache takes 13s to build and its too long for my taste. I have archived all old notes now. I want to exclude my archive.org from the refile targets. Is there a way to do that? Cheers swedebugia
Re: Bug: org-table-import fails to import xlxs files
Den Sun, 13 Sep 2020 19:15:58 +0200 skrev Re: Bug: org-table-import fails to import xlxs files: > Hi, > > swedebugia writes: > > > When trying to import a xslx table into org-mode I get a lot of > > binary data instead of a table back. > > Indeed! Let's have Org throw an error in such cases, I made this > change in master as 9c31cba00. > > Thanks, > Thank you! Do you have any idea how I can setup org-mode to use a convert tool before trying to import? cheers
Re: Bug: org-table-import fails to import xlxs files
On Sun, 13 Sep 2020 09:40:03 +0200 swedebugia wrote: > > 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 > Just for fun I compared the speed, and the found that ssconvert is slower by a factor of 10 on a ~4500 line spreadsheet. $ time xlsx2csv test.xlsx * Preparing write to ./Tabelle1.csv ** sheet range size is (4770, 11) ** Starting writing ** Done with sheet `Tabelle1` real 0m0.565s user0m0.537s sys 0m0.021s $ time ssconvert test.xlsx test.csv real0m4.249s user0m4.186s sys 0m0.061s
Re: Bug: org-table-import fails to import xlxs files
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
Bug: org-table-import fails to import xlxs files
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