00:06 habere-et-disper left 00:25 arkiuat left 00:32 arkiuat joined 00:40 arkiuat left 00:54 arkiuat joined 02:23 human_blip left 02:25 human_blip joined 02:59 arkiuat left 03:01 librasteve_ left 03:07 arkiuat joined 03:12 arkiuat left 03:33 arkiuat joined 03:37 arkiuat left 03:45 arkiuat joined 04:17 human_blip left 04:19 human_blip joined 04:21 human_blip left 05:15 human-blip joined 06:30 arkiuat left 06:44 arkiuat joined 06:48 arkiuat left
disbot5 <simon_sibl> is there a good xlsx lib for Raku ? I tried to use raku.land/zef:raku-community-modul...heet::XLSX but I get an error everytime when trying to access the $cells with [0;0] Too few positionals passed; expected 2 arguments but got 1 in block at /home/sibl/Documents/git/star/share/perl6/site/sources/22B14971541474027035F5EA10CC7FEAD3BA88D8 (Spreadsheet::XLSX::Worksheet) line 48 in method 07:16
idx-from-colref at /home/sibl/Documents/git/star/share/perl6/site/sources/22B14971541474027035F5EA10CC7FEAD3BA88D8 (Spreadsheet::XLSX::Worksheet) line 48 in method maybe-load-from-backing at /home/sibl/Documents/git/star/share/perl6/site/sources/22B14971541474027035F5EA10CC7FEAD3BA88D8 (Spreadsheet::XLSX::Worksheet) line 118 in method AT-POS at
/home/sibl/Documents/git/star/share/perl6/site/sources/22B14971541474027035F5EA10CC7FEAD3BA88D8 (Spreadsheet::XLSX::Worksheet) line 69 in sub postcircumfix:<[; ]> at /home/sibl/Documents/git/star/share/perl6/site/sources/980FC23D6FE0F2A5C012026C23A9D53F71A91E74 (Spreadsheet::XLSX) line 342 in block <unit> at ./xlsx.raku line 11 also the example in the readme seems to have error, the $workbook.worksheets.name requires a [0]
after worksheets to work otherwise .name on a list doesnt work and raku.land/zef:FRITH/Spreadsheet::Libxlsxio, is simply impossible to work with for me
<simon_sibl> I just need to be able to read the sheet, and the first library should be able to do it, but for some reason, it breaks
07:18 arkiuat joined 07:23 arkiuat left
disbot5 <simon_sibl> well I will just use Spreadsheet::Read from Perl5 amazing Raku can just do that and even improve on the syntax xD 07:27
07:36 sjn left 07:51 arkiuat joined 07:56 arkiuat left 08:04 arkiuat joined 08:09 arkiuat left
disbot5 <librasteve> lucs: thanks for clarifying, I tend to be of the “it works or it doesn’t work” mindset, so sometimes I don’t really get questions that probe stuff like “why does Raku do that”, or “how else can this be done” … mind you I learn a little bit every time 08:12
<librasteve> lucs: maybe, if you have a nice idea (short summary) of exceptions, you could post as a gist and we can put that in the Raku Tips n Tricks in the weekly? 08:13
<librasteve> SIBL: please can you raise an issue on Spreadsheet::XSLX and post the link here, I’ll try and take a look at it. 08:16
08:19 arkiuat joined 08:23 arkiuat left 08:25 arkiuat joined
disbot5 <simon_sibl> @librasteve here it is github.com/raku-community-modules/.../issues/28 🙏 08:27
<librasteve> brilliant, thanks!
08:34 arkiuat left 08:35 arkiuat joined 08:39 arkiuat left 08:46 arkiuat joined 08:50 arkiuat left 09:08 arkiuat joined 09:09 dakkar joined 09:19 arkiuat left 09:40 disbot5 left 09:41 disbot6 joined 09:44 arkiuat joined 09:48 arkiuat left 10:03 arkiuat joined 10:08 arkiuat left 10:14 arkiuat joined 10:18 arkiuat left 10:36 arkiuat joined 10:40 arkiuat left 11:09 arkiuat joined 11:14 arkiuat left 11:32 arkiuat joined 11:36 arkiuat left 11:49 arkiuat joined 11:53 arkiuat left 12:02 arkiuat joined 12:07 arkiuat left 12:08 arkiuat joined 12:15 arkiuat left 12:20 arkiuat joined 12:25 arkiuat left 12:31 arkiuat joined 12:38 arkiuat left 12:39 arkiuat joined 12:45 arkiuat left 13:03 arkiuat joined 13:12 arkiuat left 13:17 arkiuat joined 13:32 arkiuat left 13:45 arkiuat joined 13:49 arkiuat left 13:57 arkiuat joined 14:02 arkiuat left 14:34 arkiuat joined 14:39 arkiuat left 14:50 swaggboi left 14:53 arkiuat joined
disbot6 <neekotism> Really? I'm interested. 14:55
14:57 sjn joined, arkiuat left 15:00 arkiuat joined 15:03 sjn left 15:04 arkiuat left
disbot6 <simon_sibl> oh well, here is the very short code perl #!/usr/bin/env raku use Spreadsheet::Read:from<Perl5>; use Template:from<Perl5>; my $sheet = Spreadsheet::Read.new('sheet.xlsx').sheet(1); my @team = $sheet.column(2)[1..*]; my @lang = $sheet.column(3)[1..*]; my @rewa = $sheet.column(4)[1..*]; my @cols = <team lang reward>; my %db; for @team Z @lang Z @rewa -> @row { my %row-data = @cols Z=> @row; for 15:05
%row-data.kv -> $col, $val { %db{$col}{$val}.push: %row-data; } }
<neekotism> That's really cool. Does it work well? 15:08
<simon_sibl> yep perfectly
<simon_sibl> very nice feature 15:09
<simon_sibl> without all the -> and @{$var} etc.
<neekotism> That's very convenient. Has this always been a feature? 15:10
15:13 arkiuat joined
ab5tract neekotism: Inline::Perl5 pre-dates the original Christmas release of Perl 6 :) 15:14
nine++ for putting together a really solid piece of cross-language interfacing
simon_sibl: not a nitpick, just wanted to state my preference for [Z] when zipping multiple thingies 15:15
too many infix Zs and I start to get dizZy ;) 15:16
15:18 swaggboi joined
disbot6 <simon_sibl> aah havent thought of that one, indeed can make it more readable 15:20
<neekotism> Very nice. I never knew about this. It changes a lot of things for me. 15:21
ab5tract neekotism: you can even compile your Perl with a switch that allows multiple Perl5 interpreters to run in the same address space 15:22
you can use Raku async goodness to coordinate code running across multiple Perl interpreters 15:23
*you can then use
15:24 sjn joined
disbot6 <neekotism> I see! Thank you very much for telling me about it. I can imagine how powerful it is. 15:29
ab5tract I hope it proves useful! Don’t hesitate any cool outcomes :D 15:36
disbot6 <simon_sibl> there are some equivalent (probably less feature than the Perl one) for Go and Python raku.land/cpan:AZAWAWI/Inline::Go raku.land/zef:slavenskoj/Inline::Python3 (I had more luck with Inline::Python since I dont use pyenv) 15:43
<simon_sibl> perl #!/usr/bin/env raku use Inline::Python; use string:from<Python>; use re:from<Python>; say re::split('\W+', 'Words, words, words.'); say string::capwords('foo bar'); $ ./another.raku [Words words words ] Foo Bar 15:44
<neekotism> That's really cool. 15:45
<antononcube> How hard it is to write a new MS Excel ingestion package from scratch? Is there a mainstream, non-corner-case format that is easy enough ingest? 15:46
<librasteve> antononcube: note the issue that SIBL filed above ... may be simpler to get that to work ;-) 15:52
arkiuat lucs, nahita3882, thanks! Now I understand what github.com/Raku/doc/issues/4658 is complaining about much better 17:19
17:42 dakkar left 18:15 arkiuat left 18:16 arkiuat joined 18:21 arkiuat left 18:35 arkiuat joined 18:40 arkiuat left 19:07 arkiuat joined 19:29 arkiuat left 19:42 arkiuat joined 19:46 arkiuat left 19:57 arkiuat joined 20:01 arkiuat left 20:05 arkiuat joined 20:12 arkiuat left 20:14 arkiuat joined 20:18 arkiuat left 20:19 arkiuat joined 20:24 arkiuat left 20:25 arkiuat joined 20:30 arkiuat left 20:31 arkiuat joined 20:37 arkiuat left 20:40 stanrifkin joined 20:58 arkiuat joined 21:03 arkiuat left

Powered by Cro and the Raku® Programming Language.

Please report any issues / comments / feature requests as an issue on App::Raku::Log.

Thank you!