const XLSX = require('xlsx');

const wb = XLSX.utils.book_new();

const ws = XLSX.utils.json_to_sheet([]);

XLSX.utils.book_append_sheet(wb, ws, 'Bug sheet');

ws.A1 = { t: 's', f: 'square' };

XLSX.writeFile(wb, 'formula.ods');

The resulting .ODS file contains:

<table:table-cell table:formula="of:=square" office:value-type="string"><text:p>undefined</text:p></table

It would be great to have the option "skip N lines", since CSV files often contain not commented headers. Can this be implemented?
For example:

This is a data file generated by some old software.
Next line will contain a headers of parameters.
Temperature, Humidity, Voltage
22.5, 45.5, 220
23.0, 44.0, 219
...
In such case "skipLines: 2" could be added to con

I have been testing q and I've found something that could be an issue.

Issue
When I'm doing something like round(avg(c3),3) when querying, is rounding this 32655,5265 to this 32655,526 instead of expected result: 32655,527.

I think that could be an issue, or should be configurable.

Cheers.

I really wish there was more documentation than a readme. Preferably a longer description of each command with a list of available options for each command (with a description) and examples for each. Sort of like csvkit has.

Given that you're already pulling region/subregion data from the @hexorx countries package, would you be willing to also include the address formats in that same dataset?
I think it's fairly static data.

I'm happy to help with contributing if you're willing to include it.

Tabula API version: 1.2.1.18052200
Filename: 3_2019년_통계부록.pdf
Internal Server Error (500)
    
      
        Request Method:
        POST
      
      
        Request URL:
        http://127.0.0.1:8080/pdf/8a6599b3be99fda826cc0448d74f0f74dfd3d78d/data

lines must be orthogonal, vertical and horizontal

Got this while extracting table
[pdf file](https://drive.google.com/fil

I think the plugins docs need to extend beyond a single page now. I want to add a whole section on writing tests for plugins, showing how httpx can be used as seen in simonw/datasette-atom#3 and suchlike.

Originally posted by @dimitri in https://github.com/dimitri/pgloader/timeline

That's good thinking, and I think that's relevant for another PR. The PR introducing the statistics singleton should also take care of the following bits of refactoring of the code:

• the singleton is named “state” as I initially though I would update the global state of the migration to be able to know

Hello.
I've come across what (to me) seems to be a problem with the FILENAME and FILENUM variables.

# mlr --version
Miller v5.6.2

# cat /tmp/csv1
A,B,C
_2GB,255,2
_4GB,120,4
_6GB,50,6
_10GB,10,10

# cat /tmp/csv2
FIRST,SECOND,THIRD,FOURTH
1,2,3,4
5,6,7,8
9,10,11,12
13,14,15,16

# mlr --icsv cat then put 'print FILENAME'   /tmp/csv1 /tmp/csv2
/tmp/csv1
A=_2GB,B=255,C=2
/

Lack of documentation is a problem for most users. I have a few ideas for how to improve the documentation.

• There should be more examples.
• Examples should all be runnable, and sample input data should be downloadable.
• The documentation should include articles on important topics, for example, coordinate systems, simplification methods, and how to use JavaScript expressions as arguments

Please add support for CouchDB :)

Thank you

I'm using Tad Version 0.8.5 (0.8.5) on MacOS 10.13.4.

Tad doesn't appear to respond to the system shortcut to hide the current window (Cmd-H). I think it should for parity with other native MacOS apps.

IMPORT_EXPORT_USE_TRANSACTIONS default is True and not False as documented in latest
https://django-import-export.readthedocs.io/en/stable/installation.html

IMPORT_EXPORT_USE_TRANSACTIONS = False in settings is mandatory if one want to actually import something in a mysql db (at least)

without it :

result = somemodel_resource.import_data(datanew, dry_run=True)

will fail with "Impr

Hi, minor issue in the "Add asynchronous line by line processing support" (link to example) documentation.

The feature detail example:.

csv()
.fromFile(csvFilePath)
.subscribe((json,lineNumber)=>{
        return Promise((resolve,reject)=>{
  })
},

I'm using tsv-utils from the arch linux aur, trying to format some word frequency data from the new general services list dataset. tsv-utils makes at least two errors that I'm able to see when I'm running this commandline:

tsv-select -f 1,7 NGSL+1.01+with+SFI.tsv | tsv-pretty | less

adding -s 5 to tsv-pretty works around this problem. The tsv file was converted from the file NGSL+1.01+with