SQLite Forum

Use of `.excel` under Cygwin
Login

Use of `.excel` under Cygwin

(1) By Mark Lawrence (mark) on 2020-11-29 19:38:24 [link] [source]

With sqlite3.exe under Cygwin I am unable to use the .excel command. There are apparently two separate issues on a default installation.

The first is that as Cygwin is identified as a Unix-style environment, SQLite attempts to call xdg-open, which does not exist unless the user has installed the xdg-utils package. Perhaps SQLite could point this particular package out with a more helpful error message.

The second (actually the only real) issue is that the path given to xdg-open (when it is installed) appears to be invalid, missing backslashes:

Unable to start 'C:cygwin64tmpetilqs_VRZheZvmh6MvCTU.csv': The specified file was not found.
Failed: [xdg-open C:\cygwin64\tmp\etilqs_VRZheZvmh6MvCTU.csv]

Any chance someone else could confirm the same behaviour on another Cygwin installation? Maybe the devs or other interested parties feel like investigating...

Thanks, Mark

(2) By jose isaias cabrera (jicman) on 2020-11-30 14:51:40 in reply to 1 [source]


Perhaps a \\ instead of single?

>>Unable to start 'C:cygwin64tmpetilqs_VRZheZvmh6MvCTU.csv':...

>>Failed: [xdg-open C:\cygwin64\tmp\etilqs_VRZheZvmh6MvCTU.csv]

try 

C:\\cygwin64\\tmp\\etilqs_VRZheZvmh6MvCTU.csv

or better yet, use the cygdrive option

/cygdrive/c/cygwin64/tmp/etilqs_VRZheZvmh6MvCTU.csv